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 DBMS_SQL

Line 30: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

26:
27: PROCEDURE process_create_lines_in_group
28: (
29: p_group_num IN NUMBER,
30: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
31: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
32: );
33:
34: PROCEDURE process_update_lines_in_group

Line 876: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

872: -- line grouping num
873: l_group_num NUMBER := 0;
874:
875: -- variable to track records that have not been processed
876: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
877:
878: -- variable to track lines that need to be expired
879: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
880:

Line 879: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;

875: -- variable to track records that have not been processed
876: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
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:

Line 1208: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1204: ------------------------------------------------------------------------
1205: PROCEDURE process_create_lines_in_group
1206: (
1207: p_group_num IN NUMBER,
1208: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1209: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1210: ) IS
1211:
1212: d_api_name CONSTANT VARCHAR2(30) := 'process_create_lines_in_group';

Line 1523: l_processed_line_id_tbl DBMS_SQL.number_table;

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;
1524: l_processed_draft_id_tbl DBMS_SQL.number_table;
1525: l_line_ref_tbl DBMS_SQL.number_table;
1526:
1527: -- maximal interface_line_location_id_processed

Line 1524: l_processed_draft_id_tbl DBMS_SQL.number_table;

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;
1524: l_processed_draft_id_tbl DBMS_SQL.number_table;
1525: l_line_ref_tbl DBMS_SQL.number_table;
1526:
1527: -- maximal interface_line_location_id_processed
1528: l_max_intf_line_loc_id NUMBER := -1;

Line 1525: l_line_ref_tbl DBMS_SQL.number_table;

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;
1524: l_processed_draft_id_tbl DBMS_SQL.number_table;
1525: l_line_ref_tbl DBMS_SQL.number_table;
1526:
1527: -- maximal interface_line_location_id_processed
1528: l_max_intf_line_loc_id NUMBER := -1;
1529:

Line 2377: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;

2373: -- cursor variable to point to currently processing row
2374: l_attr_values_csr PO_PDOI_TYPES.intf_cursor_type;
2375:
2376: -- pl/sql table to track rows that needs to be created or updated
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;

Line 2390: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

2386:
2387: -- index for the loop
2388: l_index NUMBER;
2389:
2390: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
2391:
2392: BEGIN
2393: d_position := 0;
2394:

Line 2570: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;

2566: -- cursor variable to point to currently processing row
2567: l_attr_values_tlp_csr PO_PDOI_TYPES.intf_cursor_type;
2568:
2569: -- pl/sql table to track rows that needs to be created or updated
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;

Line 2580: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

2576:
2577: -- maximal interface_attr_values_tlp_id_processed
2578: l_max_intf_attr_values_tlp_id NUMBER := -1;
2579:
2580: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
2581: l_index NUMBER;
2582:
2583: BEGIN
2584: d_position := 0;