17: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Rec_Type
18: )
19: IS
20: l_index NUMBER := 0;
21: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
22: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
23: BEGIN
24:
25: -- Load out record
18: )
19: IS
20: l_index NUMBER := 0;
21: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
22: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;
23: BEGIN
24:
25: -- Load out record
26:
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_PRICE_LIST_LINE_rec.accrual_qty,p_old_PRICE_LIST_LINE_rec.accrual_qty)
35: THEN
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;
38: END IF;
36: l_index := l_index + 1;
37: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_QTY;
38: END IF;
39:
40: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
41: THEN
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
44: END IF;
42: l_index := l_index + 1;
43: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ACCRUAL_UOM;
44: END IF;
45:
46: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator)
47: THEN
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
50: END IF;
48: l_index := l_index + 1;
49: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ARITHMETIC_OPERATOR;
50: END IF;
51:
52: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
53: THEN
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
56: END IF;
54: l_index := l_index + 1;
55: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE1;
56: END IF;
57:
58: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
59: THEN
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
62: END IF;
60: l_index := l_index + 1;
61: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE10;
62: END IF;
63:
64: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
65: THEN
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
68: END IF;
66: l_index := l_index + 1;
67: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE11;
68: END IF;
69:
70: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
71: THEN
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
74: END IF;
72: l_index := l_index + 1;
73: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE12;
74: END IF;
75:
76: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
77: THEN
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
80: END IF;
78: l_index := l_index + 1;
79: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE13;
80: END IF;
81:
82: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
83: THEN
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
86: END IF;
84: l_index := l_index + 1;
85: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE14;
86: END IF;
87:
88: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
89: THEN
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
92: END IF;
90: l_index := l_index + 1;
91: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE15;
92: END IF;
93:
94: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
95: THEN
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
98: END IF;
96: l_index := l_index + 1;
97: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE2;
98: END IF;
99:
100: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
101: THEN
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
104: END IF;
102: l_index := l_index + 1;
103: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE3;
104: END IF;
105:
106: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
107: THEN
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
110: END IF;
108: l_index := l_index + 1;
109: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE4;
110: END IF;
111:
112: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
113: THEN
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
116: END IF;
114: l_index := l_index + 1;
115: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE5;
116: END IF;
117:
118: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
119: THEN
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
122: END IF;
120: l_index := l_index + 1;
121: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE6;
122: END IF;
123:
124: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
125: THEN
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
128: END IF;
126: l_index := l_index + 1;
127: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE7;
128: END IF;
129:
130: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
131: THEN
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
134: END IF;
132: l_index := l_index + 1;
133: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE8;
134: END IF;
135:
136: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
137: THEN
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
140: END IF;
138: l_index := l_index + 1;
139: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ATTRIBUTE9;
140: END IF;
141:
142: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,p_old_PRICE_LIST_LINE_rec.automatic_flag)
143: THEN
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
146: END IF;
144: l_index := l_index + 1;
145: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_AUTOMATIC;
146: END IF;
147:
148: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,p_old_PRICE_LIST_LINE_rec.base_qty)
149: THEN
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
152: END IF;
150: l_index := l_index + 1;
151: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_QTY;
152: END IF;
153:
154: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,p_old_PRICE_LIST_LINE_rec.base_uom_code)
155: THEN
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
158: END IF;
156: l_index := l_index + 1;
157: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_BASE_UOM;
158: END IF;
159:
160: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
161: THEN
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
164: END IF;
162: l_index := l_index + 1;
163: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_COMMENTS;
164: END IF;
165:
166: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
167: THEN
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
170: END IF;
168: l_index := l_index + 1;
169: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CONTEXT;
170: END IF;
171:
172: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
173: THEN
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
176: END IF;
174: l_index := l_index + 1;
175: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATED_BY;
176: END IF;
177:
178: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
179: THEN
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
182: END IF;
180: l_index := l_index + 1;
181: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CREATION_DATE;
182: END IF;
183:
184: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,p_old_PRICE_LIST_LINE_rec.effective_period_uom)
185: THEN
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
188: END IF;
186: l_index := l_index + 1;
187: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_EFFECTIVE_PERIOD_UOM;
188: END IF;
189:
190: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
191: THEN
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
194: END IF;
192: l_index := l_index + 1;
193: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_END_DATE_ACTIVE;
194: END IF;
195:
196: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,p_old_PRICE_LIST_LINE_rec.estim_accrual_rate)
197: THEN
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
200: END IF;
198: l_index := l_index + 1;
199: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ESTIM_ACCRUAL_RATE;
200: END IF;
201:
202: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
203: THEN
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
206: END IF;
204: l_index := l_index + 1;
205: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_GENERATE_USING_FORMULA;
206: END IF;
207:
208: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
209: THEN
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
212: END IF;
210: l_index := l_index + 1;
211: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_INVENTORY_ITEM;
212: END IF;
213:
214: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
215: THEN
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
218: END IF;
216: l_index := l_index + 1;
217: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;
218: END IF;
219:
220: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
221: THEN
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
224: END IF;
222: l_index := l_index + 1;
223: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;
224: END IF;
225:
226: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
227: THEN
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
230: END IF;
228: l_index := l_index + 1;
229: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;
230: END IF;
231:
232: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,p_old_PRICE_LIST_LINE_rec.list_header_id)
233: THEN
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
236: END IF;
234: l_index := l_index + 1;
235: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_HEADER;
236: END IF;
237:
238: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,p_old_PRICE_LIST_LINE_rec.list_line_id)
239: THEN
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
242: END IF;
240: l_index := l_index + 1;
241: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE;
242: END IF;
243:
244: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,p_old_PRICE_LIST_LINE_rec.list_line_type_code)
245: THEN
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
248: END IF;
246: l_index := l_index + 1;
247: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_LINE_TYPE;
248: END IF;
249:
250: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
251: THEN
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
254: END IF;
252: l_index := l_index + 1;
253: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_LIST_PRICE;
254: END IF;
255:
256: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id,p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id)
257: THEN
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
260: END IF;
258: l_index := l_index + 1;
259: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_FROM_RLTD_MODIFIER;
260: END IF;
261:
262: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no,p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no)
263: THEN
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
266: END IF;
264: l_index := l_index + 1;
265: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RLTD_MODIFIER_GROUP_NO;
266: END IF;
267:
268: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,p_old_PRICE_LIST_LINE_rec.product_precedence)
269: THEN
270: l_index := l_index + 1;
271: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
272: END IF;
271: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRODUCT_PRECEDENCE;
272: END IF;
273:
274:
275: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,p_old_PRICE_LIST_LINE_rec.modifier_level_code)
276: THEN
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
279: END IF;
277: l_index := l_index + 1;
278: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_MODIFIER_LEVEL;
279: END IF;
280:
281: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,p_old_PRICE_LIST_LINE_rec.number_effective_periods)
282: THEN
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
285: END IF;
283: l_index := l_index + 1;
284: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_NUMBER_EFFECTIVE_PERIODS;
285: END IF;
286:
287: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,p_old_PRICE_LIST_LINE_rec.operand)
288: THEN
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
291: END IF;
289: l_index := l_index + 1;
290: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OPERAND;
291: END IF;
292:
293: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,p_old_PRICE_LIST_LINE_rec.organization_id)
294: THEN
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
297: END IF;
295: l_index := l_index + 1;
296: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_ORGANIZATION;
297: END IF;
298:
299: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,p_old_PRICE_LIST_LINE_rec.override_flag)
300: THEN
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
303: END IF;
301: l_index := l_index + 1;
302: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_OVERRIDE;
303: END IF;
304:
305: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,p_old_PRICE_LIST_LINE_rec.percent_price)
306: THEN
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
309: END IF;
307: l_index := l_index + 1;
308: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PERCENT_PRICE;
309: END IF;
310:
311: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
312: THEN
313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
315: END IF;
313: l_index := l_index + 1;
314: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BREAK_TYPE;
315: END IF;
316:
317: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
318: THEN
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
321: END IF;
319: l_index := l_index + 1;
320: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRICE_BY_FORMULA;
321: END IF;
322:
323: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
324: THEN
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
327: END IF;
325: l_index := l_index + 1;
326: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRIMARY_UOM;
327: END IF;
328:
329: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
330: THEN
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
333: END IF;
331: l_index := l_index + 1;
332: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PRINT_ON_INVOICE;
333: END IF;
334:
335: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
336: THEN
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
339: END IF;
337: l_index := l_index + 1;
338: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_APPLICATION;
339: END IF;
340:
341: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
342: THEN
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
345: END IF;
343: l_index := l_index + 1;
344: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM;
345: END IF;
346:
347: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
348: THEN
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
351: END IF;
349: l_index := l_index + 1;
350: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;
351: END IF;
352:
353: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
354: THEN
355: l_index := l_index + 1;
356: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
357: END IF;
356: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REBATE_TRANSACTION_TYPE;
357: END IF;
358:
359: -- block pricing
360: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value, p_old_PRICE_LIST_LINE_rec.recurring_value)
361: THEN
362: l_index := l_index+1;
363: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;
364: END IF;
362: l_index := l_index+1;
363: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RECURRING_VALUE;
364: END IF;
365:
366: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,p_old_PRICE_LIST_LINE_rec.related_item_id)
367: THEN
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
370: END IF;
368: l_index := l_index + 1;
369: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATED_ITEM;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,p_old_PRICE_LIST_LINE_rec.relationship_type_id)
373: THEN
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
376: END IF;
374: l_index := l_index + 1;
375: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_RELATIONSHIP_TYPE;
376: END IF;
377:
378: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
379: THEN
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
382: END IF;
380: l_index := l_index + 1;
381: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REPRICE;
382: END IF;
383:
384: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
385: THEN
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
388: END IF;
386: l_index := l_index + 1;
387: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REQUEST;
388: END IF;
389:
390: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
391: THEN
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
394: END IF;
392: l_index := l_index + 1;
393: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
397: THEN
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
400: END IF;
398: l_index := l_index + 1;
399: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_DATE;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
403: THEN
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
406: END IF;
404: l_index := l_index + 1;
405: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_REVISION_REASON;
406: END IF;
407:
408: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
409: THEN
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
412: END IF;
410: l_index := l_index + 1;
411: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_START_DATE_ACTIVE;
412: END IF;
413:
414: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,p_old_PRICE_LIST_LINE_rec.substitution_attribute)
415: THEN
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
418: END IF;
416: l_index := l_index + 1;
417: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_ATTRIBUTE;
418: END IF;
419:
420: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,p_old_PRICE_LIST_LINE_rec.substitution_context)
421: THEN
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
424: END IF;
422: l_index := l_index + 1;
423: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_CONTEXT;
424: END IF;
425:
426: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,p_old_PRICE_LIST_LINE_rec.substitution_value)
427: THEN
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
430: END IF;
428: l_index := l_index + 1;
429: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_SUBSTITUTION_VALUE;
430: END IF;
431:
432: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id, p_old_PRICE_LIST_LINE_rec.customer_item_id)
433: THEN
434: l_index := l_index + 1;
435: l_src_attr_tbl(l_index) := QP_PRICE_LIST_LINE_UTIL.G_CUSTOMER_ITEM_ID;
436: END IF;
671:
672: -- Set reprice_flag to 'Y' every time a price list line is added/modified
673: x_PRICE_LIST_LINE_rec.reprice_flag := 'Y';
674:
675: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,p_old_PRICE_LIST_LINE_rec.accrual_qty)
676: THEN
677: NULL;
678: END IF;
679:
676: THEN
677: NULL;
678: END IF;
679:
680: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
681: THEN
682: NULL;
683: END IF;
684:
681: THEN
682: NULL;
683: END IF;
684:
685: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator)
686: THEN
687: NULL;
688: END IF;
689:
687: NULL;
688: END IF;
689:
690:
691: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
692: THEN
693: NULL;
694: END IF;
695:
692: THEN
693: NULL;
694: END IF;
695:
696: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,p_old_PRICE_LIST_LINE_rec.attribute10)
697: THEN
698: NULL;
699: END IF;
700:
697: THEN
698: NULL;
699: END IF;
700:
701: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,p_old_PRICE_LIST_LINE_rec.attribute11)
702: THEN
703: NULL;
704: END IF;
705:
702: THEN
703: NULL;
704: END IF;
705:
706: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,p_old_PRICE_LIST_LINE_rec.attribute12)
707: THEN
708: NULL;
709: END IF;
710:
707: THEN
708: NULL;
709: END IF;
710:
711: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,p_old_PRICE_LIST_LINE_rec.attribute13)
712: THEN
713: NULL;
714: END IF;
715:
712: THEN
713: NULL;
714: END IF;
715:
716: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,p_old_PRICE_LIST_LINE_rec.attribute14)
717: THEN
718: NULL;
719: END IF;
720:
717: THEN
718: NULL;
719: END IF;
720:
721: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,p_old_PRICE_LIST_LINE_rec.attribute15)
722: THEN
723: NULL;
724: END IF;
725:
722: THEN
723: NULL;
724: END IF;
725:
726: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,p_old_PRICE_LIST_LINE_rec.attribute2)
727: THEN
728: NULL;
729: END IF;
730:
727: THEN
728: NULL;
729: END IF;
730:
731: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,p_old_PRICE_LIST_LINE_rec.attribute3)
732: THEN
733: NULL;
734: END IF;
735:
732: THEN
733: NULL;
734: END IF;
735:
736: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,p_old_PRICE_LIST_LINE_rec.attribute4)
737: THEN
738: NULL;
739: END IF;
740:
737: THEN
738: NULL;
739: END IF;
740:
741: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,p_old_PRICE_LIST_LINE_rec.attribute5)
742: THEN
743: NULL;
744: END IF;
745:
742: THEN
743: NULL;
744: END IF;
745:
746: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,p_old_PRICE_LIST_LINE_rec.attribute6)
747: THEN
748: NULL;
749: END IF;
750:
747: THEN
748: NULL;
749: END IF;
750:
751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,p_old_PRICE_LIST_LINE_rec.attribute7)
752: THEN
753: NULL;
754: END IF;
755:
752: THEN
753: NULL;
754: END IF;
755:
756: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,p_old_PRICE_LIST_LINE_rec.attribute8)
757: THEN
758: NULL;
759: END IF;
760:
757: THEN
758: NULL;
759: END IF;
760:
761: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,p_old_PRICE_LIST_LINE_rec.attribute9)
762: THEN
763: NULL;
764: END IF;
765:
762: THEN
763: NULL;
764: END IF;
765:
766: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,p_old_PRICE_LIST_LINE_rec.automatic_flag)
767: THEN
768: NULL;
769: END IF;
770:
767: THEN
768: NULL;
769: END IF;
770:
771: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,p_old_PRICE_LIST_LINE_rec.base_qty)
772: THEN
773: NULL;
774: END IF;
775:
772: THEN
773: NULL;
774: END IF;
775:
776: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,p_old_PRICE_LIST_LINE_rec.base_uom_code)
777: THEN
778: NULL;
779: END IF;
780:
777: THEN
778: NULL;
779: END IF;
780:
781: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,p_old_PRICE_LIST_LINE_rec.comments)
782: THEN
783: NULL;
784: END IF;
785:
782: THEN
783: NULL;
784: END IF;
785:
786: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,p_old_PRICE_LIST_LINE_rec.context)
787: THEN
788: NULL;
789: END IF;
790:
787: THEN
788: NULL;
789: END IF;
790:
791: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,p_old_PRICE_LIST_LINE_rec.created_by)
792: THEN
793: NULL;
794: END IF;
795:
792: THEN
793: NULL;
794: END IF;
795:
796: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.creation_date,p_old_PRICE_LIST_LINE_rec.creation_date)
797: THEN
798: NULL;
799: END IF;
800:
797: THEN
798: NULL;
799: END IF;
800:
801: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,p_old_PRICE_LIST_LINE_rec.effective_period_uom)
802: THEN
803: NULL;
804: END IF;
805:
802: THEN
803: NULL;
804: END IF;
805:
806: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active,p_old_PRICE_LIST_LINE_rec.end_date_active)
807: THEN
808: NULL;
809: END IF;
810:
807: THEN
808: NULL;
809: END IF;
810:
811: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,p_old_PRICE_LIST_LINE_rec.estim_accrual_rate)
812: THEN
813: NULL;
814: END IF;
815:
812: THEN
813: NULL;
814: END IF;
815:
816: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
817: THEN
818: NULL;
819: END IF;
820:
817: THEN
818: NULL;
819: END IF;
820:
821: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,p_old_PRICE_LIST_LINE_rec.inventory_item_id)
822: THEN
823: NULL;
824: END IF;
825:
822: THEN
823: NULL;
824: END IF;
825:
826: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
827: THEN
828: NULL;
829: END IF;
830:
827: THEN
828: NULL;
829: END IF;
830:
831: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
832: THEN
833: NULL;
834: END IF;
835:
832: THEN
833: NULL;
834: END IF;
835:
836: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
837: THEN
838: NULL;
839: END IF;
840:
837: THEN
838: NULL;
839: END IF;
840:
841: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,p_old_PRICE_LIST_LINE_rec.list_header_id)
842: THEN
843: NULL;
844: END IF;
845:
842: THEN
843: NULL;
844: END IF;
845:
846: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,p_old_PRICE_LIST_LINE_rec.list_line_id)
847: THEN
848:
849: /* Commented out delayed request by dhgupta for bug 2018275. This delayed request is now being called from
850: procedure insert_row */
850: procedure insert_row */
851: null;
852: /*
853: qp_delayed_requests_PVT.log_request(
854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
855: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
856: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
857: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
858: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
852: /*
853: qp_delayed_requests_PVT.log_request(
854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
855: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
856: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
857: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
858: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
859: x_return_status => l_return_status);
860: */
854: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
855: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
856: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
857: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
858: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
859: x_return_status => l_return_status);
860: */
861: END IF;
862:
859: x_return_status => l_return_status);
860: */
861: END IF;
862:
863: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,p_old_PRICE_LIST_LINE_rec.list_line_type_code)
864: THEN
865: NULL;
866: END IF;
867:
864: THEN
865: NULL;
866: END IF;
867:
868: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,p_old_PRICE_LIST_LINE_rec.list_price)
869: THEN
870: NULL;
871: END IF;
872:
869: THEN
870: NULL;
871: END IF;
872:
873: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id,p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id)
874: THEN
875: NULL;
876: END IF;
877:
874: THEN
875: NULL;
876: END IF;
877:
878: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no,p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no)
879: THEN
880: NULL;
881: END IF;
882:
879: THEN
880: NULL;
881: END IF;
882:
883: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,p_old_PRICE_LIST_LINE_rec.product_precedence)
884: THEN
885: NULL;
886: END IF;
887:
885: NULL;
886: END IF;
887:
888:
889: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,p_old_PRICE_LIST_LINE_rec.modifier_level_code)
890: THEN
891: NULL;
892: END IF;
893:
890: THEN
891: NULL;
892: END IF;
893:
894: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,p_old_PRICE_LIST_LINE_rec.number_effective_periods)
895: THEN
896: NULL;
897: END IF;
898:
895: THEN
896: NULL;
897: END IF;
898:
899: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,p_old_PRICE_LIST_LINE_rec.operand)
900: THEN
901: NULL;
902: END IF;
903:
900: THEN
901: NULL;
902: END IF;
903:
904: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,p_old_PRICE_LIST_LINE_rec.organization_id)
905: THEN
906: NULL;
907: END IF;
908:
905: THEN
906: NULL;
907: END IF;
908:
909: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,p_old_PRICE_LIST_LINE_rec.override_flag)
910: THEN
911: NULL;
912: END IF;
913:
910: THEN
911: NULL;
912: END IF;
913:
914: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,p_old_PRICE_LIST_LINE_rec.percent_price)
915: THEN
916: NULL;
917: END IF;
918:
922:
923: --fnd_message.debug('gm before new code');
924: oe_debug_pub.add('gm before new code');
925:
926: IF NOT (QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
927: and QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator))
928: and (p_PRICE_LIST_LINE_rec.list_line_type_code = 'PBH')
929: THEN
930: qp_delayed_requests_PVT.log_request(
923: --fnd_message.debug('gm before new code');
924: oe_debug_pub.add('gm before new code');
925:
926: IF NOT (QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
927: and QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator))
928: and (p_PRICE_LIST_LINE_rec.list_line_type_code = 'PBH')
929: THEN
930: qp_delayed_requests_PVT.log_request(
931: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
927: and QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator))
928: and (p_PRICE_LIST_LINE_rec.list_line_type_code = 'PBH')
929: THEN
930: qp_delayed_requests_PVT.log_request(
931: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
932: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
933: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
934: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
935: p_request_type =>QP_GLOBALS.G_UPDATE_CHILD_BREAKS,
929: THEN
930: qp_delayed_requests_PVT.log_request(
931: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
932: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
933: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
934: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
935: p_request_type =>QP_GLOBALS.G_UPDATE_CHILD_BREAKS,
936: x_return_status => l_return_status);
937: END IF;
931: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
932: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
933: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
934: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
935: p_request_type =>QP_GLOBALS.G_UPDATE_CHILD_BREAKS,
936: x_return_status => l_return_status);
937: END IF;
938: -- END IF;
939: oe_debug_pub.add('gm after new code');
941:
942: --fnd_message.debug('gm after new code');
943:
944:
945: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
946: THEN
947: NULL;
948: END IF;
949:
946: THEN
947: NULL;
948: END IF;
949:
950: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
951: THEN
952: NULL;
953: END IF;
954:
951: THEN
952: NULL;
953: END IF;
954:
955: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
956: THEN
957: NULL;
958: END IF;
959:
956: THEN
957: NULL;
958: END IF;
959:
960: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,p_old_PRICE_LIST_LINE_rec.program_application_id)
961: THEN
962: NULL;
963: END IF;
964:
961: THEN
962: NULL;
963: END IF;
964:
965: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,p_old_PRICE_LIST_LINE_rec.program_id)
966: THEN
967: NULL;
968: END IF;
969:
966: THEN
967: NULL;
968: END IF;
969:
970: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
971: THEN
972: NULL;
973: END IF;
974:
971: THEN
972: NULL;
973: END IF;
974:
975: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
976: THEN
977: NULL;
978: END IF;
979:
977: NULL;
978: END IF;
979:
980: -- block pricing
981: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value, p_old_PRICE_LIST_LINE_rec.recurring_value)
982: THEN
983: NULL;
984: END IF;
985:
982: THEN
983: NULL;
984: END IF;
985:
986: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,p_old_PRICE_LIST_LINE_rec.related_item_id)
987: THEN
988: NULL;
989: END IF;
990:
987: THEN
988: NULL;
989: END IF;
990:
991: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,p_old_PRICE_LIST_LINE_rec.relationship_type_id)
992: THEN
993: NULL;
994: END IF;
995:
992: THEN
993: NULL;
994: END IF;
995:
996: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,p_old_PRICE_LIST_LINE_rec.reprice_flag)
997: THEN
998: NULL;
999: END IF;
1000:
997: THEN
998: NULL;
999: END IF;
1000:
1001: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,p_old_PRICE_LIST_LINE_rec.request_id)
1002: THEN
1003: NULL;
1004: END IF;
1005:
1002: THEN
1003: NULL;
1004: END IF;
1005:
1006: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,p_old_PRICE_LIST_LINE_rec.revision)
1007: THEN
1008: NULL;
1009: END IF;
1010:
1007: THEN
1008: NULL;
1009: END IF;
1010:
1011: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_date,p_old_PRICE_LIST_LINE_rec.revision_date)
1012: THEN
1013: NULL;
1014: END IF;
1015:
1012: THEN
1013: NULL;
1014: END IF;
1015:
1016: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,p_old_PRICE_LIST_LINE_rec.revision_reason_code)
1017: THEN
1018: NULL;
1019: END IF;
1020:
1017: THEN
1018: NULL;
1019: END IF;
1020:
1021: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.start_date_active,p_old_PRICE_LIST_LINE_rec.start_date_active)
1022: THEN
1023: NULL;
1024: END IF;
1025:
1022: THEN
1023: NULL;
1024: END IF;
1025:
1026: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,p_old_PRICE_LIST_LINE_rec.substitution_attribute)
1027: THEN
1028: NULL;
1029: END IF;
1030:
1027: THEN
1028: NULL;
1029: END IF;
1030:
1031: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,p_old_PRICE_LIST_LINE_rec.substitution_context)
1032: THEN
1033: NULL;
1034: END IF;
1035:
1032: THEN
1033: NULL;
1034: END IF;
1035:
1036: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,p_old_PRICE_LIST_LINE_rec.substitution_value)
1037: THEN
1038: NULL;
1039: END IF;
1040:
1037: THEN
1038: NULL;
1039: END IF;
1040:
1041: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id, p_old_PRICE_LIST_LINE_rec.customer_item_id)
1042: THEN
1043: NULL;
1044: END IF;
1045:
1042: THEN
1043: NULL;
1044: END IF;
1045:
1046: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.break_uom_code,p_old_PRICE_LIST_LINE_rec.break_uom_code)
1047: THEN
1048: NULL;
1049: END IF;
1050:
1047: THEN
1048: NULL;
1049: END IF;
1050:
1051: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.break_uom_context,p_old_PRICE_LIST_LINE_rec.break_uom_context)
1052: THEN
1053: NULL;
1054: END IF;
1055:
1052: THEN
1053: NULL;
1054: END IF;
1055:
1056: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.break_uom_attribute,p_old_PRICE_LIST_LINE_rec.break_uom_attribute)
1057: THEN
1058: NULL;
1059: END IF;
1060:
1057: THEN
1058: NULL;
1059: END IF;
1060:
1061: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.continuous_price_break_flag,p_old_PRICE_LIST_LINE_rec.continuous_price_break_flag)
1062: THEN
1063: NULL;
1064: END IF;
1065:
2037: );
2038: /* Added delayed request by dhgupta for bug 2018275 */
2039:
2040: qp_delayed_requests_PVT.log_request(
2041: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2042: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2043: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2044: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2045: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2039:
2040: qp_delayed_requests_PVT.log_request(
2041: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2042: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2043: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2044: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2045: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2046: x_return_status => l_return_status);
2047:
2041: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2042: p_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2043: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_ALL,
2044: p_requesting_entity_id => p_PRICE_LIST_LINE_rec.list_line_id,
2045: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
2046: x_return_status => l_return_status);
2047:
2048: /* Proration Start */
2049: l_check_active_flag:=nvl(fnd_profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
2834:
2835:
2836: -- Row locked. Compare IN attributes to DB attributes.
2837:
2838: IF QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,
2839: l_PRICE_LIST_LINE_rec.accrual_qty)
2840: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
2841: l_PRICE_LIST_LINE_rec.accrual_uom_code)
2842: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,
2836: -- Row locked. Compare IN attributes to DB attributes.
2837:
2838: IF QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,
2839: l_PRICE_LIST_LINE_rec.accrual_qty)
2840: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
2841: l_PRICE_LIST_LINE_rec.accrual_uom_code)
2842: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,
2843: l_PRICE_LIST_LINE_rec.arithmetic_operator)
2844: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,
2838: IF QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_qty,
2839: l_PRICE_LIST_LINE_rec.accrual_qty)
2840: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
2841: l_PRICE_LIST_LINE_rec.accrual_uom_code)
2842: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,
2843: l_PRICE_LIST_LINE_rec.arithmetic_operator)
2844: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,
2845: l_PRICE_LIST_LINE_rec.attribute1)
2846: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,
2840: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
2841: l_PRICE_LIST_LINE_rec.accrual_uom_code)
2842: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,
2843: l_PRICE_LIST_LINE_rec.arithmetic_operator)
2844: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,
2845: l_PRICE_LIST_LINE_rec.attribute1)
2846: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,
2847: l_PRICE_LIST_LINE_rec.attribute10)
2848: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,
2842: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,
2843: l_PRICE_LIST_LINE_rec.arithmetic_operator)
2844: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,
2845: l_PRICE_LIST_LINE_rec.attribute1)
2846: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,
2847: l_PRICE_LIST_LINE_rec.attribute10)
2848: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,
2849: l_PRICE_LIST_LINE_rec.attribute11)
2850: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,
2844: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,
2845: l_PRICE_LIST_LINE_rec.attribute1)
2846: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,
2847: l_PRICE_LIST_LINE_rec.attribute10)
2848: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,
2849: l_PRICE_LIST_LINE_rec.attribute11)
2850: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,
2851: l_PRICE_LIST_LINE_rec.attribute12)
2852: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,
2846: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute10,
2847: l_PRICE_LIST_LINE_rec.attribute10)
2848: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,
2849: l_PRICE_LIST_LINE_rec.attribute11)
2850: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,
2851: l_PRICE_LIST_LINE_rec.attribute12)
2852: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,
2853: l_PRICE_LIST_LINE_rec.attribute13)
2854: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,
2848: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute11,
2849: l_PRICE_LIST_LINE_rec.attribute11)
2850: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,
2851: l_PRICE_LIST_LINE_rec.attribute12)
2852: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,
2853: l_PRICE_LIST_LINE_rec.attribute13)
2854: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,
2855: l_PRICE_LIST_LINE_rec.attribute14)
2856: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,
2850: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute12,
2851: l_PRICE_LIST_LINE_rec.attribute12)
2852: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,
2853: l_PRICE_LIST_LINE_rec.attribute13)
2854: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,
2855: l_PRICE_LIST_LINE_rec.attribute14)
2856: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,
2857: l_PRICE_LIST_LINE_rec.attribute15)
2858: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,
2852: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute13,
2853: l_PRICE_LIST_LINE_rec.attribute13)
2854: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,
2855: l_PRICE_LIST_LINE_rec.attribute14)
2856: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,
2857: l_PRICE_LIST_LINE_rec.attribute15)
2858: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,
2859: l_PRICE_LIST_LINE_rec.attribute2)
2860: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,
2854: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute14,
2855: l_PRICE_LIST_LINE_rec.attribute14)
2856: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,
2857: l_PRICE_LIST_LINE_rec.attribute15)
2858: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,
2859: l_PRICE_LIST_LINE_rec.attribute2)
2860: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,
2861: l_PRICE_LIST_LINE_rec.attribute3)
2862: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,
2856: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute15,
2857: l_PRICE_LIST_LINE_rec.attribute15)
2858: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,
2859: l_PRICE_LIST_LINE_rec.attribute2)
2860: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,
2861: l_PRICE_LIST_LINE_rec.attribute3)
2862: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,
2863: l_PRICE_LIST_LINE_rec.attribute4)
2864: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,
2858: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute2,
2859: l_PRICE_LIST_LINE_rec.attribute2)
2860: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,
2861: l_PRICE_LIST_LINE_rec.attribute3)
2862: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,
2863: l_PRICE_LIST_LINE_rec.attribute4)
2864: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,
2865: l_PRICE_LIST_LINE_rec.attribute5)
2866: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,
2860: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute3,
2861: l_PRICE_LIST_LINE_rec.attribute3)
2862: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,
2863: l_PRICE_LIST_LINE_rec.attribute4)
2864: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,
2865: l_PRICE_LIST_LINE_rec.attribute5)
2866: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,
2867: l_PRICE_LIST_LINE_rec.attribute6)
2868: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,
2862: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute4,
2863: l_PRICE_LIST_LINE_rec.attribute4)
2864: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,
2865: l_PRICE_LIST_LINE_rec.attribute5)
2866: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,
2867: l_PRICE_LIST_LINE_rec.attribute6)
2868: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,
2869: l_PRICE_LIST_LINE_rec.attribute7)
2870: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,
2864: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute5,
2865: l_PRICE_LIST_LINE_rec.attribute5)
2866: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,
2867: l_PRICE_LIST_LINE_rec.attribute6)
2868: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,
2869: l_PRICE_LIST_LINE_rec.attribute7)
2870: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,
2871: l_PRICE_LIST_LINE_rec.attribute8)
2872: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,
2866: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute6,
2867: l_PRICE_LIST_LINE_rec.attribute6)
2868: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,
2869: l_PRICE_LIST_LINE_rec.attribute7)
2870: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,
2871: l_PRICE_LIST_LINE_rec.attribute8)
2872: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,
2873: l_PRICE_LIST_LINE_rec.attribute9)
2874: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2868: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute7,
2869: l_PRICE_LIST_LINE_rec.attribute7)
2870: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,
2871: l_PRICE_LIST_LINE_rec.attribute8)
2872: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,
2873: l_PRICE_LIST_LINE_rec.attribute9)
2874: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2875: l_PRICE_LIST_LINE_rec.automatic_flag)
2876: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,
2870: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute8,
2871: l_PRICE_LIST_LINE_rec.attribute8)
2872: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,
2873: l_PRICE_LIST_LINE_rec.attribute9)
2874: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2875: l_PRICE_LIST_LINE_rec.automatic_flag)
2876: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,
2877: l_PRICE_LIST_LINE_rec.base_qty)
2878: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
2872: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute9,
2873: l_PRICE_LIST_LINE_rec.attribute9)
2874: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2875: l_PRICE_LIST_LINE_rec.automatic_flag)
2876: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,
2877: l_PRICE_LIST_LINE_rec.base_qty)
2878: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
2879: l_PRICE_LIST_LINE_rec.base_uom_code)
2880: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,
2874: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
2875: l_PRICE_LIST_LINE_rec.automatic_flag)
2876: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,
2877: l_PRICE_LIST_LINE_rec.base_qty)
2878: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
2879: l_PRICE_LIST_LINE_rec.base_uom_code)
2880: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,
2881: l_PRICE_LIST_LINE_rec.comments)
2882: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,
2876: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_qty,
2877: l_PRICE_LIST_LINE_rec.base_qty)
2878: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
2879: l_PRICE_LIST_LINE_rec.base_uom_code)
2880: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,
2881: l_PRICE_LIST_LINE_rec.comments)
2882: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,
2883: l_PRICE_LIST_LINE_rec.context)
2884: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,
2878: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
2879: l_PRICE_LIST_LINE_rec.base_uom_code)
2880: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,
2881: l_PRICE_LIST_LINE_rec.comments)
2882: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,
2883: l_PRICE_LIST_LINE_rec.context)
2884: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,
2885: l_PRICE_LIST_LINE_rec.created_by)
2886: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.creation_date),
2880: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.comments,
2881: l_PRICE_LIST_LINE_rec.comments)
2882: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,
2883: l_PRICE_LIST_LINE_rec.context)
2884: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,
2885: l_PRICE_LIST_LINE_rec.created_by)
2886: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.creation_date),
2887: trunc(l_PRICE_LIST_LINE_rec.creation_date))
2888: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,
2882: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.context,
2883: l_PRICE_LIST_LINE_rec.context)
2884: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,
2885: l_PRICE_LIST_LINE_rec.created_by)
2886: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.creation_date),
2887: trunc(l_PRICE_LIST_LINE_rec.creation_date))
2888: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,
2889: l_PRICE_LIST_LINE_rec.effective_period_uom)
2890: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.end_date_active),
2884: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.created_by,
2885: l_PRICE_LIST_LINE_rec.created_by)
2886: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.creation_date),
2887: trunc(l_PRICE_LIST_LINE_rec.creation_date))
2888: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,
2889: l_PRICE_LIST_LINE_rec.effective_period_uom)
2890: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.end_date_active),
2891: trunc(l_PRICE_LIST_LINE_rec.end_date_active))
2892: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,
2886: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.creation_date),
2887: trunc(l_PRICE_LIST_LINE_rec.creation_date))
2888: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,
2889: l_PRICE_LIST_LINE_rec.effective_period_uom)
2890: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.end_date_active),
2891: trunc(l_PRICE_LIST_LINE_rec.end_date_active))
2892: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,
2893: l_PRICE_LIST_LINE_rec.estim_accrual_rate)
2894: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
2888: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.effective_period_uom,
2889: l_PRICE_LIST_LINE_rec.effective_period_uom)
2890: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.end_date_active),
2891: trunc(l_PRICE_LIST_LINE_rec.end_date_active))
2892: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,
2893: l_PRICE_LIST_LINE_rec.estim_accrual_rate)
2894: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
2895: l_PRICE_LIST_LINE_rec.generate_using_formula_id)
2896: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2890: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.end_date_active),
2891: trunc(l_PRICE_LIST_LINE_rec.end_date_active))
2892: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,
2893: l_PRICE_LIST_LINE_rec.estim_accrual_rate)
2894: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
2895: l_PRICE_LIST_LINE_rec.generate_using_formula_id)
2896: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2897: l_PRICE_LIST_LINE_rec.inventory_item_id)
2898: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,
2892: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.estim_accrual_rate,
2893: l_PRICE_LIST_LINE_rec.estim_accrual_rate)
2894: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
2895: l_PRICE_LIST_LINE_rec.generate_using_formula_id)
2896: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2897: l_PRICE_LIST_LINE_rec.inventory_item_id)
2898: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,
2899: -- l_PRICE_LIST_LINE_rec.last_updated_by)
2900: -- AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.last_update_date),
2894: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
2895: l_PRICE_LIST_LINE_rec.generate_using_formula_id)
2896: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2897: l_PRICE_LIST_LINE_rec.inventory_item_id)
2898: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,
2899: -- l_PRICE_LIST_LINE_rec.last_updated_by)
2900: -- AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.last_update_date),
2901: -- trunc(l_PRICE_LIST_LINE_rec.last_update_date))
2902: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,
2896: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2897: l_PRICE_LIST_LINE_rec.inventory_item_id)
2898: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,
2899: -- l_PRICE_LIST_LINE_rec.last_updated_by)
2900: -- AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.last_update_date),
2901: -- trunc(l_PRICE_LIST_LINE_rec.last_update_date))
2902: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,
2903: -- l_PRICE_LIST_LINE_rec.last_update_login)
2904: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
2898: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,
2899: -- l_PRICE_LIST_LINE_rec.last_updated_by)
2900: -- AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.last_update_date),
2901: -- trunc(l_PRICE_LIST_LINE_rec.last_update_date))
2902: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,
2903: -- l_PRICE_LIST_LINE_rec.last_update_login)
2904: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
2905: l_PRICE_LIST_LINE_rec.list_header_id)
2906: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
2900: -- AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.last_update_date),
2901: -- trunc(l_PRICE_LIST_LINE_rec.last_update_date))
2902: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,
2903: -- l_PRICE_LIST_LINE_rec.last_update_login)
2904: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
2905: l_PRICE_LIST_LINE_rec.list_header_id)
2906: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
2907: l_PRICE_LIST_LINE_rec.list_line_id)
2908: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
2902: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,
2903: -- l_PRICE_LIST_LINE_rec.last_update_login)
2904: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
2905: l_PRICE_LIST_LINE_rec.list_header_id)
2906: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
2907: l_PRICE_LIST_LINE_rec.list_line_id)
2908: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
2909: l_PRICE_LIST_LINE_rec.list_line_type_code)
2910: --5409776 and 8540557
2904: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
2905: l_PRICE_LIST_LINE_rec.list_header_id)
2906: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
2907: l_PRICE_LIST_LINE_rec.list_line_id)
2908: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
2909: l_PRICE_LIST_LINE_rec.list_line_type_code)
2910: --5409776 and 8540557
2911: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,
2912: -- l_PRICE_LIST_LINE_rec.list_price)
2907: l_PRICE_LIST_LINE_rec.list_line_id)
2908: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
2909: l_PRICE_LIST_LINE_rec.list_line_type_code)
2910: --5409776 and 8540557
2911: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,
2912: -- l_PRICE_LIST_LINE_rec.list_price)
2913: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,
2914: l_PRICE_LIST_LINE_rec.product_precedence)
2915: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
2909: l_PRICE_LIST_LINE_rec.list_line_type_code)
2910: --5409776 and 8540557
2911: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,
2912: -- l_PRICE_LIST_LINE_rec.list_price)
2913: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,
2914: l_PRICE_LIST_LINE_rec.product_precedence)
2915: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
2916: l_PRICE_LIST_LINE_rec.modifier_level_code)
2917: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,
2911: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_price,
2912: -- l_PRICE_LIST_LINE_rec.list_price)
2913: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,
2914: l_PRICE_LIST_LINE_rec.product_precedence)
2915: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
2916: l_PRICE_LIST_LINE_rec.modifier_level_code)
2917: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,
2918: l_PRICE_LIST_LINE_rec.number_effective_periods)
2919: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,
2913: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.product_precedence,
2914: l_PRICE_LIST_LINE_rec.product_precedence)
2915: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
2916: l_PRICE_LIST_LINE_rec.modifier_level_code)
2917: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,
2918: l_PRICE_LIST_LINE_rec.number_effective_periods)
2919: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,
2920: l_PRICE_LIST_LINE_rec.operand)
2921: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
2915: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
2916: l_PRICE_LIST_LINE_rec.modifier_level_code)
2917: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,
2918: l_PRICE_LIST_LINE_rec.number_effective_periods)
2919: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,
2920: l_PRICE_LIST_LINE_rec.operand)
2921: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
2922: l_PRICE_LIST_LINE_rec.organization_id)
2923: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
2917: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.number_effective_periods,
2918: l_PRICE_LIST_LINE_rec.number_effective_periods)
2919: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,
2920: l_PRICE_LIST_LINE_rec.operand)
2921: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
2922: l_PRICE_LIST_LINE_rec.organization_id)
2923: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
2924: l_PRICE_LIST_LINE_rec.override_flag)
2925: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,
2919: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.operand,
2920: l_PRICE_LIST_LINE_rec.operand)
2921: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
2922: l_PRICE_LIST_LINE_rec.organization_id)
2923: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
2924: l_PRICE_LIST_LINE_rec.override_flag)
2925: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,
2926: l_PRICE_LIST_LINE_rec.percent_price)
2927: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
2921: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
2922: l_PRICE_LIST_LINE_rec.organization_id)
2923: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
2924: l_PRICE_LIST_LINE_rec.override_flag)
2925: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,
2926: l_PRICE_LIST_LINE_rec.percent_price)
2927: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
2928: l_PRICE_LIST_LINE_rec.price_break_type_code)
2929: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
2923: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
2924: l_PRICE_LIST_LINE_rec.override_flag)
2925: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,
2926: l_PRICE_LIST_LINE_rec.percent_price)
2927: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
2928: l_PRICE_LIST_LINE_rec.price_break_type_code)
2929: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
2930: l_PRICE_LIST_LINE_rec.price_by_formula_id)
2931: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
2925: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.percent_price,
2926: l_PRICE_LIST_LINE_rec.percent_price)
2927: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
2928: l_PRICE_LIST_LINE_rec.price_break_type_code)
2929: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
2930: l_PRICE_LIST_LINE_rec.price_by_formula_id)
2931: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
2932: l_PRICE_LIST_LINE_rec.primary_uom_flag)
2933: --AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag, bug8206467
2927: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
2928: l_PRICE_LIST_LINE_rec.price_break_type_code)
2929: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
2930: l_PRICE_LIST_LINE_rec.price_by_formula_id)
2931: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
2932: l_PRICE_LIST_LINE_rec.primary_uom_flag)
2933: --AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag, bug8206467
2934: -- l_PRICE_LIST_LINE_rec.print_on_invoice_flag)
2935: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,
2929: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
2930: l_PRICE_LIST_LINE_rec.price_by_formula_id)
2931: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
2932: l_PRICE_LIST_LINE_rec.primary_uom_flag)
2933: --AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag, bug8206467
2934: -- l_PRICE_LIST_LINE_rec.print_on_invoice_flag)
2935: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,
2936: l_PRICE_LIST_LINE_rec.program_application_id)
2937: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,
2931: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
2932: l_PRICE_LIST_LINE_rec.primary_uom_flag)
2933: --AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag, bug8206467
2934: -- l_PRICE_LIST_LINE_rec.print_on_invoice_flag)
2935: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,
2936: l_PRICE_LIST_LINE_rec.program_application_id)
2937: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,
2938: l_PRICE_LIST_LINE_rec.program_id)
2939: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.program_update_date),
2933: --AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag, bug8206467
2934: -- l_PRICE_LIST_LINE_rec.print_on_invoice_flag)
2935: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,
2936: l_PRICE_LIST_LINE_rec.program_application_id)
2937: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,
2938: l_PRICE_LIST_LINE_rec.program_id)
2939: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.program_update_date),
2940: trunc(l_PRICE_LIST_LINE_rec.program_update_date))
2941: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
2935: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_application_id,
2936: l_PRICE_LIST_LINE_rec.program_application_id)
2937: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,
2938: l_PRICE_LIST_LINE_rec.program_id)
2939: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.program_update_date),
2940: trunc(l_PRICE_LIST_LINE_rec.program_update_date))
2941: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
2942: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
2943: -- block pricing
2937: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_id,
2938: l_PRICE_LIST_LINE_rec.program_id)
2939: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.program_update_date),
2940: trunc(l_PRICE_LIST_LINE_rec.program_update_date))
2941: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
2942: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
2943: -- block pricing
2944: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value,
2945: l_PRICE_LIST_LINE_rec.recurring_value)
2940: trunc(l_PRICE_LIST_LINE_rec.program_update_date))
2941: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
2942: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
2943: -- block pricing
2944: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value,
2945: l_PRICE_LIST_LINE_rec.recurring_value)
2946: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
2947: l_PRICE_LIST_LINE_rec.related_item_id)
2948: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
2942: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
2943: -- block pricing
2944: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value,
2945: l_PRICE_LIST_LINE_rec.recurring_value)
2946: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
2947: l_PRICE_LIST_LINE_rec.related_item_id)
2948: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
2949: l_PRICE_LIST_LINE_rec.relationship_type_id)
2950: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2944: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.recurring_value,
2945: l_PRICE_LIST_LINE_rec.recurring_value)
2946: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
2947: l_PRICE_LIST_LINE_rec.related_item_id)
2948: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
2949: l_PRICE_LIST_LINE_rec.relationship_type_id)
2950: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2951: -- l_PRICE_LIST_LINE_rec.reprice_flag)
2952: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,
2946: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
2947: l_PRICE_LIST_LINE_rec.related_item_id)
2948: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
2949: l_PRICE_LIST_LINE_rec.relationship_type_id)
2950: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2951: -- l_PRICE_LIST_LINE_rec.reprice_flag)
2952: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,
2953: l_PRICE_LIST_LINE_rec.request_id)
2954: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,
2948: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
2949: l_PRICE_LIST_LINE_rec.relationship_type_id)
2950: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2951: -- l_PRICE_LIST_LINE_rec.reprice_flag)
2952: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,
2953: l_PRICE_LIST_LINE_rec.request_id)
2954: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,
2955: l_PRICE_LIST_LINE_rec.revision)
2956: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.revision_date),
2950: -- AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2951: -- l_PRICE_LIST_LINE_rec.reprice_flag)
2952: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,
2953: l_PRICE_LIST_LINE_rec.request_id)
2954: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,
2955: l_PRICE_LIST_LINE_rec.revision)
2956: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.revision_date),
2957: trunc(l_PRICE_LIST_LINE_rec.revision_date))
2958: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2952: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.request_id,
2953: l_PRICE_LIST_LINE_rec.request_id)
2954: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,
2955: l_PRICE_LIST_LINE_rec.revision)
2956: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.revision_date),
2957: trunc(l_PRICE_LIST_LINE_rec.revision_date))
2958: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2959: l_PRICE_LIST_LINE_rec.revision_reason_code)
2960: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.start_date_active),
2954: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision,
2955: l_PRICE_LIST_LINE_rec.revision)
2956: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.revision_date),
2957: trunc(l_PRICE_LIST_LINE_rec.revision_date))
2958: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2959: l_PRICE_LIST_LINE_rec.revision_reason_code)
2960: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.start_date_active),
2961: trunc(l_PRICE_LIST_LINE_rec.start_date_active))
2962: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,
2956: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.revision_date),
2957: trunc(l_PRICE_LIST_LINE_rec.revision_date))
2958: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2959: l_PRICE_LIST_LINE_rec.revision_reason_code)
2960: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.start_date_active),
2961: trunc(l_PRICE_LIST_LINE_rec.start_date_active))
2962: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,
2963: l_PRICE_LIST_LINE_rec.substitution_attribute)
2964: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,
2958: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2959: l_PRICE_LIST_LINE_rec.revision_reason_code)
2960: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.start_date_active),
2961: trunc(l_PRICE_LIST_LINE_rec.start_date_active))
2962: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,
2963: l_PRICE_LIST_LINE_rec.substitution_attribute)
2964: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,
2965: l_PRICE_LIST_LINE_rec.substitution_context)
2966: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,
2960: AND QP_GLOBALS.Equal(trunc(p_PRICE_LIST_LINE_rec.start_date_active),
2961: trunc(l_PRICE_LIST_LINE_rec.start_date_active))
2962: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,
2963: l_PRICE_LIST_LINE_rec.substitution_attribute)
2964: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,
2965: l_PRICE_LIST_LINE_rec.substitution_context)
2966: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,
2967: l_PRICE_LIST_LINE_rec.substitution_value)
2968: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,
2962: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_attribute,
2963: l_PRICE_LIST_LINE_rec.substitution_attribute)
2964: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,
2965: l_PRICE_LIST_LINE_rec.substitution_context)
2966: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,
2967: l_PRICE_LIST_LINE_rec.substitution_value)
2968: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,
2969: l_PRICE_LIST_LINE_rec.customer_item_id)
2970: THEN
2964: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_context,
2965: l_PRICE_LIST_LINE_rec.substitution_context)
2966: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.substitution_value,
2967: l_PRICE_LIST_LINE_rec.substitution_value)
2968: AND QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,
2969: l_PRICE_LIST_LINE_rec.customer_item_id)
2970: THEN
2971:
2972: -- Row has not changed. Set out parameter.
3120:
3121: /*
3122: IF p_PRICE_LIST_LINE_rec.accrual_uom_code IS NOT NULL AND
3123: p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR AND
3124: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.accrual_uom_code,
3125: p_old_PRICE_LIST_LINE_rec.accrual_uom_code)
3126: THEN
3127: l_PRICE_LIST_LINE_val_rec.accrual_uom := QP_Id_To_Value.Accrual_Uom
3128: ( p_accrual_uom_code => p_PRICE_LIST_LINE_rec.accrual_uom_code
3132: */
3133:
3134: IF p_PRICE_LIST_LINE_rec.automatic_flag IS NOT NULL AND
3135: p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR AND
3136: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.automatic_flag,
3137: p_old_PRICE_LIST_LINE_rec.automatic_flag)
3138: THEN
3139: l_PRICE_LIST_LINE_val_rec.automatic := QP_Id_To_Value.Automatic
3140: ( p_automatic_flag => p_PRICE_LIST_LINE_rec.automatic_flag
3142: END IF;
3143:
3144: IF p_PRICE_LIST_LINE_rec.base_uom_code IS NOT NULL AND
3145: p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR AND
3146: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.base_uom_code,
3147: p_old_PRICE_LIST_LINE_rec.base_uom_code)
3148: THEN
3149: l_PRICE_LIST_LINE_val_rec.base_uom := QP_Id_To_Value.Base_Uom
3150: ( p_base_uom_code => p_PRICE_LIST_LINE_rec.base_uom_code
3152: END IF;
3153:
3154: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id IS NOT NULL AND
3155: p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM AND
3156: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.generate_using_formula_id,
3157: p_old_PRICE_LIST_LINE_rec.generate_using_formula_id)
3158: THEN
3159: l_PRICE_LIST_LINE_val_rec.generate_using_formula := QP_Id_To_Value.Generate_Using_Formula
3160: ( p_generate_using_formula_id => p_PRICE_LIST_LINE_rec.generate_using_formula_id
3163:
3164:
3165: IF p_PRICE_LIST_LINE_rec.inventory_item_id IS NOT NULL AND
3166: p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
3167: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
3168: p_old_PRICE_LIST_LINE_rec.inventory_item_id)
3169: THEN
3170: l_PRICE_LIST_LINE_val_rec.inventory_item := QP_Id_To_Value.Inventory_Item
3171: ( p_inventory_item_id => p_PRICE_LIST_LINE_rec.inventory_item_id
3173: END IF;
3174:
3175: IF p_PRICE_LIST_LINE_rec.list_header_id IS NOT NULL AND
3176: p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM AND
3177: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_header_id,
3178: p_old_PRICE_LIST_LINE_rec.list_header_id)
3179: THEN
3180: l_PRICE_LIST_LINE_val_rec.list_header := QP_Id_To_Value.List_Header
3181: ( p_list_header_id => p_PRICE_LIST_LINE_rec.list_header_id
3183: END IF;
3184:
3185: IF p_PRICE_LIST_LINE_rec.list_line_id IS NOT NULL AND
3186: p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM AND
3187: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_id,
3188: p_old_PRICE_LIST_LINE_rec.list_line_id)
3189: THEN
3190: l_PRICE_LIST_LINE_val_rec.list_line := QP_Id_To_Value.List_Line
3191: ( p_list_line_id => p_PRICE_LIST_LINE_rec.list_line_id
3193: END IF;
3194:
3195: IF p_PRICE_LIST_LINE_rec.list_line_type_code IS NOT NULL AND
3196: p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR AND
3197: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.list_line_type_code,
3198: p_old_PRICE_LIST_LINE_rec.list_line_type_code)
3199: THEN
3200: l_PRICE_LIST_LINE_val_rec.list_line_type := QP_Id_To_Value.List_Line_Type
3201: ( p_list_line_type_code => p_PRICE_LIST_LINE_rec.list_line_type_code
3203: END IF;
3204:
3205: IF p_PRICE_LIST_LINE_rec.modifier_level_code IS NOT NULL AND
3206: p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR AND
3207: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.modifier_level_code,
3208: p_old_PRICE_LIST_LINE_rec.modifier_level_code)
3209: THEN
3210: l_PRICE_LIST_LINE_val_rec.modifier_level := QP_Id_To_Value.Modifier_Level
3211: ( p_modifier_level_code => p_PRICE_LIST_LINE_rec.modifier_level_code
3213: END IF;
3214:
3215: IF p_PRICE_LIST_LINE_rec.organization_id IS NOT NULL AND
3216: p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM AND
3217: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.organization_id,
3218: p_old_PRICE_LIST_LINE_rec.organization_id)
3219: THEN
3220: l_PRICE_LIST_LINE_val_rec.organization := QP_Id_To_Value.Organization
3221: ( p_organization_id => p_PRICE_LIST_LINE_rec.organization_id
3223: END IF;
3224:
3225: IF p_PRICE_LIST_LINE_rec.override_flag IS NOT NULL AND
3226: p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR AND
3227: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.override_flag,
3228: p_old_PRICE_LIST_LINE_rec.override_flag)
3229: THEN
3230: l_PRICE_LIST_LINE_val_rec.override := QP_Id_To_Value.Override
3231: ( p_override_flag => p_PRICE_LIST_LINE_rec.override_flag
3233: END IF;
3234:
3235: IF p_PRICE_LIST_LINE_rec.price_break_type_code IS NOT NULL AND
3236: p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR AND
3237: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,
3238: p_old_PRICE_LIST_LINE_rec.price_break_type_code)
3239: THEN
3240: l_PRICE_LIST_LINE_val_rec.price_break_type := QP_Id_To_Value.Price_Break_Type
3241: ( p_price_break_type_code => p_PRICE_LIST_LINE_rec.price_break_type_code
3243: END IF;
3244:
3245: IF p_PRICE_LIST_LINE_rec.price_by_formula_id IS NOT NULL AND
3246: p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM AND
3247: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,
3248: p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
3249: THEN
3250: l_PRICE_LIST_LINE_val_rec.price_by_formula := QP_Id_To_Value.Price_By_Formula
3251: ( p_price_by_formula_id => p_PRICE_LIST_LINE_rec.price_by_formula_id
3253: END IF;
3254:
3255: IF p_PRICE_LIST_LINE_rec.primary_uom_flag IS NOT NULL AND
3256: p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR AND
3257: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.primary_uom_flag,
3258: p_old_PRICE_LIST_LINE_rec.primary_uom_flag)
3259: THEN
3260: l_PRICE_LIST_LINE_val_rec.primary_uom := QP_Id_To_Value.Primary_Uom
3261: ( p_primary_uom_flag => p_PRICE_LIST_LINE_rec.primary_uom_flag
3263: END IF;
3264:
3265: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag IS NOT NULL AND
3266: p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR AND
3267: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.print_on_invoice_flag,
3268: p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag)
3269: THEN
3270: l_PRICE_LIST_LINE_val_rec.print_on_invoice := QP_Id_To_Value.Print_On_Invoice
3271: ( p_print_on_invoice_flag => p_PRICE_LIST_LINE_rec.print_on_invoice_flag
3273: END IF;
3274:
3275: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code IS NOT NULL AND
3276: p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR AND
3277: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code,
3278: p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code)
3279: THEN
3280: l_PRICE_LIST_LINE_val_rec.rebate_transaction_type := QP_Id_To_Value.Rebate_Transaction_Type
3281: ( p_rebate_trxn_type_code => p_PRICE_LIST_LINE_rec.rebate_trxn_type_code
3283: END IF;
3284:
3285: IF p_PRICE_LIST_LINE_rec.related_item_id IS NOT NULL AND
3286: p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM AND
3287: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.related_item_id,
3288: p_old_PRICE_LIST_LINE_rec.related_item_id)
3289: THEN
3290: l_PRICE_LIST_LINE_val_rec.related_item := QP_Id_To_Value.Related_Item
3291: ( p_related_item_id => p_PRICE_LIST_LINE_rec.related_item_id
3293: END IF;
3294:
3295: IF p_PRICE_LIST_LINE_rec.relationship_type_id IS NOT NULL AND
3296: p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM AND
3297: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.relationship_type_id,
3298: p_old_PRICE_LIST_LINE_rec.relationship_type_id)
3299: THEN
3300: l_PRICE_LIST_LINE_val_rec.relationship_type := QP_Id_To_Value.Relationship_Type
3301: ( p_relationship_type_id => p_PRICE_LIST_LINE_rec.relationship_type_id
3303: END IF;
3304:
3305: IF p_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL AND
3306: p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
3307: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
3308: p_old_PRICE_LIST_LINE_rec.reprice_flag)
3309: THEN
3310: l_PRICE_LIST_LINE_val_rec.reprice := QP_Id_To_Value.Reprice
3311: ( p_reprice_flag => p_PRICE_LIST_LINE_rec.reprice_flag
3313: END IF;
3314:
3315: IF p_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL AND
3316: p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
3317: NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
3318: p_old_PRICE_LIST_LINE_rec.revision_reason_code)
3319: THEN
3320: l_PRICE_LIST_LINE_val_rec.revision_reason := QP_Id_To_Value.Revision_Reason
3321: ( p_revision_reason_code => p_PRICE_LIST_LINE_rec.revision_reason_code