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.OE_DEFAULT_PRICE_LIST dependencies on FND_API

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: 'Get_Price_List'
91: );
92: END IF;
93:
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95:
96: END Get_Price_List;
97:
98: FUNCTION Get_Rounding_Factor

Line 149: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN

145: BEGIN
146:
147: -- In the future call Flex APIs for defaults
148:
149: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
150: g_PRICE_LIST_rec.attribute1 := NULL;
151: END IF;
152:
153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN

149: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
150: g_PRICE_LIST_rec.attribute1 := NULL;
151: END IF;
152:
153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
154: g_PRICE_LIST_rec.attribute10 := NULL;
155: END IF;
156:
157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN

153: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
154: g_PRICE_LIST_rec.attribute10 := NULL;
155: END IF;
156:
157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
158: g_PRICE_LIST_rec.attribute11 := NULL;
159: END IF;
160:
161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN

157: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
158: g_PRICE_LIST_rec.attribute11 := NULL;
159: END IF;
160:
161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
162: g_PRICE_LIST_rec.attribute12 := NULL;
163: END IF;
164:
165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN

161: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
162: g_PRICE_LIST_rec.attribute12 := NULL;
163: END IF;
164:
165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
166: g_PRICE_LIST_rec.attribute13 := NULL;
167: END IF;
168:
169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN

165: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
166: g_PRICE_LIST_rec.attribute13 := NULL;
167: END IF;
168:
169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
170: g_PRICE_LIST_rec.attribute14 := NULL;
171: END IF;
172:
173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN

169: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
170: g_PRICE_LIST_rec.attribute14 := NULL;
171: END IF;
172:
173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
174: g_PRICE_LIST_rec.attribute15 := NULL;
175: END IF;
176:
177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN

173: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
174: g_PRICE_LIST_rec.attribute15 := NULL;
175: END IF;
176:
177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_PRICE_LIST_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN

177: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
178: g_PRICE_LIST_rec.attribute2 := NULL;
179: END IF;
180:
181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_PRICE_LIST_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN

181: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
182: g_PRICE_LIST_rec.attribute3 := NULL;
183: END IF;
184:
185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_PRICE_LIST_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN

185: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
186: g_PRICE_LIST_rec.attribute4 := NULL;
187: END IF;
188:
189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_PRICE_LIST_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN

189: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
190: g_PRICE_LIST_rec.attribute5 := NULL;
191: END IF;
192:
193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
194: g_PRICE_LIST_rec.attribute6 := NULL;
195: END IF;
196:
197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN

193: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
194: g_PRICE_LIST_rec.attribute6 := NULL;
195: END IF;
196:
197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
198: g_PRICE_LIST_rec.attribute7 := NULL;
199: END IF;
200:
201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN

197: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
198: g_PRICE_LIST_rec.attribute7 := NULL;
199: END IF;
200:
201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
202: g_PRICE_LIST_rec.attribute8 := NULL;
203: END IF;
204:
205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN

201: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
202: g_PRICE_LIST_rec.attribute8 := NULL;
203: END IF;
204:
205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
206: g_PRICE_LIST_rec.attribute9 := NULL;
207: END IF;
208:
209: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

Line 209: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN

205: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
206: g_PRICE_LIST_rec.attribute9 := NULL;
207: END IF;
208:
209: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
210: g_PRICE_LIST_rec.context := NULL;
211: END IF;
212:
213: END Get_Flex_So_Price_Lists;

Line 238: RAISE FND_API.G_EXC_ERROR;

234: OE_MSG_PUB.Add;
235:
236: END IF;
237:
238: RAISE FND_API.G_EXC_ERROR;
239:
240: END IF;
241:
242: -- Initialize g_PRICE_LIST_rec

Line 248: IF g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN

244: g_PRICE_LIST_rec := p_PRICE_LIST_rec;
245:
246: -- Default missing attributes.
247:
248: IF g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
249:
250: g_PRICE_LIST_rec.comments := Get_Comments;
251:
252: IF g_PRICE_LIST_rec.comments IS NOT NULL THEN

Line 269: IF g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN

265: END IF;
266:
267: END IF;
268:
269: IF g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
270:
271: g_PRICE_LIST_rec.currency_code := Get_Currency;
272:
273: IF g_PRICE_LIST_rec.currency_code IS NOT NULL THEN

Line 290: IF g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN

286: END IF;
287:
288: END IF;
289:
290: IF g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
291:
292: g_PRICE_LIST_rec.description := Get_Description;
293:
294: IF g_PRICE_LIST_rec.description IS NOT NULL THEN

Line 311: IF g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN

307: END IF;
308:
309: END IF;
310:
311: IF g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
312:
313: g_PRICE_LIST_rec.end_date_active := Get_End_Date_Active;
314:
315: IF g_PRICE_LIST_rec.end_date_active IS NOT NULL THEN

Line 332: IF g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

328: END IF;
329:
330: END IF;
331:
332: IF g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
333:
334: g_PRICE_LIST_rec.freight_terms_code := Get_Freight_Terms;
335:
336: IF g_PRICE_LIST_rec.freight_terms_code IS NOT NULL THEN

Line 353: IF g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN

349: END IF;
350:
351: END IF;
352:
353: IF g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
354:
355: g_PRICE_LIST_rec.name := Get_Name;
356:
357: IF g_PRICE_LIST_rec.name IS NOT NULL THEN

Line 374: IF g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN

370: END IF;
371:
372: END IF;
373:
374: IF g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM THEN
375:
376: g_PRICE_LIST_rec.price_list_id := Get_Price_List;
377:
378: IF g_PRICE_LIST_rec.price_list_id IS NOT NULL THEN

Line 395: IF g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN

391: END IF;
392:
393: END IF;
394:
395: IF g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
396:
397: g_PRICE_LIST_rec.rounding_factor := Get_Rounding_Factor;
398:
399: IF g_PRICE_LIST_rec.rounding_factor IS NOT NULL THEN

Line 416: IF g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN

412: END IF;
413:
414: END IF;
415:
416: IF g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM THEN
417:
418: g_PRICE_LIST_rec.secondary_price_list_id := Get_Secondary_Price_List;
419:
420: IF g_PRICE_LIST_rec.secondary_price_list_id IS NOT NULL THEN

Line 437: IF g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN

433: END IF;
434:
435: END IF;
436:
437: IF g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
438:
439: g_PRICE_LIST_rec.ship_method_code := Get_Ship_Method;
440:
441: IF g_PRICE_LIST_rec.ship_method_code IS NOT NULL THEN

Line 458: IF g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN

454: END IF;
455:
456: END IF;
457:
458: IF g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
459:
460: g_PRICE_LIST_rec.start_date_active := Get_Start_Date_Active;
461:
462: IF g_PRICE_LIST_rec.start_date_active IS NOT NULL THEN

Line 479: IF g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN

475: END IF;
476:
477: END IF;
478:
479: IF g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
480:
481: g_PRICE_LIST_rec.terms_id := Get_Terms;
482:
483: IF g_PRICE_LIST_rec.terms_id IS NOT NULL THEN

Line 500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR

496: END IF;
497:
498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR

Line 501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR

497:
498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR

Line 502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR

498: END IF;
499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR

Line 503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR

499:
500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR

Line 504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR

500: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR

Line 505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR

501: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR

Line 506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR

502: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR

Line 507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR

503: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR

Line 508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR

504: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR

Line 509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR

505: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR

Line 510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR

506: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR

Line 511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR

507: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR

Line 512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR

508: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN

Line 513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR

509: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:

Line 514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR

510: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:
518: Get_Flex_So_Price_Lists;

Line 515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR

511: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
512: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
513: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
514: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
515: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
516: THEN
517:
518: Get_Flex_So_Price_Lists;
519:

Line 522: IF g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN

518: Get_Flex_So_Price_Lists;
519:
520: END IF;
521:
522: IF g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
523:
524: g_PRICE_LIST_rec.created_by := NULL;
525:
526: END IF;

Line 528: IF g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN

524: g_PRICE_LIST_rec.created_by := NULL;
525:
526: END IF;
527:
528: IF g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
529:
530: g_PRICE_LIST_rec.creation_date := NULL;
531:
532: END IF;

Line 534: IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN

530: g_PRICE_LIST_rec.creation_date := NULL;
531:
532: END IF;
533:
534: IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
535:
536: g_PRICE_LIST_rec.last_updated_by := NULL;
537:
538: END IF;

Line 540: IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN

536: g_PRICE_LIST_rec.last_updated_by := NULL;
537:
538: END IF;
539:
540: IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
541:
542: g_PRICE_LIST_rec.last_update_date := NULL;
543:
544: END IF;

Line 546: IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN

542: g_PRICE_LIST_rec.last_update_date := NULL;
543:
544: END IF;
545:
546: IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
547:
548: g_PRICE_LIST_rec.last_update_login := NULL;
549:
550: END IF;

Line 552: IF g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN

548: g_PRICE_LIST_rec.last_update_login := NULL;
549:
550: END IF;
551:
552: IF g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
553:
554: g_PRICE_LIST_rec.program_application_id := NULL;
555:
556: END IF;

Line 558: IF g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN

554: g_PRICE_LIST_rec.program_application_id := NULL;
555:
556: END IF;
557:
558: IF g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
559:
560: g_PRICE_LIST_rec.program_id := NULL;
561:
562: END IF;

Line 564: IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN

560: g_PRICE_LIST_rec.program_id := NULL;
561:
562: END IF;
563:
564: IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
565:
566: g_PRICE_LIST_rec.program_update_date := NULL;
567:
568: END IF;

Line 570: IF g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN

566: g_PRICE_LIST_rec.program_update_date := NULL;
567:
568: END IF;
569:
570: IF g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
571:
572: g_PRICE_LIST_rec.request_id := NULL;
573:
574: END IF;

Line 578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR

574: END IF;
575:
576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR

Line 579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR

575:
576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR

Line 580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR

576: -- Redefault if there are any missing attributes.
577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR

Line 581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR

577:
578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR

Line 582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR

578: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR

Line 583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR

579: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR

Line 584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR

580: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR

Line 585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR

581: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR

Line 586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR

582: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR

Line 587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR

583: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR

Line 588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR

584: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR

Line 589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR

585: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR

Line 590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR

586: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR

Line 591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR

587: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM

Line 592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR

588: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE

Line 593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR

589: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR

Line 594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR

590: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR

Line 595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM

591: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE

Line 596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE

592: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR

Line 597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR

593: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM

Line 598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR

594: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE

Line 599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE

595: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM

Line 600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR

596: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR

Line 601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM

597: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM

Line 602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE

598: OR g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR
599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM

Line 603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM

599: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM

Line 604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR

600: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE

Line 605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM

601: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM

Line 606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM

602: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM

Line 607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM

603: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM

Line 608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE

604: OR g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR
605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR

Line 609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM

605: OR g_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE

Line 610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM

606: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM

Line 611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM

607: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN

Line 612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR

608: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:

Line 613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE

609: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:
617: OE_Default_Price_List.Attributes

Line 614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM

610: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
611: OR g_PRICE_LIST_rec.secondary_price_list_id = FND_API.G_MISS_NUM
612: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
613: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
614: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
615: THEN
616:
617: OE_Default_Price_List.Attributes
618: ( p_PRICE_LIST_rec => g_PRICE_LIST_rec