APPS.PO_GA_ORG_ASSIGN_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_org_assignment_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_org_assignment_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: BEGIN
108: d_position := 0;
109: IF (PO_LOG.d_proc) THEN

Line 261: l_record_already_exist_tbl PO_TBL_VARCHAR1;

257: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
258: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
259: d_position NUMBER;
260:
261: l_record_already_exist_tbl PO_TBL_VARCHAR1;
262:
263: BEGIN
264: d_position := 0;
265: IF (PO_LOG.d_proc) THEN

Line 273: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

269:
270: sync_draft_from_txn
271: ( p_org_assignment_id_tbl => PO_TBL_NUMBER(p_org_assignment_id),
272: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
273: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
274: x_record_already_exist_tbl => l_record_already_exist_tbl
275: );
276:
277: x_record_already_exist := l_record_already_exist_tbl(1);