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 1039: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

1035: -- line grouping num
1036: l_group_num NUMBER := 0;
1037:
1038: -- variable to track records that have not been processed
1039: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
1040:
1041: -- variable to track lines that need to be expired
1042: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;
1043:

Line 1042: l_expire_line_id_tbl DBMS_SQL.NUMBER_TABLE;

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

Line 1371: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1367: ------------------------------------------------------------------------
1368: PROCEDURE process_create_lines_in_group
1369: (
1370: p_group_num IN NUMBER,
1371: p_expire_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1372: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
1373: ) IS
1374:
1375: d_api_name CONSTANT VARCHAR2(30) := 'process_create_lines_in_group';

Line 1686: l_processed_line_id_tbl DBMS_SQL.number_table;

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;
1687: l_processed_draft_id_tbl DBMS_SQL.number_table;
1688: l_line_ref_tbl DBMS_SQL.number_table;
1689:
1690: -- maximal interface_line_location_id_processed

Line 1687: l_processed_draft_id_tbl DBMS_SQL.number_table;

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;
1687: l_processed_draft_id_tbl DBMS_SQL.number_table;
1688: l_line_ref_tbl DBMS_SQL.number_table;
1689:
1690: -- maximal interface_line_location_id_processed
1691: l_max_intf_line_loc_id NUMBER := -1;

Line 1688: l_line_ref_tbl DBMS_SQL.number_table;

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;
1687: l_processed_draft_id_tbl DBMS_SQL.number_table;
1688: l_line_ref_tbl DBMS_SQL.number_table;
1689:
1690: -- maximal interface_line_location_id_processed
1691: l_max_intf_line_loc_id NUMBER := -1;
1692:

Line 2540: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;

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

Line 2553: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

2549:
2550: -- index for the loop
2551: l_index NUMBER;
2552:
2553: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
2554:
2555: BEGIN
2556: d_position := 0;
2557:

Line 2739: l_merge_row_tbl DBMS_SQL.NUMBER_TABLE;

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

Line 2749: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;

2745:
2746: -- maximal interface_attr_values_tlp_id_processed
2747: l_max_intf_attr_values_tlp_id NUMBER := -1;
2748:
2749: l_processing_row_tbl DBMS_SQL.NUMBER_TABLE;
2750: l_index NUMBER;
2751:
2752: BEGIN
2753: d_position := 0;