[Home] [Help]
15: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.Modifiers_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: oe_debug_pub.add('BEGIN Clear_dependent_Attr in QPXUMLLB');
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: oe_debug_pub.add('BEGIN Clear_dependent_Attr in QPXUMLLB');
24:
30: -- every changed attribute clear its dependent fields.
31:
32: IF p_attr_id = FND_API.G_MISS_NUM THEN
33:
34: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
35: THEN
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ARITHMETIC_OPERATOR;
38: END IF;
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ARITHMETIC_OPERATOR;
38: END IF;
39:
40: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)
41: THEN
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE1;
44: END IF;
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE1;
44: END IF;
45:
46: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)
47: THEN
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE10;
50: END IF;
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE10;
50: END IF;
51:
52: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)
53: THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE11;
56: END IF;
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE11;
56: END IF;
57:
58: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)
59: THEN
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE12;
62: END IF;
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE12;
62: END IF;
63:
64: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)
65: THEN
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE13;
68: END IF;
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE13;
68: END IF;
69:
70: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)
71: THEN
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE14;
74: END IF;
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE14;
74: END IF;
75:
76: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)
77: THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE15;
80: END IF;
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE15;
80: END IF;
81:
82: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)
83: THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE2;
86: END IF;
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE2;
86: END IF;
87:
88: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)
89: THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE3;
92: END IF;
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE3;
92: END IF;
93:
94: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)
95: THEN
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE4;
98: END IF;
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE4;
98: END IF;
99:
100: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)
101: THEN
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE5;
104: END IF;
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE5;
104: END IF;
105:
106: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)
107: THEN
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE6;
110: END IF;
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE6;
110: END IF;
111:
112: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)
113: THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE7;
116: END IF;
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE7;
116: END IF;
117:
118: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)
119: THEN
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE8;
122: END IF;
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE8;
122: END IF;
123:
124: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)
125: THEN
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE9;
128: END IF;
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ATTRIBUTE9;
128: END IF;
129:
130: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)
131: THEN
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_AUTOMATIC;
134: END IF;
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_AUTOMATIC;
134: END IF;
135:
136: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)
137: THEN
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_QTY;
140: END IF;
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_QTY;
140: END IF;
141: */
142: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
143: THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_PHASE;
146: END IF;
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_PHASE;
146: END IF;
147:
148: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_UOM;
152: END IF;
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BASE_UOM;
152: END IF;
153: */
154: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_COMMENTS;
158: END IF;
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_COMMENTS;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTEXT;
164: END IF;
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTEXT;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATED_BY;
170: END IF;
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATED_BY;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATION_DATE;
176: END IF;
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CREATION_DATE;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EFFECTIVE_PERIOD_UOM;
182: END IF;
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EFFECTIVE_PERIOD_UOM;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_END_DATE_ACTIVE;
188: END IF;
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_END_DATE_ACTIVE;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_ACCRUAL_RATE;
194: END IF;
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_ACCRUAL_RATE;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_GENERATE_USING_FORMULA;
200: END IF;
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_GENERATE_USING_FORMULA;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INVENTORY_ITEM;
206: END IF;
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INVENTORY_ITEM;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATED_BY;
212: END IF;
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATED_BY;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_DATE;
218: END IF;
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_DATE;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
224: END IF;
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LAST_UPDATE_LOGIN;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_HEADER;
230: END IF;
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_HEADER;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE;
236: END IF;
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_TYPE;
242: END IF;
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_TYPE;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_PRICE;
248: END IF;
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_PRICE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_MODIFIER_LEVEL;
254: END IF;
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_MODIFIER_LEVEL;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
260: END IF;
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OPERAND;
266: END IF;
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OPERAND;
266: END IF;
267:
268: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ORGANIZATION;
272: END IF;
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ORGANIZATION;
272: END IF;
273:
274: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)
275: THEN
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OVERRIDE;
278: END IF;
276: l_index := l_index + 1;
277: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_OVERRIDE;
278: END IF;
279:
280: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)
281: THEN
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PERCENT_PRICE;
284: END IF;
282: l_index := l_index + 1;
283: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PERCENT_PRICE;
284: END IF;
285:
286: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)
287: THEN
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BREAK_TYPE;
290: END IF;
288: l_index := l_index + 1;
289: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BREAK_TYPE;
290: END IF;
291:
292: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)
293: THEN
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BY_FORMULA;
296: END IF;
294: l_index := l_index + 1;
295: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICE_BY_FORMULA;
296: END IF;
297:
298: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)
299: THEN
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRIMARY_UOM;
302: END IF;
300: l_index := l_index + 1;
301: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRIMARY_UOM;
302: END IF;
303:
304: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)
305: THEN
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRINT_ON_INVOICE;
308: END IF;
306: l_index := l_index + 1;
307: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRINT_ON_INVOICE;
308: END IF;
309:
310: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)
311: THEN
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_APPLICATION;
314: END IF;
312: l_index := l_index + 1;
313: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_APPLICATION;
314: END IF;
315:
316: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)
317: THEN
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM;
320: END IF;
318: l_index := l_index + 1;
319: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM;
320: END IF;
321:
322: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
323: THEN
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
326: END IF;
324: l_index := l_index + 1;
325: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PROGRAM_UPDATE_DATE;
326: END IF;
327:
328: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)
329: THEN
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REBATE_TRANSACTION_TYPE;
332: END IF;
330: l_index := l_index + 1;
331: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REBATE_TRANSACTION_TYPE;
332: END IF;
333:
334: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)
335: THEN
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATED_ITEM;
338: END IF;
336: l_index := l_index + 1;
337: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATED_ITEM;
338: END IF;
339:
340: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)
341: THEN
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATIONSHIP_TYPE;
344: END IF;
342: l_index := l_index + 1;
343: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RELATIONSHIP_TYPE;
344: END IF;
345:
346: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)
347: THEN
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REPRICE;
350: END IF;
348: l_index := l_index + 1;
349: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REPRICE;
350: END IF;
351:
352: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)
353: THEN
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REQUEST;
356: END IF;
354: l_index := l_index + 1;
355: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REQUEST;
356: END IF;
357:
358: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)
359: THEN
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION;
362: END IF;
360: l_index := l_index + 1;
361: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION;
362: END IF;
363:
364: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)
365: THEN
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_DATE;
368: END IF;
366: l_index := l_index + 1;
367: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_DATE;
368: END IF;
369:
370: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)
371: THEN
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_REASON;
374: END IF;
372: l_index := l_index + 1;
373: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_REVISION_REASON;
374: END IF;
375:
376: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)
377: THEN
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_START_DATE_ACTIVE;
380: END IF;
378: l_index := l_index + 1;
379: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_START_DATE_ACTIVE;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)
383: THEN
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_ATTRIBUTE;
386: END IF;
384: l_index := l_index + 1;
385: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_ATTRIBUTE;
386: END IF;
387:
388: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)
389: THEN
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_CONTEXT;
392: END IF;
390: l_index := l_index + 1;
391: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_CONTEXT;
392: END IF;
393:
394: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)
395: THEN
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_VALUE;
398: END IF;
396: l_index := l_index + 1;
397: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SUBSTITUTION_VALUE;
398: END IF;
399:
400: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)
401: THEN
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_FLAG;
404: END IF;
402: l_index := l_index + 1;
403: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_FLAG;
404: END IF;
405:
406: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)
407: THEN
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_GROUP_SEQUENCE;
410: END IF;
408: l_index := l_index + 1;
409: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRICING_GROUP_SEQUENCE;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)
413: THEN
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCOMPATIBILITY_GRP_CODE;
416: END IF;
414: l_index := l_index + 1;
415: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCOMPATIBILITY_GRP_CODE;
416: END IF;
417:
418: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)
419: THEN
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_NO;
422: END IF;
420: l_index := l_index + 1;
421: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_LIST_LINE_NO;
422: END IF;
423:
424: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)
425: THEN
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRODUCT_PRECEDENCE;
428: END IF;
426: l_index := l_index + 1;
427: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRODUCT_PRECEDENCE;
428: END IF;
429:
430: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)
431: THEN
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_START_DATE;
434: END IF;
432: l_index := l_index + 1;
433: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_START_DATE;
434: END IF;
435:
436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)
437: THEN
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EXPIRATION_PERIODS;
440: END IF;
438: l_index := l_index + 1;
439: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NUMBER_EXPIRATION_PERIODS;
440: END IF;
441:
442: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)
443: THEN
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_UOM;
446: END IF;
444: l_index := l_index + 1;
445: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_PERIOD_UOM;
446: END IF;
447:
448: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)
449: THEN
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_DATE;
452: END IF;
450: l_index := l_index + 1;
451: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_EXPIRATION_DATE;
452: END IF;
453:
454: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)
455: THEN
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_GL_VALUE;
458: END IF;
456: l_index := l_index + 1;
457: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ESTIM_GL_VALUE;
458: END IF;
459:
460: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)
461: THEN
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_PRICE_LIST_LINE;
464: END IF;
462: l_index := l_index + 1;
463: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_PRICE_LIST_LINE;
464: END IF;
465:
466: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)
467: THEN
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RECURRING_FLAG;
470: END IF;
468: l_index := l_index + 1;
469: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RECURRING_FLAG;
470: END IF;
471: */
472: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)
473: THEN
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_LIMIT;
476: END IF;
474: l_index := l_index + 1;
475: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_LIMIT;
476: END IF;
477:
478: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)
479: THEN
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_TYPE;
482: END IF;
480: l_index := l_index + 1;
481: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_TYPE;
482: END IF;
483:
484: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)
485: THEN
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_SUBTYPE;
488: END IF;
486: l_index := l_index + 1;
487: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CHARGE_SUBTYPE;
488: END IF;
489:
490: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)
491: THEN
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_QTY;
494: END IF;
492: l_index := l_index + 1;
493: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_QTY;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)
497: THEN
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_UOM;
500: END IF;
498: l_index := l_index + 1;
499: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_BENEFIT_UOM;
500: END IF;
501:
502: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)
503: THEN
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_CONVERSION_RATE;
506: END IF;
504: l_index := l_index + 1;
505: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCRUAL_CONVERSION_RATE;
506: END IF;
507:
508: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)
509: THEN
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRORATION_TYPE;
512: END IF;
510: l_index := l_index + 1;
511: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_PRORATION_TYPE;
512: END IF;
513:
514: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)
515: THEN
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCLUDE_ON_RETURNS_FLAG;
518: END IF;
516: l_index := l_index + 1;
517: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_INCLUDE_ON_RETURNS_FLAG;
518: END IF;
519:
520: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)
521: THEN
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_FROM_RLTD_MODIFIER;
524: END IF;
522: l_index := l_index + 1;
523: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_FROM_RLTD_MODIFIER;
524: END IF;
525:
526: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)
527: THEN
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_TO_RLTD_MODIFIER;
530: END IF;
528: l_index := l_index + 1;
529: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_TO_RLTD_MODIFIER;
530: END IF;
531:
532: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)
533: THEN
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_NO;
536: END IF;
534: l_index := l_index + 1;
535: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_NO;
536: END IF;
537:
538: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)
539: THEN
540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_TYPE;
542: END IF;
540: l_index := l_index + 1;
541: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_GRP_TYPE;
542: END IF;
543:
544: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)
545: THEN
546: l_index := l_index + 1;
547: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_ID;
548: END IF;
546: l_index := l_index + 1;
547: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_RLTD_MODIFIER_ID;
548: END IF;
549:
550: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.qualification_ind,p_old_MODIFIERS_rec.qualification_ind)
551: THEN
552: l_index := l_index + 1;
553: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_QUALIFICATION_IND;
554: END IF;
552: l_index := l_index + 1;
553: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_QUALIFICATION_IND;
554: END IF;
555:
556: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.net_amount_flag,p_old_MODIFIERS_rec.net_amount_flag)
557: THEN
558: l_index := l_index + 1;
559: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NET_AMOUNT;
560: END IF;
557: THEN
558: l_index := l_index + 1;
559: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_NET_AMOUNT;
560: END IF;
561: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)
562: THEN
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCUM_ATTRIBUTE;
565: END IF;
563: l_index := l_index + 1;
564: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_ACCUM_ATTRIBUTE;
565: END IF;
566:
567: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)
568: THEN
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;
571: END IF;
569: l_index := l_index + 1;
570: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_CONTINUOUS_PRICE_BREAK_FLAG;
571: END IF;
572: -- service project
573: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_duration,p_old_MODIFIERS_rec.service_duration)
574: THEN
575: l_index := l_index + 1;
576: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SERVICE_DURATION;
577: END IF;
574: THEN
575: l_index := l_index + 1;
576: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SERVICE_DURATION;
577: END IF;
578: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_period,p_old_MODIFIERS_rec.service_period)
579: THEN
580: l_index := l_index + 1;
581: l_src_attr_tbl(l_index) := QP_MODIFIERS_UTIL.G_SERVICE_PERIOD;
582: END IF;
883:
884: x_MODIFIERS_rec := p_MODIFIERS_rec;
885:
886: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
887: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
888: THEN
889: qp_delayed_requests_PVT.log_request(
890: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
891: p_entity_id => p_MODIFIERS_rec.list_line_id,
886: -- mkarya for bug 1874586, log the qualification indicator request before any other delayed requests
887: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
888: THEN
889: qp_delayed_requests_PVT.log_request(
890: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
891: p_entity_id => p_MODIFIERS_rec.list_line_id,
892: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
893: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
894: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
888: THEN
889: qp_delayed_requests_PVT.log_request(
890: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
891: p_entity_id => p_MODIFIERS_rec.list_line_id,
892: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
893: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
894: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
895: x_return_status => l_return_status);
896: END IF;
890: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
891: p_entity_id => p_MODIFIERS_rec.list_line_id,
892: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
893: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
894: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
895: x_return_status => l_return_status);
896: END IF;
897:
898: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
894: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
895: x_return_status => l_return_status);
896: END IF;
897:
898: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,p_old_MODIFIERS_rec.arithmetic_operator)
899: THEN
900: NULL;
901: END IF;
902:
899: THEN
900: NULL;
901: END IF;
902:
903: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,p_old_MODIFIERS_rec.attribute1)
904: THEN
905: NULL;
906: END IF;
907:
904: THEN
905: NULL;
906: END IF;
907:
908: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,p_old_MODIFIERS_rec.attribute10)
909: THEN
910: NULL;
911: END IF;
912:
909: THEN
910: NULL;
911: END IF;
912:
913: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,p_old_MODIFIERS_rec.attribute11)
914: THEN
915: NULL;
916: END IF;
917:
914: THEN
915: NULL;
916: END IF;
917:
918: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,p_old_MODIFIERS_rec.attribute12)
919: THEN
920: NULL;
921: END IF;
922:
919: THEN
920: NULL;
921: END IF;
922:
923: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,p_old_MODIFIERS_rec.attribute13)
924: THEN
925: NULL;
926: END IF;
927:
924: THEN
925: NULL;
926: END IF;
927:
928: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,p_old_MODIFIERS_rec.attribute14)
929: THEN
930: NULL;
931: END IF;
932:
929: THEN
930: NULL;
931: END IF;
932:
933: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,p_old_MODIFIERS_rec.attribute15)
934: THEN
935: NULL;
936: END IF;
937:
934: THEN
935: NULL;
936: END IF;
937:
938: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,p_old_MODIFIERS_rec.attribute2)
939: THEN
940: NULL;
941: END IF;
942:
939: THEN
940: NULL;
941: END IF;
942:
943: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,p_old_MODIFIERS_rec.attribute3)
944: THEN
945: NULL;
946: END IF;
947:
944: THEN
945: NULL;
946: END IF;
947:
948: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,p_old_MODIFIERS_rec.attribute4)
949: THEN
950: NULL;
951: END IF;
952:
949: THEN
950: NULL;
951: END IF;
952:
953: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,p_old_MODIFIERS_rec.attribute5)
954: THEN
955: NULL;
956: END IF;
957:
954: THEN
955: NULL;
956: END IF;
957:
958: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,p_old_MODIFIERS_rec.attribute6)
959: THEN
960: NULL;
961: END IF;
962:
959: THEN
960: NULL;
961: END IF;
962:
963: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,p_old_MODIFIERS_rec.attribute7)
964: THEN
965: NULL;
966: END IF;
967:
964: THEN
965: NULL;
966: END IF;
967:
968: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,p_old_MODIFIERS_rec.attribute8)
969: THEN
970: NULL;
971: END IF;
972:
969: THEN
970: NULL;
971: END IF;
972:
973: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,p_old_MODIFIERS_rec.attribute9)
974: THEN
975: NULL;
976: END IF;
977:
974: THEN
975: NULL;
976: END IF;
977:
978: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,p_old_MODIFIERS_rec.automatic_flag)
979: THEN
980: NULL;
981: END IF;
982:
979: THEN
980: NULL;
981: END IF;
982:
983: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,p_old_MODIFIERS_rec.base_qty)
984: THEN
985: NULL;
986: END IF;
987: */
984: THEN
985: NULL;
986: END IF;
987: */
988: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,p_old_MODIFIERS_rec.pricing_phase_id)
989: THEN
990: -- NULL;
991: -- jagan's PL/SQL pattern
992: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
992: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
993: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
994: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
995: qp_delayed_requests_pvt.log_request(
996: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
997: p_entity_id => p_MODIFIERS_rec.list_header_id,
998: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
999: p_request_unique_key2 => 'UD',
1000: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
996: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
997: p_entity_id => p_MODIFIERS_rec.list_header_id,
998: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
999: p_request_unique_key2 => 'UD',
1000: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1001: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1002: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1003: x_return_status => l_return_status);
1004: END IF;
998: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
999: p_request_unique_key2 => 'UD',
1000: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1001: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1002: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1003: x_return_status => l_return_status);
1004: END IF;
1005: END IF;
1006: END IF;
1004: END IF;
1005: END IF;
1006: END IF;
1007: qp_delayed_requests_PVT.log_request(
1008: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1009: p_entity_id => p_MODIFIERS_rec.list_line_id,
1010: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1012: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1006: END IF;
1007: qp_delayed_requests_PVT.log_request(
1008: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1009: p_entity_id => p_MODIFIERS_rec.list_line_id,
1010: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1012: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1013: x_return_status => l_return_status);
1014:
1008: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1009: p_entity_id => p_MODIFIERS_rec.list_line_id,
1010: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1012: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1013: x_return_status => l_return_status);
1014:
1015: qp_delayed_requests_PVT.log_request(
1016: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1012: p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE,
1013: x_return_status => l_return_status);
1014:
1015: qp_delayed_requests_PVT.log_request(
1016: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1017: p_entity_id => p_modifiers_rec.list_line_id,
1018: p_param1 => p_modifiers_rec.list_header_id,
1019: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1020: p_requesting_entity_id => p_modifiers_rec.list_line_id,
1015: qp_delayed_requests_PVT.log_request(
1016: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1017: p_entity_id => p_modifiers_rec.list_line_id,
1018: p_param1 => p_modifiers_rec.list_header_id,
1019: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1020: p_requesting_entity_id => p_modifiers_rec.list_line_id,
1021: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
1022: x_return_status => l_return_status);
1023:
1017: p_entity_id => p_modifiers_rec.list_line_id,
1018: p_param1 => p_modifiers_rec.list_header_id,
1019: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1020: p_requesting_entity_id => p_modifiers_rec.list_line_id,
1021: p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES,
1022: x_return_status => l_return_status);
1023:
1024: --hw
1025: -- log the changed lines API delayed request for phase change;
1024: --hw
1025: -- log the changed lines API delayed request for phase change;
1026: if QP_PERF_PVT.enabled = 'Y' then
1027: qp_delayed_requests_pvt.log_request(
1028: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1029: p_entity_id => p_MODIFIERS_rec.list_line_id,
1030: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1031: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1032: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
1026: if QP_PERF_PVT.enabled = 'Y' then
1027: qp_delayed_requests_pvt.log_request(
1028: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1029: p_entity_id => p_MODIFIERS_rec.list_line_id,
1030: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1031: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1032: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
1033: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
1034: p_param2 => p_old_MODIFIERS_rec.pricing_phase_id,
1028: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1029: p_entity_id => p_MODIFIERS_rec.list_line_id,
1030: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1031: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1032: p_request_type => QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH,
1033: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
1034: p_param2 => p_old_MODIFIERS_rec.pricing_phase_id,
1035: x_return_status => l_return_status);
1036: end if;
1036: end if;
1037:
1038: END IF;
1039:
1040: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,p_old_MODIFIERS_rec.base_uom_code)
1041: THEN
1042: NULL;
1043: END IF;
1044: */
1041: THEN
1042: NULL;
1043: END IF;
1044: */
1045: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.comments,p_old_MODIFIERS_rec.comments)
1046: THEN
1047: NULL;
1048: END IF;
1049:
1046: THEN
1047: NULL;
1048: END IF;
1049:
1050: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.context,p_old_MODIFIERS_rec.context)
1051: THEN
1052: NULL;
1053: END IF;
1054:
1051: THEN
1052: NULL;
1053: END IF;
1054:
1055: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,p_old_MODIFIERS_rec.created_by)
1056: THEN
1057: NULL;
1058: END IF;
1059:
1056: THEN
1057: NULL;
1058: END IF;
1059:
1060: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,p_old_MODIFIERS_rec.creation_date)
1061: THEN
1062: NULL;
1063: END IF;
1064:
1061: THEN
1062: NULL;
1063: END IF;
1064:
1065: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,p_old_MODIFIERS_rec.effective_period_uom)
1066: THEN
1067: NULL;
1068: END IF;
1069:
1066: THEN
1067: NULL;
1068: END IF;
1069:
1070: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.end_date_active,p_old_MODIFIERS_rec.end_date_active)
1071: THEN
1072: NULL;
1073: END IF;
1074:
1071: THEN
1072: NULL;
1073: END IF;
1074:
1075: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_accrual_rate,p_old_MODIFIERS_rec.estim_accrual_rate)
1076: THEN
1077: NULL;
1078: END IF;
1079:
1076: THEN
1077: NULL;
1078: END IF;
1079:
1080: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,p_old_MODIFIERS_rec.generate_using_formula_id)
1081: THEN
1082: NULL;
1083: END IF;
1084:
1081: THEN
1082: NULL;
1083: END IF;
1084:
1085: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,p_old_MODIFIERS_rec.inventory_item_id)
1086: THEN
1087: NULL;
1088: END IF;
1089:
1086: THEN
1087: NULL;
1088: END IF;
1089:
1090: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,p_old_MODIFIERS_rec.last_updated_by)
1091: THEN
1092: NULL;
1093: END IF;
1094:
1091: THEN
1092: NULL;
1093: END IF;
1094:
1095: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,p_old_MODIFIERS_rec.last_update_date)
1096: THEN
1097: NULL;
1098: END IF;
1099:
1096: THEN
1097: NULL;
1098: END IF;
1099:
1100: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,p_old_MODIFIERS_rec.last_update_login)
1101: THEN
1102: NULL;
1103: END IF;
1104:
1103: END IF;
1104:
1105: --made changes by spgopal per rchellam's request
1106: --qualification_ind has to be updated in delayed request only once, this is duplication to avoid performance problem
1107: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1108: THEN
1109: /*
1110: qp_delayed_requests_PVT.log_request(
1111: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1107: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,p_old_MODIFIERS_rec.list_header_id)
1108: THEN
1109: /*
1110: qp_delayed_requests_PVT.log_request(
1111: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1112: p_entity_id => p_MODIFIERS_rec.list_header_id,
1113: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1114: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1115: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
1109: /*
1110: qp_delayed_requests_PVT.log_request(
1111: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1112: p_entity_id => p_MODIFIERS_rec.list_header_id,
1113: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1114: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1115: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
1116: x_return_status => l_return_status);
1117: */
1111: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1112: p_entity_id => p_MODIFIERS_rec.list_header_id,
1113: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1114: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1115: p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND,
1116: x_return_status => l_return_status);
1117: */
1118: NULL;
1119: END IF;
1118: NULL;
1119: END IF;
1120:
1121: /* mkarya for bug 1874586. Commenting out here and restoring the code at the begining of the procedure Apply_Attribute_Changes so that qualification_ind delayed requests are logged as first request
1122: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1123: THEN
1124: qp_delayed_requests_PVT.log_request(
1125: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1126: p_entity_id => p_MODIFIERS_rec.list_line_id,
1121: /* mkarya for bug 1874586. Commenting out here and restoring the code at the begining of the procedure Apply_Attribute_Changes so that qualification_ind delayed requests are logged as first request
1122: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,p_old_MODIFIERS_rec.list_line_id)
1123: THEN
1124: qp_delayed_requests_PVT.log_request(
1125: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1126: p_entity_id => p_MODIFIERS_rec.list_line_id,
1127: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1128: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1129: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1123: THEN
1124: qp_delayed_requests_PVT.log_request(
1125: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1126: p_entity_id => p_MODIFIERS_rec.list_line_id,
1127: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1128: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1129: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1130: x_return_status => l_return_status);
1131: END IF;
1125: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1126: p_entity_id => p_MODIFIERS_rec.list_line_id,
1127: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
1128: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
1129: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1130: x_return_status => l_return_status);
1131: END IF;
1132: */
1133:
1130: x_return_status => l_return_status);
1131: END IF;
1132: */
1133:
1134: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,p_old_MODIFIERS_rec.list_line_type_code)
1135: THEN
1136: --added by svdeshmu
1137:
1138:
1139: --hvop
1140:
1141: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1142: qp_delayed_requests_PVT.log_request
1143: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1144: , p_entity_id => p_MODIFIERS_rec.list_line_id
1145: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1146: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1147: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1142: qp_delayed_requests_PVT.log_request
1143: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1144: , p_entity_id => p_MODIFIERS_rec.list_line_id
1145: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1146: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1147: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1148: , p_request_type =>QP_GLOBALS.G_UPDATE_HVOP
1149: , x_return_status => l_return_status
1150: );
1144: , p_entity_id => p_MODIFIERS_rec.list_line_id
1145: --, p_param1 => p_MODIFIERS_rec.list_line_type_code
1146: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1147: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1148: , p_request_type =>QP_GLOBALS.G_UPDATE_HVOP
1149: , x_return_status => l_return_status
1150: );
1151: --hvop
1152: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then
1152: if p_MODIFIERS_rec.list_line_type_code in ('PBH' ,'OID' ,'PRG') then
1153:
1154: oe_debug_pub.add('calling log request from QPXUMLLB.pls');
1155: qp_delayed_requests_PVT.log_request
1156: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1157: , p_entity_id => p_MODIFIERS_rec.list_line_id
1158: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1159: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1160: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1155: qp_delayed_requests_PVT.log_request
1156: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1157: , p_entity_id => p_MODIFIERS_rec.list_line_id
1158: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1159: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1160: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1161: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1162: , x_return_status => l_return_status
1163: );
1157: , p_entity_id => p_MODIFIERS_rec.list_line_id
1158: , p_param1 => p_MODIFIERS_rec.list_line_type_code
1159: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1160: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1161: , p_request_type =>QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1162: , x_return_status => l_return_status
1163: );
1164:
1165: else
1164:
1165: else
1166: -- Fix For Bug No - 5251238 This is a latent issue
1167: begin
1168: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1169: , p_entity_id => p_MODIFIERS_rec.list_line_id
1170: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request
1166: -- Fix For Bug No - 5251238 This is a latent issue
1167: begin
1168: IF qp_delayed_requests_PVT.Check_for_Request( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1169: , p_entity_id => p_MODIFIERS_rec.list_line_id
1170: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request
1173: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1174: , p_entity_id => p_MODIFIERS_rec.list_line_id
1169: , p_entity_id => p_MODIFIERS_rec.list_line_id
1170: , p_request_type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request
1173: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1174: , p_entity_id => p_MODIFIERS_rec.list_line_id
1175: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1176: , x_return_status => l_return_status
1177: );
1171: ) THEN
1172: QP_delayed_requests_pvt.Delete_Request
1173: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1174: , p_entity_id => p_MODIFIERS_rec.list_line_id
1175: , p_request_Type => QP_GLOBALS.G_VALIDATE_LINES_FOR_CHILD
1176: , x_return_status => l_return_status
1177: );
1178: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1179: RAISE FND_API.G_EXC_ERROR;
1187: if p_MODIFIERS_rec.list_line_type_code = 'PBH' then
1188:
1189: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1190: qp_delayed_requests_PVT.log_request
1191: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1192: , p_entity_id => p_MODIFIERS_rec.list_line_id
1193: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1194: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1195: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1189: oe_debug_pub.add('calling log request for overlapping breaks QPXUMLL');
1190: qp_delayed_requests_PVT.log_request
1191: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1192: , p_entity_id => p_MODIFIERS_rec.list_line_id
1193: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1194: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1195: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1196: , x_return_status => l_return_status
1197: );
1191: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1192: , p_entity_id => p_MODIFIERS_rec.list_line_id
1193: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1194: , p_requesting_entity_id => p_MODIFIERS_rec.list_line_id
1195: , p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1196: , x_return_status => l_return_status
1197: );
1198:
1199: End If;
1205: NULL;
1206: END IF;
1207:
1208:
1209: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,p_old_MODIFIERS_rec.list_price)
1210: THEN
1211: NULL;
1212: END IF;
1213: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR' THEN -- for bug 15993256
1210: THEN
1211: NULL;
1212: END IF;
1213: IF p_MODIFIERS_rec.list_line_type_code <> 'PMR' THEN -- for bug 15993256
1214: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,p_old_MODIFIERS_rec.modifier_level_code)
1215: THEN
1216: NULL;
1217: -- mkarya for attribute manager
1218: -- Log a delayed request to validate that if header level qualifier exist then at least
1221: oe_debug_pub.add('Logging a request G_CHECK_LINE_FOR_HEADER_QUAL for modifier level change');
1222: -- Bug 2419504, log this request only if attribute manager is installed
1223: IF qp_util.attrmgr_installed = 'Y' then
1224: qp_delayed_requests_PVT.log_request(
1225: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1226: p_entity_id => p_MODIFIERS_rec.list_header_id,
1227: p_request_unique_key1 => -1,
1228: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1229: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1224: qp_delayed_requests_PVT.log_request(
1225: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1226: p_entity_id => p_MODIFIERS_rec.list_header_id,
1227: p_request_unique_key1 => -1,
1228: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1229: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1230: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
1231: x_return_status => l_return_status);
1232: END IF;
1226: p_entity_id => p_MODIFIERS_rec.list_header_id,
1227: p_request_unique_key1 => -1,
1228: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
1229: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1230: p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL,
1231: x_return_status => l_return_status);
1232: END IF;
1233: END IF;
1234: END IF;
1231: x_return_status => l_return_status);
1232: END IF;
1233: END IF;
1234: END IF;
1235: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,p_old_MODIFIERS_rec.number_effective_periods)
1236: THEN
1237: NULL;
1238: END IF;
1239:
1236: THEN
1237: NULL;
1238: END IF;
1239:
1240: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,p_old_MODIFIERS_rec.operand)
1241: THEN
1242: NULL;
1243: END IF;
1244:
1241: THEN
1242: NULL;
1243: END IF;
1244:
1245: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,p_old_MODIFIERS_rec.organization_id)
1246: THEN
1247: NULL;
1248: END IF;
1249:
1246: THEN
1247: NULL;
1248: END IF;
1249:
1250: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,p_old_MODIFIERS_rec.override_flag)
1251: THEN
1252: NULL;
1253: END IF;
1254:
1251: THEN
1252: NULL;
1253: END IF;
1254:
1255: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,p_old_MODIFIERS_rec.percent_price)
1256: THEN
1257: NULL;
1258: END IF;
1259:
1256: THEN
1257: NULL;
1258: END IF;
1259:
1260: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,p_old_MODIFIERS_rec.price_break_type_code)
1261: THEN
1262: NULL;
1263: END IF;
1264:
1261: THEN
1262: NULL;
1263: END IF;
1264:
1265: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,p_old_MODIFIERS_rec.price_by_formula_id)
1266: THEN
1267: NULL;
1268: END IF;
1269:
1266: THEN
1267: NULL;
1268: END IF;
1269:
1270: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,p_old_MODIFIERS_rec.primary_uom_flag)
1271: THEN
1272: NULL;
1273: END IF;
1274:
1271: THEN
1272: NULL;
1273: END IF;
1274:
1275: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,p_old_MODIFIERS_rec.print_on_invoice_flag)
1276: THEN
1277: NULL;
1278: END IF;
1279:
1276: THEN
1277: NULL;
1278: END IF;
1279:
1280: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,p_old_MODIFIERS_rec.program_application_id)
1281: THEN
1282: NULL;
1283: END IF;
1284:
1281: THEN
1282: NULL;
1283: END IF;
1284:
1285: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,p_old_MODIFIERS_rec.program_id)
1286: THEN
1287: NULL;
1288: END IF;
1289:
1286: THEN
1287: NULL;
1288: END IF;
1289:
1290: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,p_old_MODIFIERS_rec.program_update_date)
1291: THEN
1292: NULL;
1293: END IF;
1294:
1291: THEN
1292: NULL;
1293: END IF;
1294:
1295: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,p_old_MODIFIERS_rec.rebate_trxn_type_code)
1296: THEN
1297: NULL;
1298: END IF;
1299:
1296: THEN
1297: NULL;
1298: END IF;
1299:
1300: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,p_old_MODIFIERS_rec.related_item_id)
1301: THEN
1302: NULL;
1303: END IF;
1304:
1301: THEN
1302: NULL;
1303: END IF;
1304:
1305: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,p_old_MODIFIERS_rec.relationship_type_id)
1306: THEN
1307: NULL;
1308: END IF;
1309:
1306: THEN
1307: NULL;
1308: END IF;
1309:
1310: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,p_old_MODIFIERS_rec.reprice_flag)
1311: THEN
1312: NULL;
1313: END IF;
1314:
1311: THEN
1312: NULL;
1313: END IF;
1314:
1315: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,p_old_MODIFIERS_rec.request_id)
1316: THEN
1317: NULL;
1318: END IF;
1319:
1316: THEN
1317: NULL;
1318: END IF;
1319:
1320: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,p_old_MODIFIERS_rec.revision)
1321: THEN
1322: NULL;
1323: END IF;
1324:
1321: THEN
1322: NULL;
1323: END IF;
1324:
1325: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,p_old_MODIFIERS_rec.revision_date)
1326: THEN
1327: NULL;
1328: END IF;
1329:
1326: THEN
1327: NULL;
1328: END IF;
1329:
1330: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,p_old_MODIFIERS_rec.revision_reason_code)
1331: THEN
1332: NULL;
1333: END IF;
1334:
1331: THEN
1332: NULL;
1333: END IF;
1334:
1335: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.start_date_active,p_old_MODIFIERS_rec.start_date_active)
1336: THEN
1337: NULL;
1338: END IF;
1339:
1336: THEN
1337: NULL;
1338: END IF;
1339:
1340: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,p_old_MODIFIERS_rec.substitution_attribute)
1341: THEN
1342: NULL;
1343: END IF;
1344:
1341: THEN
1342: NULL;
1343: END IF;
1344:
1345: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,p_old_MODIFIERS_rec.substitution_context)
1346: THEN
1347: NULL;
1348: END IF;
1349:
1346: THEN
1347: NULL;
1348: END IF;
1349:
1350: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,p_old_MODIFIERS_rec.substitution_value)
1351: THEN
1352: NULL;
1353: END IF;
1354:
1351: THEN
1352: NULL;
1353: END IF;
1354:
1355: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_flag,p_old_MODIFIERS_rec.accrual_flag)
1356: THEN
1357: NULL;
1358: END IF;
1359:
1356: THEN
1357: NULL;
1358: END IF;
1359:
1360: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,p_old_MODIFIERS_rec.pricing_group_sequence)
1361: THEN
1362: NULL;
1363: END IF;
1364:
1361: THEN
1362: NULL;
1363: END IF;
1364:
1365: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,p_old_MODIFIERS_rec.incompatibility_grp_code)
1366: THEN
1367: NULL;
1368: END IF;
1369:
1366: THEN
1367: NULL;
1368: END IF;
1369:
1370: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,p_old_MODIFIERS_rec.list_line_no)
1371: THEN
1372: NULL;
1373: END IF;
1374:
1371: THEN
1372: NULL;
1373: END IF;
1374:
1375: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.product_precedence,p_old_MODIFIERS_rec.product_precedence)
1376: THEN
1377: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1378: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1379: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1377: -- bug 3703391 - update effective_precedence in qp_attribute_groups when no product is given but line qualifier given
1378: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1379: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1380: qp_delayed_requests_pvt.log_request(
1381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1382: p_entity_id => p_MODIFIERS_rec.list_header_id,
1383: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1384: p_request_unique_key2 => 'U',
1385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1381: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1382: p_entity_id => p_MODIFIERS_rec.list_header_id,
1383: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1384: p_request_unique_key2 => 'U',
1385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1386: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1387: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1388: x_return_status => l_return_status);
1389: END IF;
1383: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1384: p_request_unique_key2 => 'U',
1385: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1386: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1387: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1388: x_return_status => l_return_status);
1389: END IF;
1390: END IF;
1391: --pattern
1393: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1394: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1395: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_UPDATE and p_MODIFIERS_rec.qualification_ind in (8,10) ) THEN
1396: qp_delayed_requests_pvt.log_request(
1397: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1398: p_entity_id => p_MODIFIERS_rec.list_header_id,
1399: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1400: p_request_unique_key2 => 'U',
1401: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1397: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1398: p_entity_id => p_MODIFIERS_rec.list_header_id,
1399: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1400: p_request_unique_key2 => 'U',
1401: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1402: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1403: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1404: x_return_status => l_return_status);
1405: END IF;
1399: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
1400: p_request_unique_key2 => 'U',
1401: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1402: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
1403: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
1404: x_return_status => l_return_status);
1405: END IF;
1406: END IF;
1407: END IF;
1407: END IF;
1408: NULL;
1409: END IF;
1410:
1411: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,p_old_MODIFIERS_rec.expiration_period_start_date)
1412: THEN
1413: NULL;
1414: END IF;
1415:
1412: THEN
1413: NULL;
1414: END IF;
1415:
1416: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,p_old_MODIFIERS_rec.number_expiration_periods)
1417: THEN
1418: NULL;
1419: END IF;
1420:
1417: THEN
1418: NULL;
1419: END IF;
1420:
1421: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,p_old_MODIFIERS_rec.expiration_period_uom)
1422: THEN
1423: NULL;
1424: END IF;
1425:
1422: THEN
1423: NULL;
1424: END IF;
1425:
1426: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,p_old_MODIFIERS_rec.expiration_date)
1427: THEN
1428: NULL;
1429: END IF;
1430:
1427: THEN
1428: NULL;
1429: END IF;
1430:
1431: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,p_old_MODIFIERS_rec.estim_gl_value)
1432: THEN
1433: NULL;
1434: END IF;
1435:
1432: THEN
1433: NULL;
1434: END IF;
1435:
1436: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,p_old_MODIFIERS_rec.benefit_price_list_line_id)
1437: THEN
1438: NULL;
1439: END IF;
1440:
1437: THEN
1438: NULL;
1439: END IF;
1440:
1441: /* IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,p_old_MODIFIERS_rec.recurring_flag)
1442: THEN
1443: NULL;
1444: END IF;
1445: */
1442: THEN
1443: NULL;
1444: END IF;
1445: */
1446: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,p_old_MODIFIERS_rec.benefit_limit)
1447: THEN
1448: NULL;
1449: END IF;
1450:
1447: THEN
1448: NULL;
1449: END IF;
1450:
1451: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,p_old_MODIFIERS_rec.charge_type_code)
1452: THEN
1453: NULL;
1454: END IF;
1455:
1452: THEN
1453: NULL;
1454: END IF;
1455:
1456: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,p_old_MODIFIERS_rec.charge_subtype_code)
1457: THEN
1458: NULL;
1459: END IF;
1460:
1457: THEN
1458: NULL;
1459: END IF;
1460:
1461: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,p_old_MODIFIERS_rec.benefit_qty)
1462: THEN
1463: NULL;
1464: END IF;
1465:
1462: THEN
1463: NULL;
1464: END IF;
1465:
1466: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,p_old_MODIFIERS_rec.benefit_uom_code)
1467: THEN
1468: NULL;
1469: END IF;
1470:
1467: THEN
1468: NULL;
1469: END IF;
1470:
1471: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,p_old_MODIFIERS_rec.accrual_conversion_rate)
1472: THEN
1473: NULL;
1474: END IF;
1475:
1472: THEN
1473: NULL;
1474: END IF;
1475:
1476: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,p_old_MODIFIERS_rec.proration_type_code)
1477: THEN
1478: NULL;
1479: END IF;
1480:
1477: THEN
1478: NULL;
1479: END IF;
1480:
1481: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.include_on_returns_flag,p_old_MODIFIERS_rec.include_on_returns_flag)
1482: THEN
1483: NULL;
1484: END IF;
1485:
1482: THEN
1483: NULL;
1484: END IF;
1485:
1486: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.from_rltd_modifier_id,p_old_MODIFIERS_rec.from_rltd_modifier_id)
1487: THEN
1488: NULL;
1489: END IF;
1490:
1487: THEN
1488: NULL;
1489: END IF;
1490:
1491: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.to_rltd_modifier_id,p_old_MODIFIERS_rec.to_rltd_modifier_id)
1492: THEN
1493: NULL;
1494: END IF;
1495:
1492: THEN
1493: NULL;
1494: END IF;
1495:
1496: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_no,p_old_MODIFIERS_rec.rltd_modifier_grp_no)
1497: THEN
1498: NULL;
1499: END IF;
1500:
1497: THEN
1498: NULL;
1499: END IF;
1500:
1501: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_grp_type,p_old_MODIFIERS_rec.rltd_modifier_grp_type)
1502: THEN
1503: NULL;
1504: END IF;
1505:
1502: THEN
1503: NULL;
1504: END IF;
1505:
1506: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rltd_modifier_id,p_old_MODIFIERS_rec.rltd_modifier_id)
1507: THEN
1508: NULL;
1509: END IF;
1510:
1507: THEN
1508: NULL;
1509: END IF;
1510:
1511: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.accum_attribute,p_old_MODIFIERS_rec.accum_attribute)
1512: THEN
1513: NULL;
1514: END IF;
1515:
1512: THEN
1513: NULL;
1514: END IF;
1515:
1516: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.continuous_price_break_flag,p_old_MODIFIERS_rec.continuous_price_break_flag)
1517: THEN
1518: NULL;
1519: END IF;
1520: -- service project
1517: THEN
1518: NULL;
1519: END IF;
1520: -- service project
1521: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_duration,p_old_MODIFIERS_rec.service_duration)
1522: THEN
1523: NULL;
1524: END IF;
1525: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_period,p_old_MODIFIERS_rec.service_period)
1521: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_duration,p_old_MODIFIERS_rec.service_duration)
1522: THEN
1523: NULL;
1524: END IF;
1525: IF NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.service_period,p_old_MODIFIERS_rec.service_period)
1526: THEN
1527: NULL;
1528: END IF;
1529: -- service project
3697: */
3698: -- Row locked. Compare IN attributes to DB attributes.
3699:
3700: IF
3701: QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,
3702: l_MODIFIERS_rec.arithmetic_operator)
3703:
3704: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3705: l_MODIFIERS_rec.attribute1)
3700: IF
3701: QP_GLOBALS.Equal(p_MODIFIERS_rec.arithmetic_operator,
3702: l_MODIFIERS_rec.arithmetic_operator)
3703:
3704: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3705: l_MODIFIERS_rec.attribute1)
3706: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3707: l_MODIFIERS_rec.attribute10)
3708: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3702: l_MODIFIERS_rec.arithmetic_operator)
3703:
3704: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3705: l_MODIFIERS_rec.attribute1)
3706: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3707: l_MODIFIERS_rec.attribute10)
3708: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3709: l_MODIFIERS_rec.attribute11)
3710: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3704: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute1,
3705: l_MODIFIERS_rec.attribute1)
3706: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3707: l_MODIFIERS_rec.attribute10)
3708: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3709: l_MODIFIERS_rec.attribute11)
3710: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3711: l_MODIFIERS_rec.attribute12)
3712: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3706: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute10,
3707: l_MODIFIERS_rec.attribute10)
3708: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3709: l_MODIFIERS_rec.attribute11)
3710: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3711: l_MODIFIERS_rec.attribute12)
3712: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3713: l_MODIFIERS_rec.attribute13)
3714: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3708: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute11,
3709: l_MODIFIERS_rec.attribute11)
3710: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3711: l_MODIFIERS_rec.attribute12)
3712: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3713: l_MODIFIERS_rec.attribute13)
3714: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3715: l_MODIFIERS_rec.attribute14)
3716: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3710: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute12,
3711: l_MODIFIERS_rec.attribute12)
3712: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3713: l_MODIFIERS_rec.attribute13)
3714: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3715: l_MODIFIERS_rec.attribute14)
3716: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3717: l_MODIFIERS_rec.attribute15)
3718: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3712: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute13,
3713: l_MODIFIERS_rec.attribute13)
3714: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3715: l_MODIFIERS_rec.attribute14)
3716: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3717: l_MODIFIERS_rec.attribute15)
3718: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3719: l_MODIFIERS_rec.attribute2)
3720: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3714: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute14,
3715: l_MODIFIERS_rec.attribute14)
3716: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3717: l_MODIFIERS_rec.attribute15)
3718: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3719: l_MODIFIERS_rec.attribute2)
3720: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3721: l_MODIFIERS_rec.attribute3)
3722: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3716: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute15,
3717: l_MODIFIERS_rec.attribute15)
3718: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3719: l_MODIFIERS_rec.attribute2)
3720: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3721: l_MODIFIERS_rec.attribute3)
3722: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3723: l_MODIFIERS_rec.attribute4)
3724: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3718: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute2,
3719: l_MODIFIERS_rec.attribute2)
3720: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3721: l_MODIFIERS_rec.attribute3)
3722: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3723: l_MODIFIERS_rec.attribute4)
3724: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3725: l_MODIFIERS_rec.attribute5)
3726: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3720: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute3,
3721: l_MODIFIERS_rec.attribute3)
3722: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3723: l_MODIFIERS_rec.attribute4)
3724: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3725: l_MODIFIERS_rec.attribute5)
3726: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3727: l_MODIFIERS_rec.attribute6)
3728: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3722: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute4,
3723: l_MODIFIERS_rec.attribute4)
3724: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3725: l_MODIFIERS_rec.attribute5)
3726: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3727: l_MODIFIERS_rec.attribute6)
3728: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3729: l_MODIFIERS_rec.attribute7)
3730: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3724: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute5,
3725: l_MODIFIERS_rec.attribute5)
3726: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3727: l_MODIFIERS_rec.attribute6)
3728: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3729: l_MODIFIERS_rec.attribute7)
3730: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3731: l_MODIFIERS_rec.attribute8)
3732: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3726: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute6,
3727: l_MODIFIERS_rec.attribute6)
3728: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3729: l_MODIFIERS_rec.attribute7)
3730: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3731: l_MODIFIERS_rec.attribute8)
3732: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3733: l_MODIFIERS_rec.attribute9)
3734:
3728: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute7,
3729: l_MODIFIERS_rec.attribute7)
3730: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute8,
3731: l_MODIFIERS_rec.attribute8)
3732: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3733: l_MODIFIERS_rec.attribute9)
3734:
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3736: l_MODIFIERS_rec.automatic_flag)
3731: l_MODIFIERS_rec.attribute8)
3732: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.attribute9,
3733: l_MODIFIERS_rec.attribute9)
3734:
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3736: l_MODIFIERS_rec.automatic_flag)
3737: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3738: -- l_MODIFIERS_rec.base_qty)
3739: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3733: l_MODIFIERS_rec.attribute9)
3734:
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3736: l_MODIFIERS_rec.automatic_flag)
3737: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3738: -- l_MODIFIERS_rec.base_qty)
3739: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3740: l_MODIFIERS_rec.pricing_phase_id)
3741:
3735: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
3736: l_MODIFIERS_rec.automatic_flag)
3737: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_qty,
3738: -- l_MODIFIERS_rec.base_qty)
3739: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3740: l_MODIFIERS_rec.pricing_phase_id)
3741:
3742: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3743: -- l_MODIFIERS_rec.base_uom_code)
3738: -- l_MODIFIERS_rec.base_qty)
3739: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_phase_id,
3740: l_MODIFIERS_rec.pricing_phase_id)
3741:
3742: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3743: -- l_MODIFIERS_rec.base_uom_code)
3744: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3745: l_MODIFIERS_rec.comments) --bug 7321894
3746: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3740: l_MODIFIERS_rec.pricing_phase_id)
3741:
3742: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3743: -- l_MODIFIERS_rec.base_uom_code)
3744: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3745: l_MODIFIERS_rec.comments) --bug 7321894
3746: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3747: l_MODIFIERS_rec.context)
3748: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3742: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
3743: -- l_MODIFIERS_rec.base_uom_code)
3744: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3745: l_MODIFIERS_rec.comments) --bug 7321894
3746: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3747: l_MODIFIERS_rec.context)
3748: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3749: -- l_MODIFIERS_rec.created_by)
3750: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3744: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.comments,l_MODIFIERS_rec.comments),
3745: l_MODIFIERS_rec.comments) --bug 7321894
3746: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3747: l_MODIFIERS_rec.context)
3748: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3749: -- l_MODIFIERS_rec.created_by)
3750: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3751: -- l_MODIFIERS_rec.creation_date)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3746: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.context,
3747: l_MODIFIERS_rec.context)
3748: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3749: -- l_MODIFIERS_rec.created_by)
3750: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3751: -- l_MODIFIERS_rec.creation_date)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3753: l_MODIFIERS_rec.effective_period_uom)
3754: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3748: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.created_by,
3749: -- l_MODIFIERS_rec.created_by)
3750: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3751: -- l_MODIFIERS_rec.creation_date)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3753: l_MODIFIERS_rec.effective_period_uom)
3754: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3755: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3756: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3750: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.creation_date,
3751: -- l_MODIFIERS_rec.creation_date)
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3753: l_MODIFIERS_rec.effective_period_uom)
3754: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3755: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3756: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3757: l_MODIFIERS_rec.estim_accrual_rate)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3752: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.effective_period_uom,
3753: l_MODIFIERS_rec.effective_period_uom)
3754: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3755: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3756: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3757: l_MODIFIERS_rec.estim_accrual_rate)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3759: l_MODIFIERS_rec.generate_using_formula_id)
3760: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3754: AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3755: to_date(to_char(l_MODIFIERS_rec.end_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3756: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3757: l_MODIFIERS_rec.estim_accrual_rate)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3759: l_MODIFIERS_rec.generate_using_formula_id)
3760: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3761: l_MODIFIERS_rec.inventory_item_id)
3762: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3756: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.estim_accrual_rate, l_MODIFIERS_rec.estim_accrual_rate),
3757: l_MODIFIERS_rec.estim_accrual_rate)
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3759: l_MODIFIERS_rec.generate_using_formula_id)
3760: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3761: l_MODIFIERS_rec.inventory_item_id)
3762: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3763: -- l_MODIFIERS_rec.last_updated_by)
3764: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3758: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
3759: l_MODIFIERS_rec.generate_using_formula_id)
3760: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3761: l_MODIFIERS_rec.inventory_item_id)
3762: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3763: -- l_MODIFIERS_rec.last_updated_by)
3764: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3765: -- l_MODIFIERS_rec.last_update_date)
3766: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3760: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
3761: l_MODIFIERS_rec.inventory_item_id)
3762: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3763: -- l_MODIFIERS_rec.last_updated_by)
3764: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3765: -- l_MODIFIERS_rec.last_update_date)
3766: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3767: -- l_MODIFIERS_rec.last_update_login)
3768:
3762: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_updated_by,
3763: -- l_MODIFIERS_rec.last_updated_by)
3764: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_date,
3765: -- l_MODIFIERS_rec.last_update_date)
3766: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3767: -- l_MODIFIERS_rec.last_update_login)
3768:
3769: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3770: l_MODIFIERS_rec.list_header_id)
3765: -- l_MODIFIERS_rec.last_update_date)
3766: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.last_update_login,
3767: -- l_MODIFIERS_rec.last_update_login)
3768:
3769: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3770: l_MODIFIERS_rec.list_header_id)
3771: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3772: l_MODIFIERS_rec.list_line_id)
3773: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3767: -- l_MODIFIERS_rec.last_update_login)
3768:
3769: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3770: l_MODIFIERS_rec.list_header_id)
3771: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3772: l_MODIFIERS_rec.list_line_id)
3773: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3774: l_MODIFIERS_rec.list_line_type_code)
3775: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3769: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.list_header_id, l_MODIFIERS_rec.list_header_id),
3770: l_MODIFIERS_rec.list_header_id)
3771: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3772: l_MODIFIERS_rec.list_line_id)
3773: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3774: l_MODIFIERS_rec.list_line_type_code)
3775: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3776: -- l_MODIFIERS_rec.list_price)
3777: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3771: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
3772: l_MODIFIERS_rec.list_line_id)
3773: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3774: l_MODIFIERS_rec.list_line_type_code)
3775: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3776: -- l_MODIFIERS_rec.list_price)
3777: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3778: l_MODIFIERS_rec.modifier_level_code)
3779:
3773: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
3774: l_MODIFIERS_rec.list_line_type_code)
3775: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_price,
3776: -- l_MODIFIERS_rec.list_price)
3777: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3778: l_MODIFIERS_rec.modifier_level_code)
3779:
3780: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3781: l_MODIFIERS_rec.number_effective_periods)
3776: -- l_MODIFIERS_rec.list_price)
3777: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
3778: l_MODIFIERS_rec.modifier_level_code)
3779:
3780: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3781: l_MODIFIERS_rec.number_effective_periods)
3782:
3783: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3784: l_MODIFIERS_rec.operand)
3779:
3780: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_effective_periods,
3781: l_MODIFIERS_rec.number_effective_periods)
3782:
3783: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3784: l_MODIFIERS_rec.operand)
3785:
3786: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3787: l_MODIFIERS_rec.organization_id)
3782:
3783: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.operand,
3784: l_MODIFIERS_rec.operand)
3785:
3786: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3787: l_MODIFIERS_rec.organization_id)
3788: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3789: l_MODIFIERS_rec.override_flag)
3790: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3784: l_MODIFIERS_rec.operand)
3785:
3786: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3787: l_MODIFIERS_rec.organization_id)
3788: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3789: l_MODIFIERS_rec.override_flag)
3790: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3791: l_MODIFIERS_rec.percent_price)
3792: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3786: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
3787: l_MODIFIERS_rec.organization_id)
3788: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3789: l_MODIFIERS_rec.override_flag)
3790: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3791: l_MODIFIERS_rec.percent_price)
3792: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3793: l_MODIFIERS_rec.price_break_type_code)
3794: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3788: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
3789: l_MODIFIERS_rec.override_flag)
3790: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3791: l_MODIFIERS_rec.percent_price)
3792: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3793: l_MODIFIERS_rec.price_break_type_code)
3794: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3795: l_MODIFIERS_rec.price_by_formula_id)
3796: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3790: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.percent_price,
3791: l_MODIFIERS_rec.percent_price)
3792: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3793: l_MODIFIERS_rec.price_break_type_code)
3794: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3795: l_MODIFIERS_rec.price_by_formula_id)
3796: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3797: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3798: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag, --ER 11828647
3792: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
3793: l_MODIFIERS_rec.price_break_type_code)
3794: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3795: l_MODIFIERS_rec.price_by_formula_id)
3796: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3797: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3798: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag, --ER 11828647
3799: -- l_MODIFIERS_rec.print_on_invoice_flag)
3800: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3794: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
3795: l_MODIFIERS_rec.price_by_formula_id)
3796: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3797: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3798: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag, --ER 11828647
3799: -- l_MODIFIERS_rec.print_on_invoice_flag)
3800: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3801: -- l_MODIFIERS_rec.program_application_id)
3802: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3796: AND QP_GLOBALS.Equal(NVL(p_MODIFIERS_rec.primary_uom_flag,l_MODIFIERS_rec.primary_uom_flag),
3797: l_MODIFIERS_rec.primary_uom_flag) --bug 7321894
3798: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag, --ER 11828647
3799: -- l_MODIFIERS_rec.print_on_invoice_flag)
3800: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3801: -- l_MODIFIERS_rec.program_application_id)
3802: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3803: -- l_MODIFIERS_rec.program_id)
3804: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3798: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag, --ER 11828647
3799: -- l_MODIFIERS_rec.print_on_invoice_flag)
3800: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3801: -- l_MODIFIERS_rec.program_application_id)
3802: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3803: -- l_MODIFIERS_rec.program_id)
3804: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3805: -- l_MODIFIERS_rec.program_update_date)
3806: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3800: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_application_id,
3801: -- l_MODIFIERS_rec.program_application_id)
3802: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3803: -- l_MODIFIERS_rec.program_id)
3804: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3805: -- l_MODIFIERS_rec.program_update_date)
3806: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3807: l_MODIFIERS_rec.rebate_trxn_type_code)
3808: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3802: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_id,
3803: -- l_MODIFIERS_rec.program_id)
3804: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3805: -- l_MODIFIERS_rec.program_update_date)
3806: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3807: l_MODIFIERS_rec.rebate_trxn_type_code)
3808: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3809: l_MODIFIERS_rec.related_item_id)
3810: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3804: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.program_update_date,
3805: -- l_MODIFIERS_rec.program_update_date)
3806: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3807: l_MODIFIERS_rec.rebate_trxn_type_code)
3808: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3809: l_MODIFIERS_rec.related_item_id)
3810: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3811: l_MODIFIERS_rec.relationship_type_id)
3812: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3806: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
3807: l_MODIFIERS_rec.rebate_trxn_type_code)
3808: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3809: l_MODIFIERS_rec.related_item_id)
3810: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3811: l_MODIFIERS_rec.relationship_type_id)
3812: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3813: l_MODIFIERS_rec.reprice_flag)
3814: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3808: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
3809: l_MODIFIERS_rec.related_item_id)
3810: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3811: l_MODIFIERS_rec.relationship_type_id)
3812: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3813: l_MODIFIERS_rec.reprice_flag)
3814: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3815: -- l_MODIFIERS_rec.request_id)
3816: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3810: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
3811: l_MODIFIERS_rec.relationship_type_id)
3812: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3813: l_MODIFIERS_rec.reprice_flag)
3814: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3815: -- l_MODIFIERS_rec.request_id)
3816: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3817: l_MODIFIERS_rec.revision)
3818: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3812: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
3813: l_MODIFIERS_rec.reprice_flag)
3814: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3815: -- l_MODIFIERS_rec.request_id)
3816: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3817: l_MODIFIERS_rec.revision)
3818: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3819: l_MODIFIERS_rec.revision_date)
3820: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3814: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.request_id,
3815: -- l_MODIFIERS_rec.request_id)
3816: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3817: l_MODIFIERS_rec.revision)
3818: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3819: l_MODIFIERS_rec.revision_date)
3820: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3821: l_MODIFIERS_rec.revision_reason_code)
3822: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3816: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision,
3817: l_MODIFIERS_rec.revision)
3818: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3819: l_MODIFIERS_rec.revision_date)
3820: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3821: l_MODIFIERS_rec.revision_reason_code)
3822: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3823: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3824: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3818: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_date,
3819: l_MODIFIERS_rec.revision_date)
3820: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3821: l_MODIFIERS_rec.revision_reason_code)
3822: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3823: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3824: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3825: l_MODIFIERS_rec.substitution_attribute)
3826: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3820: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
3821: l_MODIFIERS_rec.revision_reason_code)
3822: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3823: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3824: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3825: l_MODIFIERS_rec.substitution_attribute)
3826: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3827: l_MODIFIERS_rec.substitution_context)
3828: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3822: --AND QP_GLOBALS.Equal(to_date(to_char(p_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'),
3823: -- to_date(to_char(l_MODIFIERS_rec.start_date_active,'DD/MM/YYYY'),'DD/MM/YYYY'))
3824: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3825: l_MODIFIERS_rec.substitution_attribute)
3826: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3827: l_MODIFIERS_rec.substitution_context)
3828: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3829: l_MODIFIERS_rec.substitution_value)
3830:
3824: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_attribute,
3825: l_MODIFIERS_rec.substitution_attribute)
3826: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_context,
3827: l_MODIFIERS_rec.substitution_context)
3828: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3829: l_MODIFIERS_rec.substitution_value)
3830:
3831: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3832: l_MODIFIERS_rec.accrual_flag)
3827: l_MODIFIERS_rec.substitution_context)
3828: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.substitution_value,
3829: l_MODIFIERS_rec.substitution_value)
3830:
3831: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3832: l_MODIFIERS_rec.accrual_flag)
3833: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3834: l_MODIFIERS_rec.pricing_group_sequence)
3835: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3829: l_MODIFIERS_rec.substitution_value)
3830:
3831: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3832: l_MODIFIERS_rec.accrual_flag)
3833: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3834: l_MODIFIERS_rec.pricing_group_sequence)
3835: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3836: l_MODIFIERS_rec.incompatibility_grp_code)
3837: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3831: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.accrual_flag, l_MODIFIERS_rec.accrual_flag),
3832: l_MODIFIERS_rec.accrual_flag)
3833: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3834: l_MODIFIERS_rec.pricing_group_sequence)
3835: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3836: l_MODIFIERS_rec.incompatibility_grp_code)
3837: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3838: l_MODIFIERS_rec.list_line_no)
3839: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3833: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.pricing_group_sequence,
3834: l_MODIFIERS_rec.pricing_group_sequence)
3835: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3836: l_MODIFIERS_rec.incompatibility_grp_code)
3837: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3838: l_MODIFIERS_rec.list_line_no)
3839: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3840: l_MODIFIERS_rec.product_precedence)
3841: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3835: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.incompatibility_grp_code,
3836: l_MODIFIERS_rec.incompatibility_grp_code)
3837: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3838: l_MODIFIERS_rec.list_line_no)
3839: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3840: l_MODIFIERS_rec.product_precedence)
3841: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3842: l_MODIFIERS_rec.expiration_period_start_date)
3843: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3837: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_no,
3838: l_MODIFIERS_rec.list_line_no)
3839: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3840: l_MODIFIERS_rec.product_precedence)
3841: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3842: l_MODIFIERS_rec.expiration_period_start_date)
3843: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3844: l_MODIFIERS_rec.number_expiration_periods)
3845: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3839: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.product_precedence, l_MODIFIERS_rec.product_precedence),
3840: l_MODIFIERS_rec.product_precedence)
3841: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3842: l_MODIFIERS_rec.expiration_period_start_date)
3843: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3844: l_MODIFIERS_rec.number_expiration_periods)
3845: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3846: l_MODIFIERS_rec.expiration_period_uom)
3847: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3841: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_start_date,
3842: l_MODIFIERS_rec.expiration_period_start_date)
3843: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3844: l_MODIFIERS_rec.number_expiration_periods)
3845: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3846: l_MODIFIERS_rec.expiration_period_uom)
3847: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3848: l_MODIFIERS_rec.expiration_date)
3849: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3843: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.number_expiration_periods,
3844: l_MODIFIERS_rec.number_expiration_periods)
3845: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3846: l_MODIFIERS_rec.expiration_period_uom)
3847: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3848: l_MODIFIERS_rec.expiration_date)
3849: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3850: l_MODIFIERS_rec.estim_gl_value)
3851: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3845: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_period_uom,
3846: l_MODIFIERS_rec.expiration_period_uom)
3847: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3848: l_MODIFIERS_rec.expiration_date)
3849: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3850: l_MODIFIERS_rec.estim_gl_value)
3851: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3852: l_MODIFIERS_rec.benefit_price_list_line_id)
3853: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3847: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.expiration_date,
3848: l_MODIFIERS_rec.expiration_date)
3849: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3850: l_MODIFIERS_rec.estim_gl_value)
3851: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3852: l_MODIFIERS_rec.benefit_price_list_line_id)
3853: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3854: -- l_MODIFIERS_rec.recurring_flag)
3855: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3849: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.estim_gl_value,
3850: l_MODIFIERS_rec.estim_gl_value)
3851: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3852: l_MODIFIERS_rec.benefit_price_list_line_id)
3853: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3854: -- l_MODIFIERS_rec.recurring_flag)
3855: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3856: l_MODIFIERS_rec.benefit_limit)
3857: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3851: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_price_list_line_id,
3852: l_MODIFIERS_rec.benefit_price_list_line_id)
3853: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3854: -- l_MODIFIERS_rec.recurring_flag)
3855: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3856: l_MODIFIERS_rec.benefit_limit)
3857: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3858: l_MODIFIERS_rec.charge_type_code)
3859: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3853: -- AND QP_GLOBALS.Equal(p_MODIFIERS_rec.recurring_flag,
3854: -- l_MODIFIERS_rec.recurring_flag)
3855: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3856: l_MODIFIERS_rec.benefit_limit)
3857: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3858: l_MODIFIERS_rec.charge_type_code)
3859: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3860: l_MODIFIERS_rec.charge_subtype_code)
3861: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3855: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_limit,
3856: l_MODIFIERS_rec.benefit_limit)
3857: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3858: l_MODIFIERS_rec.charge_type_code)
3859: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3860: l_MODIFIERS_rec.charge_subtype_code)
3861: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3862: l_MODIFIERS_rec.benefit_qty)
3863: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3857: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_type_code,
3858: l_MODIFIERS_rec.charge_type_code)
3859: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3860: l_MODIFIERS_rec.charge_subtype_code)
3861: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3862: l_MODIFIERS_rec.benefit_qty)
3863: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3864: l_MODIFIERS_rec.benefit_uom_code)
3865: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3859: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.charge_subtype_code,
3860: l_MODIFIERS_rec.charge_subtype_code)
3861: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3862: l_MODIFIERS_rec.benefit_qty)
3863: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3864: l_MODIFIERS_rec.benefit_uom_code)
3865: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3866: l_MODIFIERS_rec.accrual_conversion_rate)
3867: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3861: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_qty,
3862: l_MODIFIERS_rec.benefit_qty)
3863: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3864: l_MODIFIERS_rec.benefit_uom_code)
3865: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3866: l_MODIFIERS_rec.accrual_conversion_rate)
3867: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3868: l_MODIFIERS_rec.proration_type_code)
3869: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),
3863: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.benefit_uom_code,
3864: l_MODIFIERS_rec.benefit_uom_code)
3865: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3866: l_MODIFIERS_rec.accrual_conversion_rate)
3867: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3868: l_MODIFIERS_rec.proration_type_code)
3869: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),
3870: l_MODIFIERS_rec.include_on_returns_flag)
3871:
3865: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.accrual_conversion_rate,
3866: l_MODIFIERS_rec.accrual_conversion_rate)
3867: AND QP_GLOBALS.Equal(p_MODIFIERS_rec.proration_type_code,
3868: l_MODIFIERS_rec.proration_type_code)
3869: AND QP_GLOBALS.Equal(nvl(p_MODIFIERS_rec.include_on_returns_flag, l_MODIFIERS_rec.include_on_returns_flag),
3870: l_MODIFIERS_rec.include_on_returns_flag)
3871:
3872: THEN
3873:
4037: oe_debug_pub.add('BEGIN Get_Values in QPXUMLLB');
4038:
4039: IF p_MODIFIERS_rec.automatic_flag IS NOT NULL AND
4040: p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
4041: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.automatic_flag,
4042: p_old_MODIFIERS_rec.automatic_flag)
4043: THEN
4044: l_MODIFIERS_val_rec.automatic := QP_Id_To_Value.Automatic
4045: ( p_automatic_flag => p_MODIFIERS_rec.automatic_flag
4047: END IF;
4048:
4049: /* IF p_MODIFIERS_rec.base_uom_code IS NOT NULL AND
4050: p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
4051: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.base_uom_code,
4052: p_old_MODIFIERS_rec.base_uom_code)
4053: THEN
4054: l_MODIFIERS_val_rec.base_uom := QP_Id_To_Value.Base_Uom
4055: ( p_base_uom_code => p_MODIFIERS_rec.base_uom_code
4057: END IF;
4058: */
4059: IF p_MODIFIERS_rec.generate_using_formula_id IS NOT NULL AND
4060: p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
4061: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.generate_using_formula_id,
4062: p_old_MODIFIERS_rec.generate_using_formula_id)
4063: THEN
4064: l_MODIFIERS_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
4065: ( p_generate_using_formula_id => p_MODIFIERS_rec.generate_using_formula_id
4067: END IF;
4068:
4069: IF p_MODIFIERS_rec.inventory_item_id IS NOT NULL AND
4070: p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
4071: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.inventory_item_id,
4072: p_old_MODIFIERS_rec.inventory_item_id)
4073: THEN
4074: l_MODIFIERS_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
4075: ( p_inventory_item_id => p_MODIFIERS_rec.inventory_item_id
4077: END IF;
4078:
4079: IF p_MODIFIERS_rec.list_header_id IS NOT NULL AND
4080: p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM AND
4081: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_header_id,
4082: p_old_MODIFIERS_rec.list_header_id)
4083: THEN
4084: l_MODIFIERS_val_rec.list_header := QP_Id_To_Value.List_Header
4085: ( p_list_header_id => p_MODIFIERS_rec.list_header_id
4087: END IF;
4088:
4089: IF p_MODIFIERS_rec.list_line_id IS NOT NULL AND
4090: p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM AND
4091: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_id,
4092: p_old_MODIFIERS_rec.list_line_id)
4093: THEN
4094: l_MODIFIERS_val_rec.list_line := QP_Id_To_Value.List_Line
4095: ( p_list_line_id => p_MODIFIERS_rec.list_line_id
4097: END IF;
4098:
4099: IF p_MODIFIERS_rec.list_line_type_code IS NOT NULL AND
4100: p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
4101: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.list_line_type_code,
4102: p_old_MODIFIERS_rec.list_line_type_code)
4103: THEN
4104: l_MODIFIERS_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
4105: ( p_list_line_type_code => p_MODIFIERS_rec.list_line_type_code
4107: END IF;
4108:
4109: IF p_MODIFIERS_rec.modifier_level_code IS NOT NULL AND
4110: p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
4111: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.modifier_level_code,
4112: p_old_MODIFIERS_rec.modifier_level_code)
4113: THEN
4114: l_MODIFIERS_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
4115: ( p_modifier_level_code => p_MODIFIERS_rec.modifier_level_code
4117: END IF;
4118:
4119: IF p_MODIFIERS_rec.organization_id IS NOT NULL AND
4120: p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM AND
4121: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.organization_id,
4122: p_old_MODIFIERS_rec.organization_id)
4123: THEN
4124: l_MODIFIERS_val_rec.organization := QP_Id_To_Value.Organization
4125: ( p_organization_id => p_MODIFIERS_rec.organization_id
4127: END IF;
4128:
4129: IF p_MODIFIERS_rec.override_flag IS NOT NULL AND
4130: p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR AND
4131: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.override_flag,
4132: p_old_MODIFIERS_rec.override_flag)
4133: THEN
4134: l_MODIFIERS_val_rec.override := QP_Id_To_Value.Override
4135: ( p_override_flag => p_MODIFIERS_rec.override_flag
4137: END IF;
4138:
4139: IF p_MODIFIERS_rec.price_break_type_code IS NOT NULL AND
4140: p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
4141: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_break_type_code,
4142: p_old_MODIFIERS_rec.price_break_type_code)
4143: THEN
4144: l_MODIFIERS_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
4145: ( p_price_break_type_code => p_MODIFIERS_rec.price_break_type_code
4147: END IF;
4148:
4149: IF p_MODIFIERS_rec.price_by_formula_id IS NOT NULL AND
4150: p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
4151: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.price_by_formula_id,
4152: p_old_MODIFIERS_rec.price_by_formula_id)
4153: THEN
4154: l_MODIFIERS_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
4155: ( p_price_by_formula_id => p_MODIFIERS_rec.price_by_formula_id
4157: END IF;
4158:
4159: IF p_MODIFIERS_rec.primary_uom_flag IS NOT NULL AND
4160: p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
4161: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.primary_uom_flag,
4162: p_old_MODIFIERS_rec.primary_uom_flag)
4163: THEN
4164: l_MODIFIERS_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
4165: ( p_primary_uom_flag => p_MODIFIERS_rec.primary_uom_flag
4167: END IF;
4168:
4169: IF p_MODIFIERS_rec.print_on_invoice_flag IS NOT NULL AND
4170: p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
4171: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.print_on_invoice_flag,
4172: p_old_MODIFIERS_rec.print_on_invoice_flag)
4173: THEN
4174: l_MODIFIERS_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
4175: ( p_print_on_invoice_flag => p_MODIFIERS_rec.print_on_invoice_flag
4177: END IF;
4178:
4179: IF p_MODIFIERS_rec.rebate_trxn_type_code IS NOT NULL AND
4180: p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
4181: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.rebate_trxn_type_code,
4182: p_old_MODIFIERS_rec.rebate_trxn_type_code)
4183: THEN
4184: l_MODIFIERS_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
4185: ( p_rebate_trxn_type_code => p_MODIFIERS_rec.rebate_trxn_type_code
4187: END IF;
4188:
4189: IF p_MODIFIERS_rec.related_item_id IS NOT NULL AND
4190: p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM AND
4191: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.related_item_id,
4192: p_old_MODIFIERS_rec.related_item_id)
4193: THEN
4194: l_MODIFIERS_val_rec.related_item := QP_Id_To_Value.Related_Item
4195: ( p_related_item_id => p_MODIFIERS_rec.related_item_id
4197: END IF;
4198:
4199: IF p_MODIFIERS_rec.relationship_type_id IS NOT NULL AND
4200: p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
4201: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.relationship_type_id,
4202: p_old_MODIFIERS_rec.relationship_type_id)
4203: THEN
4204: l_MODIFIERS_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
4205: ( p_relationship_type_id => p_MODIFIERS_rec.relationship_type_id
4207: END IF;
4208:
4209: IF p_MODIFIERS_rec.reprice_flag IS NOT NULL AND
4210: p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
4211: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.reprice_flag,
4212: p_old_MODIFIERS_rec.reprice_flag)
4213: THEN
4214: l_MODIFIERS_val_rec.reprice := QP_Id_To_Value.Reprice
4215: ( p_reprice_flag => p_MODIFIERS_rec.reprice_flag
4217: END IF;
4218:
4219: IF p_MODIFIERS_rec.revision_reason_code IS NOT NULL AND
4220: p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
4221: NOT QP_GLOBALS.Equal(p_MODIFIERS_rec.revision_reason_code,
4222: p_old_MODIFIERS_rec.revision_reason_code)
4223: THEN
4224: l_MODIFIERS_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
4225: ( p_revision_reason_code => p_MODIFIERS_rec.revision_reason_code
4859: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
4860: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
4861: IF (p_MODIFIERS_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
4862: qp_delayed_requests_pvt.log_request(
4863: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4864: p_entity_id => p_MODIFIERS_rec.list_header_id,
4865: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
4866: p_request_unique_key2 => 'I',
4867: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4863: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4864: p_entity_id => p_MODIFIERS_rec.list_header_id,
4865: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
4866: p_request_unique_key2 => 'I',
4867: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4868: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
4869: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
4870: x_return_status => l_return_status);
4871:
4865: p_request_unique_key1 => p_MODIFIERS_rec.list_line_id,
4866: p_request_unique_key2 => 'I',
4867: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_ALL,
4868: p_requesting_entity_id => p_MODIFIERS_rec.list_header_id,
4869: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
4870: x_return_status => l_return_status);
4871:
4872: END IF;
4873: END IF; --PL/SQL pattern search
4888: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and
4889: (p_old_MODIFIERS_rec.pricing_phase_id <> p_MODIFIERS_rec.pricing_phase_id))
4890: then
4891: qp_delayed_requests_PVT.log_request(
4892: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4893: p_entity_id => p_MODIFIERS_rec.list_header_id,
4894: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4895: p_param4 => l_call_from,
4896: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4892: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4893: p_entity_id => p_MODIFIERS_rec.list_header_id,
4894: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4895: p_param4 => l_call_from,
4896: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4897: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4898: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4899: x_return_status => l_return_status);
4900:
4894: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4895: p_param4 => l_call_from,
4896: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4897: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4898: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4899: x_return_status => l_return_status);
4900:
4901: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4902: qp_delayed_requests_PVT.log_request(
4899: x_return_status => l_return_status);
4900:
4901: if ((p_MODIFIERS_rec.operation) NOT IN(OE_GLOBALS.G_OPR_CREATE)) then
4902: qp_delayed_requests_PVT.log_request(
4903: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4904: p_entity_id => p_MODIFIERS_rec.list_header_id,
4905: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4906: p_param4 => l_call_from,
4907: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4903: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4904: p_entity_id => p_MODIFIERS_rec.list_header_id,
4905: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4906: p_param4 => l_call_from,
4907: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4908: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4909: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4910: x_return_status => l_return_status);
4911: end if;
4905: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4906: p_param4 => l_call_from,
4907: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4908: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4909: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4910: x_return_status => l_return_status);
4911: end if;
4912: end if;
4913:
4919: then
4920: Log_Update_Phases_DL(p_MODIFIERS_rec => p_MODIFIERS_rec,
4921: x_return_status => l_return_status);
4922: qp_delayed_requests_PVT.log_request(
4923: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4924: p_entity_id => p_MODIFIERS_rec.list_header_id,
4925: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4926: p_param4 => l_call_from,
4927: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4923: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4924: p_entity_id => p_MODIFIERS_rec.list_header_id,
4925: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4926: p_param4 => l_call_from,
4927: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4928: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4929: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4930: x_return_status => l_return_status);
4931: end if;
4925: p_param1 => p_old_MODIFIERS_rec.pricing_phase_id,
4926: p_param4 => l_call_from,
4927: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4928: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4929: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4930: x_return_status => l_return_status);
4931: end if;
4932: if p_MODIFIERS_rec.automatic_flag <> p_old_MODIFIERS_rec.automatic_flag then
4933: select active_flag into l_active_flag from qp_list_headers_b
4942: l_count :=0;
4943: end;
4944: if l_count >0 then
4945: qp_delayed_requests_PVT.log_request(
4946: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
4947: p_entity_id => p_MODIFIERS_rec.list_header_id,
4948: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4949: p_param2 => p_MODIFIERS_rec.automatic_flag,
4950: p_param3 => l_count,
4948: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4949: p_param2 => p_MODIFIERS_rec.automatic_flag,
4950: p_param3 => l_count,
4951: p_param4 => l_call_from,
4952: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4953: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4954: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4955: x_return_status => l_return_status);
4956: end if;
4950: p_param3 => l_count,
4951: p_param4 => l_call_from,
4952: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4953: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4954: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
4955: x_return_status => l_return_status);
4956: end if;
4957: end if;
4958: end if;
4966: oe_debug_pub.add('request to update G_UPDATE_MANUAL_MODIFIER_FLAG '||l_parent_line_type, 1);
4967: oe_debug_pub.add('Logging a request to update G_UPDATE_MANUAL_MODIFIER_FLAG ', 1);
4968:
4969: qp_delayed_requests_PVT.log_request(
4970: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4971: p_entity_id => p_MODIFIERS_rec.list_line_id,
4972: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4973: p_param2 => p_MODIFIERS_rec.automatic_flag,
4974: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4970: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4971: p_entity_id => p_MODIFIERS_rec.list_line_id,
4972: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4973: p_param2 => p_MODIFIERS_rec.automatic_flag,
4974: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4975: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4976: p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,
4977: x_return_status => l_return_status);
4978: END IF;
4972: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
4973: p_param2 => p_MODIFIERS_rec.automatic_flag,
4974: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
4975: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
4976: p_request_type => QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG,
4977: x_return_status => l_return_status);
4978: END IF;
4979:
4980: EXCEPTION
5011: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
5012:
5013: if l_manual_modifier_flag is null then
5014: qp_delayed_requests_PVT.log_request(
5015: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5016: p_entity_id => p_MODIFIERS_rec.list_header_id,
5017: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5018: p_param2 => p_MODIFIERS_rec.automatic_flag,
5019: p_param4 => l_call_from,
5016: p_entity_id => p_MODIFIERS_rec.list_header_id,
5017: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5018: p_param2 => p_MODIFIERS_rec.automatic_flag,
5019: p_param4 => l_call_from,
5020: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5021: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5022: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5023: x_return_status => l_return_status);
5024:
5018: p_param2 => p_MODIFIERS_rec.automatic_flag,
5019: p_param4 => l_call_from,
5020: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5021: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5022: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5023: x_return_status => l_return_status);
5024:
5025: elsif l_manual_modifier_flag = 'A' then
5026: if( p_MODIFIERS_rec.automatic_flag = 'Y') then
5026: if( p_MODIFIERS_rec.automatic_flag = 'Y') then
5027: null;
5028: else
5029: qp_delayed_requests_PVT.log_request(
5030: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5031: p_entity_id => p_MODIFIERS_rec.list_header_id,
5032: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5033: p_param2 => p_MODIFIERS_rec.automatic_flag,
5034: p_param4 => l_call_from,
5031: p_entity_id => p_MODIFIERS_rec.list_header_id,
5032: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5033: p_param2 => p_MODIFIERS_rec.automatic_flag,
5034: p_param4 => l_call_from,
5035: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5036: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5037: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5038: x_return_status => l_return_status);
5039: end if;
5033: p_param2 => p_MODIFIERS_rec.automatic_flag,
5034: p_param4 => l_call_from,
5035: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5036: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5037: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5038: x_return_status => l_return_status);
5039: end if;
5040: elsif l_manual_modifier_flag ='M' then
5041: if (p_MODIFIERS_rec.automatic_flag = 'N') then
5041: if (p_MODIFIERS_rec.automatic_flag = 'N') then
5042: null;
5043: else
5044: qp_delayed_requests_PVT.log_request(
5045: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
5046: p_entity_id => p_MODIFIERS_rec.list_header_id,
5047: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5048: p_param2 => p_MODIFIERS_rec.automatic_flag,
5049: p_param4 => l_call_from,
5046: p_entity_id => p_MODIFIERS_rec.list_header_id,
5047: p_param1 => p_MODIFIERS_rec.pricing_phase_id,
5048: p_param2 => p_MODIFIERS_rec.automatic_flag,
5049: p_param4 => l_call_from,
5050: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5051: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5052: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5053: x_return_status => l_return_status);
5054: end if;
5048: p_param2 => p_MODIFIERS_rec.automatic_flag,
5049: p_param4 => l_call_from,
5050: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
5051: p_requesting_entity_id => p_MODIFIERS_rec.list_line_id,
5052: p_request_type => QP_GLOBALS.G_UPDATE_PRICING_PHASE,
5053: x_return_status => l_return_status);
5054: end if;
5055: else
5056: null;