51:
52: FUNCTION Get_Currency_Detail
53: RETURN NUMBER
54: IS
55: l_currency_detail_id NUMBER := FND_API.G_MISS_NUM;
56: BEGIN
57:
58: select QP_CURRENCY_DETAILS_S.nextval
59: into l_currency_detail_id
213: BEGIN
214:
215: -- In the future call Flex APIs for defaults
216:
217: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
218: g_CURR_DETAILS_rec.attribute1 := NULL;
219: END IF;
220:
221: IF g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
217: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
218: g_CURR_DETAILS_rec.attribute1 := NULL;
219: END IF;
220:
221: IF g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
222: g_CURR_DETAILS_rec.attribute10 := NULL;
223: END IF;
224:
225: IF g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
221: IF g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
222: g_CURR_DETAILS_rec.attribute10 := NULL;
223: END IF;
224:
225: IF g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
226: g_CURR_DETAILS_rec.attribute11 := NULL;
227: END IF;
228:
229: IF g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
225: IF g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
226: g_CURR_DETAILS_rec.attribute11 := NULL;
227: END IF;
228:
229: IF g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
230: g_CURR_DETAILS_rec.attribute12 := NULL;
231: END IF;
232:
233: IF g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
229: IF g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
230: g_CURR_DETAILS_rec.attribute12 := NULL;
231: END IF;
232:
233: IF g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
234: g_CURR_DETAILS_rec.attribute13 := NULL;
235: END IF;
236:
237: IF g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
233: IF g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
234: g_CURR_DETAILS_rec.attribute13 := NULL;
235: END IF;
236:
237: IF g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
238: g_CURR_DETAILS_rec.attribute14 := NULL;
239: END IF;
240:
241: IF g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
237: IF g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
238: g_CURR_DETAILS_rec.attribute14 := NULL;
239: END IF;
240:
241: IF g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
242: g_CURR_DETAILS_rec.attribute15 := NULL;
243: END IF;
244:
245: IF g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
241: IF g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
242: g_CURR_DETAILS_rec.attribute15 := NULL;
243: END IF;
244:
245: IF g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
246: g_CURR_DETAILS_rec.attribute2 := NULL;
247: END IF;
248:
249: IF g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
245: IF g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
246: g_CURR_DETAILS_rec.attribute2 := NULL;
247: END IF;
248:
249: IF g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
250: g_CURR_DETAILS_rec.attribute3 := NULL;
251: END IF;
252:
253: IF g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
249: IF g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
250: g_CURR_DETAILS_rec.attribute3 := NULL;
251: END IF;
252:
253: IF g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
254: g_CURR_DETAILS_rec.attribute4 := NULL;
255: END IF;
256:
257: IF g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
253: IF g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
254: g_CURR_DETAILS_rec.attribute4 := NULL;
255: END IF;
256:
257: IF g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
258: g_CURR_DETAILS_rec.attribute5 := NULL;
259: END IF;
260:
261: IF g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
257: IF g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
258: g_CURR_DETAILS_rec.attribute5 := NULL;
259: END IF;
260:
261: IF g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
262: g_CURR_DETAILS_rec.attribute6 := NULL;
263: END IF;
264:
265: IF g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
261: IF g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
262: g_CURR_DETAILS_rec.attribute6 := NULL;
263: END IF;
264:
265: IF g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
266: g_CURR_DETAILS_rec.attribute7 := NULL;
267: END IF;
268:
269: IF g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
265: IF g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
266: g_CURR_DETAILS_rec.attribute7 := NULL;
267: END IF;
268:
269: IF g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
270: g_CURR_DETAILS_rec.attribute8 := NULL;
271: END IF;
272:
273: IF g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
269: IF g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
270: g_CURR_DETAILS_rec.attribute8 := NULL;
271: END IF;
272:
273: IF g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
274: g_CURR_DETAILS_rec.attribute9 := NULL;
275: END IF;
276:
277: IF g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
273: IF g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
274: g_CURR_DETAILS_rec.attribute9 := NULL;
275: END IF;
276:
277: IF g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
278: g_CURR_DETAILS_rec.context := NULL;
279: END IF;
280:
281: END Get_Flex_Curr_Details;
303: OE_MSG_PUB.Add;
304:
305: END IF;
306:
307: RAISE FND_API.G_EXC_ERROR;
308:
309: END IF;
310:
311: -- Initialize g_CURR_DETAILS_rec
313: g_CURR_DETAILS_rec := p_CURR_DETAILS_rec;
314:
315: -- Default missing attributes.
316:
317: IF g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN
318:
319: g_CURR_DETAILS_rec.conversion_date := Get_Conversion_Date;
320:
321: IF g_CURR_DETAILS_rec.conversion_date IS NOT NULL THEN
337: END IF;
338:
339: END IF;
340:
341: IF g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN
342:
343: g_CURR_DETAILS_rec.conversion_date_type := Get_Conversion_Date_Type;
344:
345: IF g_CURR_DETAILS_rec.conversion_date_type IS NOT NULL THEN
362:
363: END IF;
364:
365: /*
366: IF g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR THEN
367:
368: g_CURR_DETAILS_rec.conversion_method := Get_Conversion_Method;
369:
370: IF g_CURR_DETAILS_rec.conversion_method IS NOT NULL THEN
387:
388: END IF;
389: */
390:
391: IF g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN
392:
393: g_CURR_DETAILS_rec.conversion_type := Get_Conversion_Type;
394:
395: IF g_CURR_DETAILS_rec.conversion_type IS NOT NULL THEN
411: END IF;
412:
413: END IF;
414:
415: IF g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
416:
417: g_CURR_DETAILS_rec.currency_detail_id := Get_Currency_Detail;
418:
419: IF g_CURR_DETAILS_rec.currency_detail_id IS NOT NULL THEN
435: END IF;
436:
437: END IF;
438:
439: IF g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
440:
441: g_CURR_DETAILS_rec.currency_header_id := Get_Currency_Header;
442:
443: IF g_CURR_DETAILS_rec.currency_header_id IS NOT NULL THEN
459: END IF;
460:
461: END IF;
462:
463: IF g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN
464:
465: g_CURR_DETAILS_rec.end_date_active := Get_End_Date_Active;
466:
467: IF g_CURR_DETAILS_rec.end_date_active IS NOT NULL THEN
483: END IF;
484:
485: END IF;
486:
487: IF g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN
488:
489: g_CURR_DETAILS_rec.fixed_value := Get_Fixed_Value;
490:
491: IF g_CURR_DETAILS_rec.fixed_value IS NOT NULL THEN
507: END IF;
508:
509: END IF;
510:
511: IF g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
512:
513: g_CURR_DETAILS_rec.markup_formula_id := Get_Markup_Formula;
514:
515: IF g_CURR_DETAILS_rec.markup_formula_id IS NOT NULL THEN
531: END IF;
532:
533: END IF;
534:
535: IF g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN
536:
537: g_CURR_DETAILS_rec.markup_operator := Get_Markup_Operator;
538:
539: IF g_CURR_DETAILS_rec.markup_operator IS NOT NULL THEN
555: END IF;
556:
557: END IF;
558:
559: IF g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN
560:
561: g_CURR_DETAILS_rec.markup_value := Get_Markup_Value;
562:
563: IF g_CURR_DETAILS_rec.markup_value IS NOT NULL THEN
579: END IF;
580:
581: END IF;
582:
583: IF g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
584:
585: g_CURR_DETAILS_rec.price_formula_id := Get_Price_Formula;
586:
587: IF g_CURR_DETAILS_rec.price_formula_id IS NOT NULL THEN
603: END IF;
604:
605: END IF;
606:
607: IF g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN
608:
609: g_CURR_DETAILS_rec.rounding_factor := Get_Rounding_Factor;
610:
611: IF g_CURR_DETAILS_rec.rounding_factor IS NOT NULL THEN
627: END IF;
628:
629: END IF;
630:
631: IF g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN
632:
633: g_CURR_DETAILS_rec.selling_rounding_factor := Get_Selling_Rounding_Factor;
634:
635: IF g_CURR_DETAILS_rec.selling_rounding_factor IS NOT NULL THEN
651: END IF;
652:
653: END IF;
654:
655: IF g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN
656:
657: g_CURR_DETAILS_rec.start_date_active := Get_Start_Date_Active;
658:
659: IF g_CURR_DETAILS_rec.start_date_active IS NOT NULL THEN
675: END IF;
676:
677: END IF;
678:
679: IF g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
680:
681: g_CURR_DETAILS_rec.to_currency_code := Get_To_Currency;
682:
683: IF g_CURR_DETAILS_rec.to_currency_code IS NOT NULL THEN
699: END IF;
700:
701: END IF;
702:
703: IF g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN
704:
705: g_CURR_DETAILS_rec.curr_attribute_type := Get_curr_attribute_type;
706:
707: IF g_CURR_DETAILS_rec.curr_attribute_type IS NOT NULL THEN
723: END IF;
724:
725: END IF;
726:
727: IF g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN
728:
729: g_CURR_DETAILS_rec.curr_attribute_context := Get_curr_attribute_context;
730:
731: IF g_CURR_DETAILS_rec.curr_attribute_context IS NOT NULL THEN
747: END IF;
748:
749: END IF;
750:
751: IF g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN
752:
753: g_CURR_DETAILS_rec.curr_attribute := Get_curr_attribute;
754:
755: IF g_CURR_DETAILS_rec.curr_attribute IS NOT NULL THEN
771: END IF;
772:
773: END IF;
774:
775: IF g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN
776:
777: g_CURR_DETAILS_rec.curr_attribute_value := Get_curr_attribute_value;
778:
779: IF g_CURR_DETAILS_rec.curr_attribute_value IS NOT NULL THEN
795: END IF;
796:
797: END IF;
798:
799: IF g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN
800:
801: g_CURR_DETAILS_rec.precedence := Get_Precedence;
802:
803: IF g_CURR_DETAILS_rec.precedence IS NOT NULL THEN
820:
821: END IF;
822:
823:
824: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
821: END IF;
822:
823:
824: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
822:
823:
824: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
823:
824: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
824: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
825: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
826: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
827: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
828: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
829: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
830: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
831: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
839: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
832: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
839: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
840: THEN
833: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
839: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
840: THEN
841:
834: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
839: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
840: THEN
841:
842: Get_Flex_Curr_Details;
835: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
836: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
837: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
838: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
839: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
840: THEN
841:
842: Get_Flex_Curr_Details;
843:
842: Get_Flex_Curr_Details;
843:
844: END IF;
845:
846: IF g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN
847:
848: g_CURR_DETAILS_rec.created_by := NULL;
849:
850: END IF;
848: g_CURR_DETAILS_rec.created_by := NULL;
849:
850: END IF;
851:
852: IF g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN
853:
854: g_CURR_DETAILS_rec.creation_date := NULL;
855:
856: END IF;
854: g_CURR_DETAILS_rec.creation_date := NULL;
855:
856: END IF;
857:
858: IF g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
859:
860: g_CURR_DETAILS_rec.last_updated_by := NULL;
861:
862: END IF;
860: g_CURR_DETAILS_rec.last_updated_by := NULL;
861:
862: END IF;
863:
864: IF g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
865:
866: g_CURR_DETAILS_rec.last_update_date := NULL;
867:
868: END IF;
866: g_CURR_DETAILS_rec.last_update_date := NULL;
867:
868: END IF;
869:
870: IF g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
871:
872: g_CURR_DETAILS_rec.last_update_login := NULL;
873:
874: END IF;
872: g_CURR_DETAILS_rec.last_update_login := NULL;
873:
874: END IF;
875:
876: IF g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN
877:
878: g_CURR_DETAILS_rec.program_application_id := NULL;
879:
880: END IF;
878: g_CURR_DETAILS_rec.program_application_id := NULL;
879:
880: END IF;
881:
882: IF g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN
883:
884: g_CURR_DETAILS_rec.program_id := NULL;
885:
886: END IF;
884: g_CURR_DETAILS_rec.program_id := NULL;
885:
886: END IF;
887:
888: IF g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
889:
890: g_CURR_DETAILS_rec.program_update_date := NULL;
891:
892: END IF;
890: g_CURR_DETAILS_rec.program_update_date := NULL;
891:
892: END IF;
893:
894: IF g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN
895:
896: g_CURR_DETAILS_rec.request_id := NULL;
897:
898: END IF;
898: END IF;
899:
900: -- Redefault if there are any missing attributes.
901:
902: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
899:
900: -- Redefault if there are any missing attributes.
901:
902: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
900: -- Redefault if there are any missing attributes.
901:
902: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
901:
902: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
902: IF g_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
903: OR g_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
904: OR g_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
905: OR g_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
906: OR g_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
907: OR g_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
908: OR g_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
909: OR g_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
910: OR g_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
911: OR g_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
912: OR g_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
913: OR g_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
914: OR g_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
915: OR g_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
916: OR g_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
917: OR g_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
918: OR g_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
919: OR g_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
920: --OR g_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
921: OR g_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
922: OR g_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
923: OR g_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
924: OR g_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
925: OR g_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
926: OR g_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
927: OR g_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
928: OR g_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
929: OR g_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
930: OR g_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
931: OR g_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
932: OR g_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
933: OR g_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
934: OR g_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
935: OR g_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
936: OR g_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
937: OR g_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
938: OR g_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
939: OR g_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
947: OR g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM
940: OR g_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
947: OR g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM
948: THEN
941: OR g_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
947: OR g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM
948: THEN
949:
942: OR g_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
947: OR g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM
948: THEN
949:
950: QP_Default_Curr_Details.Attributes
943: OR g_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR
944: OR g_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR
945: OR g_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR
946: OR g_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR
947: OR g_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM
948: THEN
949:
950: QP_Default_Curr_Details.Attributes
951: ( p_CURR_DETAILS_rec => g_CURR_DETAILS_rec