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_MAINPROC_PVT dependencies on PO_TBL_NUMBER

Line 200: l_rej_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

196:
197: -- variables to track the records that need to be rejected due
198: -- to errors in the processing
199: l_count NUMBER := 0;
200: l_rej_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
201:
202: BEGIN
203: d_position := 0;
204:

Line 526: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

522: l_max_intf_line_id NUMBER := -1;
523:
524: -- variables to track the records that need to be rejected due
525: -- to errors in the processing
526: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
527:
528: BEGIN
529: d_position := 0;
530:

Line 881: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

877:
878: -- variable to track lines that need to be expired
879: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
880:
881: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
882: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
883:
884: BEGIN
885: d_position := 0;

Line 882: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

878: -- variable to track lines that need to be expired
879: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
880:
881: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
882: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
883:
884: BEGIN
885: d_position := 0;
886:

Line 1219: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1215:
1216: -- variables to track the records that need to be rejected due
1217: -- to errors in the processing
1218: l_count NUMBER := 0;
1219: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1220:
1221: BEGIN
1222: d_position := 0;
1223:

Line 1381: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1377:
1378: -- variables to track the records that need to be rejected due
1379: -- to errors in the processing
1380: l_count NUMBER := 0;
1381: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1382:
1383: BEGIN
1384: d_position := 0;
1385:

Line 1519: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1515: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1516:
1517: -- variables to track the records that need to be rejected due
1518: -- to errors in the processing
1519: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1520:
1521: -- keep record of lines processed in this request
1522: -- the record will be used in post line location processing
1523: l_processed_line_id_tbl DBMS_SQL.number_table;

Line 1852: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1848: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
1849:
1850: -- variables to track the records that need to be rejected due
1851: -- to errors in the processing
1852: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1853:
1854: -- maximal interface_line_location_id_processed
1855: l_max_intf_dist_id NUMBER := -1;
1856:

Line 2074: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2070: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2071:
2072: -- variables to track the records that need to be rejected due
2073: -- to errors in the processing
2074: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2075:
2076: -- maximal interface_price_diff_id_processed
2077: l_max_intf_price_diff_id NUMBER := -1;
2078:

Line 2381: l_sync_attr_id_tbl PO_TBL_NUMBER;

2377: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2378:
2379: -- pl/sql table to track rows that need to be synced from txn
2380: -- table to draft table
2381: l_sync_attr_id_tbl PO_TBL_NUMBER;
2382: l_sync_draft_id_tbl PO_TBL_NUMBER;
2383:
2384: -- maximal interface_attr_values_id_processed
2385: l_max_intf_attr_values_id NUMBER := -1;

Line 2382: l_sync_draft_id_tbl PO_TBL_NUMBER;

2378:
2379: -- pl/sql table to track rows that need to be synced from txn
2380: -- table to draft table
2381: l_sync_attr_id_tbl PO_TBL_NUMBER;
2382: l_sync_draft_id_tbl PO_TBL_NUMBER;
2383:
2384: -- maximal interface_attr_values_id_processed
2385: l_max_intf_attr_values_id NUMBER := -1;
2386:

Line 2574: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;

2570: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2571:
2572: -- pl/sql table to track rows that need to be synced from txn
2573: -- table to draft table
2574: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
2575: l_sync_draft_id_tbl PO_TBL_NUMBER;
2576:
2577: -- maximal interface_attr_values_tlp_id_processed
2578: l_max_intf_attr_values_tlp_id NUMBER := -1;

Line 2575: l_sync_draft_id_tbl PO_TBL_NUMBER;

2571:
2572: -- pl/sql table to track rows that need to be synced from txn
2573: -- table to draft table
2574: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
2575: l_sync_draft_id_tbl PO_TBL_NUMBER;
2576:
2577: -- maximal interface_attr_values_tlp_id_processed
2578: l_max_intf_attr_values_tlp_id NUMBER := -1;
2579: