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_LINES_UTIL dependencies on QP_GLOBALS

Line 19: l_src_attr_tbl QP_GLOBALS.NUMBER_Tbl_Type;

15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_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 FormulaLines 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 FormulaLines Util Pkg');
24: -- Load out record

Line 33: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,p_old_FORMULA_LINES_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_LINES_rec.attribute1,p_old_FORMULA_LINES_rec.attribute1)
34: THEN
35: l_index := l_index + 1;
36: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_ATTRIBUTE1;
37: END IF;

Line 39: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,p_old_FORMULA_LINES_rec.attribute10)

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

Line 45: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,p_old_FORMULA_LINES_rec.attribute11)

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

Line 51: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,p_old_FORMULA_LINES_rec.attribute12)

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

Line 57: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,p_old_FORMULA_LINES_rec.attribute13)

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

Line 63: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,p_old_FORMULA_LINES_rec.attribute14)

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

Line 69: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,p_old_FORMULA_LINES_rec.attribute15)

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

Line 75: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,p_old_FORMULA_LINES_rec.attribute2)

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

Line 81: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,p_old_FORMULA_LINES_rec.attribute3)

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

Line 87: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,p_old_FORMULA_LINES_rec.attribute4)

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

Line 93: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,p_old_FORMULA_LINES_rec.attribute5)

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

Line 99: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,p_old_FORMULA_LINES_rec.attribute6)

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

Line 105: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,p_old_FORMULA_LINES_rec.attribute7)

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

Line 111: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,p_old_FORMULA_LINES_rec.attribute8)

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

Line 117: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,p_old_FORMULA_LINES_rec.attribute9)

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

Line 123: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,p_old_FORMULA_LINES_rec.context)

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

Line 129: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,p_old_FORMULA_LINES_rec.created_by)

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

Line 135: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,p_old_FORMULA_LINES_rec.creation_date)

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

Line 141: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,p_old_FORMULA_LINES_rec.end_date_active)

137: l_index := l_index + 1;
138: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_CREATION_DATE;
139: END IF;
140:
141: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,p_old_FORMULA_LINES_rec.end_date_active)
142: THEN
143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_END_DATE_ACTIVE;
145: END IF;

Line 147: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)

143: l_index := l_index + 1;
144: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_END_DATE_ACTIVE;
145: END IF;
146:
147: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)
148: THEN
149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATED_BY;
151: END IF;

Line 153: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)

149: l_index := l_index + 1;
150: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATED_BY;
151: END IF;
152:
153: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)
154: THEN
155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_DATE;
157: END IF;

Line 159: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)

155: l_index := l_index + 1;
156: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_DATE;
157: END IF;
158:
159: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)
160: THEN
161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_LOGIN;
163: END IF;

Line 165: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,p_old_FORMULA_LINES_rec.numeric_constant)

161: l_index := l_index + 1;
162: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_LAST_UPDATE_LOGIN;
163: END IF;
164:
165: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,p_old_FORMULA_LINES_rec.numeric_constant)
166: THEN
167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_NUMERIC_CONSTANT;
169: END IF;

Line 171: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,p_old_FORMULA_LINES_rec.price_formula_id)

167: l_index := l_index + 1;
168: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_NUMERIC_CONSTANT;
169: END IF;
170:
171: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,p_old_FORMULA_LINES_rec.price_formula_id)
172: THEN
173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA;
175: END IF;

Line 177: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,p_old_FORMULA_LINES_rec.price_formula_line_id)

173: l_index := l_index + 1;
174: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA;
175: END IF;
176:
177: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,p_old_FORMULA_LINES_rec.price_formula_line_id)
178: THEN
179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA_LINE;
181: END IF;

Line 183: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,p_old_FORMULA_LINES_rec.formula_line_type_code)

179: l_index := l_index + 1;
180: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA_LINE;
181: END IF;
182:
183: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,p_old_FORMULA_LINES_rec.formula_line_type_code)
184: THEN
185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA_LINE_TYPE;
187: END IF;

Line 189: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,p_old_FORMULA_LINES_rec.price_list_line_id)

185: l_index := l_index + 1;
186: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_FORMULA_LINE_TYPE;
187: END IF;
188:
189: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,p_old_FORMULA_LINES_rec.price_list_line_id)
190: THEN
191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_LIST_LINE;
193: END IF;

Line 195: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,p_old_FORMULA_LINES_rec.price_modifier_list_id)

191: l_index := l_index + 1;
192: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_LIST_LINE;
193: END IF;
194:
195: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,p_old_FORMULA_LINES_rec.price_modifier_list_id)
196: THEN
197: l_index := l_index + 1;
198: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_MODIFIER_LIST;
199: END IF;

Line 201: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,p_old_FORMULA_LINES_rec.pricing_attribute)

197: l_index := l_index + 1;
198: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICE_MODIFIER_LIST;
199: END IF;
200:
201: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,p_old_FORMULA_LINES_rec.pricing_attribute)
202: THEN
203: l_index := l_index + 1;
204: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICING_ATTRIBUTE;
205: END IF;

Line 207: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,p_old_FORMULA_LINES_rec.pricing_attribute_context)

203: l_index := l_index + 1;
204: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICING_ATTRIBUTE;
205: END IF;
206:
207: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,p_old_FORMULA_LINES_rec.pricing_attribute_context)
208: THEN
209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
211: END IF;

Line 213: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,p_old_FORMULA_LINES_rec.start_date_active)

209: l_index := l_index + 1;
210: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_PRICING_ATTRIBUTE_CONTEXT;
211: END IF;
212:
213: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,p_old_FORMULA_LINES_rec.start_date_active)
214: THEN
215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_START_DATE_ACTIVE;
217: END IF;

Line 219: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,p_old_FORMULA_LINES_rec.step_number)

215: l_index := l_index + 1;
216: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_START_DATE_ACTIVE;
217: END IF;
218:
219: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,p_old_FORMULA_LINES_rec.step_number)
220: THEN
221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_STEP_NUMBER;
223: END IF;

Line 225: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,p_old_FORMULA_LINES_rec.reqd_flag)

221: l_index := l_index + 1;
222: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_STEP_NUMBER;
223: END IF;
224:
225: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,p_old_FORMULA_LINES_rec.reqd_flag)
226: THEN
227: l_index := l_index + 1;
228: l_src_attr_tbl(l_index) := QP_FORMULA_LINES_UTIL.G_REQD_FLAG;
229: END IF;

Line 351: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,p_old_FORMULA_LINES_rec.attribute1)

347: -- Load out record
348:
349: x_FORMULA_LINES_rec := p_FORMULA_LINES_rec;
350:
351: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,p_old_FORMULA_LINES_rec.attribute1)
352: THEN
353: NULL;
354: END IF;
355:

Line 356: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,p_old_FORMULA_LINES_rec.attribute10)

352: THEN
353: NULL;
354: END IF;
355:
356: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,p_old_FORMULA_LINES_rec.attribute10)
357: THEN
358: NULL;
359: END IF;
360:

Line 361: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,p_old_FORMULA_LINES_rec.attribute11)

357: THEN
358: NULL;
359: END IF;
360:
361: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,p_old_FORMULA_LINES_rec.attribute11)
362: THEN
363: NULL;
364: END IF;
365:

Line 366: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,p_old_FORMULA_LINES_rec.attribute12)

362: THEN
363: NULL;
364: END IF;
365:
366: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,p_old_FORMULA_LINES_rec.attribute12)
367: THEN
368: NULL;
369: END IF;
370:

Line 371: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,p_old_FORMULA_LINES_rec.attribute13)

367: THEN
368: NULL;
369: END IF;
370:
371: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,p_old_FORMULA_LINES_rec.attribute13)
372: THEN
373: NULL;
374: END IF;
375:

Line 376: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,p_old_FORMULA_LINES_rec.attribute14)

372: THEN
373: NULL;
374: END IF;
375:
376: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,p_old_FORMULA_LINES_rec.attribute14)
377: THEN
378: NULL;
379: END IF;
380:

Line 381: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,p_old_FORMULA_LINES_rec.attribute15)

377: THEN
378: NULL;
379: END IF;
380:
381: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,p_old_FORMULA_LINES_rec.attribute15)
382: THEN
383: NULL;
384: END IF;
385:

Line 386: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,p_old_FORMULA_LINES_rec.attribute2)

382: THEN
383: NULL;
384: END IF;
385:
386: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,p_old_FORMULA_LINES_rec.attribute2)
387: THEN
388: NULL;
389: END IF;
390:

Line 391: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,p_old_FORMULA_LINES_rec.attribute3)

387: THEN
388: NULL;
389: END IF;
390:
391: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,p_old_FORMULA_LINES_rec.attribute3)
392: THEN
393: NULL;
394: END IF;
395:

Line 396: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,p_old_FORMULA_LINES_rec.attribute4)

392: THEN
393: NULL;
394: END IF;
395:
396: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,p_old_FORMULA_LINES_rec.attribute4)
397: THEN
398: NULL;
399: END IF;
400:

Line 401: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,p_old_FORMULA_LINES_rec.attribute5)

397: THEN
398: NULL;
399: END IF;
400:
401: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,p_old_FORMULA_LINES_rec.attribute5)
402: THEN
403: NULL;
404: END IF;
405:

Line 406: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,p_old_FORMULA_LINES_rec.attribute6)

402: THEN
403: NULL;
404: END IF;
405:
406: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,p_old_FORMULA_LINES_rec.attribute6)
407: THEN
408: NULL;
409: END IF;
410:

Line 411: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,p_old_FORMULA_LINES_rec.attribute7)

407: THEN
408: NULL;
409: END IF;
410:
411: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,p_old_FORMULA_LINES_rec.attribute7)
412: THEN
413: NULL;
414: END IF;
415:

Line 416: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,p_old_FORMULA_LINES_rec.attribute8)

412: THEN
413: NULL;
414: END IF;
415:
416: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,p_old_FORMULA_LINES_rec.attribute8)
417: THEN
418: NULL;
419: END IF;
420:

Line 421: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,p_old_FORMULA_LINES_rec.attribute9)

417: THEN
418: NULL;
419: END IF;
420:
421: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,p_old_FORMULA_LINES_rec.attribute9)
422: THEN
423: NULL;
424: END IF;
425:

Line 426: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,p_old_FORMULA_LINES_rec.context)

422: THEN
423: NULL;
424: END IF;
425:
426: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,p_old_FORMULA_LINES_rec.context)
427: THEN
428: NULL;
429: END IF;
430:

Line 431: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,p_old_FORMULA_LINES_rec.created_by)

427: THEN
428: NULL;
429: END IF;
430:
431: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,p_old_FORMULA_LINES_rec.created_by)
432: THEN
433: NULL;
434: END IF;
435:

Line 436: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,p_old_FORMULA_LINES_rec.creation_date)

432: THEN
433: NULL;
434: END IF;
435:
436: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,p_old_FORMULA_LINES_rec.creation_date)
437: THEN
438: NULL;
439: END IF;
440:

Line 441: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,p_old_FORMULA_LINES_rec.end_date_active)

437: THEN
438: NULL;
439: END IF;
440:
441: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,p_old_FORMULA_LINES_rec.end_date_active)
442: THEN
443: NULL;
444: END IF;
445:

Line 446: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)

442: THEN
443: NULL;
444: END IF;
445:
446: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,p_old_FORMULA_LINES_rec.last_updated_by)
447: THEN
448: NULL;
449: END IF;
450:

Line 451: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)

447: THEN
448: NULL;
449: END IF;
450:
451: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,p_old_FORMULA_LINES_rec.last_update_date)
452: THEN
453: NULL;
454: END IF;
455:

Line 456: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)

452: THEN
453: NULL;
454: END IF;
455:
456: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,p_old_FORMULA_LINES_rec.last_update_login)
457: THEN
458: NULL;
459: END IF;
460:

Line 461: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,p_old_FORMULA_LINES_rec.numeric_constant)

457: THEN
458: NULL;
459: END IF;
460:
461: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,p_old_FORMULA_LINES_rec.numeric_constant)
462: THEN
463: NULL;
464: END IF;
465:

Line 466: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,p_old_FORMULA_LINES_rec.price_formula_id)

462: THEN
463: NULL;
464: END IF;
465:
466: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,p_old_FORMULA_LINES_rec.price_formula_id)
467: THEN
468: NULL;
469: END IF;
470:

Line 471: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,p_old_FORMULA_LINES_rec.price_formula_line_id)

467: THEN
468: NULL;
469: END IF;
470:
471: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,p_old_FORMULA_LINES_rec.price_formula_line_id)
472: THEN
473: NULL;
474: END IF;
475:

Line 476: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,p_old_FORMULA_LINES_rec.formula_line_type_code)

472: THEN
473: NULL;
474: END IF;
475:
476: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,p_old_FORMULA_LINES_rec.formula_line_type_code)
477: THEN
478: NULL;
479: END IF;
480:

Line 481: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,p_old_FORMULA_LINES_rec.price_list_line_id)

477: THEN
478: NULL;
479: END IF;
480:
481: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,p_old_FORMULA_LINES_rec.price_list_line_id)
482: THEN
483: NULL;
484: END IF;
485:

Line 486: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,p_old_FORMULA_LINES_rec.price_modifier_list_id)

482: THEN
483: NULL;
484: END IF;
485:
486: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,p_old_FORMULA_LINES_rec.price_modifier_list_id)
487: THEN
488: NULL;
489: END IF;
490:

Line 491: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,p_old_FORMULA_LINES_rec.pricing_attribute)

487: THEN
488: NULL;
489: END IF;
490:
491: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,p_old_FORMULA_LINES_rec.pricing_attribute)
492: THEN
493: NULL;
494: END IF;
495:

Line 496: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,p_old_FORMULA_LINES_rec.pricing_attribute_context)

492: THEN
493: NULL;
494: END IF;
495:
496: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,p_old_FORMULA_LINES_rec.pricing_attribute_context)
497: THEN
498: NULL;
499: END IF;
500:

Line 501: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,p_old_FORMULA_LINES_rec.start_date_active)

497: THEN
498: NULL;
499: END IF;
500:
501: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,p_old_FORMULA_LINES_rec.start_date_active)
502: THEN
503: NULL;
504: END IF;
505:

Line 506: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,p_old_FORMULA_LINES_rec.step_number)

502: THEN
503: NULL;
504: END IF;
505:
506: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,p_old_FORMULA_LINES_rec.step_number)
507: THEN
508: NULL;
509: END IF;
510:

Line 511: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,p_old_FORMULA_LINES_rec.reqd_flag)

507: THEN
508: NULL;
509: END IF;
510:
511: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,p_old_FORMULA_LINES_rec.reqd_flag)
512: THEN
513: NULL;
514: END IF;
515:

Line 1292: IF QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,

1288: FOR UPDATE NOWAIT;
1289:
1290: -- Row locked. Compare IN attributes to DB attributes.
1291:
1292: IF QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,
1293: l_FORMULA_LINES_rec.attribute1)
1294: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,
1295: l_FORMULA_LINES_rec.attribute10)
1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,

Line 1294: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,

1290: -- Row locked. Compare IN attributes to DB attributes.
1291:
1292: IF QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,
1293: l_FORMULA_LINES_rec.attribute1)
1294: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,
1295: l_FORMULA_LINES_rec.attribute10)
1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,
1297: l_FORMULA_LINES_rec.attribute11)
1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,

Line 1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,

1292: IF QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,
1293: l_FORMULA_LINES_rec.attribute1)
1294: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,
1295: l_FORMULA_LINES_rec.attribute10)
1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,
1297: l_FORMULA_LINES_rec.attribute11)
1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,
1299: l_FORMULA_LINES_rec.attribute12)
1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,

Line 1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,

1294: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute10,
1295: l_FORMULA_LINES_rec.attribute10)
1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,
1297: l_FORMULA_LINES_rec.attribute11)
1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,
1299: l_FORMULA_LINES_rec.attribute12)
1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,
1301: l_FORMULA_LINES_rec.attribute13)
1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,

Line 1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,

1296: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute11,
1297: l_FORMULA_LINES_rec.attribute11)
1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,
1299: l_FORMULA_LINES_rec.attribute12)
1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,
1301: l_FORMULA_LINES_rec.attribute13)
1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,
1303: l_FORMULA_LINES_rec.attribute14)
1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,

Line 1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,

1298: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute12,
1299: l_FORMULA_LINES_rec.attribute12)
1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,
1301: l_FORMULA_LINES_rec.attribute13)
1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,
1303: l_FORMULA_LINES_rec.attribute14)
1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,
1305: l_FORMULA_LINES_rec.attribute15)
1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,

Line 1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,

1300: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute13,
1301: l_FORMULA_LINES_rec.attribute13)
1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,
1303: l_FORMULA_LINES_rec.attribute14)
1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,
1305: l_FORMULA_LINES_rec.attribute15)
1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,
1307: l_FORMULA_LINES_rec.attribute2)
1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,

Line 1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,

1302: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute14,
1303: l_FORMULA_LINES_rec.attribute14)
1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,
1305: l_FORMULA_LINES_rec.attribute15)
1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,
1307: l_FORMULA_LINES_rec.attribute2)
1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,
1309: l_FORMULA_LINES_rec.attribute3)
1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,

Line 1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,

1304: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute15,
1305: l_FORMULA_LINES_rec.attribute15)
1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,
1307: l_FORMULA_LINES_rec.attribute2)
1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,
1309: l_FORMULA_LINES_rec.attribute3)
1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,
1311: l_FORMULA_LINES_rec.attribute4)
1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,

Line 1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,

1306: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute2,
1307: l_FORMULA_LINES_rec.attribute2)
1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,
1309: l_FORMULA_LINES_rec.attribute3)
1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,
1311: l_FORMULA_LINES_rec.attribute4)
1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,
1313: l_FORMULA_LINES_rec.attribute5)
1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,

Line 1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,

1308: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute3,
1309: l_FORMULA_LINES_rec.attribute3)
1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,
1311: l_FORMULA_LINES_rec.attribute4)
1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,
1313: l_FORMULA_LINES_rec.attribute5)
1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,
1315: l_FORMULA_LINES_rec.attribute6)
1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,

Line 1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,

1310: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute4,
1311: l_FORMULA_LINES_rec.attribute4)
1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,
1313: l_FORMULA_LINES_rec.attribute5)
1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,
1315: l_FORMULA_LINES_rec.attribute6)
1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,
1317: l_FORMULA_LINES_rec.attribute7)
1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,

Line 1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,

1312: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute5,
1313: l_FORMULA_LINES_rec.attribute5)
1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,
1315: l_FORMULA_LINES_rec.attribute6)
1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,
1317: l_FORMULA_LINES_rec.attribute7)
1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,
1319: l_FORMULA_LINES_rec.attribute8)
1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,

Line 1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,

1314: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute6,
1315: l_FORMULA_LINES_rec.attribute6)
1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,
1317: l_FORMULA_LINES_rec.attribute7)
1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,
1319: l_FORMULA_LINES_rec.attribute8)
1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,
1321: l_FORMULA_LINES_rec.attribute9)
1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,

Line 1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,

1316: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute7,
1317: l_FORMULA_LINES_rec.attribute7)
1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,
1319: l_FORMULA_LINES_rec.attribute8)
1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,
1321: l_FORMULA_LINES_rec.attribute9)
1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,
1323: l_FORMULA_LINES_rec.context)
1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,

Line 1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,

1318: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute8,
1319: l_FORMULA_LINES_rec.attribute8)
1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,
1321: l_FORMULA_LINES_rec.attribute9)
1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,
1323: l_FORMULA_LINES_rec.context)
1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,
1325: l_FORMULA_LINES_rec.created_by)
1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,

Line 1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,

1320: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute9,
1321: l_FORMULA_LINES_rec.attribute9)
1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,
1323: l_FORMULA_LINES_rec.context)
1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,
1325: l_FORMULA_LINES_rec.created_by)
1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,
1327: l_FORMULA_LINES_rec.creation_date)
1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,

Line 1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,

1322: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.context,
1323: l_FORMULA_LINES_rec.context)
1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,
1325: l_FORMULA_LINES_rec.created_by)
1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,
1327: l_FORMULA_LINES_rec.creation_date)
1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,
1329: l_FORMULA_LINES_rec.end_date_active)
1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,

Line 1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,

1324: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.created_by,
1325: l_FORMULA_LINES_rec.created_by)
1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,
1327: l_FORMULA_LINES_rec.creation_date)
1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,
1329: l_FORMULA_LINES_rec.end_date_active)
1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,
1331: l_FORMULA_LINES_rec.last_updated_by)
1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,

Line 1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,

1326: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.creation_date,
1327: l_FORMULA_LINES_rec.creation_date)
1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,
1329: l_FORMULA_LINES_rec.end_date_active)
1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,
1331: l_FORMULA_LINES_rec.last_updated_by)
1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,
1333: l_FORMULA_LINES_rec.last_update_date)
1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,

Line 1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,

1328: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.end_date_active,
1329: l_FORMULA_LINES_rec.end_date_active)
1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,
1331: l_FORMULA_LINES_rec.last_updated_by)
1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,
1333: l_FORMULA_LINES_rec.last_update_date)
1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,
1335: l_FORMULA_LINES_rec.last_update_login)
1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,

Line 1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,

1330: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_updated_by,
1331: l_FORMULA_LINES_rec.last_updated_by)
1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,
1333: l_FORMULA_LINES_rec.last_update_date)
1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,
1335: l_FORMULA_LINES_rec.last_update_login)
1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,
1337: l_FORMULA_LINES_rec.numeric_constant)
1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,

Line 1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,

1332: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_date,
1333: l_FORMULA_LINES_rec.last_update_date)
1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,
1335: l_FORMULA_LINES_rec.last_update_login)
1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,
1337: l_FORMULA_LINES_rec.numeric_constant)
1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1339: l_FORMULA_LINES_rec.price_formula_id)
1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,

Line 1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,

1334: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.last_update_login,
1335: l_FORMULA_LINES_rec.last_update_login)
1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,
1337: l_FORMULA_LINES_rec.numeric_constant)
1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1339: l_FORMULA_LINES_rec.price_formula_id)
1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1341: l_FORMULA_LINES_rec.price_formula_line_id)
1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,

Line 1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,

1336: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.numeric_constant,
1337: l_FORMULA_LINES_rec.numeric_constant)
1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1339: l_FORMULA_LINES_rec.price_formula_id)
1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1341: l_FORMULA_LINES_rec.price_formula_line_id)
1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1343: l_FORMULA_LINES_rec.formula_line_type_code)
1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,

Line 1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,

1338: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1339: l_FORMULA_LINES_rec.price_formula_id)
1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1341: l_FORMULA_LINES_rec.price_formula_line_id)
1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1343: l_FORMULA_LINES_rec.formula_line_type_code)
1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1345: l_FORMULA_LINES_rec.price_list_line_id)
1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,

Line 1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,

1340: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1341: l_FORMULA_LINES_rec.price_formula_line_id)
1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1343: l_FORMULA_LINES_rec.formula_line_type_code)
1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1345: l_FORMULA_LINES_rec.price_list_line_id)
1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1347: l_FORMULA_LINES_rec.price_modifier_list_id)
1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,

Line 1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,

1342: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1343: l_FORMULA_LINES_rec.formula_line_type_code)
1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1345: l_FORMULA_LINES_rec.price_list_line_id)
1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1347: l_FORMULA_LINES_rec.price_modifier_list_id)
1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,
1349: l_FORMULA_LINES_rec.pricing_attribute)
1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,

Line 1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,

1344: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1345: l_FORMULA_LINES_rec.price_list_line_id)
1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1347: l_FORMULA_LINES_rec.price_modifier_list_id)
1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,
1349: l_FORMULA_LINES_rec.pricing_attribute)
1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,
1351: l_FORMULA_LINES_rec.pricing_attribute_context)
1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,

Line 1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,

1346: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1347: l_FORMULA_LINES_rec.price_modifier_list_id)
1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,
1349: l_FORMULA_LINES_rec.pricing_attribute)
1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,
1351: l_FORMULA_LINES_rec.pricing_attribute_context)
1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,
1353: l_FORMULA_LINES_rec.start_date_active)
1354: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,

Line 1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,

1348: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute,
1349: l_FORMULA_LINES_rec.pricing_attribute)
1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,
1351: l_FORMULA_LINES_rec.pricing_attribute_context)
1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,
1353: l_FORMULA_LINES_rec.start_date_active)
1354: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,
1355: l_FORMULA_LINES_rec.step_number)
1356: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,

Line 1354: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,

1350: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.pricing_attribute_context,
1351: l_FORMULA_LINES_rec.pricing_attribute_context)
1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,
1353: l_FORMULA_LINES_rec.start_date_active)
1354: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,
1355: l_FORMULA_LINES_rec.step_number)
1356: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,
1357: l_FORMULA_LINES_rec.reqd_flag)
1358: THEN

Line 1356: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,

1352: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.start_date_active,
1353: l_FORMULA_LINES_rec.start_date_active)
1354: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.step_number,
1355: l_FORMULA_LINES_rec.step_number)
1356: AND QP_GLOBALS.Equal(p_FORMULA_LINES_rec.reqd_flag,
1357: l_FORMULA_LINES_rec.reqd_flag)
1358: THEN
1359:
1360: -- Row has not changed. Set out parameter.

Line 1442: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,

1438:
1439: oe_debug_pub.add('Entering proc Get_Values in FormulaLines Util Pkg');
1440: IF p_FORMULA_LINES_rec.price_formula_id IS NOT NULL AND
1441: p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1442: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1443: p_old_FORMULA_LINES_rec.price_formula_id)
1444: THEN
1445: l_FORMULA_LINES_val_rec.price_formula := QP_Id_To_Value.Price_Formula
1446: ( p_price_formula_id => p_FORMULA_LINES_rec.price_formula_id

Line 1452: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,

1448: END IF;
1449:
1450: IF p_FORMULA_LINES_rec.price_formula_line_id IS NOT NULL AND
1451: p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM AND
1452: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1453: p_old_FORMULA_LINES_rec.price_formula_line_id)
1454: THEN
1455: l_FORMULA_LINES_val_rec.price_formula_line := QP_Id_To_Value.Price_Formula_Line
1456: ( p_price_formula_line_id => p_FORMULA_LINES_rec.price_formula_line_id

Line 1462: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,

1458: END IF;
1459:
1460: IF p_FORMULA_LINES_rec.formula_line_type_code IS NOT NULL AND
1461: p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR AND
1462: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1463: p_old_FORMULA_LINES_rec.formula_line_type_code)
1464: THEN
1465: l_FORMULA_LINES_val_rec.price_formula_line_type := QP_Id_To_Value.Price_Formula_Line_Type
1466: ( p_formula_line_type_code => p_FORMULA_LINES_rec.formula_line_type_code

Line 1472: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,

1468: END IF;
1469:
1470: IF p_FORMULA_LINES_rec.price_list_line_id IS NOT NULL AND
1471: p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM AND
1472: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1473: p_old_FORMULA_LINES_rec.price_list_line_id)
1474: THEN
1475: l_FORMULA_LINES_val_rec.price_list_line := QP_Id_To_Value.Price_List_Line
1476: ( p_price_list_line_id => p_FORMULA_LINES_rec.price_list_line_id

Line 1482: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,

1478: END IF;
1479:
1480: IF p_FORMULA_LINES_rec.price_modifier_list_id IS NOT NULL AND
1481: p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM AND
1482: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1483: p_old_FORMULA_LINES_rec.price_modifier_list_id)
1484: THEN
1485: l_FORMULA_LINES_val_rec.price_modifier_list := QP_Id_To_Value.Price_Modifier_List
1486: ( p_price_modifier_list_id => p_FORMULA_LINES_rec.price_modifier_list_id