APPS.PO_NOTIFICATION_CTRL_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 95: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

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

Line 96: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 104: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 302: l_record_already_exist_tbl PO_TBL_VARCHAR1;

298: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
299: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
300: d_position NUMBER;
301:
302: l_record_already_exist_tbl PO_TBL_VARCHAR1;
303:
304: BEGIN
305: d_position := 0;
306: IF (PO_LOG.d_proc) THEN

Line 314: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

310:
311: sync_draft_from_txn
312: ( p_notification_id_tbl => PO_TBL_NUMBER(p_notification_id),
313: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
314: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
315: x_record_already_exist_tbl => l_record_already_exist_tbl
316: );
317:
318: x_record_already_exist := l_record_already_exist_tbl(1);