APPS.PO_DISTRIBUTIONS_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 92: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

88: ------------------------------------------------------------------------
89: PROCEDURE sync_draft_from_txn
90: ( p_po_distribution_id_tbl IN PO_TBL_NUMBER,
91: p_draft_id_tbl IN PO_TBL_NUMBER,
92: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
93: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
94: ) IS
95:
96: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';

Line 93: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 101: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 489: l_record_already_exist_tbl PO_TBL_VARCHAR1;

485: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
486: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
487: d_position NUMBER;
488:
489: l_record_already_exist_tbl PO_TBL_VARCHAR1;
490:
491: BEGIN
492: d_position := 0;
493: IF (PO_LOG.d_proc) THEN

Line 501: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

497:
498: sync_draft_from_txn
499: ( p_po_distribution_id_tbl => PO_TBL_NUMBER(p_po_distribution_id),
500: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
501: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
502: x_record_already_exist_tbl => l_record_already_exist_tbl
503: );
504:
505: x_record_already_exist := l_record_already_exist_tbl(1);