APPS.QP_QUALIFIER_RULES_UTIL dependencies on QP_QUALIFIER_RULES_UTIL

Line 1: PACKAGE BODY QP_Qualifier_Rules_Util AS

1: PACKAGE BODY QP_Qualifier_Rules_Util AS
2: /* $Header: QPXUQPRB.pls 120.1 2005/06/13 05:19:49 appldev $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUQPRB.pls 120.1 2005/06/13 05:19:49 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Qualifier_Rules_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 35: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;

31:
32: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute1,p_old_QUALIFIER_RULES_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
35: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;
36: END IF;
37:
38: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,p_old_QUALIFIER_RULES_rec.attribute10)
39: THEN

Line 41: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;

37:
38: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute10,p_old_QUALIFIER_RULES_rec.attribute10)
39: THEN
40: l_index := l_index + 1;
41: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;
42: END IF;
43:
44: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,p_old_QUALIFIER_RULES_rec.attribute11)
45: THEN

Line 47: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;

43:
44: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute11,p_old_QUALIFIER_RULES_rec.attribute11)
45: THEN
46: l_index := l_index + 1;
47: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;
48: END IF;
49:
50: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,p_old_QUALIFIER_RULES_rec.attribute12)
51: THEN

Line 53: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;

49:
50: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute12,p_old_QUALIFIER_RULES_rec.attribute12)
51: THEN
52: l_index := l_index + 1;
53: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;
54: END IF;
55:
56: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,p_old_QUALIFIER_RULES_rec.attribute13)
57: THEN

Line 59: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;

55:
56: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute13,p_old_QUALIFIER_RULES_rec.attribute13)
57: THEN
58: l_index := l_index + 1;
59: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;
60: END IF;
61:
62: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,p_old_QUALIFIER_RULES_rec.attribute14)
63: THEN

Line 65: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;

61:
62: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute14,p_old_QUALIFIER_RULES_rec.attribute14)
63: THEN
64: l_index := l_index + 1;
65: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;
66: END IF;
67:
68: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,p_old_QUALIFIER_RULES_rec.attribute15)
69: THEN

Line 71: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;

67:
68: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute15,p_old_QUALIFIER_RULES_rec.attribute15)
69: THEN
70: l_index := l_index + 1;
71: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;
72: END IF;
73:
74: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,p_old_QUALIFIER_RULES_rec.attribute2)
75: THEN

Line 77: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;

73:
74: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute2,p_old_QUALIFIER_RULES_rec.attribute2)
75: THEN
76: l_index := l_index + 1;
77: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;
78: END IF;
79:
80: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,p_old_QUALIFIER_RULES_rec.attribute3)
81: THEN

Line 83: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;

79:
80: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute3,p_old_QUALIFIER_RULES_rec.attribute3)
81: THEN
82: l_index := l_index + 1;
83: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;
84: END IF;
85:
86: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,p_old_QUALIFIER_RULES_rec.attribute4)
87: THEN

Line 89: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;

85:
86: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute4,p_old_QUALIFIER_RULES_rec.attribute4)
87: THEN
88: l_index := l_index + 1;
89: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;
90: END IF;
91:
92: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,p_old_QUALIFIER_RULES_rec.attribute5)
93: THEN

Line 95: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;

91:
92: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute5,p_old_QUALIFIER_RULES_rec.attribute5)
93: THEN
94: l_index := l_index + 1;
95: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;
96: END IF;
97:
98: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,p_old_QUALIFIER_RULES_rec.attribute6)
99: THEN

Line 101: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;

97:
98: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute6,p_old_QUALIFIER_RULES_rec.attribute6)
99: THEN
100: l_index := l_index + 1;
101: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;
102: END IF;
103:
104: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,p_old_QUALIFIER_RULES_rec.attribute7)
105: THEN

Line 107: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;

103:
104: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute7,p_old_QUALIFIER_RULES_rec.attribute7)
105: THEN
106: l_index := l_index + 1;
107: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;
108: END IF;
109:
110: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,p_old_QUALIFIER_RULES_rec.attribute8)
111: THEN

Line 113: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;

109:
110: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute8,p_old_QUALIFIER_RULES_rec.attribute8)
111: THEN
112: l_index := l_index + 1;
113: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;
114: END IF;
115:
116: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,p_old_QUALIFIER_RULES_rec.attribute9)
117: THEN

Line 119: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;

115:
116: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.attribute9,p_old_QUALIFIER_RULES_rec.attribute9)
117: THEN
118: l_index := l_index + 1;
119: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;
120: END IF;
121:
122: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,p_old_QUALIFIER_RULES_rec.context)
123: THEN

Line 125: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;

121:
122: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.context,p_old_QUALIFIER_RULES_rec.context)
123: THEN
124: l_index := l_index + 1;
125: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;
126: END IF;
127:
128: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,p_old_QUALIFIER_RULES_rec.created_by)
129: THEN

Line 131: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;

127:
128: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.created_by,p_old_QUALIFIER_RULES_rec.created_by)
129: THEN
130: l_index := l_index + 1;
131: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;
132: END IF;
133:
134: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,p_old_QUALIFIER_RULES_rec.creation_date)
135: THEN

Line 137: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;

133:
134: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.creation_date,p_old_QUALIFIER_RULES_rec.creation_date)
135: THEN
136: l_index := l_index + 1;
137: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;
138: END IF;
139:
140: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)
141: THEN

Line 143: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;

139:
140: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.description,p_old_QUALIFIER_RULES_rec.description)
141: THEN
142: l_index := l_index + 1;
143: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
144: END IF;
145:
146: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)
147: THEN

Line 149: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;

145:
146: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_updated_by,p_old_QUALIFIER_RULES_rec.last_updated_by)
147: THEN
148: l_index := l_index + 1;
149: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
150: END IF;
151:
152: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)
153: THEN

Line 155: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;

151:
152: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_date,p_old_QUALIFIER_RULES_rec.last_update_date)
153: THEN
154: l_index := l_index + 1;
155: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
156: END IF;
157:
158: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)
159: THEN

Line 161: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;

157:
158: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.last_update_login,p_old_QUALIFIER_RULES_rec.last_update_login)
159: THEN
160: l_index := l_index + 1;
161: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
162: END IF;
163:
164: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)
165: THEN

Line 167: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;

163:
164: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.name,p_old_QUALIFIER_RULES_rec.name)
165: THEN
166: l_index := l_index + 1;
167: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
168: END IF;
169:
170: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,p_old_QUALIFIER_RULES_rec.program_application_id)
171: THEN

Line 173: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;

169:
170: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_application_id,p_old_QUALIFIER_RULES_rec.program_application_id)
171: THEN
172: l_index := l_index + 1;
173: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;
174: END IF;
175:
176: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,p_old_QUALIFIER_RULES_rec.program_id)
177: THEN

Line 179: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;

175:
176: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_id,p_old_QUALIFIER_RULES_rec.program_id)
177: THEN
178: l_index := l_index + 1;
179: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;
180: END IF;
181:
182: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,p_old_QUALIFIER_RULES_rec.program_update_date)
183: THEN

Line 185: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;

181:
182: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.program_update_date,p_old_QUALIFIER_RULES_rec.program_update_date)
183: THEN
184: l_index := l_index + 1;
185: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;
186: END IF;
187:
188: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
189: THEN

Line 191: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;

187:
188: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.qualifier_rule_id,p_old_QUALIFIER_RULES_rec.qualifier_rule_id)
189: THEN
190: l_index := l_index + 1;
191: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
192: END IF;
193:
194: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)
195: THEN

Line 197: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;

193:
194: IF NOT QP_GLOBALS.Equal(p_QUALIFIER_RULES_rec.request_id,p_old_QUALIFIER_RULES_rec.request_id)
195: THEN
196: l_index := l_index + 1;
197: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;
198: END IF;
199:
200: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
201: l_index := l_index + 1;

Line 202: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;

198: END IF;
199:
200: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;
203: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;
206: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 205: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;

201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE1;
203: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;
206: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;
209: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 208: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;

204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE10;
206: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;
209: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;
212: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 211: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;

207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE11;
209: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;
212: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;
215: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 214: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;

210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE12;
212: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;
215: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;
218: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 217: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;

213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE13;
215: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;
218: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;
221: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 220: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;

216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE14;
218: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;
221: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;
224: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 223: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;

219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE15;
221: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;
224: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;
227: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 226: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;

222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE2;
224: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;
227: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;
230: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 229: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;

225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE3;
227: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;
230: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;
233: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 232: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;

228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE4;
230: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;
233: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;
236: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 235: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;

231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE5;
233: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;
236: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;
239: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 238: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;

234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE6;
236: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;
239: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;
242: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 241: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;

237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE7;
239: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;
242: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;
245: ELSIF p_attr_id = G_CONTEXT THEN

Line 244: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;

240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE8;
242: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;
245: ELSIF p_attr_id = G_CONTEXT THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;
248: ELSIF p_attr_id = G_CREATED_BY THEN

Line 247: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;

243: l_index := l_index + 1;
244: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_ATTRIBUTE9;
245: ELSIF p_attr_id = G_CONTEXT THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;
248: ELSIF p_attr_id = G_CREATED_BY THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;
251: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 250: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;

246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CONTEXT;
248: ELSIF p_attr_id = G_CREATED_BY THEN
249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;
251: ELSIF p_attr_id = G_CREATION_DATE THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;
254: ELSIF p_attr_id = G_DESCRIPTION THEN

Line 253: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;

249: l_index := l_index + 1;
250: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATED_BY;
251: ELSIF p_attr_id = G_CREATION_DATE THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;
254: ELSIF p_attr_id = G_DESCRIPTION THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
257: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 256: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;

252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_CREATION_DATE;
254: ELSIF p_attr_id = G_DESCRIPTION THEN
255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
257: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
260: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 259: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;

255: l_index := l_index + 1;
256: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_DESCRIPTION;
257: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
260: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
263: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 262: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;

258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATED_BY;
260: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
263: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
266: ELSIF p_attr_id = G_NAME THEN

Line 265: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;

261: l_index := l_index + 1;
262: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_DATE;
263: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
266: ELSIF p_attr_id = G_NAME THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 268: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;

264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_LAST_UPDATE_LOGIN;
266: ELSIF p_attr_id = G_NAME THEN
267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN

Line 271: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;

267: l_index := l_index + 1;
268: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_NAME;
269: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 274: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;

270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_APPLICATION;
272: ELSIF p_attr_id = G_PROGRAM THEN
273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_QUALIFIER_RULE THEN

Line 277: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;

273: l_index := l_index + 1;
274: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM;
275: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
281: ELSIF p_attr_id = G_REQUEST THEN

Line 280: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;

276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_PROGRAM_UPDATE_DATE;
278: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
281: ELSIF p_attr_id = G_REQUEST THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;
284: END IF;

Line 283: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;

279: l_index := l_index + 1;
280: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_QUALIFIER_RULE;
281: ELSIF p_attr_id = G_REQUEST THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_QUALIFIER_RULES_UTIL.G_REQUEST;
284: END IF;
285:
286: END Clear_Dependent_Attr;
287:

Line 1247: END QP_Qualifier_Rules_Util;

1243: RETURN l_QUALIFIER_RULES_rec;
1244:
1245: END Get_Ids;
1246:
1247: END QP_Qualifier_Rules_Util;