eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_FORMULA_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_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('Entering proc clear_dependent_attr in Formula Util Pkg');

Line 20: l_dep_attr_tbl QP_GLOBALS.NUMBER_Tbl_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('Entering proc clear_dependent_attr in Formula Util Pkg');
24: -- Load out record

Line 33: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)

29: -- every changed attribute clear its dependent fields.
30:
31: IF p_attr_id = FND_API.G_MISS_NUM THEN
32:
33: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)
34: THEN
35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;
37: END IF;

Line 39: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)

35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE1;
37: END IF;
38:
39: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)
40: THEN
41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
43: END IF;

Line 45: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)

41: l_index := l_index + 1;
42: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE10;
43: END IF;
44:
45: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)
46: THEN
47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
49: END IF;

Line 51: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)

47: l_index := l_index + 1;
48: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE11;
49: END IF;
50:
51: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)
52: THEN
53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
55: END IF;

Line 57: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)

53: l_index := l_index + 1;
54: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE12;
55: END IF;
56:
57: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)
58: THEN
59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
61: END IF;

Line 63: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)

59: l_index := l_index + 1;
60: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE13;
61: END IF;
62:
63: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)
64: THEN
65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
67: END IF;

Line 69: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)

65: l_index := l_index + 1;
66: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE14;
67: END IF;
68:
69: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)
70: THEN
71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
73: END IF;

Line 75: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)

71: l_index := l_index + 1;
72: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE15;
73: END IF;
74:
75: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)
76: THEN
77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
79: END IF;

Line 81: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)

77: l_index := l_index + 1;
78: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE2;
79: END IF;
80:
81: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)
82: THEN
83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
85: END IF;

Line 87: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)

83: l_index := l_index + 1;
84: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE3;
85: END IF;
86:
87: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)
88: THEN
89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
91: END IF;

Line 93: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)

89: l_index := l_index + 1;
90: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE4;
91: END IF;
92:
93: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)
94: THEN
95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
97: END IF;

Line 99: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)

95: l_index := l_index + 1;
96: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE5;
97: END IF;
98:
99: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)
100: THEN
101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
103: END IF;

Line 105: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)

101: l_index := l_index + 1;
102: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE6;
103: END IF;
104:
105: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)
106: THEN
107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
109: END IF;

Line 111: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)

107: l_index := l_index + 1;
108: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE7;
109: END IF;
110:
111: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)
112: THEN
113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
115: END IF;

Line 117: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)

113: l_index := l_index + 1;
114: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE8;
115: END IF;
116:
117: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)
118: THEN
119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
121: END IF;

Line 123: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)

119: l_index := l_index + 1;
120: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_ATTRIBUTE9;
121: END IF;
122:
123: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)
124: THEN
125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
127: END IF;

Line 129: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)

125: l_index := l_index + 1;
126: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CONTEXT;
127: END IF;
128:
129: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)
130: THEN
131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
133: END IF;

Line 135: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)

131: l_index := l_index + 1;
132: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATED_BY;
133: END IF;
134:
135: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)
136: THEN
137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
139: END IF;

Line 141: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)

137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_CREATION_DATE;
139: END IF;
140:
141: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
145: END IF;

Line 147: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)

143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_DESCRIPTION;
145: END IF;
146:
147: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)
148: THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
151: END IF;

Line 153: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)

149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_END_DATE_ACTIVE;
151: END IF;
152:
153: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)
154: THEN
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
157: END IF;

Line 159: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)

155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_FORMULA;
157: END IF;
158:
159: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)
160: THEN
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
163: END IF;

Line 165: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)

161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATED_BY;
163: END IF;
164:
165: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)
166: THEN
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
169: END IF;

Line 171: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)

167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_DATE;
169: END IF;
170:
171: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)
172: THEN
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
175: END IF;

Line 177: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)

173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_LAST_UPDATE_LOGIN;
175: END IF;
176:
177: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)
178: THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
181: END IF;

Line 183: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)

179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_NAME;
181: END IF;
182:
183: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)
184: THEN
185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
187: END IF;

Line 189: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)

185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_PRICE_FORMULA;
187: END IF;
188:
189: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)
190: THEN
191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_FORMULA_UTIL.G_START_DATE_ACTIVE;
193: END IF;

Line 297: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)

293: -- Load out NOCOPY record
294:
295: x_FORMULA_rec := p_FORMULA_rec;
296:
297: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,p_old_FORMULA_rec.attribute1)
298: THEN
299: NULL;
300: END IF;
301:

Line 302: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)

298: THEN
299: NULL;
300: END IF;
301:
302: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,p_old_FORMULA_rec.attribute10)
303: THEN
304: NULL;
305: END IF;
306:

Line 307: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)

303: THEN
304: NULL;
305: END IF;
306:
307: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,p_old_FORMULA_rec.attribute11)
308: THEN
309: NULL;
310: END IF;
311:

Line 312: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)

308: THEN
309: NULL;
310: END IF;
311:
312: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,p_old_FORMULA_rec.attribute12)
313: THEN
314: NULL;
315: END IF;
316:

Line 317: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)

313: THEN
314: NULL;
315: END IF;
316:
317: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,p_old_FORMULA_rec.attribute13)
318: THEN
319: NULL;
320: END IF;
321:

Line 322: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)

318: THEN
319: NULL;
320: END IF;
321:
322: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,p_old_FORMULA_rec.attribute14)
323: THEN
324: NULL;
325: END IF;
326:

Line 327: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)

323: THEN
324: NULL;
325: END IF;
326:
327: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,p_old_FORMULA_rec.attribute15)
328: THEN
329: NULL;
330: END IF;
331:

Line 332: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)

328: THEN
329: NULL;
330: END IF;
331:
332: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,p_old_FORMULA_rec.attribute2)
333: THEN
334: NULL;
335: END IF;
336:

Line 337: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)

333: THEN
334: NULL;
335: END IF;
336:
337: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,p_old_FORMULA_rec.attribute3)
338: THEN
339: NULL;
340: END IF;
341:

Line 342: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)

338: THEN
339: NULL;
340: END IF;
341:
342: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,p_old_FORMULA_rec.attribute4)
343: THEN
344: NULL;
345: END IF;
346:

Line 347: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)

343: THEN
344: NULL;
345: END IF;
346:
347: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,p_old_FORMULA_rec.attribute5)
348: THEN
349: NULL;
350: END IF;
351:

Line 352: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)

348: THEN
349: NULL;
350: END IF;
351:
352: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,p_old_FORMULA_rec.attribute6)
353: THEN
354: NULL;
355: END IF;
356:

Line 357: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)

353: THEN
354: NULL;
355: END IF;
356:
357: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,p_old_FORMULA_rec.attribute7)
358: THEN
359: NULL;
360: END IF;
361:

Line 362: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)

358: THEN
359: NULL;
360: END IF;
361:
362: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,p_old_FORMULA_rec.attribute8)
363: THEN
364: NULL;
365: END IF;
366:

Line 367: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)

363: THEN
364: NULL;
365: END IF;
366:
367: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,p_old_FORMULA_rec.attribute9)
368: THEN
369: NULL;
370: END IF;
371:

Line 372: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)

368: THEN
369: NULL;
370: END IF;
371:
372: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.context,p_old_FORMULA_rec.context)
373: THEN
374: NULL;
375: END IF;
376:

Line 377: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)

373: THEN
374: NULL;
375: END IF;
376:
377: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.created_by,p_old_FORMULA_rec.created_by)
378: THEN
379: NULL;
380: END IF;
381:

Line 382: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)

378: THEN
379: NULL;
380: END IF;
381:
382: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,p_old_FORMULA_rec.creation_date)
383: THEN
384: NULL;
385: END IF;
386:

Line 387: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)

383: THEN
384: NULL;
385: END IF;
386:
387: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.description,p_old_FORMULA_rec.description)
388: THEN
389: NULL;
390: END IF;
391:

Line 392: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)

388: THEN
389: NULL;
390: END IF;
391:
392: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,p_old_FORMULA_rec.end_date_active)
393: THEN
394: NULL;
395: END IF;
396:

Line 397: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)

393: THEN
394: NULL;
395: END IF;
396:
397: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.formula,p_old_FORMULA_rec.formula)
398: THEN
399: NULL;
400: END IF;
401:

Line 402: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)

398: THEN
399: NULL;
400: END IF;
401:
402: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,p_old_FORMULA_rec.last_updated_by)
403: THEN
404: NULL;
405: END IF;
406:

Line 407: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)

403: THEN
404: NULL;
405: END IF;
406:
407: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,p_old_FORMULA_rec.last_update_date)
408: THEN
409: NULL;
410: END IF;
411:

Line 412: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)

408: THEN
409: NULL;
410: END IF;
411:
412: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,p_old_FORMULA_rec.last_update_login)
413: THEN
414: NULL;
415: END IF;
416:

Line 417: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)

413: THEN
414: NULL;
415: END IF;
416:
417: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.name,p_old_FORMULA_rec.name)
418: THEN
419: NULL;
420: END IF;
421:

Line 422: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)

418: THEN
419: NULL;
420: END IF;
421:
422: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,p_old_FORMULA_rec.price_formula_id)
423: THEN
424: NULL;
425: END IF;
426:

Line 427: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)

423: THEN
424: NULL;
425: END IF;
426:
427: IF NOT QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,p_old_FORMULA_rec.start_date_active)
428: THEN
429: NULL;
430: END IF;
431:

Line 1049: IF QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,

1045: FOR UPDATE NOWAIT;
1046:
1047: -- Row locked. Compare IN attributes to DB attributes.
1048:
1049: IF QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,
1050: l_FORMULA_rec.attribute1)
1051: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,
1052: l_FORMULA_rec.attribute10)
1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,

Line 1051: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,

1047: -- Row locked. Compare IN attributes to DB attributes.
1048:
1049: IF QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,
1050: l_FORMULA_rec.attribute1)
1051: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,
1052: l_FORMULA_rec.attribute10)
1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,
1054: l_FORMULA_rec.attribute11)
1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,

Line 1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,

1049: IF QP_GLOBALS.Equal(p_FORMULA_rec.attribute1,
1050: l_FORMULA_rec.attribute1)
1051: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,
1052: l_FORMULA_rec.attribute10)
1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,
1054: l_FORMULA_rec.attribute11)
1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,
1056: l_FORMULA_rec.attribute12)
1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,

Line 1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,

1051: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute10,
1052: l_FORMULA_rec.attribute10)
1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,
1054: l_FORMULA_rec.attribute11)
1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,
1056: l_FORMULA_rec.attribute12)
1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,
1058: l_FORMULA_rec.attribute13)
1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,

Line 1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,

1053: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute11,
1054: l_FORMULA_rec.attribute11)
1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,
1056: l_FORMULA_rec.attribute12)
1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,
1058: l_FORMULA_rec.attribute13)
1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,
1060: l_FORMULA_rec.attribute14)
1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,

Line 1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,

1055: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute12,
1056: l_FORMULA_rec.attribute12)
1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,
1058: l_FORMULA_rec.attribute13)
1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,
1060: l_FORMULA_rec.attribute14)
1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,
1062: l_FORMULA_rec.attribute15)
1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,

Line 1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,

1057: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute13,
1058: l_FORMULA_rec.attribute13)
1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,
1060: l_FORMULA_rec.attribute14)
1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,
1062: l_FORMULA_rec.attribute15)
1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,
1064: l_FORMULA_rec.attribute2)
1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,

Line 1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,

1059: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute14,
1060: l_FORMULA_rec.attribute14)
1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,
1062: l_FORMULA_rec.attribute15)
1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,
1064: l_FORMULA_rec.attribute2)
1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,
1066: l_FORMULA_rec.attribute3)
1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,

Line 1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,

1061: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute15,
1062: l_FORMULA_rec.attribute15)
1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,
1064: l_FORMULA_rec.attribute2)
1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,
1066: l_FORMULA_rec.attribute3)
1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,
1068: l_FORMULA_rec.attribute4)
1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,

Line 1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,

1063: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute2,
1064: l_FORMULA_rec.attribute2)
1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,
1066: l_FORMULA_rec.attribute3)
1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,
1068: l_FORMULA_rec.attribute4)
1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,
1070: l_FORMULA_rec.attribute5)
1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,

Line 1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,

1065: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute3,
1066: l_FORMULA_rec.attribute3)
1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,
1068: l_FORMULA_rec.attribute4)
1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,
1070: l_FORMULA_rec.attribute5)
1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,
1072: l_FORMULA_rec.attribute6)
1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,

Line 1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,

1067: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute4,
1068: l_FORMULA_rec.attribute4)
1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,
1070: l_FORMULA_rec.attribute5)
1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,
1072: l_FORMULA_rec.attribute6)
1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,
1074: l_FORMULA_rec.attribute7)
1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,

Line 1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,

1069: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute5,
1070: l_FORMULA_rec.attribute5)
1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,
1072: l_FORMULA_rec.attribute6)
1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,
1074: l_FORMULA_rec.attribute7)
1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,
1076: l_FORMULA_rec.attribute8)
1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,

Line 1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,

1071: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute6,
1072: l_FORMULA_rec.attribute6)
1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,
1074: l_FORMULA_rec.attribute7)
1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,
1076: l_FORMULA_rec.attribute8)
1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,
1078: l_FORMULA_rec.attribute9)
1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,

Line 1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,

1073: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute7,
1074: l_FORMULA_rec.attribute7)
1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,
1076: l_FORMULA_rec.attribute8)
1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,
1078: l_FORMULA_rec.attribute9)
1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,
1080: l_FORMULA_rec.context)
1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,

Line 1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,

1075: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute8,
1076: l_FORMULA_rec.attribute8)
1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,
1078: l_FORMULA_rec.attribute9)
1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,
1080: l_FORMULA_rec.context)
1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,
1082: l_FORMULA_rec.created_by)
1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,

Line 1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,

1077: AND QP_GLOBALS.Equal(p_FORMULA_rec.attribute9,
1078: l_FORMULA_rec.attribute9)
1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,
1080: l_FORMULA_rec.context)
1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,
1082: l_FORMULA_rec.created_by)
1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,
1084: l_FORMULA_rec.creation_date)
1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,

Line 1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,

1079: AND QP_GLOBALS.Equal(p_FORMULA_rec.context,
1080: l_FORMULA_rec.context)
1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,
1082: l_FORMULA_rec.created_by)
1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,
1084: l_FORMULA_rec.creation_date)
1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,
1086: l_FORMULA_rec.end_date_active)
1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,

Line 1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,

1081: AND QP_GLOBALS.Equal(p_FORMULA_rec.created_by,
1082: l_FORMULA_rec.created_by)
1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,
1084: l_FORMULA_rec.creation_date)
1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,
1086: l_FORMULA_rec.end_date_active)
1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,
1088: l_FORMULA_rec.formula)
1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,

Line 1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,

1083: AND QP_GLOBALS.Equal(p_FORMULA_rec.creation_date,
1084: l_FORMULA_rec.creation_date)
1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,
1086: l_FORMULA_rec.end_date_active)
1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,
1088: l_FORMULA_rec.formula)
1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,
1090: l_FORMULA_rec.last_updated_by)
1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,

Line 1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,

1085: AND QP_GLOBALS.Equal(p_FORMULA_rec.end_date_active,
1086: l_FORMULA_rec.end_date_active)
1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,
1088: l_FORMULA_rec.formula)
1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,
1090: l_FORMULA_rec.last_updated_by)
1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,
1092: l_FORMULA_rec.last_update_date)
1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,

Line 1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,

1087: AND QP_GLOBALS.Equal(p_FORMULA_rec.formula,
1088: l_FORMULA_rec.formula)
1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,
1090: l_FORMULA_rec.last_updated_by)
1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,
1092: l_FORMULA_rec.last_update_date)
1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,
1094: l_FORMULA_rec.last_update_login)
1095: AND QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,

Line 1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,

1089: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_updated_by,
1090: l_FORMULA_rec.last_updated_by)
1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,
1092: l_FORMULA_rec.last_update_date)
1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,
1094: l_FORMULA_rec.last_update_login)
1095: AND QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,
1096: l_FORMULA_rec.price_formula_id)
1097: AND QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,

Line 1095: AND QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,

1091: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_date,
1092: l_FORMULA_rec.last_update_date)
1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,
1094: l_FORMULA_rec.last_update_login)
1095: AND QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,
1096: l_FORMULA_rec.price_formula_id)
1097: AND QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,
1098: l_FORMULA_rec.start_date_active)
1099: THEN

Line 1097: AND QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,

1093: AND QP_GLOBALS.Equal(p_FORMULA_rec.last_update_login,
1094: l_FORMULA_rec.last_update_login)
1095: AND QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,
1096: l_FORMULA_rec.price_formula_id)
1097: AND QP_GLOBALS.Equal(p_FORMULA_rec.start_date_active,
1098: l_FORMULA_rec.start_date_active)
1099: THEN
1100:
1101: -- Row has not changed. Set out parameter.

Line 1183: NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,

1179:
1180: oe_debug_pub.add('Entering proc Get_Values in Formula Util Pkg');
1181: IF p_FORMULA_rec.price_formula_id IS NOT NULL AND
1182: p_FORMULA_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1183: NOT QP_GLOBALS.Equal(p_FORMULA_rec.price_formula_id,
1184: p_old_FORMULA_rec.price_formula_id)
1185: THEN
1186: l_FORMULA_val_rec.price_formula := QP_Id_To_Value.Price_Formula
1187: ( p_price_formula_id => p_FORMULA_rec.price_formula_id