APPS.PO_LINES_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 129: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

125: ------------------------------------------------------------------------
126: PROCEDURE sync_draft_from_txn
127: ( p_po_line_id_tbl IN PO_TBL_NUMBER,
128: p_draft_id_tbl IN PO_TBL_NUMBER,
129: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
130: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
131: ) IS
132:
133: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';

Line 130: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

126: PROCEDURE sync_draft_from_txn
127: ( p_po_line_id_tbl IN PO_TBL_NUMBER,
128: p_draft_id_tbl IN PO_TBL_NUMBER,
129: p_delete_flag_tbl IN PO_TBL_VARCHAR1,
130: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1
131: ) IS
132:
133: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
134: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';

Line 138: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

134: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
135: d_position NUMBER;
136:
137: l_distinct_id_list DBMS_SQL.NUMBER_TABLE;
138: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
139: l_draft_type_tbl PO_TBL_VARCHAR30 := PO_TBL_VARCHAR30();
140:
141: BEGIN
142: d_position := 0;

Line 671: l_record_already_exist_tbl PO_TBL_VARCHAR1;

667: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
668: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
669: d_position NUMBER;
670:
671: l_record_already_exist_tbl PO_TBL_VARCHAR1;
672:
673: BEGIN
674: d_position := 0;
675: IF (PO_LOG.d_proc) THEN

Line 683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

679:
680: sync_draft_from_txn
681: ( p_po_line_id_tbl => PO_TBL_NUMBER(p_po_line_id),
682: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
683: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
684: x_record_already_exist_tbl => l_record_already_exist_tbl
685: );
686:
687: x_record_already_exist := l_record_already_exist_tbl(1);