APPS.HR_GENERAL2 dependencies on FND_API

Line 578: and p_title<>fnd_api.g_miss_char then

574: IS
575: l_full_name hz_person_profiles.person_name%TYPE;
576: BEGIN
577: if p_title is not null
578: and p_title<>fnd_api.g_miss_char then
579: l_full_name:=l_full_name||p_title;
580: end if;
581:
582: if p_first_name is not null

Line 583: and p_first_name<>fnd_api.g_miss_char then

579: l_full_name:=l_full_name||p_title;
580: end if;
581:
582: if p_first_name is not null
583: and p_first_name<>fnd_api.g_miss_char then
584: l_full_name:=l_full_name||' '||p_first_name;
585: end if;
586:
587: if p_middle_name is not null

Line 588: and p_middle_name<>fnd_api.g_miss_char then

584: l_full_name:=l_full_name||' '||p_first_name;
585: end if;
586:
587: if p_middle_name is not null
588: and p_middle_name<>fnd_api.g_miss_char then
589: l_full_name:=l_full_name||' '||p_middle_name;
590: end if;
591:
592: if p_last_name is not null

Line 593: and p_last_name<>fnd_api.g_miss_char then

589: l_full_name:=l_full_name||' '||p_middle_name;
590: end if;
591:
592: if p_last_name is not null
593: and p_last_name<>fnd_api.g_miss_char then
594: l_full_name:=l_full_name||' '||p_last_name;
595: end if;
596:
597: if p_suffix is not null

Line 598: and p_suffix<>fnd_api.g_miss_char then

594: l_full_name:=l_full_name||' '||p_last_name;
595: end if;
596:
597: if p_suffix is not null
598: and p_suffix<>fnd_api.g_miss_char then
599: l_full_name:=l_full_name||' '||p_suffix;
600: end if;
601:
602: return l_full_name;

Line 620: and p_last_name<>fnd_api.g_miss_char) THEN

616: l_full_name hz_person_profiles.person_name%TYPE;
617: BEGIN
618: IF (p_leg_code = 'JP') THEN
619: IF (p_last_name is not null
620: and p_last_name<>fnd_api.g_miss_char) THEN
621: l_full_name := l_full_name || p_last_name ;
622: END IF;
623:
624: if (p_first_name is not null

Line 625: and p_first_name<>fnd_api.g_miss_char) then

621: l_full_name := l_full_name || p_last_name ;
622: END IF;
623:
624: if (p_first_name is not null
625: and p_first_name<>fnd_api.g_miss_char) then
626: l_full_name:=l_full_name||' '||p_first_name;
627: end if;
628:
629: IF (p_last_name is not null ) or (p_first_name is not null) THEN

Line 634: and p_jp_lname <> fnd_api.g_miss_char) THEN

630: l_full_name := l_full_name ||' /';
631: END IF;
632:
633: IF (p_jp_lname is not null
634: and p_jp_lname <> fnd_api.g_miss_char) THEN
635: l_full_name := l_full_name ||' '|| p_jp_lname ;
636: END IF;
637:
638: IF (p_jp_fname is not null

Line 639: and p_jp_fname <> fnd_api.g_miss_char) THEN

635: l_full_name := l_full_name ||' '|| p_jp_lname ;
636: END IF;
637:
638: IF (p_jp_fname is not null
639: and p_jp_fname <> fnd_api.g_miss_char) THEN
640: l_full_name := l_full_name ||' '|| p_jp_fname ;
641: END IF;
642:
643:

Line 647: and p_title<>fnd_api.g_miss_char then

643:
644: ELSE
645:
646: if p_title is not null
647: and p_title<>fnd_api.g_miss_char then
648: l_full_name:=l_full_name||p_title;
649: end if;
650:
651: if p_first_name is not null

Line 652: and p_first_name<>fnd_api.g_miss_char then

648: l_full_name:=l_full_name||p_title;
649: end if;
650:
651: if p_first_name is not null
652: and p_first_name<>fnd_api.g_miss_char then
653: l_full_name:=l_full_name||' '||p_first_name;
654: end if;
655:
656: if p_middle_name is not null

Line 657: and p_middle_name<>fnd_api.g_miss_char then

653: l_full_name:=l_full_name||' '||p_first_name;
654: end if;
655:
656: if p_middle_name is not null
657: and p_middle_name<>fnd_api.g_miss_char then
658: l_full_name:=l_full_name||' '||p_middle_name;
659: end if;
660:
661: if p_last_name is not null

Line 662: and p_last_name<>fnd_api.g_miss_char then

658: l_full_name:=l_full_name||' '||p_middle_name;
659: end if;
660:
661: if p_last_name is not null
662: and p_last_name<>fnd_api.g_miss_char then
663: l_full_name:=l_full_name||' '||p_last_name;
664: end if;
665:
666: if p_suffix is not null

Line 667: and p_suffix<>fnd_api.g_miss_char then

663: l_full_name:=l_full_name||' '||p_last_name;
664: end if;
665:
666: if p_suffix is not null
667: and p_suffix<>fnd_api.g_miss_char then
668: l_full_name:=l_full_name||' '||p_suffix;
669: end if;
670:
671: END IF;