This section provides information about API Procedures and Functions. All the procedures and functions of the M_API_SITE package are listed below, with the corresponding tables and the purpose.
Proc/Func |
Name |
Table |
Purpose |
---|---|---|---|
F |
build_query_cond |
Build the query conditions for C.30.01.02 Assigned Work Packages |
|
F |
check_export |
||
F |
check_tag_master_detail |
Check split tag |
|
F |
check_undo |
Check Undo Forecast/Reservation Run |
|
F |
create_rr_from_fr |
Create a reservation run from an existing forecast run |
|
P |
delete_mir |
Delete unposted MIR |
|
P |
disable_site_api |
Deactivation of export triggers |
|
P |
enable_site_api |
Activation of export triggers |
|
P |
exec_ddl |
Procedure creates the views and the grants |
|
P |
fah_results |
Retrieving forecast/reservation run results |
|
P |
get_actual_polis_data |
M_ACTUAL_POLIS |
|
P |
get_appl_role_data |
M_APPL_ROLES |
Selects roles data from m_appl_roles |
P |
get_bin_loc_data |
M_BIN_LOCATIONS |
Bin Locations |
P |
get_bin_loc_loc_data |
M_BIN_LOC_LOCATIONS |
Bin Location Warehouse Locations |
P |
get_bin_loc_nls_data |
M_BIN_LOCATION_NLS |
Bin Location NLS |
P |
get_bin_loc_wh_data |
M_BIN_LOC_WAREHOUSES |
Bin Location Warehouses |
P |
get_c4001_totals |
Get total quantities from C4001 |
|
F |
get_cascade_del_proj_id |
Get proj_id for detail tables for cascade delete |
|
P |
get_cc_layout_data |
M_COMMODITY_CODE_LAYOUTS |
|
P |
get_cc_nls_data |
M_COMMODITY_CODE_NLS |
|
F |
get_commodity_code |
M_COMMODITY_CODES |
Returns the current commodity code (current session) |
P |
get_commodity_code_data |
M_COMMODITY_CODES |
|
F |
get_commodity_id |
M_COMMODITY_CODES |
Returns the current commodity ID (current session) |
P |
get_company_data |
M_COMPANIES |
Selects company data from m_companies |
P |
get_discipline_data |
M_DISCIPLINES |
Selects discipline data from m_disciplines |
F |
get_esi_active |
Get interface status (enabled Y/N) |
|
F |
get_esi_active_all |
Get interface status (enabled Y/N) for tables without proj_id |
|
P |
get_heat_data |
M_HEATS |
Heat numbers |
P |
get_heat_detail_data |
M_HEAT_DETAILS |
Heat number details |
F |
get_ident |
M_IDENTS |
Returns the current ident (current session) |
F |
get_ident_code |
M_IDENTS |
Returns the current ident code (current session) |
P |
get_ident_nls_data |
M_IDENT_NLS |
|
P |
get_idents_data |
M_IDENTS |
|
P |
get_item_ship_data |
M_ITEM_SHIPS |
|
F |
get_ivi_id_by_uk |
||
P |
get_list_node_data |
M_LIST_NODES |
|
P |
get_list_node_nls_data |
M_LIST_NODE_NLS |
|
P |
get_list_pos_data |
M_LIST_POS |
|
P |
get_location_data |
M_LOCATIONS |
Selects warehouse location data from m_locations |
P |
get_location_nls_data |
M_LOCATION_NLS |
Selects the language dependent |
P |
get_lp_by_ident_tag |
Get list position by ident or tag_number |
|
P |
get_lp_values |
M_LIST_POS_VALUES |
|
P |
get_mat_stat_data |
M_SITE_MATL_STATUS |
Selects receiving status data from m_site_matl_status |
P |
get_mat_stat_nls_data |
M_SITE_MATL_STATUS_NLS |
Selects the language dependent receiving status description from m_site_matl_status_nls |
F |
get_max_run_number |
Get the max run number of a forecast run |
|
P |
get_nls_data |
M_NLS |
Selects language data from m_nls |
F |
get_pg_code |
Returns the product group for project |
|
P |
get_po_line_data |
M_PO_LINE_ITEMS |
|
P |
get_poh_data |
M_PO_HEADERS |
Purchase order header |
P |
get_poh_nls_data |
M_PO_HEADER_NLS |
Language dependent purchase order description |
P |
get_project_data |
M_PROJECTS |
Selects project data from m_projects |
P |
get_shipment_group_data |
M_SHIPMENT_GROUPS |
|
P |
get_status_data |
M_STATUS |
Selects status data from m_status |
P |
get_supplier_data |
M_SUPPLIERS |
|
F |
get_sysdate |
Returns the current date |
|
P |
get_unit_data |
M_UNITS |
Selects unit data from m_units |
P |
get_unit_group_data |
M_UNIT_GROUPS |
Selects unit group data from m_unit_groups |
P |
get_user_data |
M_USERS |
Selects user data from m_users |
P |
get_user_sec_data |
M_USER_SECURITIES |
Selects user securities data from m_user_securities |
P |
get_warehouse_data |
M_WAREHOUSES |
Selects warehouse data from m_warehouses |
P |
get_warehouse_nls_data |
M_WAREHOUSE_NLS |
Selects the language dependent warehouse descriptions from m_warehouse_nls |
P |
get_wh_user_data |
M_WH_TO_USERS |
Selects warehouse to user data from m_wh_to_users |
P |
mir_results |
Retrieving MIR data |
|
P |
mrr_results |
Retrieving MRR data |
|
F |
new_run |
Create a new run of an existing forecast run |
|
F |
post_mir |
Posting of a MIR |
|
F |
post_mrr |
Posting of an MRR |
|
F |
post_mtr |
Posting of an MTR |
|
P |
set_api_ind |
Switch the api_ind in A.20.06.02 User Security for Projects dependent on project and discipline |
|
P |
set_cascade_del_proj_id |
Get proj_id for detail tables for cascade delete |
|
P |
set_login_env |
Set the login environment (us_id) |
|
F |
start_fah |
Start forecast/reservation run |
|
F |
undo_node |
Undo BOM node of Forecast/Reservation Run |
|
F |
undo_pos |
Undo BOM position of Forecast/Reservation Run |
|
F |
undo_run |
Undo Forecast/Reservation Run |
|
F |
unpost_mrr |
Revert the posting of an MRR |
|
F |
write_exp_ctrl |
Inserts trace records into m_esi_export_ctrls table |
|
F |
write_fa_header |
Import forecast/reservation run |
|
F |
write_fa_header_nls |
Import language dependent forecast/reservation run description |
|
F |
write_heat_detail |
Import heat details |
|
F |
write_inv_issues |
Import inventory issues |
|
F |
write_inv_receipts |
Import MRR line items |
|
F |
write_inv_transfers |
Import material transfer details |
|
F |
write_mir_header |
Import material issue report (MIR) |
|
F |
write_mir_header_nls |
Import language dependent MIR description |
|
F |
write_mrr_by_traffic |
Import material receiving report (MRR) by Traffic |
|
F |
write_mrr_header |
Import material receiving report (MRR) |
|
F |
write_mrr_header_nls |
Import language dependent MRR description |
|
F |
write_mtr_header |
Import material transfer report (MTR) |
|
F |
write_mtr_header_nls |
Import language dependent MTR description |
|
F |
write_osd |
Import over, short & damaged report (OSD) |
|
F |
write_osd_nls |
Import language dependent OSD description |
|
F |
write_srr_header |
Import stores requisition report (SRR) |
|
F |
write_srr_header_nls |
Import language dependent SRR description |
|
F |
write_stores_requisitions |
Import stores requisition details |
|
F |
write_work_pack |
Import work package |
|
F |
write_work_pack_details |
Import work package details |
|
F |
write_work_pack_nls |
Import language dependent work package description |