APPS.PO_LINE_LOCATIONS_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 128: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

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

Line 129: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 137: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

133: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
134: d_position NUMBER;
135:
136: l_distinct_id_list DBMS_SQL.NUMBER_TABLE;
137: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
138:
139: BEGIN
140: d_position := 0;
141: IF (PO_LOG.d_proc) THEN

Line 627: l_record_already_exist_tbl PO_TBL_VARCHAR1;

623: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
624: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
625: d_position NUMBER;
626:
627: l_record_already_exist_tbl PO_TBL_VARCHAR1;
628:
629: BEGIN
630: d_position := 0;
631: IF (PO_LOG.d_proc) THEN

Line 639: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

635:
636: sync_draft_from_txn
637: ( p_line_location_id_tbl => PO_TBL_NUMBER(p_line_location_id),
638: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
639: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
640: x_record_already_exist_tbl => l_record_already_exist_tbl
641: );
642:
643: x_record_already_exist := l_record_already_exist_tbl(1);