APPS.PO_PRICE_DIFF_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 96: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

92: ------------------------------------------------------------------------
93: PROCEDURE sync_draft_from_txn
94: ( p_price_differential_id_tbl IN PO_TBL_NUMBER,
95: p_draft_id_tbl IN PO_TBL_NUMBER,
96: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
97: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
98: ) IS
99:
100: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';

Line 97: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

93: PROCEDURE sync_draft_from_txn
94: ( p_price_differential_id_tbl IN PO_TBL_NUMBER,
95: p_draft_id_tbl IN PO_TBL_NUMBER,
96: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
97: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
98: ) IS
99:
100: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
101: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 105: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

101: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
102: d_position NUMBER;
103:
104: l_distinct_id_list DBMS_SQL.NUMBER_TABLE;
105: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
106:
107:
108: BEGIN
109: d_position := 0;

Line 268: l_record_already_exist_tbl PO_TBL_VARCHAR1;

264: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
265: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
266: d_position NUMBER;
267:
268: l_record_already_exist_tbl PO_TBL_VARCHAR1;
269:
270: BEGIN
271: d_position := 0;
272: IF (PO_LOG.d_proc) THEN

Line 281: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

277:
278: sync_draft_from_txn
279: ( p_price_differential_id_tbl => PO_TBL_NUMBER(p_price_differential_id),
280: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
281: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
282: x_record_already_exist_tbl => l_record_already_exist_tbl
283: );
284:
285: x_record_already_exist := l_record_already_exist_tbl(1);