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_DEFAULT_FORMULA dependencies on FND_API

Line 81: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN

77: BEGIN
78:
79: -- In the future call Flex APIs for defaults
80:
81: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
82: g_FORMULA_rec.attribute1 := NULL;
83: END IF;
84:
85: IF g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 85: IF g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN

81: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR THEN
82: g_FORMULA_rec.attribute1 := NULL;
83: END IF;
84:
85: IF g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
86: g_FORMULA_rec.attribute10 := NULL;
87: END IF;
88:
89: IF g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 89: IF g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN

85: IF g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR THEN
86: g_FORMULA_rec.attribute10 := NULL;
87: END IF;
88:
89: IF g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
90: g_FORMULA_rec.attribute11 := NULL;
91: END IF;
92:
93: IF g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 93: IF g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN

89: IF g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR THEN
90: g_FORMULA_rec.attribute11 := NULL;
91: END IF;
92:
93: IF g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
94: g_FORMULA_rec.attribute12 := NULL;
95: END IF;
96:
97: IF g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 97: IF g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN

93: IF g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR THEN
94: g_FORMULA_rec.attribute12 := NULL;
95: END IF;
96:
97: IF g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
98: g_FORMULA_rec.attribute13 := NULL;
99: END IF;
100:
101: IF g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 101: IF g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN

97: IF g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR THEN
98: g_FORMULA_rec.attribute13 := NULL;
99: END IF;
100:
101: IF g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
102: g_FORMULA_rec.attribute14 := NULL;
103: END IF;
104:
105: IF g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 105: IF g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN

101: IF g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR THEN
102: g_FORMULA_rec.attribute14 := NULL;
103: END IF;
104:
105: IF g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
106: g_FORMULA_rec.attribute15 := NULL;
107: END IF;
108:
109: IF g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 109: IF g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN

105: IF g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR THEN
106: g_FORMULA_rec.attribute15 := NULL;
107: END IF;
108:
109: IF g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
110: g_FORMULA_rec.attribute2 := NULL;
111: END IF;
112:
113: IF g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 113: IF g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN

109: IF g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR THEN
110: g_FORMULA_rec.attribute2 := NULL;
111: END IF;
112:
113: IF g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
114: g_FORMULA_rec.attribute3 := NULL;
115: END IF;
116:
117: IF g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 117: IF g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN

113: IF g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR THEN
114: g_FORMULA_rec.attribute3 := NULL;
115: END IF;
116:
117: IF g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
118: g_FORMULA_rec.attribute4 := NULL;
119: END IF;
120:
121: IF g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 121: IF g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN

117: IF g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR THEN
118: g_FORMULA_rec.attribute4 := NULL;
119: END IF;
120:
121: IF g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
122: g_FORMULA_rec.attribute5 := NULL;
123: END IF;
124:
125: IF g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 125: IF g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN

121: IF g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR THEN
122: g_FORMULA_rec.attribute5 := NULL;
123: END IF;
124:
125: IF g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
126: g_FORMULA_rec.attribute6 := NULL;
127: END IF;
128:
129: IF g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 129: IF g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN

125: IF g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR THEN
126: g_FORMULA_rec.attribute6 := NULL;
127: END IF;
128:
129: IF g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
130: g_FORMULA_rec.attribute7 := NULL;
131: END IF;
132:
133: IF g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 133: IF g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN

129: IF g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR THEN
130: g_FORMULA_rec.attribute7 := NULL;
131: END IF;
132:
133: IF g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
134: g_FORMULA_rec.attribute8 := NULL;
135: END IF;
136:
137: IF g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 137: IF g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN

133: IF g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR THEN
134: g_FORMULA_rec.attribute8 := NULL;
135: END IF;
136:
137: IF g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
138: g_FORMULA_rec.attribute9 := NULL;
139: END IF;
140:
141: IF g_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

Line 141: IF g_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN

137: IF g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR THEN
138: g_FORMULA_rec.attribute9 := NULL;
139: END IF;
140:
141: IF g_FORMULA_rec.context = FND_API.G_MISS_CHAR THEN
142: g_FORMULA_rec.context := NULL;
143: END IF;
144:
145: END Get_Flex_Formula;

Line 171: RAISE FND_API.G_EXC_ERROR;

167: OE_MSG_PUB.Add;
168:
169: END IF;
170:
171: RAISE FND_API.G_EXC_ERROR;
172:
173: END IF;
174:
175: -- Initialize g_FORMULA_rec

Line 181: IF g_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN

177: g_FORMULA_rec := p_FORMULA_rec;
178:
179: -- Default missing attributes.
180:
181: IF g_FORMULA_rec.description = FND_API.G_MISS_CHAR THEN
182:
183: g_FORMULA_rec.description := Get_Description;
184:
185: IF g_FORMULA_rec.description IS NOT NULL THEN

Line 205: IF g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN

201: END IF;
202:
203: END IF;
204:
205: IF g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE THEN
206:
207: g_FORMULA_rec.end_date_active := Get_End_Date_Active;
208:
209: IF g_FORMULA_rec.end_date_active IS NOT NULL THEN

Line 229: IF g_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN

225: END IF;
226:
227: END IF;
228:
229: IF g_FORMULA_rec.formula = FND_API.G_MISS_CHAR THEN
230:
231: g_FORMULA_rec.formula := Get_Formula;
232:
233: IF g_FORMULA_rec.formula IS NOT NULL THEN

Line 253: IF g_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN

249: END IF;
250:
251: END IF;
252:
253: IF g_FORMULA_rec.name = FND_API.G_MISS_CHAR THEN
254:
255: g_FORMULA_rec.name := Get_Name;
256:
257: IF g_FORMULA_rec.name IS NOT NULL THEN

Line 277: IF g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN

273: END IF;
274:
275: END IF;
276:
277: IF g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM THEN
278:
279: g_FORMULA_rec.price_formula_id := Get_Price_Formula;
280:
281: IF g_FORMULA_rec.price_formula_id IS NOT NULL THEN

Line 301: IF g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN

297: END IF;
298:
299: END IF;
300:
301: IF g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE THEN
302:
303: g_FORMULA_rec.start_date_active := Get_Start_Date_Active;
304:
305: IF g_FORMULA_rec.start_date_active IS NOT NULL THEN

Line 325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR

321: END IF;
322:
323: END IF;
324:
325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR

Line 326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR

322:
323: END IF;
324:
325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR

Line 327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR

323: END IF;
324:
325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR

Line 328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR

324:
325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR

Line 329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR

325: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR

Line 330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR

326: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR

Line 331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR

327: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR

Line 332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR

328: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR

Line 333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR

329: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR

Line 334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR

330: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR

Line 335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR

331: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR

Line 336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR

332: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR

Line 337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR

333: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
341: THEN

Line 338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR

334: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
341: THEN
342:

Line 339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR

335: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
341: THEN
342:
343: Get_Flex_Formula;

Line 340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR

336: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
337: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
338: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
339: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
340: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
341: THEN
342:
343: Get_Flex_Formula;
344:

Line 347: IF g_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN

343: Get_Flex_Formula;
344:
345: END IF;
346:
347: IF g_FORMULA_rec.created_by = FND_API.G_MISS_NUM THEN
348:
349: g_FORMULA_rec.created_by := NULL;
350:
351: END IF;

Line 353: IF g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN

349: g_FORMULA_rec.created_by := NULL;
350:
351: END IF;
352:
353: IF g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE THEN
354:
355: g_FORMULA_rec.creation_date := NULL;
356:
357: END IF;

Line 359: IF g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN

355: g_FORMULA_rec.creation_date := NULL;
356:
357: END IF;
358:
359: IF g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM THEN
360:
361: g_FORMULA_rec.last_updated_by := NULL;
362:
363: END IF;

Line 365: IF g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN

361: g_FORMULA_rec.last_updated_by := NULL;
362:
363: END IF;
364:
365: IF g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE THEN
366:
367: g_FORMULA_rec.last_update_date := NULL;
368:
369: END IF;

Line 371: IF g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN

367: g_FORMULA_rec.last_update_date := NULL;
368:
369: END IF;
370:
371: IF g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM THEN
372:
373: g_FORMULA_rec.last_update_login := NULL;
374:
375: END IF;

Line 379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR

375: END IF;
376:
377: -- Redefault if there are any missing attributes.
378:
379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR

Line 380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR

376:
377: -- Redefault if there are any missing attributes.
378:
379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR

Line 381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR

377: -- Redefault if there are any missing attributes.
378:
379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR

Line 382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR

378:
379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR

Line 383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR

379: IF g_FORMULA_rec.attribute1 = FND_API.G_MISS_CHAR
380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR

Line 384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR

380: OR g_FORMULA_rec.attribute10 = FND_API.G_MISS_CHAR
381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR

Line 385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR

381: OR g_FORMULA_rec.attribute11 = FND_API.G_MISS_CHAR
382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR

Line 386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR

382: OR g_FORMULA_rec.attribute12 = FND_API.G_MISS_CHAR
383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR

Line 387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR

383: OR g_FORMULA_rec.attribute13 = FND_API.G_MISS_CHAR
384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR

Line 388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR

384: OR g_FORMULA_rec.attribute14 = FND_API.G_MISS_CHAR
385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR

Line 389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR

385: OR g_FORMULA_rec.attribute15 = FND_API.G_MISS_CHAR
386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR

Line 390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR

386: OR g_FORMULA_rec.attribute2 = FND_API.G_MISS_CHAR
387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR

Line 391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR

387: OR g_FORMULA_rec.attribute3 = FND_API.G_MISS_CHAR
388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM

Line 392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR

388: OR g_FORMULA_rec.attribute4 = FND_API.G_MISS_CHAR
389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE

Line 393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR

389: OR g_FORMULA_rec.attribute5 = FND_API.G_MISS_CHAR
390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR

Line 394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR

390: OR g_FORMULA_rec.attribute6 = FND_API.G_MISS_CHAR
391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE

Line 395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM

391: OR g_FORMULA_rec.attribute7 = FND_API.G_MISS_CHAR
392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR

Line 396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE

392: OR g_FORMULA_rec.attribute8 = FND_API.G_MISS_CHAR
393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM

Line 397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR

393: OR g_FORMULA_rec.attribute9 = FND_API.G_MISS_CHAR
394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE

Line 398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE

394: OR g_FORMULA_rec.context = FND_API.G_MISS_CHAR
395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM

Line 399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR

395: OR g_FORMULA_rec.created_by = FND_API.G_MISS_NUM
396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR

Line 400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM

396: OR g_FORMULA_rec.creation_date = FND_API.G_MISS_DATE
397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM

Line 401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE

397: OR g_FORMULA_rec.description = FND_API.G_MISS_CHAR
398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE

Line 402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM

398: OR g_FORMULA_rec.end_date_active = FND_API.G_MISS_DATE
399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE
406: THEN

Line 403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR

399: OR g_FORMULA_rec.formula = FND_API.G_MISS_CHAR
400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE
406: THEN
407:

Line 404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM

400: OR g_FORMULA_rec.last_updated_by = FND_API.G_MISS_NUM
401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE
406: THEN
407:
408: QP_Default_Formula.Attributes

Line 405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE

401: OR g_FORMULA_rec.last_update_date = FND_API.G_MISS_DATE
402: OR g_FORMULA_rec.last_update_login = FND_API.G_MISS_NUM
403: OR g_FORMULA_rec.name = FND_API.G_MISS_CHAR
404: OR g_FORMULA_rec.price_formula_id = FND_API.G_MISS_NUM
405: OR g_FORMULA_rec.start_date_active = FND_API.G_MISS_DATE
406: THEN
407:
408: QP_Default_Formula.Attributes
409: ( p_FORMULA_rec => g_FORMULA_rec