eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_TBL_NUMBER

Line 742: l_index_tbl PO_TBL_NUMBER;

738: l_index NUMBER;
739: l_key PO_SESSION_GT.key%TYPE;
740:
741: -- variables used to read result from po_session_gt table
742: l_index_tbl PO_TBL_NUMBER;
743: l_org_id_tbl PO_TBL_NUMBER;
744: l_item_id_tbl PO_TBL_NUMBER;
745:
746: -- flag to indicate whether item exists in some orgs

Line 743: l_org_id_tbl PO_TBL_NUMBER;

739: l_key PO_SESSION_GT.key%TYPE;
740:
741: -- variables used to read result from po_session_gt table
742: l_index_tbl PO_TBL_NUMBER;
743: l_org_id_tbl PO_TBL_NUMBER;
744: l_item_id_tbl PO_TBL_NUMBER;
745:
746: -- flag to indicate whether item exists in some orgs
747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 744: l_item_id_tbl PO_TBL_NUMBER;

740:
741: -- variables used to read result from po_session_gt table
742: l_index_tbl PO_TBL_NUMBER;
743: l_org_id_tbl PO_TBL_NUMBER;
744: l_item_id_tbl PO_TBL_NUMBER;
745:
746: -- flag to indicate whether item exists in some orgs
747: l_exist_in_ship_to_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
748: l_exist_in_master_org_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 965: l_set_process_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

961: d_api_name CONSTANT VARCHAR2(30) := 'insert_master_item';
962: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
963: d_position NUMBER;
964:
965: l_set_process_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
966: l_index NUMBER;
967:
968: -- key value used to identify records in po_session_gt
969: l_key PO_SESSION_GT.key%TYPE;

Line 977: l_index_tbl PO_TBL_NUMBER;

973: l_err_text VARCHAR2(3000);
974: l_return_code NUMBER;
975:
976: -- variables used to get processed result from interface table
977: l_index_tbl PO_TBL_NUMBER;
978: l_process_flag_tbl PO_TBL_NUMBER;
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;

Line 978: l_process_flag_tbl PO_TBL_NUMBER;

974: l_return_code NUMBER;
975:
976: -- variables used to get processed result from interface table
977: l_index_tbl PO_TBL_NUMBER;
978: l_process_flag_tbl PO_TBL_NUMBER;
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;
982: l_revision_tbl PO_TBL_VARCHAR5;

Line 979: l_transaction_id_tbl PO_TBL_NUMBER;

975:
976: -- variables used to get processed result from interface table
977: l_index_tbl PO_TBL_NUMBER;
978: l_process_flag_tbl PO_TBL_NUMBER;
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;
982: l_revision_tbl PO_TBL_VARCHAR5;
983: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 980: l_item_id_tbl PO_TBL_NUMBER;

976: -- variables used to get processed result from interface table
977: l_index_tbl PO_TBL_NUMBER;
978: l_process_flag_tbl PO_TBL_NUMBER;
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;
982: l_revision_tbl PO_TBL_VARCHAR5;
983: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
984:

Line 981: l_org_id_tbl PO_TBL_NUMBER;

977: l_index_tbl PO_TBL_NUMBER;
978: l_process_flag_tbl PO_TBL_NUMBER;
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;
982: l_revision_tbl PO_TBL_VARCHAR5;
983: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
984:
985: -- rows that return errors when creating items

Line 1409: l_index_tbl PO_TBL_NUMBER;

1405: l_index NUMBER;
1406: l_key po_session_gt.key%TYPE;
1407:
1408: -- variables to store results of original values defined in item
1409: l_index_tbl PO_TBL_NUMBER;
1410: l_orig_desc_tbl PO_TBL_VARCHAR2000;
1411: l_orig_list_price_tbl PO_TBL_NUMBER;
1412:
1413: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;

Line 1411: l_orig_list_price_tbl PO_TBL_NUMBER;

1407:
1408: -- variables to store results of original values defined in item
1409: l_index_tbl PO_TBL_NUMBER;
1410: l_orig_desc_tbl PO_TBL_VARCHAR2000;
1411: l_orig_list_price_tbl PO_TBL_NUMBER;
1412:
1413: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
1414:
1415: -- variables to hold results from INV's API call