APPS.QP_PTE_UTIL dependencies on QP_PTE_UTIL

Line 1: PACKAGE BODY QP_Pte_Util AS

1: PACKAGE BODY QP_Pte_Util AS
2: /* $Header: QPXUPTEB.pls 120.1 2005/06/12 23:51:52 appldev $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Pte_Util';

2: /* $Header: QPXUPTEB.pls 120.1 2005/06/12 23:51:52 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Pte_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_DESCRIPTION;

31:
32: IF NOT QP_GLOBALS.Equal(p_PTE_rec.description,p_old_PTE_rec.description)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_DESCRIPTION;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_PTE_rec.enabled_flag,p_old_PTE_rec.enabled_flag)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;

37:
38: IF NOT QP_GLOBALS.Equal(p_PTE_rec.enabled_flag,p_old_PTE_rec.enabled_flag)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_PTE_rec.end_date_active,p_old_PTE_rec.end_date_active)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;

43:
44: IF NOT QP_GLOBALS.Equal(p_PTE_rec.end_date_active,p_old_PTE_rec.end_date_active)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_PTE_rec.lookup_code,p_old_PTE_rec.lookup_code)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;

49:
50: IF NOT QP_GLOBALS.Equal(p_PTE_rec.lookup_code,p_old_PTE_rec.lookup_code)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_PTE_rec.lookup_type,p_old_PTE_rec.lookup_type)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;

55:
56: IF NOT QP_GLOBALS.Equal(p_PTE_rec.lookup_type,p_old_PTE_rec.lookup_type)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_PTE_rec.meaning,p_old_PTE_rec.meaning)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;

61:
62: IF NOT QP_GLOBALS.Equal(p_PTE_rec.meaning,p_old_PTE_rec.meaning)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_PTE_rec.start_date_active,p_old_PTE_rec.start_date_active)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_START_DATE_ACTIVE;

67:
68: IF NOT QP_GLOBALS.Equal(p_PTE_rec.start_date_active,p_old_PTE_rec.start_date_active)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_START_DATE_ACTIVE;
72: END IF;
73:
74: ELSIF p_attr_id = G_DESCRIPTION THEN
75: l_index := l_index + 1;

Line 76: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_DESCRIPTION;

72: END IF;
73:
74: ELSIF p_attr_id = G_DESCRIPTION THEN
75: l_index := l_index + 1;
76: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_DESCRIPTION;
77: ELSIF p_attr_id = G_ENABLED THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;
80: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 79: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;

75: l_index := l_index + 1;
76: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_DESCRIPTION;
77: ELSIF p_attr_id = G_ENABLED THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;
80: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;
83: ELSIF p_attr_id = G_LOOKUP THEN

Line 82: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;

78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_ENABLED;
80: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;
83: ELSIF p_attr_id = G_LOOKUP THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;
86: ELSIF p_attr_id = G_LOOKUP_TYPE THEN

Line 85: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;

81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_END_DATE_ACTIVE;
83: ELSIF p_attr_id = G_LOOKUP THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;
86: ELSIF p_attr_id = G_LOOKUP_TYPE THEN
87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;
89: ELSIF p_attr_id = G_MEANING THEN

Line 88: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;

84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP;
86: ELSIF p_attr_id = G_LOOKUP_TYPE THEN
87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;
89: ELSIF p_attr_id = G_MEANING THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;
92: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 91: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;

87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_LOOKUP_TYPE;
89: ELSIF p_attr_id = G_MEANING THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;
92: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
93: l_index := l_index + 1;
94: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_START_DATE_ACTIVE;
95: END IF;

Line 94: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_START_DATE_ACTIVE;

90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_MEANING;
92: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
93: l_index := l_index + 1;
94: l_src_attr_tbl(l_index) := QP_PTE_UTIL.G_START_DATE_ACTIVE;
95: END IF;
96:
97: END Clear_Dependent_Attr;
98:

Line 627: END QP_Pte_Util;

623: RETURN l_PTE_rec;
624:
625: END Get_Ids;
626:
627: END QP_Pte_Util;