[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');
2369:
2370: -- Row locked. Compare IN attributes to DB attributes.
2371:
2372:
2373: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2374: l_QUALIFIERS_rec.attribute1)
2375: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2376: l_QUALIFIERS_rec.attribute10)
2377: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2371:
2372:
2373: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2374: l_QUALIFIERS_rec.attribute1)
2375: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2376: l_QUALIFIERS_rec.attribute10)
2377: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2378: l_QUALIFIERS_rec.attribute11)
2379: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2373: /*IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2374: l_QUALIFIERS_rec.attribute1)
2375: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2376: l_QUALIFIERS_rec.attribute10)
2377: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2378: l_QUALIFIERS_rec.attribute11)
2379: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2380: l_QUALIFIERS_rec.attribute12)
2381: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2375: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2376: l_QUALIFIERS_rec.attribute10)
2377: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2378: l_QUALIFIERS_rec.attribute11)
2379: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2380: l_QUALIFIERS_rec.attribute12)
2381: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2382: l_QUALIFIERS_rec.attribute13)
2383: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2377: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2378: l_QUALIFIERS_rec.attribute11)
2379: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2380: l_QUALIFIERS_rec.attribute12)
2381: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2382: l_QUALIFIERS_rec.attribute13)
2383: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2384: l_QUALIFIERS_rec.attribute14)
2385: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2379: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2380: l_QUALIFIERS_rec.attribute12)
2381: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2382: l_QUALIFIERS_rec.attribute13)
2383: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2384: l_QUALIFIERS_rec.attribute14)
2385: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2386: l_QUALIFIERS_rec.attribute15)
2387: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2381: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2382: l_QUALIFIERS_rec.attribute13)
2383: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2384: l_QUALIFIERS_rec.attribute14)
2385: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2386: l_QUALIFIERS_rec.attribute15)
2387: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2388: l_QUALIFIERS_rec.attribute2)
2389: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2383: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2384: l_QUALIFIERS_rec.attribute14)
2385: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2386: l_QUALIFIERS_rec.attribute15)
2387: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2388: l_QUALIFIERS_rec.attribute2)
2389: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2390: l_QUALIFIERS_rec.attribute3)
2391: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2385: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2386: l_QUALIFIERS_rec.attribute15)
2387: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2388: l_QUALIFIERS_rec.attribute2)
2389: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2390: l_QUALIFIERS_rec.attribute3)
2391: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2392: l_QUALIFIERS_rec.attribute4)
2393: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2387: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2388: l_QUALIFIERS_rec.attribute2)
2389: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2390: l_QUALIFIERS_rec.attribute3)
2391: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2392: l_QUALIFIERS_rec.attribute4)
2393: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2394: l_QUALIFIERS_rec.attribute5)
2395: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2389: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2390: l_QUALIFIERS_rec.attribute3)
2391: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2392: l_QUALIFIERS_rec.attribute4)
2393: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2394: l_QUALIFIERS_rec.attribute5)
2395: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2396: l_QUALIFIERS_rec.attribute6)
2397: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2391: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2392: l_QUALIFIERS_rec.attribute4)
2393: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2394: l_QUALIFIERS_rec.attribute5)
2395: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2396: l_QUALIFIERS_rec.attribute6)
2397: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2398: l_QUALIFIERS_rec.attribute7)
2399: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2393: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2394: l_QUALIFIERS_rec.attribute5)
2395: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2396: l_QUALIFIERS_rec.attribute6)
2397: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2398: l_QUALIFIERS_rec.attribute7)
2399: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2400: l_QUALIFIERS_rec.attribute8)
2401: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2395: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2396: l_QUALIFIERS_rec.attribute6)
2397: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2398: l_QUALIFIERS_rec.attribute7)
2399: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2400: l_QUALIFIERS_rec.attribute8)
2401: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2402: l_QUALIFIERS_rec.attribute9)
2403: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2397: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2398: l_QUALIFIERS_rec.attribute7)
2399: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2400: l_QUALIFIERS_rec.attribute8)
2401: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2402: l_QUALIFIERS_rec.attribute9)
2403: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2404: l_QUALIFIERS_rec.comparison_operator_code)
2405: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2399: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2400: l_QUALIFIERS_rec.attribute8)
2401: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2402: l_QUALIFIERS_rec.attribute9)
2403: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2404: l_QUALIFIERS_rec.comparison_operator_code)
2405: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2406: l_QUALIFIERS_rec.context)
2407: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2401: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2402: l_QUALIFIERS_rec.attribute9)
2403: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2404: l_QUALIFIERS_rec.comparison_operator_code)
2405: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2406: l_QUALIFIERS_rec.context)
2407: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2408: l_QUALIFIERS_rec.created_by)
2409: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2403: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2404: l_QUALIFIERS_rec.comparison_operator_code)
2405: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2406: l_QUALIFIERS_rec.context)
2407: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2408: l_QUALIFIERS_rec.created_by)
2409: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2410: l_QUALIFIERS_rec.created_from_rule_id)
2411: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2405: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2406: l_QUALIFIERS_rec.context)
2407: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2408: l_QUALIFIERS_rec.created_by)
2409: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2410: l_QUALIFIERS_rec.created_from_rule_id)
2411: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2412: -- l_QUALIFIERS_rec.creation_date)
2413: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2407: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2408: l_QUALIFIERS_rec.created_by)
2409: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2410: l_QUALIFIERS_rec.created_from_rule_id)
2411: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2412: -- l_QUALIFIERS_rec.creation_date)
2413: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2414: l_QUALIFIERS_rec.end_date_active)
2415: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2409: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2410: l_QUALIFIERS_rec.created_from_rule_id)
2411: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2412: -- l_QUALIFIERS_rec.creation_date)
2413: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2414: l_QUALIFIERS_rec.end_date_active)
2415: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2416: l_QUALIFIERS_rec.excluder_flag)
2417: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2411: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2412: -- l_QUALIFIERS_rec.creation_date)
2413: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2414: l_QUALIFIERS_rec.end_date_active)
2415: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2416: l_QUALIFIERS_rec.excluder_flag)
2417: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2418: -- l_QUALIFIERS_rec.last_updated_by)
2419: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2413: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2414: l_QUALIFIERS_rec.end_date_active)
2415: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2416: l_QUALIFIERS_rec.excluder_flag)
2417: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2418: -- l_QUALIFIERS_rec.last_updated_by)
2419: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2420: -- l_QUALIFIERS_rec.last_update_date)
2421: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2415: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2416: l_QUALIFIERS_rec.excluder_flag)
2417: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2418: -- l_QUALIFIERS_rec.last_updated_by)
2419: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2420: -- l_QUALIFIERS_rec.last_update_date)
2421: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2422: l_QUALIFIERS_rec.last_update_login)
2423: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2417: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2418: -- l_QUALIFIERS_rec.last_updated_by)
2419: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2420: -- l_QUALIFIERS_rec.last_update_date)
2421: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2422: l_QUALIFIERS_rec.last_update_login)
2423: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2424: l_QUALIFIERS_rec.list_header_id)
2425: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2419: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2420: -- l_QUALIFIERS_rec.last_update_date)
2421: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2422: l_QUALIFIERS_rec.last_update_login)
2423: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2424: l_QUALIFIERS_rec.list_header_id)
2425: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2426: l_QUALIFIERS_rec.list_line_id)
2427: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2421: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2422: l_QUALIFIERS_rec.last_update_login)
2423: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2424: l_QUALIFIERS_rec.list_header_id)
2425: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2426: l_QUALIFIERS_rec.list_line_id)
2427: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2428: l_QUALIFIERS_rec.program_application_id)
2429: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2423: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2424: l_QUALIFIERS_rec.list_header_id)
2425: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2426: l_QUALIFIERS_rec.list_line_id)
2427: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2428: l_QUALIFIERS_rec.program_application_id)
2429: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2430: l_QUALIFIERS_rec.program_id)
2431: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2425: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2426: l_QUALIFIERS_rec.list_line_id)
2427: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2428: l_QUALIFIERS_rec.program_application_id)
2429: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2430: l_QUALIFIERS_rec.program_id)
2431: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2432: -- l_QUALIFIERS_rec.program_update_date)
2433: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2427: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2428: l_QUALIFIERS_rec.program_application_id)
2429: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2430: l_QUALIFIERS_rec.program_id)
2431: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2432: -- l_QUALIFIERS_rec.program_update_date)
2433: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2434: l_QUALIFIERS_rec.qualifier_attribute)
2435: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2429: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2430: l_QUALIFIERS_rec.program_id)
2431: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2432: -- l_QUALIFIERS_rec.program_update_date)
2433: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2434: l_QUALIFIERS_rec.qualifier_attribute)
2435: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2436: l_QUALIFIERS_rec.qualifier_attr_value)
2437: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2431: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2432: -- l_QUALIFIERS_rec.program_update_date)
2433: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2434: l_QUALIFIERS_rec.qualifier_attribute)
2435: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2436: l_QUALIFIERS_rec.qualifier_attr_value)
2437: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2438: l_QUALIFIERS_rec.qualifier_attr_value_to)
2439: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2433: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2434: l_QUALIFIERS_rec.qualifier_attribute)
2435: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2436: l_QUALIFIERS_rec.qualifier_attr_value)
2437: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2438: l_QUALIFIERS_rec.qualifier_attr_value_to)
2439: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2440: l_QUALIFIERS_rec.qualifier_context)
2441: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2435: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2436: l_QUALIFIERS_rec.qualifier_attr_value)
2437: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2438: l_QUALIFIERS_rec.qualifier_attr_value_to)
2439: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2440: l_QUALIFIERS_rec.qualifier_context)
2441: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2442: l_QUALIFIERS_rec.qualifier_datatype)
2443: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2437: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2438: l_QUALIFIERS_rec.qualifier_attr_value_to)
2439: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2440: l_QUALIFIERS_rec.qualifier_context)
2441: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2442: l_QUALIFIERS_rec.qualifier_datatype)
2443: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2444: -- l_QUALIFIERS_rec.qualifier_date_format)
2445: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2439: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2440: l_QUALIFIERS_rec.qualifier_context)
2441: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2442: l_QUALIFIERS_rec.qualifier_datatype)
2443: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2444: -- l_QUALIFIERS_rec.qualifier_date_format)
2445: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2446: l_QUALIFIERS_rec.qualifier_grouping_no)
2447: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2441: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2442: l_QUALIFIERS_rec.qualifier_datatype)
2443: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2444: -- l_QUALIFIERS_rec.qualifier_date_format)
2445: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2446: l_QUALIFIERS_rec.qualifier_grouping_no)
2447: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2448: l_QUALIFIERS_rec.qualifier_id)
2449: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2443: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2444: -- l_QUALIFIERS_rec.qualifier_date_format)
2445: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2446: l_QUALIFIERS_rec.qualifier_grouping_no)
2447: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2448: l_QUALIFIERS_rec.qualifier_id)
2449: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2450: -- l_QUALIFIERS_rec.qualifier_number_format)
2451: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2445: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2446: l_QUALIFIERS_rec.qualifier_grouping_no)
2447: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2448: l_QUALIFIERS_rec.qualifier_id)
2449: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2450: -- l_QUALIFIERS_rec.qualifier_number_format)
2451: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2452: l_QUALIFIERS_rec.qualifier_precedence)
2453: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2447: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2448: l_QUALIFIERS_rec.qualifier_id)
2449: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2450: -- l_QUALIFIERS_rec.qualifier_number_format)
2451: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2452: l_QUALIFIERS_rec.qualifier_precedence)
2453: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2454: l_QUALIFIERS_rec.qualifier_rule_id)
2455: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2449: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2450: -- l_QUALIFIERS_rec.qualifier_number_format)
2451: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2452: l_QUALIFIERS_rec.qualifier_precedence)
2453: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2454: l_QUALIFIERS_rec.qualifier_rule_id)
2455: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2456: l_QUALIFIERS_rec.request_id)
2457: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2451: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2452: l_QUALIFIERS_rec.qualifier_precedence)
2453: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2454: l_QUALIFIERS_rec.qualifier_rule_id)
2455: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2456: l_QUALIFIERS_rec.request_id)
2457: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2458: l_QUALIFIERS_rec.start_date_active)*/
2459:
2453: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2454: l_QUALIFIERS_rec.qualifier_rule_id)
2455: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2456: l_QUALIFIERS_rec.request_id)
2457: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2458: l_QUALIFIERS_rec.start_date_active)*/
2459:
2460:
2461: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2457: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2458: l_QUALIFIERS_rec.start_date_active)*/
2459:
2460:
2461: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2462: l_QUALIFIERS_rec.attribute1)
2463: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2464: l_QUALIFIERS_rec.attribute10)
2465: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2459:
2460:
2461: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2462: l_QUALIFIERS_rec.attribute1)
2463: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2464: l_QUALIFIERS_rec.attribute10)
2465: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2466: l_QUALIFIERS_rec.attribute11)
2467: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2461: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute1,
2462: l_QUALIFIERS_rec.attribute1)
2463: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2464: l_QUALIFIERS_rec.attribute10)
2465: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2466: l_QUALIFIERS_rec.attribute11)
2467: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2468: l_QUALIFIERS_rec.attribute12)
2469: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2463: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute10,
2464: l_QUALIFIERS_rec.attribute10)
2465: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2466: l_QUALIFIERS_rec.attribute11)
2467: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2468: l_QUALIFIERS_rec.attribute12)
2469: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2470: l_QUALIFIERS_rec.attribute13)
2471: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2465: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute11,
2466: l_QUALIFIERS_rec.attribute11)
2467: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2468: l_QUALIFIERS_rec.attribute12)
2469: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2470: l_QUALIFIERS_rec.attribute13)
2471: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2472: l_QUALIFIERS_rec.attribute14)
2473: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2467: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute12,
2468: l_QUALIFIERS_rec.attribute12)
2469: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2470: l_QUALIFIERS_rec.attribute13)
2471: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2472: l_QUALIFIERS_rec.attribute14)
2473: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2474: l_QUALIFIERS_rec.attribute15)
2475: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2469: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute13,
2470: l_QUALIFIERS_rec.attribute13)
2471: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2472: l_QUALIFIERS_rec.attribute14)
2473: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2474: l_QUALIFIERS_rec.attribute15)
2475: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2476: l_QUALIFIERS_rec.attribute2)
2477: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2471: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute14,
2472: l_QUALIFIERS_rec.attribute14)
2473: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2474: l_QUALIFIERS_rec.attribute15)
2475: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2476: l_QUALIFIERS_rec.attribute2)
2477: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2478: l_QUALIFIERS_rec.attribute3)
2479: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2473: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute15,
2474: l_QUALIFIERS_rec.attribute15)
2475: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2476: l_QUALIFIERS_rec.attribute2)
2477: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2478: l_QUALIFIERS_rec.attribute3)
2479: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2480: l_QUALIFIERS_rec.attribute4)
2481: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2475: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute2,
2476: l_QUALIFIERS_rec.attribute2)
2477: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2478: l_QUALIFIERS_rec.attribute3)
2479: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2480: l_QUALIFIERS_rec.attribute4)
2481: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2482: l_QUALIFIERS_rec.attribute5)
2483: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2477: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute3,
2478: l_QUALIFIERS_rec.attribute3)
2479: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2480: l_QUALIFIERS_rec.attribute4)
2481: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2482: l_QUALIFIERS_rec.attribute5)
2483: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2484: l_QUALIFIERS_rec.attribute6)
2485: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2479: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute4,
2480: l_QUALIFIERS_rec.attribute4)
2481: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2482: l_QUALIFIERS_rec.attribute5)
2483: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2484: l_QUALIFIERS_rec.attribute6)
2485: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2486: l_QUALIFIERS_rec.attribute7)
2487: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2481: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute5,
2482: l_QUALIFIERS_rec.attribute5)
2483: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2484: l_QUALIFIERS_rec.attribute6)
2485: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2486: l_QUALIFIERS_rec.attribute7)
2487: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2488: l_QUALIFIERS_rec.attribute8)
2489: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2483: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute6,
2484: l_QUALIFIERS_rec.attribute6)
2485: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2486: l_QUALIFIERS_rec.attribute7)
2487: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2488: l_QUALIFIERS_rec.attribute8)
2489: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2490: l_QUALIFIERS_rec.attribute9)
2491: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2485: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute7,
2486: l_QUALIFIERS_rec.attribute7)
2487: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2488: l_QUALIFIERS_rec.attribute8)
2489: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2490: l_QUALIFIERS_rec.attribute9)
2491: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2492: l_QUALIFIERS_rec.comparison_operator_code)
2493: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2487: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute8,
2488: l_QUALIFIERS_rec.attribute8)
2489: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2490: l_QUALIFIERS_rec.attribute9)
2491: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2492: l_QUALIFIERS_rec.comparison_operator_code)
2493: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2494: l_QUALIFIERS_rec.context)
2495: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2489: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.attribute9,
2490: l_QUALIFIERS_rec.attribute9)
2491: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2492: l_QUALIFIERS_rec.comparison_operator_code)
2493: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2494: l_QUALIFIERS_rec.context)
2495: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2496: -- l_QUALIFIERS_rec.created_by)
2497: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2491: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2492: l_QUALIFIERS_rec.comparison_operator_code)
2493: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2494: l_QUALIFIERS_rec.context)
2495: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2496: -- l_QUALIFIERS_rec.created_by)
2497: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2498: l_QUALIFIERS_rec.created_from_rule_id)
2499: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2493: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.context,
2494: l_QUALIFIERS_rec.context)
2495: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2496: -- l_QUALIFIERS_rec.created_by)
2497: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2498: l_QUALIFIERS_rec.created_from_rule_id)
2499: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2500: -- l_QUALIFIERS_rec.creation_date)
2501: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2495: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_by,
2496: -- l_QUALIFIERS_rec.created_by)
2497: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2498: l_QUALIFIERS_rec.created_from_rule_id)
2499: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2500: -- l_QUALIFIERS_rec.creation_date)
2501: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2502: l_QUALIFIERS_rec.end_date_active)
2503: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2497: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2498: l_QUALIFIERS_rec.created_from_rule_id)
2499: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2500: -- l_QUALIFIERS_rec.creation_date)
2501: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2502: l_QUALIFIERS_rec.end_date_active)
2503: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2504: l_QUALIFIERS_rec.excluder_flag)
2505: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2499: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.creation_date,
2500: -- l_QUALIFIERS_rec.creation_date)
2501: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2502: l_QUALIFIERS_rec.end_date_active)
2503: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2504: l_QUALIFIERS_rec.excluder_flag)
2505: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2506: -- l_QUALIFIERS_rec.last_updated_by)
2507: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2501: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.end_date_active,
2502: l_QUALIFIERS_rec.end_date_active)
2503: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2504: l_QUALIFIERS_rec.excluder_flag)
2505: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2506: -- l_QUALIFIERS_rec.last_updated_by)
2507: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2508: -- l_QUALIFIERS_rec.last_update_date)
2509: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2503: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2504: l_QUALIFIERS_rec.excluder_flag)
2505: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2506: -- l_QUALIFIERS_rec.last_updated_by)
2507: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2508: -- l_QUALIFIERS_rec.last_update_date)
2509: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2510: -- l_QUALIFIERS_rec.last_update_login)
2511: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2505: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_updated_by,
2506: -- l_QUALIFIERS_rec.last_updated_by)
2507: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2508: -- l_QUALIFIERS_rec.last_update_date)
2509: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2510: -- l_QUALIFIERS_rec.last_update_login)
2511: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2512: l_QUALIFIERS_rec.list_header_id)
2513: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2507: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_date,
2508: -- l_QUALIFIERS_rec.last_update_date)
2509: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2510: -- l_QUALIFIERS_rec.last_update_login)
2511: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2512: l_QUALIFIERS_rec.list_header_id)
2513: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2514: l_QUALIFIERS_rec.list_line_id)
2515: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2509: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.last_update_login,
2510: -- l_QUALIFIERS_rec.last_update_login)
2511: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2512: l_QUALIFIERS_rec.list_header_id)
2513: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2514: l_QUALIFIERS_rec.list_line_id)
2515: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2516: -- l_QUALIFIERS_rec.program_application_id)
2517: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2511: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2512: l_QUALIFIERS_rec.list_header_id)
2513: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2514: l_QUALIFIERS_rec.list_line_id)
2515: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2516: -- l_QUALIFIERS_rec.program_application_id)
2517: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2518: -- l_QUALIFIERS_rec.program_id)
2519: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2513: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2514: l_QUALIFIERS_rec.list_line_id)
2515: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2516: -- l_QUALIFIERS_rec.program_application_id)
2517: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2518: -- l_QUALIFIERS_rec.program_id)
2519: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2520: -- l_QUALIFIERS_rec.program_update_date)
2521: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2515: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_application_id,
2516: -- l_QUALIFIERS_rec.program_application_id)
2517: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2518: -- l_QUALIFIERS_rec.program_id)
2519: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2520: -- l_QUALIFIERS_rec.program_update_date)
2521: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2522: l_QUALIFIERS_rec.qualifier_attribute)
2523: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2517: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_id,
2518: -- l_QUALIFIERS_rec.program_id)
2519: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2520: -- l_QUALIFIERS_rec.program_update_date)
2521: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2522: l_QUALIFIERS_rec.qualifier_attribute)
2523: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2524: l_QUALIFIERS_rec.qualifier_attr_value)
2525: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2519: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.program_update_date,
2520: -- l_QUALIFIERS_rec.program_update_date)
2521: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2522: l_QUALIFIERS_rec.qualifier_attribute)
2523: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2524: l_QUALIFIERS_rec.qualifier_attr_value)
2525: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2526: l_QUALIFIERS_rec.qualifier_attr_value_to)
2527: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2521: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
2522: l_QUALIFIERS_rec.qualifier_attribute)
2523: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2524: l_QUALIFIERS_rec.qualifier_attr_value)
2525: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2526: l_QUALIFIERS_rec.qualifier_attr_value_to)
2527: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2528: l_QUALIFIERS_rec.qualifier_context)
2529: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2523: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value,
2524: l_QUALIFIERS_rec.qualifier_attr_value)
2525: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2526: l_QUALIFIERS_rec.qualifier_attr_value_to)
2527: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2528: l_QUALIFIERS_rec.qualifier_context)
2529: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2530: l_QUALIFIERS_rec.qualifier_datatype)
2531: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2525: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attr_value_to,
2526: l_QUALIFIERS_rec.qualifier_attr_value_to)
2527: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2528: l_QUALIFIERS_rec.qualifier_context)
2529: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2530: l_QUALIFIERS_rec.qualifier_datatype)
2531: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2532: -- l_QUALIFIERS_rec.qualifier_date_format)
2533: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2527: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_context,
2528: l_QUALIFIERS_rec.qualifier_context)
2529: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2530: l_QUALIFIERS_rec.qualifier_datatype)
2531: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2532: -- l_QUALIFIERS_rec.qualifier_date_format)
2533: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2534: l_QUALIFIERS_rec.qualifier_grouping_no)
2535: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2529: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_datatype,
2530: l_QUALIFIERS_rec.qualifier_datatype)
2531: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2532: -- l_QUALIFIERS_rec.qualifier_date_format)
2533: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2534: l_QUALIFIERS_rec.qualifier_grouping_no)
2535: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2536: l_QUALIFIERS_rec.qualifier_id)
2537: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2531: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_date_format,
2532: -- l_QUALIFIERS_rec.qualifier_date_format)
2533: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2534: l_QUALIFIERS_rec.qualifier_grouping_no)
2535: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2536: l_QUALIFIERS_rec.qualifier_id)
2537: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2538: -- l_QUALIFIERS_rec.qualifier_number_format)
2539: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2533: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
2534: l_QUALIFIERS_rec.qualifier_grouping_no)
2535: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2536: l_QUALIFIERS_rec.qualifier_id)
2537: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2538: -- l_QUALIFIERS_rec.qualifier_number_format)
2539: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2540: l_QUALIFIERS_rec.qualifier_precedence)
2541: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2535: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2536: l_QUALIFIERS_rec.qualifier_id)
2537: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2538: -- l_QUALIFIERS_rec.qualifier_number_format)
2539: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2540: l_QUALIFIERS_rec.qualifier_precedence)
2541: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2542: l_QUALIFIERS_rec.qualifier_rule_id)
2543: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2537: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_number_format,
2538: -- l_QUALIFIERS_rec.qualifier_number_format)
2539: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2540: l_QUALIFIERS_rec.qualifier_precedence)
2541: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2542: l_QUALIFIERS_rec.qualifier_rule_id)
2543: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2544: -- l_QUALIFIERS_rec.request_id)
2545: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2539: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_precedence,
2540: l_QUALIFIERS_rec.qualifier_precedence)
2541: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2542: l_QUALIFIERS_rec.qualifier_rule_id)
2543: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2544: -- l_QUALIFIERS_rec.request_id)
2545: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2546: l_QUALIFIERS_rec.start_date_active)
2547: -- Added for TCA
2541: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2542: l_QUALIFIERS_rec.qualifier_rule_id)
2543: --AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.request_id,
2544: -- l_QUALIFIERS_rec.request_id)
2545: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2546: l_QUALIFIERS_rec.start_date_active)
2547: -- Added for TCA
2548: AND (QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,
2549: l_QUALIFIERS_rec.qualify_hier_descendent_flag)
2544: -- l_QUALIFIERS_rec.request_id)
2545: AND QP_GLOBALS.Equal(p_QUALIFIERS_rec.start_date_active,
2546: l_QUALIFIERS_rec.start_date_active)
2547: -- Added for TCA
2548: AND (QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualify_hier_descendent_flag,
2549: l_QUALIFIERS_rec.qualify_hier_descendent_flag)
2550: OR (p_QUALIFIERS_rec.qualify_hier_descendent_flag = FND_API.G_MISS_CHAR
2551: and l_QUALIFIERS_rec.qualify_hier_descendent_flag is null))
2552: THEN
2680: BEGIN
2681:
2682: /*IF p_QUALIFIERS_rec.comparison_operator_code IS NOT NULL AND
2683: p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR AND
2684: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.comparison_operator_code,
2685: p_old_QUALIFIERS_rec.comparison_operator_code)
2686: THEN
2687: l_QUALIFIERS_val_rec.comparison_operator := QP_Id_To_Value.Comparison_Operator
2688: ( p_comparison_operator_code => p_QUALIFIERS_rec.comparison_operator_code
2690: END IF;*/
2691:
2692: IF p_QUALIFIERS_rec.created_from_rule_id IS NOT NULL AND
2693: p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM AND
2694: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.created_from_rule_id,
2695: p_old_QUALIFIERS_rec.created_from_rule_id)
2696: THEN
2697: l_QUALIFIERS_val_rec.created_from_rule := QP_Id_To_Value.Created_From_Rule
2698: ( p_created_from_rule_id => p_QUALIFIERS_rec.created_from_rule_id
2700: END IF;
2701:
2702: /* IF p_QUALIFIERS_rec.excluder_flag IS NOT NULL AND
2703: p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2704: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.excluder_flag,
2705: p_old_QUALIFIERS_rec.excluder_flag)
2706: THEN
2707: l_QUALIFIERS_val_rec.excluder := QP_Id_To_Value.Excluder
2708: ( p_excluder_flag => p_QUALIFIERS_rec.excluder_flag
2710: END IF;*/
2711:
2712: IF p_QUALIFIERS_rec.list_header_id IS NOT NULL AND
2713: p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
2714: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_header_id,
2715: p_old_QUALIFIERS_rec.list_header_id)
2716: THEN
2717: l_QUALIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
2718: ( p_list_header_id => p_QUALIFIERS_rec.list_header_id
2720: END IF;
2721:
2722: IF p_QUALIFIERS_rec.list_line_id IS NOT NULL AND
2723: p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
2724: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.list_line_id,
2725: p_old_QUALIFIERS_rec.list_line_id)
2726: THEN
2727: l_QUALIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
2728: ( p_list_line_id => p_QUALIFIERS_rec.list_line_id
2730: END IF;
2731:
2732: /*IF p_QUALIFIERS_rec.qualifier_id IS NOT NULL AND
2733: p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM AND
2734: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_id,
2735: p_old_QUALIFIERS_rec.qualifier_id)
2736: THEN
2737: l_QUALIFIERS_val_rec.qualifier := QP_Id_To_Value.Qualifier
2738: ( p_qualifier_id => p_QUALIFIERS_rec.qualifier_id
2740: END IF;*/
2741:
2742: IF p_QUALIFIERS_rec.qualifier_rule_id IS NOT NULL AND
2743: p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM AND
2744: NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_rule_id,
2745: p_old_QUALIFIERS_rec.qualifier_rule_id)
2746: THEN
2747: l_QUALIFIERS_val_rec.qualifier_rule := QP_Id_To_Value.Qualifier_Rule
2748: ( p_qualifier_rule_id => p_QUALIFIERS_rec.qualifier_rule_id
3109:
3110:
3111: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3112:
3113: IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3114: QP_GLOBALS.G_OPR_DELETE) ) THEN
3115: -- Get the List Type Code
3116: BEGIN
3117: SELECT list_type_code
3110:
3111: x_QUALIFIERS_rec := l_QUALIFIERS_rec;
3112:
3113: IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3114: QP_GLOBALS.G_OPR_DELETE) ) THEN
3115: -- Get the List Type Code
3116: BEGIN
3117: SELECT list_type_code
3118: INTO l_list_type_code
3194: END;
3195:
3196: --Submit a Header Level Delayed Request to update qualification_ind
3197: --while creating the first or deleting the last header level qualifier.
3198: IF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3199: p_QUALIFIERS_rec.list_line_id = -1 AND
3200: l_hlq_count = 0) OR
3201: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3202: p_QUALIFIERS_rec.list_line_id = -1 AND
3197: --while creating the first or deleting the last header level qualifier.
3198: IF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3199: p_QUALIFIERS_rec.list_line_id = -1 AND
3200: l_hlq_count = 0) OR
3201: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3202: p_QUALIFIERS_rec.list_line_id = -1 AND
3203: l_hlq_count = 1)
3204: THEN
3205:
3209: IF NOT (l_list_type_code = 'PRL' and p_QUALIFIERS_rec.qualifier_context='MODLIST'
3210: and p_QUALIFIERS_rec.qualifier_attribute='QUALIFIER_ATTRIBUTE4') THEN
3211:
3212: qp_delayed_requests_PVT.log_request(
3213: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3214: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3215: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3216: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3217: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3211:
3212: qp_delayed_requests_PVT.log_request(
3213: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3214: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3215: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3216: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3217: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3218: x_return_status => l_return_status);
3219: END IF;
3213: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3214: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3215: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3216: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3217: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
3218: x_return_status => l_return_status);
3219: END IF;
3220:
3221: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3222:
3223: oe_debug_pub.add('log delayed request------------');
3224:
3225: qp_delayed_requests_PVT.log_request(
3226: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3227: p_param1 => p_QUALIFIERS_rec.list_header_id,
3228: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3229: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3230: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3225: qp_delayed_requests_PVT.log_request(
3226: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3227: p_param1 => p_QUALIFIERS_rec.list_header_id,
3228: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3229: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3230: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3231: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3232: x_return_status => l_return_status);
3233:
3227: p_param1 => p_QUALIFIERS_rec.list_header_id,
3228: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3229: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3230: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3231: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3232: x_return_status => l_return_status);
3233:
3234: END IF;
3235:
3234: END IF;
3235:
3236: --Submit a Line Level Delayed Request to update qualification_ind
3237: --while creating the first or deleting the last line level qualifier.
3238: ELSIF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3239: p_QUALIFIERS_rec.list_line_id <> -1 AND
3240: l_llq_count = 0) OR
3241: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3242: p_QUALIFIERS_rec.list_line_id <> -1 AND
3237: --while creating the first or deleting the last line level qualifier.
3238: ELSIF (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3239: p_QUALIFIERS_rec.list_line_id <> -1 AND
3240: l_llq_count = 0) OR
3241: (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3242: p_QUALIFIERS_rec.list_line_id <> -1 AND
3243: l_llq_count = 1)
3244: THEN
3245: qp_delayed_requests_PVT.log_request(
3242: p_QUALIFIERS_rec.list_line_id <> -1 AND
3243: l_llq_count = 1)
3244: THEN
3245: qp_delayed_requests_PVT.log_request(
3246: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3247: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3248: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3249: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3250: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3244: THEN
3245: qp_delayed_requests_PVT.log_request(
3246: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3247: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3248: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3249: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3250: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3251: x_return_status => l_return_status);
3252:
3246: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3247: p_entity_id => p_QUALIFIERS_rec.list_line_id,
3248: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3249: p_requesting_entity_id => p_QUALIFIERS_rec.list_line_id,
3250: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
3251: x_return_status => l_return_status);
3252:
3253: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3254: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3252:
3253: -- mkarya for bug1769955 - log the MAINTAIN_LIST_HEADER_PHASES request for line qualifier
3254: IF l_list_type_code NOT IN ('PRL', 'AGR') THEN
3255: qp_delayed_requests_PVT.log_request(
3256: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3257: p_param1 => p_QUALIFIERS_rec.list_header_id,
3258: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3259: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3260: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3255: qp_delayed_requests_PVT.log_request(
3256: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3257: p_param1 => p_QUALIFIERS_rec.list_header_id,
3258: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3259: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3260: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3261: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3262: x_return_status => l_return_status);
3263: END IF;
3257: p_param1 => p_QUALIFIERS_rec.list_header_id,
3258: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3259: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3260: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3261: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
3262: x_return_status => l_return_status);
3263: END IF;
3264:
3265: END IF;
3266:
3267: END IF; -- If operation is create or delete.
3268:
3269: /* Added for 7120399 */
3270: if p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE then
3271:
3272: BEGIN
3273: SELECT list_type_code
3274: INTO l_list_type_code
3279: NULL;
3280: END;
3281: end if;
3282:
3283: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3284: QP_GLOBALS.G_OPR_UPDATE,
3285: QP_GLOBALS.G_OPR_DELETE) THEN
3286: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3287:
3280: END;
3281: end if;
3282:
3283: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3284: QP_GLOBALS.G_OPR_UPDATE,
3285: QP_GLOBALS.G_OPR_DELETE) THEN
3286: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3287:
3288: qp_delayed_requests_PVT.log_request(
3281: end if;
3282:
3283: IF p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3284: QP_GLOBALS.G_OPR_UPDATE,
3285: QP_GLOBALS.G_OPR_DELETE) THEN
3286: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3287:
3288: qp_delayed_requests_PVT.log_request(
3289: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3285: QP_GLOBALS.G_OPR_DELETE) THEN
3286: IF (l_list_type_code in ('PRL','AGR')) OR ((l_list_type_code NOT IN ('PRL','AGR')) AND (l_denormalize_qual= 'Y')) then --7120399
3287:
3288: qp_delayed_requests_PVT.log_request(
3289: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3290: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3291: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3293: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3287:
3288: qp_delayed_requests_PVT.log_request(
3289: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3290: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3291: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3293: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3294: x_return_status => l_return_status);
3295: END IF;
3289: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3290: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3291: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3292: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3293: p_request_type => QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS,
3294: x_return_status => l_return_status);
3295: END IF;
3296: --Added following delayed request for Attributes Manager
3297: qp_delayed_requests_PVT.log_request(
3294: x_return_status => l_return_status);
3295: END IF;
3296: --Added following delayed request for Attributes Manager
3297: qp_delayed_requests_PVT.log_request(
3298: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3299: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3300: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3301: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3302: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3296: --Added following delayed request for Attributes Manager
3297: qp_delayed_requests_PVT.log_request(
3298: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3299: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3300: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3301: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3302: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3303: p_param1 => p_QUALIFIERS_rec.qualifier_rule_id,
3304: x_return_status => l_return_status);
3298: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3299: p_entity_id => p_QUALIFIERS_rec.qualifier_id,
3300: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3301: p_requesting_entity_id => p_QUALIFIERS_rec.qualifier_id,
3302: p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS,
3303: p_param1 => p_QUALIFIERS_rec.qualifier_rule_id,
3304: x_return_status => l_return_status);
3305:
3306: END IF;
3306: END IF;
3307:
3308: /*
3309: IF (p_QUALIFIERS_rec.operation IN
3310: (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)) THEN
3311:
3312: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3313:
3314: qp_delayed_requests_PVT.log_request(
3311:
3312: oe_debug_pub.add('log delayed request--------warn_same_qual_grp');
3313:
3314: qp_delayed_requests_PVT.log_request(
3315: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3316: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3317: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3318: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3319: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3313:
3314: qp_delayed_requests_PVT.log_request(
3315: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3316: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3317: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3318: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3319: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3320: p_param1 => p_QUALIFIERS_rec.list_line_id,
3321: p_param2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3315: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3316: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3317: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3318: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3319: p_request_type =>QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP,
3320: p_param1 => p_QUALIFIERS_rec.list_line_id,
3321: p_param2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3322: p_param3 => p_QUALIFIERS_rec.qualifier_context,
3323: p_param4 => p_QUALIFIERS_rec.qualifier_attribute,
3328:
3329: -- Attribute Manager Change BEGIN - required for modifiers
3330: -- Logging the request here instead of apply_attribute_changes because list_line_id is -1 even
3331: -- if qualifier is LINE level in apply_attribute_changes
3332: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3333: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3334: IF qp_util.attrmgr_installed = 'Y' THEN
3335: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3336: p_old_QUALIFIERS_rec.qualifier_attribute))
3329: -- Attribute Manager Change BEGIN - required for modifiers
3330: -- Logging the request here instead of apply_attribute_changes because list_line_id is -1 even
3331: -- if qualifier is LINE level in apply_attribute_changes
3332: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3333: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3334: IF qp_util.attrmgr_installed = 'Y' THEN
3335: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3336: p_old_QUALIFIERS_rec.qualifier_attribute))
3337: OR
3331: -- if qualifier is LINE level in apply_attribute_changes
3332: --IF ( p_QUALIFIERS_rec.operation IN (QP_GLOBALS.G_OPR_CREATE,
3333: -- QP_GLOBALS.G_OPR_UPDATE) ) THEN
3334: IF qp_util.attrmgr_installed = 'Y' THEN
3335: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3336: p_old_QUALIFIERS_rec.qualifier_attribute))
3337: OR
3338: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3339: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3334: IF qp_util.attrmgr_installed = 'Y' THEN
3335: IF (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_attribute,
3336: p_old_QUALIFIERS_rec.qualifier_attribute))
3337: OR
3338: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3339: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3340: OR (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE) THEN
3341: -- Get the List Type Code
3342: BEGIN
3336: p_old_QUALIFIERS_rec.qualifier_attribute))
3337: OR
3338: (NOT QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3339: p_old_QUALIFIERS_rec.qualifier_grouping_no))
3340: OR (p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE) THEN
3341: -- Get the List Type Code
3342: BEGIN
3343: SELECT list_type_code
3344: INTO l_list_type_code
3352: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3353: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3354: oe_debug_pub.add('qualifier_grouping_no = ' || p_qualifiers_rec.qualifier_grouping_no);
3355: qp_delayed_requests_PVT.log_request(
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3357: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3358: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3359: p_entity_id => p_qualifiers_rec.list_line_id,
3360: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3356: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3357: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3358: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3359: p_entity_id => p_qualifiers_rec.list_line_id,
3360: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3361: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3362: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3363: x_return_status => l_return_status);
3364:
3358: p_request_unique_key2 => p_qualifiers_rec.qualifier_grouping_no,
3359: p_entity_id => p_qualifiers_rec.list_line_id,
3360: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3361: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3362: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3363: x_return_status => l_return_status);
3364:
3365: -- mkarya for attribute manager
3366: -- Log a delayed request to validate that if header level qualifier exist then at least
3367: -- one qualifier should exist for any existence of modifier line of modifier level
3368: -- 'LINE' or 'ORDER'
3369: if p_qualifiers_rec.list_line_id = -1 then
3370: qp_delayed_requests_PVT.log_request(
3371: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3372: p_entity_id => l_qualifiers_rec.list_header_id,
3373: p_request_unique_key1 => -1,
3374: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3375: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3370: qp_delayed_requests_PVT.log_request(
3371: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3372: p_entity_id => l_qualifiers_rec.list_header_id,
3373: p_request_unique_key1 => -1,
3374: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3375: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3376: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
3377: x_return_status => l_return_status);
3378: end if;
3372: p_entity_id => l_qualifiers_rec.list_header_id,
3373: p_request_unique_key1 => -1,
3374: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
3375: p_requesting_entity_id => l_qualifiers_rec.list_header_id,
3376: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
3377: x_return_status => l_return_status);
3378: end if;
3379:
3380: -- if qualifier_grouping_no is updated to -1 then log the request for all other
3379:
3380: -- if qualifier_grouping_no is updated to -1 then log the request for all other
3381: -- qualifier_grouping_no for the given list_header_id and list_line_id
3382: if p_qualifiers_rec.qualifier_grouping_no = -1
3383: and p_qualifiers_rec.operation = QP_GLOBALS.G_OPR_UPDATE then
3384: declare
3385: cursor c_qual_grp is
3386: select distinct qualifier_grouping_no qualifier_grouping_no
3387: from qp_qualifiers
3396: oe_debug_pub.add('list_header_id = ' || p_qualifiers_rec.list_header_id);
3397: oe_debug_pub.add('list_line_id = ' || p_qualifiers_rec.list_line_id);
3398: oe_debug_pub.add('qualifier_grouping_no = ' || l_rec.qualifier_grouping_no);
3399: qp_delayed_requests_PVT.log_request(
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3401: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3402: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3403: p_entity_id => p_qualifiers_rec.list_line_id,
3404: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3400: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS,
3401: p_request_unique_key1 => p_qualifiers_rec.list_header_id,
3402: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3403: p_entity_id => p_qualifiers_rec.list_line_id,
3404: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3405: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3406: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3407: x_return_status => l_return_status);
3408:
3402: p_request_unique_key2 => l_rec.qualifier_grouping_no,
3403: p_entity_id => p_qualifiers_rec.list_line_id,
3404: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_QUALIFIERS,
3405: p_requesting_entity_id => p_qualifiers_rec.list_line_id,
3406: p_request_type =>QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP,
3407: x_return_status => l_return_status);
3408:
3409: END LOOP;
3410:
3419: --pattern
3420:
3421: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
3422:
3423: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3424: p_QUALIFIERS_rec.list_line_id = -1 THEN
3425: -- header qualifier is added to price list/modifier
3426: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3427: qp_delayed_requests_pvt.log_request(
3424: p_QUALIFIERS_rec.list_line_id = -1 THEN
3425: -- header qualifier is added to price list/modifier
3426: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3427: qp_delayed_requests_pvt.log_request(
3428: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3429: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3430: p_request_unique_key1 => NULL,
3431: p_request_unique_key2 => 'I',
3432: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3428: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3429: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3430: p_request_unique_key1 => NULL,
3431: p_request_unique_key2 => 'I',
3432: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3433: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3434: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3435: x_return_status => l_return_status);
3436: ELSE
3430: p_request_unique_key1 => NULL,
3431: p_request_unique_key2 => 'I',
3432: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3433: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3434: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3435: x_return_status => l_return_status);
3436: ELSE
3437: qp_delayed_requests_pvt.log_request(
3438: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3434: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3435: x_return_status => l_return_status);
3436: ELSE
3437: qp_delayed_requests_pvt.log_request(
3438: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3439: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3440: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3441: p_request_unique_key2 => 'I',
3442: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3438: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3439: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3440: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3441: p_request_unique_key2 => 'I',
3442: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3443: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3444: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3445: x_return_status => l_return_status);
3446: END IF;
3440: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3441: p_request_unique_key2 => 'I',
3442: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3443: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3444: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3445: x_return_status => l_return_status);
3446: END IF;
3447: END IF;
3448:
3445: x_return_status => l_return_status);
3446: END IF;
3447: END IF;
3448:
3449: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3450: p_QUALIFIERS_rec.list_line_id = -1 THEN
3451: -- header qualifier is modified
3452: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3453: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3448:
3449: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3450: p_QUALIFIERS_rec.list_line_id = -1 THEN
3451: -- header qualifier is modified
3452: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3453: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3454: -- updated other than qualifier grouping number
3455: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3456: qp_delayed_requests_pvt.log_request(
3453: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3454: -- updated other than qualifier grouping number
3455: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3456: qp_delayed_requests_pvt.log_request(
3457: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3458: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3459: p_request_unique_key1 => NULL,
3460: p_request_unique_key2 => 'U',
3461: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3457: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3458: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3459: p_request_unique_key1 => NULL,
3460: p_request_unique_key2 => 'U',
3461: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3462: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3463: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3464: x_return_status => l_return_status);
3465: ELSE
3459: p_request_unique_key1 => NULL,
3460: p_request_unique_key2 => 'U',
3461: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3462: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3463: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3464: x_return_status => l_return_status);
3465: ELSE
3466: qp_delayed_requests_pvt.log_request(
3467: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3463: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3464: x_return_status => l_return_status);
3465: ELSE
3466: qp_delayed_requests_pvt.log_request(
3467: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3468: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3469: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3470: p_request_unique_key2 => 'U',
3471: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3467: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3468: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3469: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3470: p_request_unique_key2 => 'U',
3471: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3472: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3473: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3474: x_return_status => l_return_status);
3475: END IF;
3469: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3470: p_request_unique_key2 => 'U',
3471: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3472: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3473: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3474: x_return_status => l_return_status);
3475: END IF;
3476:
3477: ELSE
3478: -- qualifier grouping number is modified
3479: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3480: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3481: qp_delayed_requests_pvt.log_request(
3482: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3483: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3484: p_request_unique_key1 => NULL,
3485: p_request_unique_key2 => 'U',
3486: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3482: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3483: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3484: p_request_unique_key1 => NULL,
3485: p_request_unique_key2 => 'U',
3486: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3487: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3488: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3489: x_return_status => l_return_status);
3490: ELSE
3484: p_request_unique_key1 => NULL,
3485: p_request_unique_key2 => 'U',
3486: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3487: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3488: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3489: x_return_status => l_return_status);
3490: ELSE
3491: qp_delayed_requests_pvt.log_request(
3492: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3488: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3489: x_return_status => l_return_status);
3490: ELSE
3491: qp_delayed_requests_pvt.log_request(
3492: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3493: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3494: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3495: p_request_unique_key2 => 'U',
3496: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3492: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3493: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3494: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3495: p_request_unique_key2 => 'U',
3496: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3497: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3498: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3499: x_return_status => l_return_status);
3500: qp_delayed_requests_pvt.log_request(
3494: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3495: p_request_unique_key2 => 'U',
3496: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3497: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3498: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3499: x_return_status => l_return_status);
3500: qp_delayed_requests_pvt.log_request(
3501: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3502: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3497: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3498: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3499: x_return_status => l_return_status);
3500: qp_delayed_requests_pvt.log_request(
3501: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3502: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3503: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3504: p_request_unique_key2 => 'U',
3505: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3501: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3502: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3503: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3504: p_request_unique_key2 => 'U',
3505: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3506: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3507: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3508: x_return_status => l_return_status);
3509: END IF;
3503: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3504: p_request_unique_key2 => 'U',
3505: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3506: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3507: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3508: x_return_status => l_return_status);
3509: END IF;
3510: END IF;
3511:
3510: END IF;
3511:
3512: END IF;
3513:
3514: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3515: p_QUALIFIERS_rec.list_line_id = -1 THEN
3516: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3517: qp_delayed_requests_pvt.log_request(
3518: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3514: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3515: p_QUALIFIERS_rec.list_line_id = -1 THEN
3516: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3517: qp_delayed_requests_pvt.log_request(
3518: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3519: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3520: p_request_unique_key1 => NULL,
3521: p_request_unique_key2 => 'D',
3522: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3518: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3519: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3520: p_request_unique_key1 => NULL,
3521: p_request_unique_key2 => 'D',
3522: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3523: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3524: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3525: x_return_status => l_return_status);
3526: ELSE
3520: p_request_unique_key1 => NULL,
3521: p_request_unique_key2 => 'D',
3522: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3523: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3524: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3525: x_return_status => l_return_status);
3526: ELSE
3527: qp_delayed_requests_pvt.log_request(
3528: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3524: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3525: x_return_status => l_return_status);
3526: ELSE
3527: qp_delayed_requests_pvt.log_request(
3528: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3529: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3530: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3531: p_request_unique_key2 => 'D',
3532: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3528: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3529: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3530: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3531: p_request_unique_key2 => 'D',
3532: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3533: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3534: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3535: x_return_status => l_return_status);
3536: END IF;
3530: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3531: p_request_unique_key2 => 'D',
3532: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3533: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3534: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3535: x_return_status => l_return_status);
3536: END IF;
3537:
3538: END IF;
3536: END IF;
3537:
3538: END IF;
3539: -- line pattern
3540: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3541: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3542: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3543: qp_delayed_requests_pvt.log_request(
3544: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3540: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3541: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3542: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3543: qp_delayed_requests_pvt.log_request(
3544: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3545: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3546: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3547: p_request_unique_key2 => NULL,
3548: p_request_unique_key3 => 'I',
3545: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3546: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3547: p_request_unique_key2 => NULL,
3548: p_request_unique_key3 => 'I',
3549: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3550: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3551: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3552: x_return_status => l_return_status);
3553: ELSE
3547: p_request_unique_key2 => NULL,
3548: p_request_unique_key3 => 'I',
3549: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3550: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3551: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3552: x_return_status => l_return_status);
3553: ELSE
3554: qp_delayed_requests_pvt.log_request(
3555: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3551: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3552: x_return_status => l_return_status);
3553: ELSE
3554: qp_delayed_requests_pvt.log_request(
3555: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3556: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3557: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3558: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3559: p_request_unique_key3 => 'I',
3556: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3557: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3558: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3559: p_request_unique_key3 => 'I',
3560: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3561: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3562: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3563: x_return_status => l_return_status);
3564: END IF;
3558: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3559: p_request_unique_key3 => 'I',
3560: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3561: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3562: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3563: x_return_status => l_return_status);
3564: END IF;
3565: END IF;
3566:
3563: x_return_status => l_return_status);
3564: END IF;
3565: END IF;
3566:
3567: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3568: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3569: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3570: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3571: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3565: END IF;
3566:
3567: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3568: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3569: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3570: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3571: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3572: qp_delayed_requests_pvt.log_request(
3573: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3569: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3570: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3571: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
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 => NULL,
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 => NULL,
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: ELSE
3576: p_request_unique_key2 => NULL,
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: ELSE
3583: qp_delayed_requests_pvt.log_request(
3584: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3580: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3581: x_return_status => l_return_status);
3582: ELSE
3583: qp_delayed_requests_pvt.log_request(
3584: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3585: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3586: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3587: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3588: p_request_unique_key3 => 'U',
3585: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3586: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3587: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3588: p_request_unique_key3 => 'U',
3589: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3590: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3591: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3592: x_return_status => l_return_status);
3593: END IF;
3587: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3588: p_request_unique_key3 => 'U',
3589: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3590: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3591: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3592: x_return_status => l_return_status);
3593: END IF;
3594:
3595: ELSE
3595: ELSE
3596: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3597: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3598: qp_delayed_requests_pvt.log_request(
3599: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3600: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3601: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3602: p_request_unique_key2 => NULL,
3603: p_request_unique_key3 => 'U',
3600: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3601: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3602: p_request_unique_key2 => NULL,
3603: p_request_unique_key3 => 'U',
3604: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3605: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3606: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3607: x_return_status => l_return_status);
3608: ELSE
3602: p_request_unique_key2 => NULL,
3603: p_request_unique_key3 => 'U',
3604: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3605: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3606: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3607: x_return_status => l_return_status);
3608: ELSE
3609: qp_delayed_requests_pvt.log_request(
3610: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3606: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3607: x_return_status => l_return_status);
3608: ELSE
3609: qp_delayed_requests_pvt.log_request(
3610: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3611: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3612: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3613: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3614: p_request_unique_key3 => 'U',
3611: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3612: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3613: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3614: p_request_unique_key3 => 'U',
3615: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3616: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3617: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3618: x_return_status => l_return_status);
3619: qp_delayed_requests_pvt.log_request(
3613: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3614: p_request_unique_key3 => 'U',
3615: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3616: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3617: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3618: x_return_status => l_return_status);
3619: qp_delayed_requests_pvt.log_request(
3620: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3621: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3616: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3617: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3618: x_return_status => l_return_status);
3619: qp_delayed_requests_pvt.log_request(
3620: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3621: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3622: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3623: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3624: p_request_unique_key3 => 'U',
3621: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3622: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3623: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3624: p_request_unique_key3 => 'U',
3625: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3626: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3627: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3628: x_return_status => l_return_status);
3629: END IF;
3623: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3624: p_request_unique_key3 => 'U',
3625: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3626: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3627: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3628: x_return_status => l_return_status);
3629: END IF;
3630: END IF;
3631:
3630: END IF;
3631:
3632: END IF;
3633:
3634: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3635: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3636: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3637: qp_delayed_requests_pvt.log_request(
3638: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3634: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3635: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3636: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3637: qp_delayed_requests_pvt.log_request(
3638: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3639: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3640: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3641: p_request_unique_key2 => NULL,
3642: p_request_unique_key3 => 'D',
3639: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3640: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3641: p_request_unique_key2 => NULL,
3642: p_request_unique_key3 => 'D',
3643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3644: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3645: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3646: x_return_status => l_return_status);
3647: ELSE
3641: p_request_unique_key2 => NULL,
3642: p_request_unique_key3 => 'D',
3643: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3644: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3645: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3646: x_return_status => l_return_status);
3647: ELSE
3648: qp_delayed_requests_pvt.log_request(
3649: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3645: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3646: x_return_status => l_return_status);
3647: ELSE
3648: qp_delayed_requests_pvt.log_request(
3649: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3650: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3651: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3652: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3653: p_request_unique_key3 => 'D',
3650: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3651: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3652: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3653: p_request_unique_key3 => 'D',
3654: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3655: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3656: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3657: x_return_status => l_return_status);
3658: END IF;
3652: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3653: p_request_unique_key3 => 'D',
3654: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3655: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3656: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3657: x_return_status => l_return_status);
3658: END IF;
3659:
3660: END IF;
3664: -- jagan's PL/SQL pattern
3665: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
3666: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
3667:
3668: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3669: p_QUALIFIERS_rec.list_line_id = -1 THEN
3670: -- header qualifier is added to price list/modifier
3671: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3672: qp_delayed_requests_pvt.log_request(
3669: p_QUALIFIERS_rec.list_line_id = -1 THEN
3670: -- header qualifier is added to price list/modifier
3671: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3672: qp_delayed_requests_pvt.log_request(
3673: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3674: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3675: p_request_unique_key1 => NULL,
3676: p_request_unique_key2 => 'I',
3677: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3673: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3674: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3675: p_request_unique_key1 => NULL,
3676: p_request_unique_key2 => 'I',
3677: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3678: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3679: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3680: x_return_status => l_return_status);
3681: ELSE
3675: p_request_unique_key1 => NULL,
3676: p_request_unique_key2 => 'I',
3677: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3678: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3679: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3680: x_return_status => l_return_status);
3681: ELSE
3682: qp_delayed_requests_pvt.log_request(
3683: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3679: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3680: x_return_status => l_return_status);
3681: ELSE
3682: qp_delayed_requests_pvt.log_request(
3683: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3684: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3685: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3686: p_request_unique_key2 => 'I',
3687: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3683: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3684: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3685: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3686: p_request_unique_key2 => 'I',
3687: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3688: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3689: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3690: x_return_status => l_return_status);
3691: END IF;
3685: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3686: p_request_unique_key2 => 'I',
3687: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3688: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3689: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3690: x_return_status => l_return_status);
3691: END IF;
3692: END IF;
3693: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3689: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3690: x_return_status => l_return_status);
3691: END IF;
3692: END IF;
3693: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3694: p_QUALIFIERS_rec.list_line_id = -1 THEN
3695: -- header qualifier is modified
3696: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3697: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3692: END IF;
3693: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3694: p_QUALIFIERS_rec.list_line_id = -1 THEN
3695: -- header qualifier is modified
3696: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3697: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3698: -- updated other than qualifier grouping number
3699: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3700: qp_delayed_requests_pvt.log_request(
3697: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3698: -- updated other than qualifier grouping number
3699: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3700: qp_delayed_requests_pvt.log_request(
3701: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3702: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3703: p_request_unique_key1 => NULL,
3704: p_request_unique_key2 => 'U',
3705: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3701: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3702: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3703: p_request_unique_key1 => NULL,
3704: p_request_unique_key2 => 'U',
3705: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3706: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3707: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3708: x_return_status => l_return_status);
3709: ELSE
3703: p_request_unique_key1 => NULL,
3704: p_request_unique_key2 => 'U',
3705: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3706: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3707: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3708: x_return_status => l_return_status);
3709: ELSE
3710: qp_delayed_requests_pvt.log_request(
3711: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3707: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3708: x_return_status => l_return_status);
3709: ELSE
3710: qp_delayed_requests_pvt.log_request(
3711: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3712: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3713: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3714: p_request_unique_key2 => 'U',
3715: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3711: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3712: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3713: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3714: p_request_unique_key2 => 'U',
3715: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3716: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3717: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3718: x_return_status => l_return_status);
3719: END IF;
3713: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3714: p_request_unique_key2 => 'U',
3715: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3716: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3717: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3718: x_return_status => l_return_status);
3719: END IF;
3720: ELSE
3721: -- qualifier grouping number is modified
3721: -- qualifier grouping number is modified
3722: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3723: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3724: qp_delayed_requests_pvt.log_request(
3725: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3726: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3727: p_request_unique_key1 => NULL,
3728: p_request_unique_key2 => 'U',
3729: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3725: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3726: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3727: p_request_unique_key1 => NULL,
3728: p_request_unique_key2 => 'U',
3729: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3730: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3731: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3732: x_return_status => l_return_status);
3733: ELSE
3727: p_request_unique_key1 => NULL,
3728: p_request_unique_key2 => 'U',
3729: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3730: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3731: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3732: x_return_status => l_return_status);
3733: ELSE
3734: qp_delayed_requests_pvt.log_request(
3735: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3731: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3732: x_return_status => l_return_status);
3733: ELSE
3734: qp_delayed_requests_pvt.log_request(
3735: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3736: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3737: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3738: p_request_unique_key2 => 'U',
3739: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3735: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3736: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3737: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3738: p_request_unique_key2 => 'U',
3739: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3740: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3741: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3742: x_return_status => l_return_status);
3743: qp_delayed_requests_pvt.log_request(
3737: p_request_unique_key1 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3738: p_request_unique_key2 => 'U',
3739: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3740: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3741: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3742: x_return_status => l_return_status);
3743: qp_delayed_requests_pvt.log_request(
3744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3745: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3740: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3741: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3742: x_return_status => l_return_status);
3743: qp_delayed_requests_pvt.log_request(
3744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3745: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3746: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3747: p_request_unique_key2 => 'U',
3748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3744: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3745: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3746: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3747: p_request_unique_key2 => 'U',
3748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3749: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3750: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3751: x_return_status => l_return_status);
3752: END IF;
3746: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3747: p_request_unique_key2 => 'U',
3748: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3749: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3750: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3751: x_return_status => l_return_status);
3752: END IF;
3753: END IF;
3754:
3752: END IF;
3753: END IF;
3754:
3755: END IF;
3756: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3757: p_QUALIFIERS_rec.list_line_id = -1 THEN
3758: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3759: qp_delayed_requests_pvt.log_request(
3760: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3756: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3757: p_QUALIFIERS_rec.list_line_id = -1 THEN
3758: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 then
3759: qp_delayed_requests_pvt.log_request(
3760: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3761: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3762: p_request_unique_key1 => NULL,
3763: p_request_unique_key2 => 'D',
3764: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3760: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3761: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3762: p_request_unique_key1 => NULL,
3763: p_request_unique_key2 => 'D',
3764: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3765: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3766: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3767: x_return_status => l_return_status);
3768: ELSE
3762: p_request_unique_key1 => NULL,
3763: p_request_unique_key2 => 'D',
3764: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3765: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3766: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3767: x_return_status => l_return_status);
3768: ELSE
3769: qp_delayed_requests_pvt.log_request(
3770: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3766: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3767: x_return_status => l_return_status);
3768: ELSE
3769: qp_delayed_requests_pvt.log_request(
3770: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3771: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3772: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3773: p_request_unique_key2 => 'D',
3774: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3770: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3771: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3772: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3773: p_request_unique_key2 => 'D',
3774: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3775: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3776: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3777: x_return_status => l_return_status);
3778: END IF;
3772: p_request_unique_key1 => p_QUALIFIERS_rec.qualifier_grouping_no,
3773: p_request_unique_key2 => 'D',
3774: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3775: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3776: p_request_type => QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN,
3777: x_return_status => l_return_status);
3778: END IF;
3779: END IF;
3780: -- line pattern
3777: x_return_status => l_return_status);
3778: END IF;
3779: END IF;
3780: -- line pattern
3781: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3782: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3783: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3784: qp_delayed_requests_pvt.log_request(
3785: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3781: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE AND
3782: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3783: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3784: qp_delayed_requests_pvt.log_request(
3785: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3786: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3787: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3788: p_request_unique_key2 => NULL,
3789: p_request_unique_key3 => 'I',
3786: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3787: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3788: p_request_unique_key2 => NULL,
3789: p_request_unique_key3 => 'I',
3790: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3791: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3792: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3793: x_return_status => l_return_status);
3794: ELSE
3788: p_request_unique_key2 => NULL,
3789: p_request_unique_key3 => 'I',
3790: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3791: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3792: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3793: x_return_status => l_return_status);
3794: ELSE
3795: qp_delayed_requests_pvt.log_request(
3796: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3792: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3793: x_return_status => l_return_status);
3794: ELSE
3795: qp_delayed_requests_pvt.log_request(
3796: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3797: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3798: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3799: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3800: p_request_unique_key3 => 'I',
3797: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3798: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3799: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3800: p_request_unique_key3 => 'I',
3801: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3802: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3803: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3804: x_return_status => l_return_status);
3805: END IF;
3799: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3800: p_request_unique_key3 => 'I',
3801: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3802: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3803: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3804: x_return_status => l_return_status);
3805: END IF;
3806: END IF;
3807: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3803: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3804: x_return_status => l_return_status);
3805: END IF;
3806: END IF;
3807: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3808: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3809: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3810: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3811: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3805: END IF;
3806: END IF;
3807: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE AND
3808: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3809: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3810: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3811: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3812: qp_delayed_requests_pvt.log_request(
3813: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3809: IF QP_GLOBALS.Equal(p_QUALIFIERS_rec.qualifier_grouping_no,
3810: p_old_QUALIFIERS_rec.qualifier_grouping_no) THEN
3811: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3812: qp_delayed_requests_pvt.log_request(
3813: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3814: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3815: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3816: p_request_unique_key2 => NULL,
3817: p_request_unique_key3 => 'U',
3814: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3815: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3816: p_request_unique_key2 => NULL,
3817: p_request_unique_key3 => 'U',
3818: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3819: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3820: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3821: x_return_status => l_return_status);
3822: ELSE
3816: p_request_unique_key2 => NULL,
3817: p_request_unique_key3 => 'U',
3818: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3819: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3820: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3821: x_return_status => l_return_status);
3822: ELSE
3823: qp_delayed_requests_pvt.log_request(
3824: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3820: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3821: x_return_status => l_return_status);
3822: ELSE
3823: qp_delayed_requests_pvt.log_request(
3824: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3825: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3826: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3827: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3828: p_request_unique_key3 => 'U',
3825: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3826: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3827: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3828: p_request_unique_key3 => 'U',
3829: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3830: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3831: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3832: x_return_status => l_return_status);
3833: END IF;
3827: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3828: p_request_unique_key3 => 'U',
3829: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3830: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3831: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3832: x_return_status => l_return_status);
3833: END IF;
3834: ELSE
3835: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3834: ELSE
3835: IF (p_QUALIFIERS_rec.qualifier_grouping_no = -1 or
3836: p_old_QUALIFIERS_rec.qualifier_grouping_no = -1) THEN
3837: qp_delayed_requests_pvt.log_request(
3838: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3839: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3840: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3841: p_request_unique_key2 => NULL,
3842: p_request_unique_key3 => 'U',
3839: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3840: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3841: p_request_unique_key2 => NULL,
3842: p_request_unique_key3 => 'U',
3843: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3844: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3845: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3846: x_return_status => l_return_status);
3847: ELSE
3841: p_request_unique_key2 => NULL,
3842: p_request_unique_key3 => 'U',
3843: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3844: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3845: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3846: x_return_status => l_return_status);
3847: ELSE
3848: qp_delayed_requests_pvt.log_request(
3849: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3845: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3846: x_return_status => l_return_status);
3847: ELSE
3848: qp_delayed_requests_pvt.log_request(
3849: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3850: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3851: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3852: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3853: p_request_unique_key3 => 'U',
3850: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3851: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3852: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3853: p_request_unique_key3 => 'U',
3854: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3855: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3856: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3857: x_return_status => l_return_status);
3858: qp_delayed_requests_pvt.log_request(
3852: p_request_unique_key2 => p_old_QUALIFIERS_rec.qualifier_grouping_no,
3853: p_request_unique_key3 => 'U',
3854: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3855: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3856: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3857: x_return_status => l_return_status);
3858: qp_delayed_requests_pvt.log_request(
3859: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3860: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3855: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3856: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3857: x_return_status => l_return_status);
3858: qp_delayed_requests_pvt.log_request(
3859: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3860: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3861: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3862: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3863: p_request_unique_key3 => 'U',
3860: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3861: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3862: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3863: p_request_unique_key3 => 'U',
3864: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3865: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3866: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3867: x_return_status => l_return_status);
3868: END IF;
3862: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3863: p_request_unique_key3 => 'U',
3864: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3865: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3866: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3867: x_return_status => l_return_status);
3868: END IF;
3869: END IF;
3870:
3868: END IF;
3869: END IF;
3870:
3871: END IF;
3872: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3873: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3874: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3875: qp_delayed_requests_pvt.log_request(
3876: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3872: IF p_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE AND
3873: p_QUALIFIERS_rec.list_line_id <> -1 THEN
3874: IF p_QUALIFIERS_rec.qualifier_grouping_no = -1 THEN
3875: qp_delayed_requests_pvt.log_request(
3876: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3877: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3878: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3879: p_request_unique_key2 => NULL,
3880: p_request_unique_key3 => 'D',
3877: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3878: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3879: p_request_unique_key2 => NULL,
3880: p_request_unique_key3 => 'D',
3881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3882: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3883: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3884: x_return_status => l_return_status);
3885: ELSE
3879: p_request_unique_key2 => NULL,
3880: p_request_unique_key3 => 'D',
3881: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3882: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3883: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3884: x_return_status => l_return_status);
3885: ELSE
3886: qp_delayed_requests_pvt.log_request(
3887: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3883: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3884: x_return_status => l_return_status);
3885: ELSE
3886: qp_delayed_requests_pvt.log_request(
3887: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3888: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3889: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3890: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3891: p_request_unique_key3 => 'D',
3888: p_entity_id => p_QUALIFIERS_rec.list_header_id,
3889: p_request_unique_key1 => p_QUALIFIERS_rec.list_line_id,
3890: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3891: p_request_unique_key3 => 'D',
3892: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3893: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3894: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3895: x_return_status => l_return_status);
3896: END IF;
3890: p_request_unique_key2 => p_QUALIFIERS_rec.qualifier_grouping_no,
3891: p_request_unique_key3 => 'D',
3892: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3893: p_requesting_entity_id => p_QUALIFIERS_rec.list_header_id,
3894: p_request_type => QP_GLOBALS.G_MAINTAIN_LINE_PATTERN,
3895: x_return_status => l_return_status);
3896: END IF;
3897:
3898: END IF;