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,
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:
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
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();
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 :=
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:
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;
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;
642: d_api_name CONSTANT VARCHAR2(30) := 'expire_lines_by_catalog_name';
643: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
644: d_position NUMBER;
645:
646: l_draft_id_tbl PO_TBL_NUMBER;
647: l_line_id_tbl PO_TBL_NUMBER;
648: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
649:
650: l_record_exist_tbl PO_TBL_VARCHAR1;
643: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
644: d_position NUMBER;
645:
646: l_draft_id_tbl PO_TBL_NUMBER;
647: l_line_id_tbl PO_TBL_NUMBER;
648: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
649:
650: l_record_exist_tbl PO_TBL_VARCHAR1;
651: BEGIN
729: --OUT:
730: --End of Comments
731: ------------------------------------------------------------------------
732: PROCEDURE init_doc_info_tbl
733: ( p_intf_header_id_tbl PO_TBL_NUMBER
734: ) IS
735:
736: d_api_name CONSTANT VARCHAR2(30) := 'init_doc_info_tbl';
737: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';