APPS.PO_PDOI_PREPROC_PVT dependencies on DBMS_SQL

Line 800: l_ordered_num_list DBMS_SQL.NUMBER_TABLE;

796:
797: l_column_name VARCHAR2(30);
798: l_token_value VARCHAR2(200);
799:
800: l_ordered_num_list DBMS_SQL.NUMBER_TABLE;
801:
802: BEGIN
803: d_position := 0;
804:

Line 2001: l_rowid_tbl DBMS_SQL.urowid_table;

1997: WHERE PLLI.processing_id = PO_PDOI_PARAMS.g_processing_id
1998: AND PLLI.interface_line_id = PLI.interface_line_id
1999: AND NVL(PLI.line_loc_populated_flag, 'N') = 'N';
2000:
2001: l_rowid_tbl DBMS_SQL.urowid_table;
2002: l_intf_line_tbl PO_TBL_NUMBER;
2003: l_intf_line_loc_tbl PO_TBL_NUMBER;
2004: -- << PDOI for Complex PO Project: Start >>
2005: l_is_complex_work_style BOOLEAN;

Line 3136: l_num_list DBMS_SQL.NUMBER_TABLE;

3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3135: -- table used to save the index of the each row
3136: l_num_list DBMS_SQL.NUMBER_TABLE;
3137: -- key of temp table used to identify the derived result
3138: l_key po_session_gt.key%TYPE;
3139: l_index_tbl PO_TBL_NUMBER;
3140: l_index NUMBER;

Line 3279: l_num_list DBMS_SQL.NUMBER_TABLE;

3275: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3276: d_position NUMBER;
3277: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3278: -- table used to save the index of the each row
3279: l_num_list DBMS_SQL.NUMBER_TABLE;
3280: -- key of temp table used to identify the derived result
3281: l_key po_session_gt.key%TYPE;
3282: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3283: l_index NUMBER;

Line 3379: l_num_list DBMS_SQL.NUMBER_TABLE;

3375: d_position NUMBER;
3376: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3377: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3378: -- table used to save the index of the each row
3379: l_num_list DBMS_SQL.NUMBER_TABLE;
3380: -- key of temp table used to identify the derived result
3381: l_key po_session_gt.key%TYPE;
3382: l_index NUMBER;
3383: BEGIN