92: --Testing:
93: --End of Comments
94: ------------------------------------------------------------------------
95: PROCEDURE sync_draft_from_txn
96: ( p_price_adjustment_id_tbl IN PO_TBL_NUMBER,
97: p_draft_id_tbl IN PO_TBL_NUMBER,
98: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
99: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
100: ) IS
93: --End of Comments
94: ------------------------------------------------------------------------
95: PROCEDURE sync_draft_from_txn
96: ( p_price_adjustment_id_tbl IN PO_TBL_NUMBER,
97: p_draft_id_tbl IN PO_TBL_NUMBER,
98: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
99: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
100: ) IS
101:
480: PO_LOG.proc_begin(d_module, 'p_price_adjustment_id', p_price_adjustment_id);
481: END IF;
482:
483: sync_draft_from_txn
484: ( p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id),
485: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
486: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
487: x_record_already_exist_tbl => l_record_already_exist_tbl
488: );
481: END IF;
482:
483: sync_draft_from_txn
484: ( p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id),
485: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
486: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
487: x_record_already_exist_tbl => l_record_already_exist_tbl
488: );
489:
540: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
541: d_position NUMBER;
542:
543: l_record_already_exist_tbl PO_TBL_VARCHAR1;
544: l_price_adjustment_id_tbl PO_TBL_NUMBER;
545: l_draft_id_tbl PO_TBL_NUMBER;
546: l_delete_flag_tbl PO_TBL_VARCHAR1;
547:
548: BEGIN
541: d_position NUMBER;
542:
543: l_record_already_exist_tbl PO_TBL_VARCHAR1;
544: l_price_adjustment_id_tbl PO_TBL_NUMBER;
545: l_draft_id_tbl PO_TBL_NUMBER;
546: l_delete_flag_tbl PO_TBL_VARCHAR1;
547:
548: BEGIN
549: d_position := 0;