DBA Data[Home] [Help]

APPS.PO_PRICE_ADJ_DRAFT_PKG dependencies on PO_TBL_NUMBER

Line 96: ( p_price_adjustment_id_tbl IN PO_TBL_NUMBER,

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

Line 97: p_draft_id_tbl IN PO_TBL_NUMBER,

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:

Line 484: ( p_price_adjustment_id_tbl => PO_TBL_NUMBER(p_price_adjustment_id),

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: );

Line 485: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_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: );
489:

Line 544: l_price_adjustment_id_tbl PO_TBL_NUMBER;

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

Line 545: l_draft_id_tbl PO_TBL_NUMBER;

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;