[Home] [Help]
15: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
16: )
17: IS
18: l_index NUMBER := 0;
19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
21: BEGIN
22:
23: -- Load out record
24:
45:
46:
47: IF p_attr_id = FND_API.G_MISS_NUM THEN
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;
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
57: l_index := l_index + 1;
58: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE10;
59: END IF;
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
63: l_index := l_index + 1;
64: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE11;
65: END IF;
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
69: l_index := l_index + 1;
70: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE12;
71: END IF;
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
75: l_index := l_index + 1;
76: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE13;
77: END IF;
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
81: l_index := l_index + 1;
82: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE14;
83: END IF;
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
87: l_index := l_index + 1;
88: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE15;
89: END IF;
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
93: l_index := l_index + 1;
94: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE2;
95: END IF;
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
99: l_index := l_index + 1;
100: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE3;
101: END IF;
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
105: l_index := l_index + 1;
106: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE4;
107: END IF;
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
111: l_index := l_index + 1;
112: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE5;
113: END IF;
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
117: l_index := l_index + 1;
118: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE6;
119: END IF;
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
123: l_index := l_index + 1;
124: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE7;
125: END IF;
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
129: l_index := l_index + 1;
130: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE8;
131: END IF;
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
135: l_index := l_index + 1;
136: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_ATTRIBUTE9;
137: END IF;
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
141: l_index := l_index + 1;
142: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_COMPARISON_OPERATOR;
143: END IF;
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
147: l_index := l_index + 1;
148: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CONTEXT;
149: END IF;
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
153: l_index := l_index + 1;
154: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_BY;
155: END IF;
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
159: l_index := l_index + 1;
160: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATED_FROM_RULE;
161: END IF;
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
165: l_index := l_index + 1;
166: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_CREATION_DATE;
167: END IF;
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
171: l_index := l_index + 1;
172: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_END_DATE_ACTIVE;
173: END IF;
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
177: l_index := l_index + 1;
178: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_EXCLUDER;
179: END IF;
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
183: l_index := l_index + 1;
184: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATED_BY;
185: END IF;
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
189: l_index := l_index + 1;
190: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_DATE;
191: END IF;
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
195: l_index := l_index + 1;
196: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
197: END IF;
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
201: l_index := l_index + 1;
202: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_HEADER;
203: END IF;
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
207: l_index := l_index + 1;
208: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_LIST_LINE;
209: END IF;
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
213: l_index := l_index + 1;
214: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_APPLICATION;
215: END IF;
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
219: l_index := l_index + 1;
220: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM;
221: END IF;
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
225: l_index := l_index + 1;
226: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
227: END IF;
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
231: l_index := l_index + 1;
232: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTRIBUTE;
233: END IF;
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
237: l_index := l_index + 1;
238: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_ATTR_VALUE;
239: END IF;
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)
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;
248:
249:
250:
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;
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
260: l_index := l_index + 1;
261: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATATYPE;
262: END IF;
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
266: l_index := l_index + 1;
267: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_DATE_FORMAT;
268: END IF;*/
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
272: l_index := l_index + 1;
273: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_GROUPING_NO;
274: END IF;
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
278: l_index := l_index + 1;
279: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER;
280: END IF;
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
284: l_index := l_index + 1;
285: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_NUMBER_FORMAT;
286: END IF;*/
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
290: l_index := l_index + 1;
291: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_PRECEDENCE;
292: END IF;
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
296: l_index := l_index + 1;
297: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFIER_RULE;
298: END IF;
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
302: l_index := l_index + 1;
303: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_REQUEST;
304: END IF;
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
308: l_index := l_index + 1;
309: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_START_DATE_ACTIVE;
310: END IF;
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
314: l_index := l_index + 1;
315: l_src_attr_tbl(l_index) := QP_QUALIFIERS_UTIL.G_QUALIFY_HIER_DESCENDENT_FLAG;
316: END IF;
471: -- Load out record
472:
473: x_QUALIFIERS_rec := p_QUALIFIERS_rec;
474:
475: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,p_old_QUALIFIERS_rec.attribute1)
476: THEN
477: NULL;
478: END IF;
479:
476: THEN
477: NULL;
478: END IF;
479:
480: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,p_old_QUALIFIERS_rec.attribute10)
481: THEN
482: NULL;
483: END IF;
484:
481: THEN
482: NULL;
483: END IF;
484:
485: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,p_old_QUALIFIERS_rec.attribute11)
486: THEN
487: NULL;
488: END IF;
489:
486: THEN
487: NULL;
488: END IF;
489:
490: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,p_old_QUALIFIERS_rec.attribute12)
491: THEN
492: NULL;
493: END IF;
494:
491: THEN
492: NULL;
493: END IF;
494:
495: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,p_old_QUALIFIERS_rec.attribute13)
496: THEN
497: NULL;
498: END IF;
499:
496: THEN
497: NULL;
498: END IF;
499:
500: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,p_old_QUALIFIERS_rec.attribute14)
501: THEN
502: NULL;
503: END IF;
504:
501: THEN
502: NULL;
503: END IF;
504:
505: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,p_old_QUALIFIERS_rec.attribute15)
506: THEN
507: NULL;
508: END IF;
509:
506: THEN
507: NULL;
508: END IF;
509:
510: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,p_old_QUALIFIERS_rec.attribute2)
511: THEN
512: NULL;
513: END IF;
514:
511: THEN
512: NULL;
513: END IF;
514:
515: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,p_old_QUALIFIERS_rec.attribute3)
516: THEN
517: NULL;
518: END IF;
519:
516: THEN
517: NULL;
518: END IF;
519:
520: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,p_old_QUALIFIERS_rec.attribute4)
521: THEN
522: NULL;
523: END IF;
524:
521: THEN
522: NULL;
523: END IF;
524:
525: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,p_old_QUALIFIERS_rec.attribute5)
526: THEN
527: NULL;
528: END IF;
529:
526: THEN
527: NULL;
528: END IF;
529:
530: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,p_old_QUALIFIERS_rec.attribute6)
531: THEN
532: NULL;
533: END IF;
534:
531: THEN
532: NULL;
533: END IF;
534:
535: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,p_old_QUALIFIERS_rec.attribute7)
536: THEN
537: NULL;
538: END IF;
539:
536: THEN
537: NULL;
538: END IF;
539:
540: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,p_old_QUALIFIERS_rec.attribute8)
541: THEN
542: NULL;
543: END IF;
544:
541: THEN
542: NULL;
543: END IF;
544:
545: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,p_old_QUALIFIERS_rec.attribute9)
546: THEN
547: NULL;
548: END IF;
549:
546: THEN
547: NULL;
548: END IF;
549:
550: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,p_old_QUALIFIERS_rec.comparison_operator_code)
551: THEN
552: NULL;
553: END IF;
554:
551: THEN
552: NULL;
553: END IF;
554:
555: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,p_old_QUALIFIERS_rec.context)
556: THEN
557: NULL;
558: END IF;
559:
556: THEN
557: NULL;
558: END IF;
559:
560: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,p_old_QUALIFIERS_rec.created_by)
561: THEN
562: NULL;
563: END IF;
564:
561: THEN
562: NULL;
563: END IF;
564:
565: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,p_old_QUALIFIERS_rec.created_from_rule_id)
566: THEN
567: NULL;
568: END IF;
569:
566: THEN
567: NULL;
568: END IF;
569:
570: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,p_old_QUALIFIERS_rec.creation_date)
571: THEN
572: NULL;
573: END IF;
574:
571: THEN
572: NULL;
573: END IF;
574:
575: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,p_old_QUALIFIERS_rec.end_date_active)
576: THEN
577: NULL;
578: END IF;
579:
576: THEN
577: NULL;
578: END IF;
579:
580: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,p_old_QUALIFIERS_rec.excluder_flag)
581: THEN
582: NULL;
583: END IF;
584:
581: THEN
582: NULL;
583: END IF;
584:
585: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,p_old_QUALIFIERS_rec.last_updated_by)
586: THEN
587: NULL;
588: END IF;
589:
586: THEN
587: NULL;
588: END IF;
589:
590: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,p_old_QUALIFIERS_rec.last_update_date)
591: THEN
592: NULL;
593: END IF;
594:
591: THEN
592: NULL;
593: END IF;
594:
595: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,p_old_QUALIFIERS_rec.last_update_login)
596: THEN
597: NULL;
598: END IF;
599:
596: THEN
597: NULL;
598: END IF;
599:
600: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,p_old_QUALIFIERS_rec.list_header_id)
601: THEN
602: NULL;
603: END IF;
604:
601: THEN
602: NULL;
603: END IF;
604:
605: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,p_old_QUALIFIERS_rec.list_line_id)
606: THEN
607: NULL;
608: END IF;
609:
606: THEN
607: NULL;
608: END IF;
609:
610: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,p_old_QUALIFIERS_rec.program_application_id)
611: THEN
612: NULL;
613: END IF;
614:
611: THEN
612: NULL;
613: END IF;
614:
615: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,p_old_QUALIFIERS_rec.program_id)
616: THEN
617: NULL;
618: END IF;
619:
616: THEN
617: NULL;
618: END IF;
619:
620: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,p_old_QUALIFIERS_rec.program_update_date)
621: THEN
622: NULL;
623: END IF;
624:
621: THEN
622: NULL;
623: END IF;
624:
625: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,p_old_QUALIFIERS_rec.qualifier_attribute)
626: THEN
627: NULL;
628: END IF;
629:
626: THEN
627: NULL;
628: END IF;
629:
630: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
631: THEN
632: NULL;
633: END IF;
634: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)
630: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,p_old_QUALIFIERS_rec.qualifier_attr_value)
631: THEN
632: NULL;
633: END IF;
634: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,p_old_QUALIFIERS_rec.qualifier_attr_value_to)
635: THEN
636: NULL;
637: END IF;
638:
635: THEN
636: NULL;
637: END IF;
638:
639: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,p_old_QUALIFIERS_rec.qualifier_context)
640: THEN
641: NULL;
642: END IF;
643:
640: THEN
641: NULL;
642: END IF;
643:
644: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,p_old_QUALIFIERS_rec.qualifier_datatype)
645: THEN
646: NULL;
647: END IF;
648:
645: THEN
646: NULL;
647: END IF;
648:
649: /*IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,p_old_QUALIFIERS_rec.qualifier_date_format)
650: THEN
651: NULL;
652: END IF;*/
653:
650: THEN
651: NULL;
652: END IF;*/
653:
654: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,p_old_QUALIFIERS_rec.qualifier_grouping_no)
655: THEN
656: NULL;
657: END IF;
658:
655: THEN
656: NULL;
657: END IF;
658:
659: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,p_old_QUALIFIERS_rec.qualifier_id)
660: THEN
661: NULL;
662: END IF;
663:
660: THEN
661: NULL;
662: END IF;
663:
664: /* IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,p_old_QUALIFIERS_rec.qualifier_number_format)
665: THEN
666: NULL;
667: END IF;*/
668:
665: THEN
666: NULL;
667: END IF;*/
668:
669: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,p_old_QUALIFIERS_rec.qualifier_precedence)
670: THEN
671: NULL;
672: END IF;
673:
670: THEN
671: NULL;
672: END IF;
673:
674: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,p_old_QUALIFIERS_rec.qualifier_rule_id)
675: THEN
676: NULL;
677: END IF;
678:
675: THEN
676: NULL;
677: END IF;
678:
679: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,p_old_QUALIFIERS_rec.request_id)
680: THEN
681: NULL;
682: END IF;
683:
680: THEN
681: NULL;
682: END IF;
683:
684: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,p_old_QUALIFIERS_rec.start_date_active)
685: THEN
686: NULL;
687: END IF;
688: -- Added for TCA
685: THEN
686: NULL;
687: END IF;
688: -- Added for TCA
689: IF NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,p_old_QUALIFIERS_rec.qualify_hier_descendent_flag)
690: THEN
691: NULL;
692: END IF;
693: oe_debug_pub.add(' leaving apply attribute changes');
2370:
2371: -- Row locked. Compare IN attributes to DB attributes.
2372:
2373:
2374: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2375: l_QUALIFIERS_rec.attribute1)
2376: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2377: l_QUALIFIERS_rec.attribute10)
2378: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2372:
2373:
2374: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2375: l_QUALIFIERS_rec.attribute1)
2376: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2377: l_QUALIFIERS_rec.attribute10)
2378: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2379: l_QUALIFIERS_rec.attribute11)
2380: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2374: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2375: l_QUALIFIERS_rec.attribute1)
2376: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2377: l_QUALIFIERS_rec.attribute10)
2378: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2379: l_QUALIFIERS_rec.attribute11)
2380: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2381: l_QUALIFIERS_rec.attribute12)
2382: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2376: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2377: l_QUALIFIERS_rec.attribute10)
2378: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2379: l_QUALIFIERS_rec.attribute11)
2380: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2381: l_QUALIFIERS_rec.attribute12)
2382: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2383: l_QUALIFIERS_rec.attribute13)
2384: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2378: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2379: l_QUALIFIERS_rec.attribute11)
2380: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2381: l_QUALIFIERS_rec.attribute12)
2382: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2383: l_QUALIFIERS_rec.attribute13)
2384: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2385: l_QUALIFIERS_rec.attribute14)
2386: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2380: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2381: l_QUALIFIERS_rec.attribute12)
2382: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2383: l_QUALIFIERS_rec.attribute13)
2384: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2385: l_QUALIFIERS_rec.attribute14)
2386: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2387: l_QUALIFIERS_rec.attribute15)
2388: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2382: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2383: l_QUALIFIERS_rec.attribute13)
2384: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2385: l_QUALIFIERS_rec.attribute14)
2386: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2387: l_QUALIFIERS_rec.attribute15)
2388: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2389: l_QUALIFIERS_rec.attribute2)
2390: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2384: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2385: l_QUALIFIERS_rec.attribute14)
2386: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2387: l_QUALIFIERS_rec.attribute15)
2388: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2389: l_QUALIFIERS_rec.attribute2)
2390: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2391: l_QUALIFIERS_rec.attribute3)
2392: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2386: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2387: l_QUALIFIERS_rec.attribute15)
2388: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2389: l_QUALIFIERS_rec.attribute2)
2390: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2391: l_QUALIFIERS_rec.attribute3)
2392: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2393: l_QUALIFIERS_rec.attribute4)
2394: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2388: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2389: l_QUALIFIERS_rec.attribute2)
2390: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2391: l_QUALIFIERS_rec.attribute3)
2392: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2393: l_QUALIFIERS_rec.attribute4)
2394: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2395: l_QUALIFIERS_rec.attribute5)
2396: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2390: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2391: l_QUALIFIERS_rec.attribute3)
2392: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2393: l_QUALIFIERS_rec.attribute4)
2394: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2395: l_QUALIFIERS_rec.attribute5)
2396: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2397: l_QUALIFIERS_rec.attribute6)
2398: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2392: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2393: l_QUALIFIERS_rec.attribute4)
2394: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2395: l_QUALIFIERS_rec.attribute5)
2396: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2397: l_QUALIFIERS_rec.attribute6)
2398: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2399: l_QUALIFIERS_rec.attribute7)
2400: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2394: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2395: l_QUALIFIERS_rec.attribute5)
2396: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2397: l_QUALIFIERS_rec.attribute6)
2398: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2399: l_QUALIFIERS_rec.attribute7)
2400: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2401: l_QUALIFIERS_rec.attribute8)
2402: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2396: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2397: l_QUALIFIERS_rec.attribute6)
2398: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2399: l_QUALIFIERS_rec.attribute7)
2400: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2401: l_QUALIFIERS_rec.attribute8)
2402: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2403: l_QUALIFIERS_rec.attribute9)
2404: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2398: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2399: l_QUALIFIERS_rec.attribute7)
2400: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2401: l_QUALIFIERS_rec.attribute8)
2402: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2403: l_QUALIFIERS_rec.attribute9)
2404: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2405: l_QUALIFIERS_rec.comparison_operator_code)
2406: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2400: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2401: l_QUALIFIERS_rec.attribute8)
2402: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2403: l_QUALIFIERS_rec.attribute9)
2404: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2405: l_QUALIFIERS_rec.comparison_operator_code)
2406: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2407: l_QUALIFIERS_rec.context)
2408: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2402: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2403: l_QUALIFIERS_rec.attribute9)
2404: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2405: l_QUALIFIERS_rec.comparison_operator_code)
2406: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2407: l_QUALIFIERS_rec.context)
2408: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2409: l_QUALIFIERS_rec.created_by)
2410: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2404: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2405: l_QUALIFIERS_rec.comparison_operator_code)
2406: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2407: l_QUALIFIERS_rec.context)
2408: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2409: l_QUALIFIERS_rec.created_by)
2410: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2411: l_QUALIFIERS_rec.created_from_rule_id)
2412: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2406: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2407: l_QUALIFIERS_rec.context)
2408: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2409: l_QUALIFIERS_rec.created_by)
2410: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2411: l_QUALIFIERS_rec.created_from_rule_id)
2412: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2413: -- l_QUALIFIERS_rec.creation_date)
2414: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2408: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2409: l_QUALIFIERS_rec.created_by)
2410: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2411: l_QUALIFIERS_rec.created_from_rule_id)
2412: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2413: -- l_QUALIFIERS_rec.creation_date)
2414: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2415: l_QUALIFIERS_rec.end_date_active)
2416: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2410: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2411: l_QUALIFIERS_rec.created_from_rule_id)
2412: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2413: -- l_QUALIFIERS_rec.creation_date)
2414: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2415: l_QUALIFIERS_rec.end_date_active)
2416: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2417: l_QUALIFIERS_rec.excluder_flag)
2418: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2412: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2413: -- l_QUALIFIERS_rec.creation_date)
2414: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2415: l_QUALIFIERS_rec.end_date_active)
2416: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2417: l_QUALIFIERS_rec.excluder_flag)
2418: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2419: -- l_QUALIFIERS_rec.last_updated_by)
2420: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2414: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2415: l_QUALIFIERS_rec.end_date_active)
2416: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2417: l_QUALIFIERS_rec.excluder_flag)
2418: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2419: -- l_QUALIFIERS_rec.last_updated_by)
2420: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2421: -- l_QUALIFIERS_rec.last_update_date)
2422: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2416: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2417: l_QUALIFIERS_rec.excluder_flag)
2418: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2419: -- l_QUALIFIERS_rec.last_updated_by)
2420: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2421: -- l_QUALIFIERS_rec.last_update_date)
2422: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2423: l_QUALIFIERS_rec.last_update_login)
2424: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2418: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2419: -- l_QUALIFIERS_rec.last_updated_by)
2420: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2421: -- l_QUALIFIERS_rec.last_update_date)
2422: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2423: l_QUALIFIERS_rec.last_update_login)
2424: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2425: l_QUALIFIERS_rec.list_header_id)
2426: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2420: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2421: -- l_QUALIFIERS_rec.last_update_date)
2422: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2423: l_QUALIFIERS_rec.last_update_login)
2424: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2425: l_QUALIFIERS_rec.list_header_id)
2426: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2427: l_QUALIFIERS_rec.list_line_id)
2428: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2422: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2423: l_QUALIFIERS_rec.last_update_login)
2424: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2425: l_QUALIFIERS_rec.list_header_id)
2426: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2427: l_QUALIFIERS_rec.list_line_id)
2428: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2429: l_QUALIFIERS_rec.program_application_id)
2430: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2424: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2425: l_QUALIFIERS_rec.list_header_id)
2426: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2427: l_QUALIFIERS_rec.list_line_id)
2428: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2429: l_QUALIFIERS_rec.program_application_id)
2430: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2431: l_QUALIFIERS_rec.program_id)
2432: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2426: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2427: l_QUALIFIERS_rec.list_line_id)
2428: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2429: l_QUALIFIERS_rec.program_application_id)
2430: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2431: l_QUALIFIERS_rec.program_id)
2432: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2433: -- l_QUALIFIERS_rec.program_update_date)
2434: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2428: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2429: l_QUALIFIERS_rec.program_application_id)
2430: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2431: l_QUALIFIERS_rec.program_id)
2432: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2433: -- l_QUALIFIERS_rec.program_update_date)
2434: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2435: l_QUALIFIERS_rec.qualifier_attribute)
2436: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2430: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2431: l_QUALIFIERS_rec.program_id)
2432: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2433: -- l_QUALIFIERS_rec.program_update_date)
2434: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2435: l_QUALIFIERS_rec.qualifier_attribute)
2436: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2437: l_QUALIFIERS_rec.qualifier_attr_value)
2438: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2432: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2433: -- l_QUALIFIERS_rec.program_update_date)
2434: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2435: l_QUALIFIERS_rec.qualifier_attribute)
2436: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2437: l_QUALIFIERS_rec.qualifier_attr_value)
2438: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2439: l_QUALIFIERS_rec.qualifier_attr_value_to)
2440: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2434: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2435: l_QUALIFIERS_rec.qualifier_attribute)
2436: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2437: l_QUALIFIERS_rec.qualifier_attr_value)
2438: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2439: l_QUALIFIERS_rec.qualifier_attr_value_to)
2440: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2441: l_QUALIFIERS_rec.qualifier_context)
2442: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2436: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2437: l_QUALIFIERS_rec.qualifier_attr_value)
2438: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2439: l_QUALIFIERS_rec.qualifier_attr_value_to)
2440: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2441: l_QUALIFIERS_rec.qualifier_context)
2442: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2443: l_QUALIFIERS_rec.qualifier_datatype)
2444: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2438: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2439: l_QUALIFIERS_rec.qualifier_attr_value_to)
2440: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2441: l_QUALIFIERS_rec.qualifier_context)
2442: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2443: l_QUALIFIERS_rec.qualifier_datatype)
2444: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2445: -- l_QUALIFIERS_rec.qualifier_date_format)
2446: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2440: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2441: l_QUALIFIERS_rec.qualifier_context)
2442: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2443: l_QUALIFIERS_rec.qualifier_datatype)
2444: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2445: -- l_QUALIFIERS_rec.qualifier_date_format)
2446: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2447: l_QUALIFIERS_rec.qualifier_grouping_no)
2448: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2442: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2443: l_QUALIFIERS_rec.qualifier_datatype)
2444: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2445: -- l_QUALIFIERS_rec.qualifier_date_format)
2446: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2447: l_QUALIFIERS_rec.qualifier_grouping_no)
2448: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2449: l_QUALIFIERS_rec.qualifier_id)
2450: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2444: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2445: -- l_QUALIFIERS_rec.qualifier_date_format)
2446: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2447: l_QUALIFIERS_rec.qualifier_grouping_no)
2448: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2449: l_QUALIFIERS_rec.qualifier_id)
2450: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2451: -- l_QUALIFIERS_rec.qualifier_number_format)
2452: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2446: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2447: l_QUALIFIERS_rec.qualifier_grouping_no)
2448: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2449: l_QUALIFIERS_rec.qualifier_id)
2450: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2451: -- l_QUALIFIERS_rec.qualifier_number_format)
2452: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2453: l_QUALIFIERS_rec.qualifier_precedence)
2454: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2448: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2449: l_QUALIFIERS_rec.qualifier_id)
2450: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2451: -- l_QUALIFIERS_rec.qualifier_number_format)
2452: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2453: l_QUALIFIERS_rec.qualifier_precedence)
2454: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2455: l_QUALIFIERS_rec.qualifier_rule_id)
2456: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2450: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2451: -- l_QUALIFIERS_rec.qualifier_number_format)
2452: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2453: l_QUALIFIERS_rec.qualifier_precedence)
2454: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2455: l_QUALIFIERS_rec.qualifier_rule_id)
2456: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2457: l_QUALIFIERS_rec.request_id)
2458: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2452: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2453: l_QUALIFIERS_rec.qualifier_precedence)
2454: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2455: l_QUALIFIERS_rec.qualifier_rule_id)
2456: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2457: l_QUALIFIERS_rec.request_id)
2458: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2459: l_QUALIFIERS_rec.start_date_active)*/
2460:
2454: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2455: l_QUALIFIERS_rec.qualifier_rule_id)
2456: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2457: l_QUALIFIERS_rec.request_id)
2458: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2459: l_QUALIFIERS_rec.start_date_active)*/
2460:
2461:
2462: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2458: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2459: l_QUALIFIERS_rec.start_date_active)*/
2460:
2461:
2462: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2463: l_QUALIFIERS_rec.attribute1)
2464: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2465: l_QUALIFIERS_rec.attribute10)
2466: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2460:
2461:
2462: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2463: l_QUALIFIERS_rec.attribute1)
2464: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2465: l_QUALIFIERS_rec.attribute10)
2466: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2467: l_QUALIFIERS_rec.attribute11)
2468: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2462: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2463: l_QUALIFIERS_rec.attribute1)
2464: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2465: l_QUALIFIERS_rec.attribute10)
2466: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2467: l_QUALIFIERS_rec.attribute11)
2468: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2469: l_QUALIFIERS_rec.attribute12)
2470: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2464: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2465: l_QUALIFIERS_rec.attribute10)
2466: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2467: l_QUALIFIERS_rec.attribute11)
2468: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2469: l_QUALIFIERS_rec.attribute12)
2470: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2471: l_QUALIFIERS_rec.attribute13)
2472: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2466: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2467: l_QUALIFIERS_rec.attribute11)
2468: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2469: l_QUALIFIERS_rec.attribute12)
2470: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2471: l_QUALIFIERS_rec.attribute13)
2472: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2473: l_QUALIFIERS_rec.attribute14)
2474: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2468: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2469: l_QUALIFIERS_rec.attribute12)
2470: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2471: l_QUALIFIERS_rec.attribute13)
2472: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2473: l_QUALIFIERS_rec.attribute14)
2474: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2475: l_QUALIFIERS_rec.attribute15)
2476: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2470: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2471: l_QUALIFIERS_rec.attribute13)
2472: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2473: l_QUALIFIERS_rec.attribute14)
2474: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2475: l_QUALIFIERS_rec.attribute15)
2476: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2477: l_QUALIFIERS_rec.attribute2)
2478: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2472: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2473: l_QUALIFIERS_rec.attribute14)
2474: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2475: l_QUALIFIERS_rec.attribute15)
2476: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2477: l_QUALIFIERS_rec.attribute2)
2478: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2479: l_QUALIFIERS_rec.attribute3)
2480: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2474: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2475: l_QUALIFIERS_rec.attribute15)
2476: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2477: l_QUALIFIERS_rec.attribute2)
2478: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2479: l_QUALIFIERS_rec.attribute3)
2480: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2481: l_QUALIFIERS_rec.attribute4)
2482: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2476: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2477: l_QUALIFIERS_rec.attribute2)
2478: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2479: l_QUALIFIERS_rec.attribute3)
2480: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2481: l_QUALIFIERS_rec.attribute4)
2482: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2483: l_QUALIFIERS_rec.attribute5)
2484: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2478: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2479: l_QUALIFIERS_rec.attribute3)
2480: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2481: l_QUALIFIERS_rec.attribute4)
2482: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2483: l_QUALIFIERS_rec.attribute5)
2484: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2485: l_QUALIFIERS_rec.attribute6)
2486: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2480: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2481: l_QUALIFIERS_rec.attribute4)
2482: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2483: l_QUALIFIERS_rec.attribute5)
2484: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2485: l_QUALIFIERS_rec.attribute6)
2486: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2487: l_QUALIFIERS_rec.attribute7)
2488: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2482: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2483: l_QUALIFIERS_rec.attribute5)
2484: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2485: l_QUALIFIERS_rec.attribute6)
2486: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2487: l_QUALIFIERS_rec.attribute7)
2488: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2489: l_QUALIFIERS_rec.attribute8)
2490: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2484: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2485: l_QUALIFIERS_rec.attribute6)
2486: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2487: l_QUALIFIERS_rec.attribute7)
2488: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2489: l_QUALIFIERS_rec.attribute8)
2490: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2491: l_QUALIFIERS_rec.attribute9)
2492: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2486: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2487: l_QUALIFIERS_rec.attribute7)
2488: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2489: l_QUALIFIERS_rec.attribute8)
2490: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2491: l_QUALIFIERS_rec.attribute9)
2492: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2493: l_QUALIFIERS_rec.comparison_operator_code)
2494: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2488: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2489: l_QUALIFIERS_rec.attribute8)
2490: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2491: l_QUALIFIERS_rec.attribute9)
2492: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2493: l_QUALIFIERS_rec.comparison_operator_code)
2494: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2495: l_QUALIFIERS_rec.context)
2496: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2490: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2491: l_QUALIFIERS_rec.attribute9)
2492: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2493: l_QUALIFIERS_rec.comparison_operator_code)
2494: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2495: l_QUALIFIERS_rec.context)
2496: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2497: -- l_QUALIFIERS_rec.created_by)
2498: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2492: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2493: l_QUALIFIERS_rec.comparison_operator_code)
2494: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2495: l_QUALIFIERS_rec.context)
2496: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2497: -- l_QUALIFIERS_rec.created_by)
2498: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2499: l_QUALIFIERS_rec.created_from_rule_id)
2500: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2494: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2495: l_QUALIFIERS_rec.context)
2496: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2497: -- l_QUALIFIERS_rec.created_by)
2498: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2499: l_QUALIFIERS_rec.created_from_rule_id)
2500: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2501: -- l_QUALIFIERS_rec.creation_date)
2502: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2496: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2497: -- l_QUALIFIERS_rec.created_by)
2498: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2499: l_QUALIFIERS_rec.created_from_rule_id)
2500: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2501: -- l_QUALIFIERS_rec.creation_date)
2502: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2503: l_QUALIFIERS_rec.end_date_active)
2504: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2498: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2499: l_QUALIFIERS_rec.created_from_rule_id)
2500: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2501: -- l_QUALIFIERS_rec.creation_date)
2502: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2503: l_QUALIFIERS_rec.end_date_active)
2504: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2505: l_QUALIFIERS_rec.excluder_flag)
2506: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2500: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2501: -- l_QUALIFIERS_rec.creation_date)
2502: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2503: l_QUALIFIERS_rec.end_date_active)
2504: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2505: l_QUALIFIERS_rec.excluder_flag)
2506: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2507: -- l_QUALIFIERS_rec.last_updated_by)
2508: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2502: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2503: l_QUALIFIERS_rec.end_date_active)
2504: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2505: l_QUALIFIERS_rec.excluder_flag)
2506: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2507: -- l_QUALIFIERS_rec.last_updated_by)
2508: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2509: -- l_QUALIFIERS_rec.last_update_date)
2510: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2504: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2505: l_QUALIFIERS_rec.excluder_flag)
2506: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2507: -- l_QUALIFIERS_rec.last_updated_by)
2508: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2509: -- l_QUALIFIERS_rec.last_update_date)
2510: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2511: -- l_QUALIFIERS_rec.last_update_login)
2512: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2506: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2507: -- l_QUALIFIERS_rec.last_updated_by)
2508: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2509: -- l_QUALIFIERS_rec.last_update_date)
2510: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2511: -- l_QUALIFIERS_rec.last_update_login)
2512: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2513: l_QUALIFIERS_rec.list_header_id)
2514: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2508: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2509: -- l_QUALIFIERS_rec.last_update_date)
2510: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2511: -- l_QUALIFIERS_rec.last_update_login)
2512: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2513: l_QUALIFIERS_rec.list_header_id)
2514: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2515: l_QUALIFIERS_rec.list_line_id)
2516: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2510: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2511: -- l_QUALIFIERS_rec.last_update_login)
2512: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2513: l_QUALIFIERS_rec.list_header_id)
2514: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2515: l_QUALIFIERS_rec.list_line_id)
2516: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2517: -- l_QUALIFIERS_rec.program_application_id)
2518: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2512: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2513: l_QUALIFIERS_rec.list_header_id)
2514: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2515: l_QUALIFIERS_rec.list_line_id)
2516: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2517: -- l_QUALIFIERS_rec.program_application_id)
2518: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2519: -- l_QUALIFIERS_rec.program_id)
2520: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2514: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2515: l_QUALIFIERS_rec.list_line_id)
2516: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2517: -- l_QUALIFIERS_rec.program_application_id)
2518: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2519: -- l_QUALIFIERS_rec.program_id)
2520: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2521: -- l_QUALIFIERS_rec.program_update_date)
2522: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2516: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2517: -- l_QUALIFIERS_rec.program_application_id)
2518: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2519: -- l_QUALIFIERS_rec.program_id)
2520: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2521: -- l_QUALIFIERS_rec.program_update_date)
2522: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2523: l_QUALIFIERS_rec.qualifier_attribute)
2524: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2518: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2519: -- l_QUALIFIERS_rec.program_id)
2520: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2521: -- l_QUALIFIERS_rec.program_update_date)
2522: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2523: l_QUALIFIERS_rec.qualifier_attribute)
2524: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2525: l_QUALIFIERS_rec.qualifier_attr_value)
2526: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2520: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2521: -- l_QUALIFIERS_rec.program_update_date)
2522: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2523: l_QUALIFIERS_rec.qualifier_attribute)
2524: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2525: l_QUALIFIERS_rec.qualifier_attr_value)
2526: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2527: l_QUALIFIERS_rec.qualifier_attr_value_to)
2528: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2522: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2523: l_QUALIFIERS_rec.qualifier_attribute)
2524: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2525: l_QUALIFIERS_rec.qualifier_attr_value)
2526: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2527: l_QUALIFIERS_rec.qualifier_attr_value_to)
2528: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2529: l_QUALIFIERS_rec.qualifier_context)
2530: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2524: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2525: l_QUALIFIERS_rec.qualifier_attr_value)
2526: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2527: l_QUALIFIERS_rec.qualifier_attr_value_to)
2528: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2529: l_QUALIFIERS_rec.qualifier_context)
2530: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2531: l_QUALIFIERS_rec.qualifier_datatype)
2532: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2526: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2527: l_QUALIFIERS_rec.qualifier_attr_value_to)
2528: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2529: l_QUALIFIERS_rec.qualifier_context)
2530: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2531: l_QUALIFIERS_rec.qualifier_datatype)
2532: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2533: -- l_QUALIFIERS_rec.qualifier_date_format)
2534: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2528: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2529: l_QUALIFIERS_rec.qualifier_context)
2530: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2531: l_QUALIFIERS_rec.qualifier_datatype)
2532: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2533: -- l_QUALIFIERS_rec.qualifier_date_format)
2534: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2535: l_QUALIFIERS_rec.qualifier_grouping_no)
2536: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2530: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2531: l_QUALIFIERS_rec.qualifier_datatype)
2532: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2533: -- l_QUALIFIERS_rec.qualifier_date_format)
2534: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2535: l_QUALIFIERS_rec.qualifier_grouping_no)
2536: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2537: l_QUALIFIERS_rec.qualifier_id)
2538: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2532: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2533: -- l_QUALIFIERS_rec.qualifier_date_format)
2534: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2535: l_QUALIFIERS_rec.qualifier_grouping_no)
2536: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2537: l_QUALIFIERS_rec.qualifier_id)
2538: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2539: -- l_QUALIFIERS_rec.qualifier_number_format)
2540: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2534: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2535: l_QUALIFIERS_rec.qualifier_grouping_no)
2536: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2537: l_QUALIFIERS_rec.qualifier_id)
2538: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2539: -- l_QUALIFIERS_rec.qualifier_number_format)
2540: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2541: l_QUALIFIERS_rec.qualifier_precedence)
2542: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2536: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2537: l_QUALIFIERS_rec.qualifier_id)
2538: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2539: -- l_QUALIFIERS_rec.qualifier_number_format)
2540: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2541: l_QUALIFIERS_rec.qualifier_precedence)
2542: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2543: l_QUALIFIERS_rec.qualifier_rule_id)
2544: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2538: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2539: -- l_QUALIFIERS_rec.qualifier_number_format)
2540: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2541: l_QUALIFIERS_rec.qualifier_precedence)
2542: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2543: l_QUALIFIERS_rec.qualifier_rule_id)
2544: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2545: -- l_QUALIFIERS_rec.request_id)
2546: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2540: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2541: l_QUALIFIERS_rec.qualifier_precedence)
2542: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2543: l_QUALIFIERS_rec.qualifier_rule_id)
2544: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2545: -- l_QUALIFIERS_rec.request_id)
2546: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2547: l_QUALIFIERS_rec.start_date_active)
2548: -- Added for TCA
2542: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2543: l_QUALIFIERS_rec.qualifier_rule_id)
2544: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2545: -- l_QUALIFIERS_rec.request_id)
2546: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2547: l_QUALIFIERS_rec.start_date_active)
2548: -- Added for TCA
2549: AND (QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,
2550: l_QUALIFIERS_rec.qualify_hier_descendent_flag)
2545: -- l_QUALIFIERS_rec.request_id)
2546: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2547: l_QUALIFIERS_rec.start_date_active)
2548: -- Added for TCA
2549: AND (QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,
2550: l_QUALIFIERS_rec.qualify_hier_descendent_flag)
2551: OR (p_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR
2552: and l_QUALIFIERS_rec.qualify_hier_descendent_flag is null))
2553: THEN
2634: BEGIN
2635:
2636: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2637: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
2638: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2639: p_old_QUALIFIERS_rec.comparison_operator_code)
2640: THEN
2641: l_QUALIFIERS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator
2642: ( p_comparison_operator_code => p_QUALIFIERS_rec.comparison_operator_code
2644: END IF;*/
2645:
2646: IF p_QUALIFIERS_rec.created_from_rule_id IS NOT NULL AND
2647: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND
2648: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2649: p_old_QUALIFIERS_rec.created_from_rule_id)
2650: THEN
2651: l_QUALIFIERS_val_rec.created_from_rule := QP_Id_To_Value.Created_From_Rule
2652: ( p_created_from_rule_id => p_QUALIFIERS_rec.created_from_rule_id
2654: END IF;
2655:
2656: /* IF p_QUALIFIERS_rec.excluder_flag IS NOT NULL AND
2657: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2658: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2659: p_old_QUALIFIERS_rec.excluder_flag)
2660: THEN
2661: l_QUALIFIERS_val_rec.excluder := QP_Id_To_Value.Excluder
2662: ( p_excluder_flag => p_QUALIFIERS_rec.excluder_flag
2664: END IF;*/
2665:
2666: IF p_QUALIFIERS_rec.list_header_id IS NOT NULL AND
2667: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
2668: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2669: p_old_QUALIFIERS_rec.list_header_id)
2670: THEN
2671: l_QUALIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
2672: ( p_list_header_id => p_QUALIFIERS_rec.list_header_id
2674: END IF;
2675:
2676: IF p_QUALIFIERS_rec.list_line_id IS NOT NULL AND
2677: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
2678: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2679: p_old_QUALIFIERS_rec.list_line_id)
2680: THEN
2681: l_QUALIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
2682: ( p_list_line_id => p_QUALIFIERS_rec.list_line_id
2684: END IF;
2685:
2686: /*IF p_QUALIFIERS_rec.qualifier_id IS NOT NULL AND
2687: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND
2688: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2689: p_old_QUALIFIERS_rec.qualifier_id)
2690: THEN
2691: l_QUALIFIERS_val_rec.qualifier := QP_Id_To_Value.Qualifier
2692: ( p_qualifier_id => p_QUALIFIERS_rec.qualifier_id
2694: END IF;*/
2695:
2696: IF p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL AND
2697: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
2698: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2699: p_old_QUALIFIERS_rec.qualifier_rule_id)
2700: THEN
2701: l_QUALIFIERS_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule
2702: ( p_qualifier_rule_id => p_QUALIFIERS_rec.qualifier_rule_id
3063:
3064:
3065: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3066:
3067: IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3068: QP_GLOBALS.G_OPR_DELETE) ) THEN
3069: -- Get the List Type Code
3070: BEGIN
3071: SELECT list_type_code
3064:
3065: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3066:
3067: IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3068: QP_GLOBALS.G_OPR_DELETE) ) THEN
3069: -- Get the List Type Code
3070: BEGIN
3071: SELECT list_type_code
3072: INTO l_list_type_code
3148: END;
3149:
3150: --Submit a Header Level Delayed Request to update qualification_ind
3151: --while creating the first or deleting the last header level qualifier.
3152: IF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3153: p_QUALIFIERS_rec.list_line_id = -1 AND
3154: l_hlq_count = 0) OR
3155: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3156: p_QUALIFIERS_rec.list_line_id = -1 AND
3151: --while creating the first or deleting the last header level qualifier.
3152: IF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3153: p_QUALIFIERS_rec.list_line_id = -1 AND
3154: l_hlq_count = 0) OR
3155: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3156: p_QUALIFIERS_rec.list_line_id = -1 AND
3157: l_hlq_count = 1)
3158: THEN
3159:
3163: IF NOT (l_list_type_code = 'PRL' and p_QUALIFIERS_rec.qualifier_context='MODLIST'
3164: and p_QUALIFIERS_rec.qualifier_attribute='QUALIFIER_ATTRIBUTE4') THEN
3165:
3166: qp_delayed_requests_PVT.log_request(
3167: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3168: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3169: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3170: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3171: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3165:
3166: qp_delayed_requests_PVT.log_request(
3167: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3168: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3169: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3170: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3171: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3172: x_return_status => l_return_status);
3173: END IF;
3167: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3168: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3169: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3170: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3171: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3172: x_return_status => l_return_status);
3173: END IF;
3174:
3175: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3176:
3177: oe_debug_pub.add('log delayed request------------');
3178:
3179: qp_delayed_requests_PVT.log_request(
3180: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3181: p_param1 => p_QUALIFIERS_rec.list_header_id,
3182: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3183: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3184: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3179: qp_delayed_requests_PVT.log_request(
3180: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3181: p_param1 => p_QUALIFIERS_rec.list_header_id,
3182: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3183: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3184: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3185: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3186: x_return_status => l_return_status);
3187:
3181: p_param1 => p_QUALIFIERS_rec.list_header_id,
3182: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3183: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3184: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3185: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3186: x_return_status => l_return_status);
3187:
3188: END IF;
3189:
3188: END IF;
3189:
3190: --Submit a Line Level Delayed Request to update qualification_ind
3191: --while creating the first or deleting the last line level qualifier.
3192: ELSIF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3193: p_QUALIFIERS_rec.list_line_id <> -1 AND
3194: l_llq_count = 0) OR
3195: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3196: p_QUALIFIERS_rec.list_line_id <> -1 AND
3191: --while creating the first or deleting the last line level qualifier.
3192: ELSIF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3193: p_QUALIFIERS_rec.list_line_id <> -1 AND
3194: l_llq_count = 0) OR
3195: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3196: p_QUALIFIERS_rec.list_line_id <> -1 AND
3197: l_llq_count = 1)
3198: THEN
3199: qp_delayed_requests_PVT.log_request(
3196: p_QUALIFIERS_rec.list_line_id <> -1 AND
3197: l_llq_count = 1)
3198: THEN
3199: qp_delayed_requests_PVT.log_request(
3200: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3201: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3202: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3203: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3204: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3198: THEN
3199: qp_delayed_requests_PVT.log_request(
3200: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3201: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3202: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3203: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3204: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3205: x_return_status => l_return_status);
3206:
3200: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3201: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3202: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3203: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3204: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3205: x_return_status => l_return_status);
3206:
3207: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3208: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3206:
3207: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3208: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3209: qp_delayed_requests_PVT.log_request(
3210: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3211: p_param1 => p_QUALIFIERS_rec.list_header_id,
3212: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3213: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3214: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3209: qp_delayed_requests_PVT.log_request(
3210: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3211: p_param1 => p_QUALIFIERS_rec.list_header_id,
3212: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3213: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3214: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3215: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3216: x_return_status => l_return_status);
3217: END IF;
3211: p_param1 => p_QUALIFIERS_rec.list_header_id,
3212: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3213: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3214: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3215: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3216: x_return_status => l_return_status);
3217: END IF;
3218:
3219: END IF;
3220:
3221: END IF; -- If operation is create or delete.
3222:
3223: /* Added for 7120399 */
3224: if p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE then
3225:
3226: BEGIN
3227: SELECT list_type_code
3228: INTO l_list_type_code
3233: NULL;
3234: END;
3235: end if;
3236:
3237: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3238: QP_GLOBALS.G_OPR_UPDATE,
3239: QP_GLOBALS.G_OPR_DELETE) THEN
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3234: END;
3235: end if;
3236:
3237: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3238: QP_GLOBALS.G_OPR_UPDATE,
3239: QP_GLOBALS.G_OPR_DELETE) THEN
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3235: end if;
3236:
3237: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3238: QP_GLOBALS.G_OPR_UPDATE,
3239: QP_GLOBALS.G_OPR_DELETE) THEN
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3243: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3238: QP_GLOBALS.G_OPR_UPDATE,
3239: QP_GLOBALS.G_OPR_DELETE) THEN
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3243: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3244: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3245: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3246: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3240: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3241: qp_delayed_requests_PVT.log_request(
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3243: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3244: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3245: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3246: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3247: x_return_status => l_return_status);
3248: END IF;
3242: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3243: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3244: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3245: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3246: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3247: x_return_status => l_return_status);
3248: END IF;
3249: --Added following delayed request for Attributes Manager
3250: qp_delayed_requests_PVT.log_request(
3247: x_return_status => l_return_status);
3248: END IF;
3249: --Added following delayed request for Attributes Manager
3250: qp_delayed_requests_PVT.log_request(
3251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3252: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3253: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3254: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3255: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3249: --Added following delayed request for Attributes Manager
3250: qp_delayed_requests_PVT.log_request(
3251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3252: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3253: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3254: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3255: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3256: p_param1 => p_QUALIFIERS_rec.qualifier_rule_id,
3257: x_return_status => l_return_status);
3251: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3252: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3253: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3254: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3255: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3256: p_param1 => p_QUALIFIERS_rec.qualifier_rule_id,
3257: x_return_status => l_return_status);
3258:
3259: END IF;
3259: END IF;
3260:
3261: /*
3262: IF (p_QUALIFIERS_rec.operation IN
3263: (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)) THEN
3264:
3265: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3266:
3267: qp_delayed_requests_PVT.log_request(
3264:
3265: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3266:
3267: qp_delayed_requests_PVT.log_request(
3268: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3269: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3270: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3271: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3272: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3266:
3267: qp_delayed_requests_PVT.log_request(
3268: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3269: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3270: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3271: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3272: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3273: p_param1 => p_QUALIFIERS_rec.list_line_id,
3274: p_param2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3268: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3269: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3270: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3271: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3272: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3273: p_param1 => p_QUALIFIERS_rec.list_line_id,
3274: p_param2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3275: p_param3 => p_QUALIFIERS_rec.qualifier_context,
3276: p_param4 => p_QUALIFIERS_rec.qualifier_attribute,
3281:
3282: -- Attribute Manager Change BEGIN - required for modifiers
3283: -- Logging the request here instead of apply_attribute_changes because list_line_id is -1 even
3284: -- if qualifier is LINE level in apply_attribute_changes
3285: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3286: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3287: IF qp_util.attrmgr_installed = 'Y' THEN
3288: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3289: p_old_QUALIFIERS_rec.qualifier_attribute))
3282: -- Attribute Manager Change BEGIN - required for modifiers
3283: -- Logging the request here instead of apply_attribute_changes because list_line_id is -1 even
3284: -- if qualifier is LINE level in apply_attribute_changes
3285: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3286: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3287: IF qp_util.attrmgr_installed = 'Y' THEN
3288: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3289: p_old_QUALIFIERS_rec.qualifier_attribute))
3290: OR
3284: -- if qualifier is LINE level in apply_attribute_changes
3285: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3286: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3287: IF qp_util.attrmgr_installed = 'Y' THEN
3288: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3289: p_old_QUALIFIERS_rec.qualifier_attribute))
3290: OR
3291: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3292: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3287: IF qp_util.attrmgr_installed = 'Y' THEN
3288: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3289: p_old_QUALIFIERS_rec.qualifier_attribute))
3290: OR
3291: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3292: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3293: OR (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE) THEN
3294: -- Get the List Type Code
3295: BEGIN
3289: p_old_QUALIFIERS_rec.qualifier_attribute))
3290: OR
3291: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3292: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3293: OR (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE) THEN
3294: -- Get the List Type Code
3295: BEGIN
3296: SELECT list_type_code
3297: INTO l_list_type_code
3305: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3306: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3307: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3308: qp_delayed_requests_PVT.log_request(
3309: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3310: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3311: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3312: p_entity_id => p_qualifiers_rec.list_line_id,
3313: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3309: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3310: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3311: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3312: p_entity_id => p_qualifiers_rec.list_line_id,
3313: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3314: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3315: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3316: x_return_status => l_return_status);
3317:
3311: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3312: p_entity_id => p_qualifiers_rec.list_line_id,
3313: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3314: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3315: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3316: x_return_status => l_return_status);
3317:
3318: -- mkarya for attribute manager
3319: -- Log a delayed request to validate that if header level qualifier exist then at least
3320: -- one qualifier should exist for any existence of modifier line of modifier level
3321: -- 'LINE' or 'ORDER'
3322: if p_qualifiers_rec.list_line_id = -1 then
3323: qp_delayed_requests_PVT.log_request(
3324: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3325: p_entity_id => l_qualifiers_rec.list_header_id,
3326: p_request_unique_key1 => -1,
3327: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3328: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3323: qp_delayed_requests_PVT.log_request(
3324: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3325: p_entity_id => l_qualifiers_rec.list_header_id,
3326: p_request_unique_key1 => -1,
3327: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3328: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3329: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
3330: x_return_status => l_return_status);
3331: end if;
3325: p_entity_id => l_qualifiers_rec.list_header_id,
3326: p_request_unique_key1 => -1,
3327: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3328: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3329: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
3330: x_return_status => l_return_status);
3331: end if;
3332:
3333: -- if qualifier_grouping_no is updated to -1 then log the request for all other
3332:
3333: -- if qualifier_grouping_no is updated to -1 then log the request for all other
3334: -- qualifier_grouping_no for the given list_header_id and list_line_id
3335: if p_qualifiers_rec.qualifier_grouping_no = -1
3336: and p_qualifiers_rec.operation = QP_GLOBALS.G_OPR_UPDATE then
3337: declare
3338: cursor c_qual_grp is
3339: select distinct qualifier_grouping_no qualifier_grouping_no
3340: from qp_qualifiers
3349: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3350: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3351: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3352: qp_delayed_requests_PVT.log_request(
3353: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3354: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3355: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3356: p_entity_id => p_qualifiers_rec.list_line_id,
3357: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3353: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3354: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3355: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3356: p_entity_id => p_qualifiers_rec.list_line_id,
3357: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3358: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3359: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3360: x_return_status => l_return_status);
3361:
3355: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3356: p_entity_id => p_qualifiers_rec.list_line_id,
3357: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3358: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3359: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3360: x_return_status => l_return_status);
3361:
3362: END LOOP;
3363:
3372: --pattern
3373:
3374: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
3375:
3376: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3377: p_QUALIFIERS_rec.list_line_id = -1 THEN
3378: -- header qualifier is added to price list/modifier
3379: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3380: qp_delayed_requests_pvt.log_request(
3377: p_QUALIFIERS_rec.list_line_id = -1 THEN
3378: -- header qualifier is added to price list/modifier
3379: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3380: qp_delayed_requests_pvt.log_request(
3381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3382: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3383: p_request_unique_key1 => NULL,
3384: p_request_unique_key2 => 'I',
3385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3382: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3383: p_request_unique_key1 => NULL,
3384: p_request_unique_key2 => 'I',
3385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3386: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3387: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3388: x_return_status => l_return_status);
3389: ELSE
3383: p_request_unique_key1 => NULL,
3384: p_request_unique_key2 => 'I',
3385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3386: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3387: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3388: x_return_status => l_return_status);
3389: ELSE
3390: qp_delayed_requests_pvt.log_request(
3391: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3387: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3388: x_return_status => l_return_status);
3389: ELSE
3390: qp_delayed_requests_pvt.log_request(
3391: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3392: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3393: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3394: p_request_unique_key2 => 'I',
3395: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3391: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3392: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3393: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3394: p_request_unique_key2 => 'I',
3395: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3396: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3397: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3398: x_return_status => l_return_status);
3399: END IF;
3393: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3394: p_request_unique_key2 => 'I',
3395: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3396: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3397: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3398: x_return_status => l_return_status);
3399: END IF;
3400: END IF;
3401:
3398: x_return_status => l_return_status);
3399: END IF;
3400: END IF;
3401:
3402: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3403: p_QUALIFIERS_rec.list_line_id = -1 THEN
3404: -- header qualifier is modified
3405: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3406: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3401:
3402: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3403: p_QUALIFIERS_rec.list_line_id = -1 THEN
3404: -- header qualifier is modified
3405: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3406: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3407: -- updated other than qualifier grouping number
3408: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3409: qp_delayed_requests_pvt.log_request(
3406: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3407: -- updated other than qualifier grouping number
3408: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3409: qp_delayed_requests_pvt.log_request(
3410: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3411: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3412: p_request_unique_key1 => NULL,
3413: p_request_unique_key2 => 'U',
3414: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3410: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3411: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3412: p_request_unique_key1 => NULL,
3413: p_request_unique_key2 => 'U',
3414: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3415: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3416: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3417: x_return_status => l_return_status);
3418: ELSE
3412: p_request_unique_key1 => NULL,
3413: p_request_unique_key2 => 'U',
3414: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3415: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3416: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3417: x_return_status => l_return_status);
3418: ELSE
3419: qp_delayed_requests_pvt.log_request(
3420: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3416: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3417: x_return_status => l_return_status);
3418: ELSE
3419: qp_delayed_requests_pvt.log_request(
3420: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3421: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3422: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3423: p_request_unique_key2 => 'U',
3424: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3420: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3421: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3422: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3423: p_request_unique_key2 => 'U',
3424: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3425: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3426: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3427: x_return_status => l_return_status);
3428: END IF;
3422: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3423: p_request_unique_key2 => 'U',
3424: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3425: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3426: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3427: x_return_status => l_return_status);
3428: END IF;
3429:
3430: ELSE
3431: -- qualifier grouping number is modified
3432: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3433: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3434: qp_delayed_requests_pvt.log_request(
3435: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3436: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3437: p_request_unique_key1 => NULL,
3438: p_request_unique_key2 => 'U',
3439: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3435: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3436: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3437: p_request_unique_key1 => NULL,
3438: p_request_unique_key2 => 'U',
3439: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3440: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3441: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3442: x_return_status => l_return_status);
3443: ELSE
3437: p_request_unique_key1 => NULL,
3438: p_request_unique_key2 => 'U',
3439: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3440: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3441: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3442: x_return_status => l_return_status);
3443: ELSE
3444: qp_delayed_requests_pvt.log_request(
3445: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3441: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3442: x_return_status => l_return_status);
3443: ELSE
3444: qp_delayed_requests_pvt.log_request(
3445: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3446: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3447: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3448: p_request_unique_key2 => 'U',
3449: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3445: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3446: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3447: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3448: p_request_unique_key2 => 'U',
3449: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3450: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3451: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3452: x_return_status => l_return_status);
3453: qp_delayed_requests_pvt.log_request(
3447: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3448: p_request_unique_key2 => 'U',
3449: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3450: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3451: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3452: x_return_status => l_return_status);
3453: qp_delayed_requests_pvt.log_request(
3454: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3455: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3450: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3451: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3452: x_return_status => l_return_status);
3453: qp_delayed_requests_pvt.log_request(
3454: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3455: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3456: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3457: p_request_unique_key2 => 'U',
3458: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3454: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3455: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3456: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3457: p_request_unique_key2 => 'U',
3458: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3459: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3460: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3461: x_return_status => l_return_status);
3462: END IF;
3456: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3457: p_request_unique_key2 => 'U',
3458: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3459: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3460: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3461: x_return_status => l_return_status);
3462: END IF;
3463: END IF;
3464:
3463: END IF;
3464:
3465: END IF;
3466:
3467: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3468: p_QUALIFIERS_rec.list_line_id = -1 THEN
3469: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3470: qp_delayed_requests_pvt.log_request(
3471: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3467: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3468: p_QUALIFIERS_rec.list_line_id = -1 THEN
3469: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3470: qp_delayed_requests_pvt.log_request(
3471: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3472: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3473: p_request_unique_key1 => NULL,
3474: p_request_unique_key2 => 'D',
3475: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3471: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3472: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3473: p_request_unique_key1 => NULL,
3474: p_request_unique_key2 => 'D',
3475: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3476: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3477: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3478: x_return_status => l_return_status);
3479: ELSE
3473: p_request_unique_key1 => NULL,
3474: p_request_unique_key2 => 'D',
3475: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3476: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3477: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3478: x_return_status => l_return_status);
3479: ELSE
3480: qp_delayed_requests_pvt.log_request(
3481: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3477: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3478: x_return_status => l_return_status);
3479: ELSE
3480: qp_delayed_requests_pvt.log_request(
3481: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3482: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3483: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3484: p_request_unique_key2 => 'D',
3485: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3481: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3482: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3483: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3484: p_request_unique_key2 => 'D',
3485: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3486: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3487: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3488: x_return_status => l_return_status);
3489: END IF;
3483: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3484: p_request_unique_key2 => 'D',
3485: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3486: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3487: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3488: x_return_status => l_return_status);
3489: END IF;
3490:
3491: END IF;
3489: END IF;
3490:
3491: END IF;
3492: -- line pattern
3493: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3494: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3495: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3496: qp_delayed_requests_pvt.log_request(
3497: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3493: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3494: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3495: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3496: qp_delayed_requests_pvt.log_request(
3497: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3498: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3499: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3500: p_request_unique_key2 => NULL,
3501: p_request_unique_key3 => 'I',
3498: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3499: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3500: p_request_unique_key2 => NULL,
3501: p_request_unique_key3 => 'I',
3502: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3503: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3504: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3505: x_return_status => l_return_status);
3506: ELSE
3500: p_request_unique_key2 => NULL,
3501: p_request_unique_key3 => 'I',
3502: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3503: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3504: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3505: x_return_status => l_return_status);
3506: ELSE
3507: qp_delayed_requests_pvt.log_request(
3508: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3504: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3505: x_return_status => l_return_status);
3506: ELSE
3507: qp_delayed_requests_pvt.log_request(
3508: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3509: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3510: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3511: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3512: p_request_unique_key3 => 'I',
3509: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3510: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3511: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3512: p_request_unique_key3 => 'I',
3513: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3514: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3515: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3516: x_return_status => l_return_status);
3517: END IF;
3511: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3512: p_request_unique_key3 => 'I',
3513: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3514: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3515: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3516: x_return_status => l_return_status);
3517: END IF;
3518: END IF;
3519:
3516: x_return_status => l_return_status);
3517: END IF;
3518: END IF;
3519:
3520: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3521: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3522: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3523: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3524: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3518: END IF;
3519:
3520: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3521: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3522: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3523: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3524: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3525: qp_delayed_requests_pvt.log_request(
3526: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3522: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3523: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3524: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3525: qp_delayed_requests_pvt.log_request(
3526: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3527: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3528: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3529: p_request_unique_key2 => NULL,
3530: p_request_unique_key3 => 'U',
3527: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3528: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3529: p_request_unique_key2 => NULL,
3530: p_request_unique_key3 => 'U',
3531: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3532: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3533: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3534: x_return_status => l_return_status);
3535: ELSE
3529: p_request_unique_key2 => NULL,
3530: p_request_unique_key3 => 'U',
3531: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3532: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3533: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3534: x_return_status => l_return_status);
3535: ELSE
3536: qp_delayed_requests_pvt.log_request(
3537: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3533: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3534: x_return_status => l_return_status);
3535: ELSE
3536: qp_delayed_requests_pvt.log_request(
3537: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3538: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3539: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3540: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3541: p_request_unique_key3 => 'U',
3538: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3539: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3540: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3541: p_request_unique_key3 => 'U',
3542: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3543: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3544: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3545: x_return_status => l_return_status);
3546: END IF;
3540: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3541: p_request_unique_key3 => 'U',
3542: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3543: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3544: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3545: x_return_status => l_return_status);
3546: END IF;
3547:
3548: ELSE
3548: ELSE
3549: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3550: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3551: qp_delayed_requests_pvt.log_request(
3552: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3553: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3554: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3555: p_request_unique_key2 => NULL,
3556: p_request_unique_key3 => 'U',
3553: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3554: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3555: p_request_unique_key2 => NULL,
3556: p_request_unique_key3 => 'U',
3557: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3558: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3559: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3560: x_return_status => l_return_status);
3561: ELSE
3555: p_request_unique_key2 => NULL,
3556: p_request_unique_key3 => 'U',
3557: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3558: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3559: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3560: x_return_status => l_return_status);
3561: ELSE
3562: qp_delayed_requests_pvt.log_request(
3563: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3559: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3560: x_return_status => l_return_status);
3561: ELSE
3562: qp_delayed_requests_pvt.log_request(
3563: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3564: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3565: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3566: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3567: p_request_unique_key3 => 'U',
3564: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3565: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3566: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3567: p_request_unique_key3 => 'U',
3568: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3569: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3570: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3571: x_return_status => l_return_status);
3572: qp_delayed_requests_pvt.log_request(
3566: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3567: p_request_unique_key3 => 'U',
3568: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3569: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3570: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3571: x_return_status => l_return_status);
3572: qp_delayed_requests_pvt.log_request(
3573: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3574: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3569: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3570: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3571: x_return_status => l_return_status);
3572: qp_delayed_requests_pvt.log_request(
3573: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3574: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3575: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3576: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3577: p_request_unique_key3 => 'U',
3574: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3575: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3576: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3577: p_request_unique_key3 => 'U',
3578: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3579: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3580: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3581: x_return_status => l_return_status);
3582: END IF;
3576: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3577: p_request_unique_key3 => 'U',
3578: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3579: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3580: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3581: x_return_status => l_return_status);
3582: END IF;
3583: END IF;
3584:
3583: END IF;
3584:
3585: END IF;
3586:
3587: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3588: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3589: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3590: qp_delayed_requests_pvt.log_request(
3591: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3587: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3588: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3589: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3590: qp_delayed_requests_pvt.log_request(
3591: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3592: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3593: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3594: p_request_unique_key2 => NULL,
3595: p_request_unique_key3 => 'D',
3592: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3593: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3594: p_request_unique_key2 => NULL,
3595: p_request_unique_key3 => 'D',
3596: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3597: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3598: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3599: x_return_status => l_return_status);
3600: ELSE
3594: p_request_unique_key2 => NULL,
3595: p_request_unique_key3 => 'D',
3596: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3597: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3598: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3599: x_return_status => l_return_status);
3600: ELSE
3601: qp_delayed_requests_pvt.log_request(
3602: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3598: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3599: x_return_status => l_return_status);
3600: ELSE
3601: qp_delayed_requests_pvt.log_request(
3602: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3603: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3604: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3605: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3606: p_request_unique_key3 => 'D',
3603: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3604: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3605: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3606: p_request_unique_key3 => 'D',
3607: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3608: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3609: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3610: x_return_status => l_return_status);
3611: END IF;
3605: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3606: p_request_unique_key3 => 'D',
3607: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3608: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3609: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3610: x_return_status => l_return_status);
3611: END IF;
3612:
3613: END IF;