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 215: l_rej_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

211:
212: -- variables to track the records that need to be rejected due
213: -- to errors in the processing
214: l_count NUMBER := 0;
215: l_rej_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
216:
217: --Bug 16730873
218: l_delete_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
219: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 659: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

655: l_max_intf_line_id NUMBER := -1;
656:
657: -- variables to track the records that need to be rejected due
658: -- to errors in the processing
659: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
660:
661: -- bug#13367649- variable to track the number of records fetched
662: -- for each loop iteration
663: l_lines_count NUMBER;

Line 1044: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1040:
1041: -- variable to track lines that need to be expired
1042: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1043:
1044: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1045: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1046:
1047: BEGIN
1048: d_position := 0;

Line 1045: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1041: -- variable to track lines that need to be expired
1042: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1043:
1044: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1045: l_notified_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1046:
1047: BEGIN
1048: d_position := 0;
1049:

Line 1382: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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

Line 1544: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1540:
1541: -- variables to track the records that need to be rejected due
1542: -- to errors in the processing
1543: l_count NUMBER := 0;
1544: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1545:
1546: BEGIN
1547: d_position := 0;
1548:

Line 1682: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

1678: l_line_locs PO_PDOI_TYPES.line_locs_rec_type;
1679:
1680: -- variables to track the records that need to be rejected due
1681: -- to errors in the processing
1682: l_rej_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1683:
1684: -- keep record of lines processed in this request
1685: -- the record will be used in post line location processing
1686: l_processed_line_id_tbl DBMS_SQL.number_table;

Line 2015: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2011: l_dists_csr PO_PDOI_TYPES.intf_cursor_type;
2012:
2013: -- variables to track the records that need to be rejected due
2014: -- to errors in the processing
2015: l_rej_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2016:
2017: -- maximal interface_line_location_id_processed
2018: l_max_intf_dist_id NUMBER := -1;
2019:

Line 2237: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2233: l_price_diffs_csr PO_PDOI_TYPES.intf_cursor_type;
2234:
2235: -- variables to track the records that need to be rejected due
2236: -- to errors in the processing
2237: l_rej_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2238:
2239: -- maximal interface_price_diff_id_processed
2240: l_max_intf_price_diff_id NUMBER := -1;
2241:

Line 2544: l_sync_attr_id_tbl PO_TBL_NUMBER;

2540: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2541:
2542: -- pl/sql table to track rows that need to be synced from txn
2543: -- table to draft table
2544: l_sync_attr_id_tbl PO_TBL_NUMBER;
2545: l_sync_draft_id_tbl PO_TBL_NUMBER;
2546:
2547: -- maximal interface_attr_values_id_processed
2548: l_max_intf_attr_values_id NUMBER := -1;

Line 2545: l_sync_draft_id_tbl PO_TBL_NUMBER;

2541:
2542: -- pl/sql table to track rows that need to be synced from txn
2543: -- table to draft table
2544: l_sync_attr_id_tbl PO_TBL_NUMBER;
2545: l_sync_draft_id_tbl PO_TBL_NUMBER;
2546:
2547: -- maximal interface_attr_values_id_processed
2548: l_max_intf_attr_values_id NUMBER := -1;
2549:

Line 2743: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;

2739: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;
2740:
2741: -- pl/sql table to track rows that need to be synced from txn
2742: -- table to draft table
2743: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
2744: l_sync_draft_id_tbl PO_TBL_NUMBER;
2745:
2746: -- maximal interface_attr_values_tlp_id_processed
2747: l_max_intf_attr_values_tlp_id NUMBER := -1;

Line 2744: l_sync_draft_id_tbl PO_TBL_NUMBER;

2740:
2741: -- pl/sql table to track rows that need to be synced from txn
2742: -- table to draft table
2743: l_sync_attr_tlp_id_tbl PO_TBL_NUMBER;
2744: l_sync_draft_id_tbl PO_TBL_NUMBER;
2745:
2746: -- maximal interface_attr_values_tlp_id_processed
2747: l_max_intf_attr_values_tlp_id NUMBER := -1;
2748:

Line 2930: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

2926: l_max_intf_line_id NUMBER := -1;
2927:
2928: -- variables to track the records that need to be rejected due
2929: -- to errors in the processing
2930: l_rej_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
2931: l_po_line_id NUMBER := 0;
2932: BEGIN
2933: d_position := 0;
2934:

Line 3229: l_clm_base_line_num_tbl PO_TBL_NUMBER;

3225: IS
3226: d_api_name CONSTANT VARCHAR2(30) := 'set_intf_base_line_num_to_dft';
3227: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3228: d_position NUMBER;
3229: l_clm_base_line_num_tbl PO_TBL_NUMBER;
3230: l_po_line_id_tbl PO_TBL_NUMBER;
3231:
3232: BEGIN
3233:

Line 3230: l_po_line_id_tbl PO_TBL_NUMBER;

3226: d_api_name CONSTANT VARCHAR2(30) := 'set_intf_base_line_num_to_dft';
3227: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3228: d_position NUMBER;
3229: l_clm_base_line_num_tbl PO_TBL_NUMBER;
3230: l_po_line_id_tbl PO_TBL_NUMBER;
3231:
3232: BEGIN
3233:
3234: IF (PO_LOG.d_proc) THEN