37:
38: d_api_name CONSTANT VARCHAR2(30) := 'delete_rows';
39: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
40: d_position NUMBER;
41: po_line_ids_tbl PO_TBL_NUMBER;
42:
43: BEGIN
44: d_position := 0;
45: IF (PO_LOG.d_proc) THEN
123: --Testing:
124: --End of Comments
125: ------------------------------------------------------------------------
126: PROCEDURE sync_draft_from_txn
127: ( p_po_line_id_tbl IN PO_TBL_NUMBER,
128: p_draft_id_tbl IN PO_TBL_NUMBER,
129: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
130: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
131: ) IS
124: --End of Comments
125: ------------------------------------------------------------------------
126: PROCEDURE sync_draft_from_txn
127: ( p_po_line_id_tbl IN PO_TBL_NUMBER,
128: p_draft_id_tbl IN PO_TBL_NUMBER,
129: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
130: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
131: ) IS
132:
677: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
678: END IF;
679:
680: sync_draft_from_txn
681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),
682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
684: x_record_already_exist_tbl => l_record_already_exist_tbl
685: );
678: END IF;
679:
680: sync_draft_from_txn
681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),
682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
684: x_record_already_exist_tbl => l_record_already_exist_tbl
685: );
686:
729: ( p_draft_id IN NUMBER,
730: p_draft_type PO_DRAFTS.draft_type%TYPE DEFAULT NULL
731: ) IS
732:
733: l_line_id_tbl PO_TBL_NUMBER;
734: d_api_name CONSTANT VARCHAR2(30) := 'merge_changes';
735: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
736: d_position NUMBER;
737: