APPS.PO_PRICE_ADJ_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 98: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

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:
102: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';

Line 99: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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:
102: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
103: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 107: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

103: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
104: d_position NUMBER;
105:
106: l_distinct_id_list DBMS_SQL.NUMBER_TABLE;
107: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
108:
109: BEGIN
110: d_position := 0;
111: IF (PO_LOG.d_proc) THEN

Line 475: l_record_already_exist_tbl PO_TBL_VARCHAR1;

471: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
472: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
473: d_position NUMBER;
474:
475: l_record_already_exist_tbl PO_TBL_VARCHAR1;
476: BEGIN
477: d_position := 0;
478: IF (PO_LOG.d_proc) THEN
479: PO_LOG.proc_begin(d_module);

Line 486: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

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:
490: x_record_already_exist := l_record_already_exist_tbl(1);

Line 543: l_record_already_exist_tbl PO_TBL_VARCHAR1;

539: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
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:

Line 546: l_delete_flag_tbl PO_TBL_VARCHAR1;

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;
550: IF (PO_LOG.d_proc) THEN