APPS.PO_ATTR_VALUES_TLP_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_attribute_values_tlp_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_attribute_values_tlp_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 583: l_record_already_exist_tbl PO_TBL_VARCHAR1;

579: d_api_name CONSTANT VARCHAR2(30) := 'sync_draft_from_txn';
580: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
581: d_position NUMBER;
582:
583: l_record_already_exist_tbl PO_TBL_VARCHAR1;
584:
585: BEGIN
586: d_position := 0;
587: IF (PO_LOG.d_proc) THEN

Line 596: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),

592:
593: sync_draft_from_txn
594: ( p_attribute_values_tlp_id_tbl => PO_TBL_NUMBER(p_attribute_values_tlp_id),
595: p_draft_id_tbl => PO_TBL_NUMBER(p_draft_id),
596: p_delete_flag_tbl => PO_TBL_VARCHAR1(p_delete_flag),
597: x_record_already_exist_tbl => l_record_already_exist_tbl
598: );
599:
600: x_record_already_exist := l_record_already_exist_tbl(1);