APPS.PO_PDOI_HEADER_GROUPING_PVT dependencies on PO_TBL_NUMBER

Line 20: ( p_intf_header_id_tbl PO_TBL_NUMBER

16:
17: PROCEDURE expire_lines_by_catalog_name;
18:
19: PROCEDURE init_doc_info_tbl
20: ( p_intf_header_id_tbl PO_TBL_NUMBER
21: );
22:
23: PROCEDURE check_new_draft_needed
24: ( p_draft_id IN NUMBER,

Line 144: l_intf_header_id_tbl PO_TBL_NUMBER;

140: d_position NUMBER;
141:
142: l_process_update_replace BOOLEAN := FALSE;
143:
144: l_intf_header_id_tbl PO_TBL_NUMBER;
145: l_po_header_id_tbl PO_TBL_NUMBER;
146:
147: l_process_list DBMS_SQL.NUMBER_TABLE;
148:

Line 145: l_po_header_id_tbl PO_TBL_NUMBER;

141:
142: l_process_update_replace BOOLEAN := FALSE;
143:
144: l_intf_header_id_tbl PO_TBL_NUMBER;
145: l_po_header_id_tbl PO_TBL_NUMBER;
146:
147: l_process_list DBMS_SQL.NUMBER_TABLE;
148:
149: BEGIN

Line 323: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

319: d_api_name CONSTANT VARCHAR2(30) := 'assign_draft_id';
320: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
321: d_position NUMBER;
322:
323: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
324: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
325:
326: l_new_dft_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=
327: PO_PDOI_UTL.pls_integer_tbl_type();

Line 324: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();

320: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
321: d_position NUMBER;
322:
323: l_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
324: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
325:
326: l_new_dft_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=
327: PO_PDOI_UTL.pls_integer_tbl_type();
328: l_existing_dft_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=

Line 331: l_intf_header_id_tbl PO_TBL_NUMBER;

327: PO_PDOI_UTL.pls_integer_tbl_type();
328: l_existing_dft_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=
329: PO_PDOI_UTL.pls_integer_tbl_type();
330:
331: l_intf_header_id_tbl PO_TBL_NUMBER;
332: l_po_header_id_tbl PO_TBL_NUMBER;
333: l_action_tbl PO_TBL_VARCHAR30;
334: l_revision_num_tbl PO_TBL_NUMBER;
335:

Line 332: l_po_header_id_tbl PO_TBL_NUMBER;

328: l_existing_dft_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=
329: PO_PDOI_UTL.pls_integer_tbl_type();
330:
331: l_intf_header_id_tbl PO_TBL_NUMBER;
332: l_po_header_id_tbl PO_TBL_NUMBER;
333: l_action_tbl PO_TBL_VARCHAR30;
334: l_revision_num_tbl PO_TBL_NUMBER;
335:
336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;

Line 334: l_revision_num_tbl PO_TBL_NUMBER;

330:
331: l_intf_header_id_tbl PO_TBL_NUMBER;
332: l_po_header_id_tbl PO_TBL_NUMBER;
333: l_action_tbl PO_TBL_VARCHAR30;
334: l_revision_num_tbl PO_TBL_NUMBER;
335:
336: l_tmp_draft_id PO_DRAFTS.draft_id%TYPE;
337: l_tmp_draft_status PO_DRAFTS.status%TYPE;
338: l_tmp_draft_owner_role PO_DRAFTS.owner_role%TYPE;

Line 627: l_draft_id_tbl PO_TBL_NUMBER;

623: d_api_name CONSTANT VARCHAR2(30) := 'expire_lines_by_catalog_name';
624: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
625: d_position NUMBER;
626:
627: l_draft_id_tbl PO_TBL_NUMBER;
628: l_line_id_tbl PO_TBL_NUMBER;
629: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
630:
631: l_record_exist_tbl PO_TBL_VARCHAR1;

Line 628: l_line_id_tbl PO_TBL_NUMBER;

624: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
625: d_position NUMBER;
626:
627: l_draft_id_tbl PO_TBL_NUMBER;
628: l_line_id_tbl PO_TBL_NUMBER;
629: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
630:
631: l_record_exist_tbl PO_TBL_VARCHAR1;
632: BEGIN

Line 714: ( p_intf_header_id_tbl PO_TBL_NUMBER

710: --OUT:
711: --End of Comments
712: ------------------------------------------------------------------------
713: PROCEDURE init_doc_info_tbl
714: ( p_intf_header_id_tbl PO_TBL_NUMBER
715: ) IS
716:
717: d_api_name CONSTANT VARCHAR2(30) := 'init_doc_info_tbl';
718: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';