DBA Data[Home] [Help]

APPS.PO_ATTR_VALUES_TLP_DRAFT_PVT dependencies on PO_TBL_VARCHAR1

Line 42: ) RETURN PO_TBL_VARCHAR1

38: ------------------------------------------------------------------------
39: FUNCTION draft_changes_exist
40: ( p_draft_id_tbl IN PO_TBL_NUMBER,
41: p_attribute_values_tlp_id_tbl IN PO_TBL_NUMBER
42: ) RETURN PO_TBL_VARCHAR1
43: IS
44: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
45: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
46: d_position NUMBER;

Line 50: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

46: d_position NUMBER;
47:
48: l_key NUMBER;
49: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
50: l_dft_exists_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
51: l_dft_exists_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
52:
53: BEGIN
54: d_position := 0;

Line 161: l_exists_tbl PO_TBL_VARCHAR1;

157: d_api_name CONSTANT VARCHAR2(30) := 'draft_changes_exist';
158: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
159: d_position NUMBER;
160:
161: l_exists_tbl PO_TBL_VARCHAR1;
162: BEGIN
163: d_position := 0;
164: IF (PO_LOG.d_proc) THEN
165: PO_LOG.proc_begin(d_module);