DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_QUALIFIERS_UTIL

Line 1: PACKAGE BODY QP_Qualifiers_Util AS

1: PACKAGE BODY QP_Qualifiers_Util AS
2: /* $Header: QPXUQPQB.pls 120.16.12020000.2 2013/03/01 06:14:54 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXUQPQB.pls 120.16.12020000.2 2013/03/01 06:14:54 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Qualifiers_Util';
7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr

Line 52: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;

48:
49: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,p_old_QUALIFIERS_rec.attribute1)
50: THEN
51: l_index := l_index + 1;
52: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
53: END IF;
54:
55: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,p_old_QUALIFIERS_rec.attribute10)
56: THEN

Line 58: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;

54:
55: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,p_old_QUALIFIERS_rec.attribute10)
56: THEN
57: l_index := l_index + 1;
58: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
59: END IF;
60:
61: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,p_old_QUALIFIERS_rec.attribute11)
62: THEN

Line 64: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;

60:
61: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,p_old_QUALIFIERS_rec.attribute11)
62: THEN
63: l_index := l_index + 1;
64: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
65: END IF;
66:
67: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,p_old_QUALIFIERS_rec.attribute12)
68: THEN

Line 70: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;

66:
67: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,p_old_QUALIFIERS_rec.attribute12)
68: THEN
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
71: END IF;
72:
73: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,p_old_QUALIFIERS_rec.attribute13)
74: THEN

Line 76: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;

72:
73: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,p_old_QUALIFIERS_rec.attribute13)
74: THEN
75: l_index := l_index + 1;
76: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
77: END IF;
78:
79: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,p_old_QUALIFIERS_rec.attribute14)
80: THEN

Line 82: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;

78:
79: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,p_old_QUALIFIERS_rec.attribute14)
80: THEN
81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
83: END IF;
84:
85: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,p_old_QUALIFIERS_rec.attribute15)
86: THEN

Line 88: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;

84:
85: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,p_old_QUALIFIERS_rec.attribute15)
86: THEN
87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
89: END IF;
90:
91: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,p_old_QUALIFIERS_rec.attribute2)
92: THEN

Line 94: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;

90:
91: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,p_old_QUALIFIERS_rec.attribute2)
92: THEN
93: l_index := l_index + 1;
94: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
95: END IF;
96:
97: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,p_old_QUALIFIERS_rec.attribute3)
98: THEN

Line 100: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;

96:
97: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,p_old_QUALIFIERS_rec.attribute3)
98: THEN
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
101: END IF;
102:
103: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,p_old_QUALIFIERS_rec.attribute4)
104: THEN

Line 106: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;

102:
103: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,p_old_QUALIFIERS_rec.attribute4)
104: THEN
105: l_index := l_index + 1;
106: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
107: END IF;
108:
109: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,p_old_QUALIFIERS_rec.attribute5)
110: THEN

Line 112: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;

108:
109: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,p_old_QUALIFIERS_rec.attribute5)
110: THEN
111: l_index := l_index + 1;
112: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
113: END IF;
114:
115: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,p_old_QUALIFIERS_rec.attribute6)
116: THEN

Line 118: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;

114:
115: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,p_old_QUALIFIERS_rec.attribute6)
116: THEN
117: l_index := l_index + 1;
118: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
119: END IF;
120:
121: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,p_old_QUALIFIERS_rec.attribute7)
122: THEN

Line 124: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;

120:
121: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,p_old_QUALIFIERS_rec.attribute7)
122: THEN
123: l_index := l_index + 1;
124: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
125: END IF;
126:
127: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,p_old_QUALIFIERS_rec.attribute8)
128: THEN

Line 130: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;

126:
127: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,p_old_QUALIFIERS_rec.attribute8)
128: THEN
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
131: END IF;
132:
133: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,p_old_QUALIFIERS_rec.attribute9)
134: THEN

Line 136: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;

132:
133: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,p_old_QUALIFIERS_rec.attribute9)
134: THEN
135: l_index := l_index + 1;
136: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
137: END IF;
138:
139: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,p_old_QUALIFIERS_rec.comparison_operator_code)
140: THEN

Line 142: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;

138:
139: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,p_old_QUALIFIERS_rec.comparison_operator_code)
140: THEN
141: l_index := l_index + 1;
142: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
143: END IF;
144:
145: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,p_old_QUALIFIERS_rec.context)
146: THEN

Line 148: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;

144:
145: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,p_old_QUALIFIERS_rec.context)
146: THEN
147: l_index := l_index + 1;
148: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
149: END IF;
150:
151: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,p_old_QUALIFIERS_rec.created_by)
152: THEN

Line 154: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;

150:
151: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,p_old_QUALIFIERS_rec.created_by)
152: THEN
153: l_index := l_index + 1;
154: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
155: END IF;
156:
157: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,p_old_QUALIFIERS_rec.created_from_rule_id)
158: THEN

Line 160: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;

156:
157: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,p_old_QUALIFIERS_rec.created_from_rule_id)
158: THEN
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
161: END IF;
162:
163: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,p_old_QUALIFIERS_rec.creation_date)
164: THEN

Line 166: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;

162:
163: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,p_old_QUALIFIERS_rec.creation_date)
164: THEN
165: l_index := l_index + 1;
166: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
167: END IF;
168:
169: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,p_old_QUALIFIERS_rec.end_date_active)
170: THEN

Line 172: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;

168:
169: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,p_old_QUALIFIERS_rec.end_date_active)
170: THEN
171: l_index := l_index + 1;
172: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
173: END IF;
174:
175: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,p_old_QUALIFIERS_rec.excluder_flag)
176: THEN

Line 178: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;

174:
175: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,p_old_QUALIFIERS_rec.excluder_flag)
176: THEN
177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
179: END IF;
180:
181: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
182: THEN

Line 184: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

180:
181: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
182: THEN
183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
185: END IF;
186:
187: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
188: THEN

Line 190: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

186:
187: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
188: THEN
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
191: END IF;
192:
193: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
194: THEN

Line 196: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

192:
193: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
194: THEN
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
197: END IF;
198:
199: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,p_old_QUALIFIERS_rec.list_header_id)
200: THEN

Line 202: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;

198:
199: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,p_old_QUALIFIERS_rec.list_header_id)
200: THEN
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
203: END IF;
204:
205: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,p_old_QUALIFIERS_rec.list_line_id)
206: THEN

Line 208: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;

204:
205: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,p_old_QUALIFIERS_rec.list_line_id)
206: THEN
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
209: END IF;
210:
211: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,p_old_QUALIFIERS_rec.program_application_id)
212: THEN

Line 214: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;

210:
211: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,p_old_QUALIFIERS_rec.program_application_id)
212: THEN
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
215: END IF;
216:
217: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,p_old_QUALIFIERS_rec.program_id)
218: THEN

Line 220: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;

216:
217: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,p_old_QUALIFIERS_rec.program_id)
218: THEN
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
221: END IF;
222:
223: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
224: THEN

Line 226: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

222:
223: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
224: THEN
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
227: END IF;
228:
229: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,p_old_QUALIFIERS_rec.qualifier_attribute)
230: THEN

Line 232: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;

228:
229: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,p_old_QUALIFIERS_rec.qualifier_attribute)
230: THEN
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
233: END IF;
234:
235: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
236: THEN

Line 238: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;

234:
235: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
236: THEN
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
239: END IF;
240:
241:
242: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)

Line 245: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;

241:
242: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)
243: THEN
244: l_index := l_index + 1;
245: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
246: END IF;
247:
248:
249:

Line 255: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;

251:
252: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,p_old_QUALIFIERS_rec.qualifier_context)
253: THEN
254: l_index := l_index + 1;
255: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
256: END IF;
257:
258: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,p_old_QUALIFIERS_rec.qualifier_datatype)
259: THEN

Line 261: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;

257:
258: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,p_old_QUALIFIERS_rec.qualifier_datatype)
259: THEN
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
262: END IF;
263:
264: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,p_old_QUALIFIERS_rec.qualifier_date_format)
265: THEN

Line 267: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;

263:
264: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,p_old_QUALIFIERS_rec.qualifier_date_format)
265: THEN
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
268: END IF;*/
269:
270: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,p_old_QUALIFIERS_rec.qualifier_grouping_no)
271: THEN

Line 273: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;

269:
270: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,p_old_QUALIFIERS_rec.qualifier_grouping_no)
271: THEN
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
274: END IF;
275:
276: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,p_old_QUALIFIERS_rec.qualifier_id)
277: THEN

Line 279: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;

275:
276: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,p_old_QUALIFIERS_rec.qualifier_id)
277: THEN
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
280: END IF;
281:
282: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,p_old_QUALIFIERS_rec.qualifier_number_format)
283: THEN

Line 285: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;

281:
282: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,p_old_QUALIFIERS_rec.qualifier_number_format)
283: THEN
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
286: END IF;*/
287:
288: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,p_old_QUALIFIERS_rec.qualifier_precedence)
289: THEN

Line 291: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;

287:
288: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,p_old_QUALIFIERS_rec.qualifier_precedence)
289: THEN
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
292: END IF;
293:
294: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,p_old_QUALIFIERS_rec.qualifier_rule_id)
295: THEN

Line 297: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;

293:
294: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,p_old_QUALIFIERS_rec.qualifier_rule_id)
295: THEN
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
298: END IF;
299:
300: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,p_old_QUALIFIERS_rec.request_id)
301: THEN

Line 303: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;

299:
300: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,p_old_QUALIFIERS_rec.request_id)
301: THEN
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
304: END IF;
305:
306: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,p_old_QUALIFIERS_rec.start_date_active)
307: THEN

Line 309: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;

305:
306: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,p_old_QUALIFIERS_rec.start_date_active)
307: THEN
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
310: END IF;
311: -- Added for TCA
312: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
313: THEN

Line 315: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

311: -- Added for TCA
312: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
313: THEN
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;
316: END IF;
317:
318: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
319: l_index := l_index + 1;

Line 320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;

316: END IF;
317:
318: ELSIF p_attr_id = G_ATTRIBUTE1 THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
321: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN

Line 323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;

319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE1;
321: ELSIF p_attr_id = G_ATTRIBUTE10 THEN
322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN

Line 326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;

322: l_index := l_index + 1;
323: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
324: ELSIF p_attr_id = G_ATTRIBUTE11 THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN

Line 329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;

325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
327: ELSIF p_attr_id = G_ATTRIBUTE12 THEN
328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN

Line 332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;

328: l_index := l_index + 1;
329: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
330: ELSIF p_attr_id = G_ATTRIBUTE13 THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN

Line 335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;

331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
333: ELSIF p_attr_id = G_ATTRIBUTE14 THEN
334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN

Line 338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;

334: l_index := l_index + 1;
335: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
336: ELSIF p_attr_id = G_ATTRIBUTE15 THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN

Line 341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;

337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
339: ELSIF p_attr_id = G_ATTRIBUTE2 THEN
340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN

Line 344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;

340: l_index := l_index + 1;
341: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
342: ELSIF p_attr_id = G_ATTRIBUTE3 THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN

Line 347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;

343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
345: ELSIF p_attr_id = G_ATTRIBUTE4 THEN
346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN

Line 350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;

346: l_index := l_index + 1;
347: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
348: ELSIF p_attr_id = G_ATTRIBUTE5 THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN

Line 353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;

349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
351: ELSIF p_attr_id = G_ATTRIBUTE6 THEN
352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN

Line 356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;

352: l_index := l_index + 1;
353: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
354: ELSIF p_attr_id = G_ATTRIBUTE7 THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN

Line 359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;

355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
357: ELSIF p_attr_id = G_ATTRIBUTE8 THEN
358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN

Line 362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;

358: l_index := l_index + 1;
359: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
360: ELSIF p_attr_id = G_ATTRIBUTE9 THEN
361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN

Line 365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;

361: l_index := l_index + 1;
362: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
363: ELSIF p_attr_id = G_COMPARISON_OPERATOR THEN
364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN

Line 368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;

364: l_index := l_index + 1;
365: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
366: ELSIF p_attr_id = G_CONTEXT THEN
367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN

Line 371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;

367: l_index := l_index + 1;
368: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
369: ELSIF p_attr_id = G_CREATED_BY THEN
370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN

Line 374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;

370: l_index := l_index + 1;
371: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
372: ELSIF p_attr_id = G_CREATED_FROM_RULE THEN
373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN

Line 377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;

373: l_index := l_index + 1;
374: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
375: ELSIF p_attr_id = G_CREATION_DATE THEN
376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN

Line 380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;

376: l_index := l_index + 1;
377: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
378: ELSIF p_attr_id = G_END_DATE_ACTIVE THEN
379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN

Line 383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;

379: l_index := l_index + 1;
380: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
381: ELSIF p_attr_id = G_EXCLUDER THEN
382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN

Line 386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;

382: l_index := l_index + 1;
383: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
384: ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN

Line 389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;

385: l_index := l_index + 1;
386: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
387: ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN

Line 392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;

388: l_index := l_index + 1;
389: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
390: ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN

Line 395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;

391: l_index := l_index + 1;
392: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
393: ELSIF p_attr_id = G_LIST_HEADER THEN
394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN

Line 398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;

394: l_index := l_index + 1;
395: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
396: ELSIF p_attr_id = G_LIST_LINE THEN
397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN

Line 401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;

397: l_index := l_index + 1;
398: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
399: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN

Line 404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;

400: l_index := l_index + 1;
401: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
402: ELSIF p_attr_id = G_PROGRAM THEN
403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN

Line 407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;

403: l_index := l_index + 1;
404: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
405: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN

Line 410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;

406: l_index := l_index + 1;
407: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
408: ELSIF p_attr_id = G_QUALIFIER_ATTRIBUTE THEN
409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN

Line 413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;

409: l_index := l_index + 1;
410: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
411: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE THEN
412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN

Line 416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;

412: l_index := l_index + 1;
413: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
414: ELSIF p_attr_id = G_QUALIFIER_ATTR_VALUE_TO THEN
415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN

Line 419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;

415: l_index := l_index + 1;
416: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE_TO;
417: ELSIF p_attr_id = G_QUALIFIER_CONTEXT THEN
418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN

Line 422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;

418: l_index := l_index + 1;
419: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_CONTEXT;
420: ELSIF p_attr_id = G_QUALIFIER_DATATYPE THEN
421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN
424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN

Line 425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;

421: l_index := l_index + 1;
422: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
423: --ELSIF p_attr_id = G_QUALIFIER_DATE_FORMAT THEN
424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN

Line 428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;

424: -- l_index := l_index + 1;
425: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
426: ELSIF p_attr_id = G_QUALIFIER_GROUPING_NO THEN
427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN

Line 431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;

427: l_index := l_index + 1;
428: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
429: ELSIF p_attr_id = G_QUALIFIER THEN
430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN
433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN

Line 434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;

430: l_index := l_index + 1;
431: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
432: --ELSIF p_attr_id = G_QUALIFIER_NUMBER_FORMAT THEN
433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN

Line 437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;

433: -- l_index := l_index + 1;
434: -- l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
435: ELSIF p_attr_id = G_QUALIFIER_PRECEDENCE THEN
436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN

Line 440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;

436: l_index := l_index + 1;
437: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
438: ELSIF p_attr_id = G_QUALIFIER_RULE THEN
439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN

Line 443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;

439: l_index := l_index + 1;
440: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
441: ELSIF p_attr_id = G_REQUEST THEN
442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA

Line 446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;

442: l_index := l_index + 1;
443: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
444: ELSIF p_attr_id = G_START_DATE_ACTIVE THEN
445: l_index := l_index + 1;
446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA
448: ELSIF p_attr_id = G_QUALIFY_HIER_DESCENDENT_FLAG THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

Line 450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;

446: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
447: -- Added for TCA
448: ELSIF p_attr_id = G_QUALIFY_HIER_DESCENDENT_FLAG THEN
449: l_index := l_index + 1;
450: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;
451: END IF;
452:
453: END Clear_Dependent_Attr;
454:

Line 3919: END QP_Qualifiers_Util;

3915: END IF;
3916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3917: END Pre_Write_Process;
3918:
3919: END QP_Qualifiers_Util;