APPS.PO_ATTR_VALUES_DRAFT_PKG dependencies on PO_TBL_VARCHAR1

Line 94: p_delete_flag_tbl IN PO_TBL_VARCHAR1,

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

Line 95: x_record_already_exist_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

Line 103: l_duplicate_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 886: l_record_already_exist_tbl PO_TBL_VARCHAR1;

882: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
883: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
884: d_position NUMBER;
885:
886: l_record_already_exist_tbl PO_TBL_VARCHAR1;
887:
888: BEGIN
889: d_position := 0;
890: IF (PO_LOG.d_proc) THEN

Line 898: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

894:
895: sync_draft_from_txn
896: ( p_attribute_values_id_tbl => PO_TBL_NUMBER(p_attribute_values_id),
897: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
898: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
899: x_record_already_exist_tbl => l_record_already_exist_tbl
900: );
901:
902: x_record_already_exist := l_record_already_exist_tbl(1);