DBA Data[Home] [Help]

APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_DATE

Line 645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);

641: --
642: -- This is only for Date upgrades, do not try Time masks.
643: --
644: IF (l_length = 8) THEN
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
646: ELSIF (l_length = 9) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
648: ELSIF (l_length = 10) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);

Line 647: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);

643: --
644: IF (l_length = 8) THEN
645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
646: ELSIF (l_length = 9) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
648: ELSIF (l_length = 10) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
650: ELSIF (l_length = 11) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);

Line 649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);

645: l_date := fnd_date.string_to_date(p_char_in, g_mask_9_8);
646: ELSIF (l_length = 9) THEN
647: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
648: ELSIF (l_length = 10) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
650: ELSIF (l_length = 11) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
652: ELSIF (l_length = 14) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);

Line 651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);

647: l_date := fnd_date.string_to_date(p_char_in, g_mask_9);
648: ELSIF (l_length = 10) THEN
649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
650: ELSIF (l_length = 11) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
652: ELSIF (l_length = 14) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
654: ELSIF (l_length = 15) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);

Line 653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);

649: l_date := fnd_date.string_to_date(p_char_in, g_mask_11_10);
650: ELSIF (l_length = 11) THEN
651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
652: ELSIF (l_length = 14) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
654: ELSIF (l_length = 15) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
656: ELSIF (l_length = 16) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);

Line 655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);

651: l_date := fnd_date.string_to_date(p_char_in, g_mask_11);
652: ELSIF (l_length = 14) THEN
653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
654: ELSIF (l_length = 15) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
656: ELSIF (l_length = 16) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
658: ELSIF (l_length = 17) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);

Line 657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);

653: l_date := fnd_date.string_to_date(p_char_in, g_mask_15_14);
654: ELSIF (l_length = 15) THEN
655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
656: ELSIF (l_length = 16) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
658: ELSIF (l_length = 17) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
660: IF (l_date IS NULL) THEN
661: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);

Line 659: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);

655: l_date := fnd_date.string_to_date(p_char_in, g_mask_15);
656: ELSIF (l_length = 16) THEN
657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
658: ELSIF (l_length = 17) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
660: IF (l_date IS NULL) THEN
661: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
662: END IF;
663: ELSIF (l_length = 18) THEN

Line 661: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);

657: l_date := fnd_date.string_to_date(p_char_in, g_mask_17_16);
658: ELSIF (l_length = 17) THEN
659: l_date := fnd_date.string_to_date(p_char_in, g_mask_17);
660: IF (l_date IS NULL) THEN
661: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
662: END IF;
663: ELSIF (l_length = 18) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
665: ELSIF (l_length = 19) THEN

Line 664: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);

660: IF (l_date IS NULL) THEN
661: l_date := fnd_date.string_to_date(p_char_in, g_mask_18_17);
662: END IF;
663: ELSIF (l_length = 18) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
665: ELSIF (l_length = 19) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
667: IF (l_date IS NULL) THEN
668: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);

Line 666: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);

662: END IF;
663: ELSIF (l_length = 18) THEN
664: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
665: ELSIF (l_length = 19) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
667: IF (l_date IS NULL) THEN
668: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
669: END IF;
670: ELSIF (l_length = 20) THEN

Line 668: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);

664: l_date := fnd_date.string_to_date(p_char_in, g_mask_18);
665: ELSIF (l_length = 19) THEN
666: l_date := fnd_date.string_to_date(p_char_in, g_mask_19);
667: IF (l_date IS NULL) THEN
668: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
669: END IF;
670: ELSIF (l_length = 20) THEN
671: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);
672: ELSE

Line 671: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);

667: IF (l_date IS NULL) THEN
668: l_date := fnd_date.string_to_date(p_char_in, g_mask_20_19);
669: END IF;
670: ELSIF (l_length = 20) THEN
671: l_date := fnd_date.string_to_date(p_char_in, g_mask_20);
672: ELSE
673: x_error :=
674: set_error(l_func_name,
675: 'Unknown length. Old Value : ''' ||