APPS.HR_GENERAL2 dependencies on FND_API

Line 531: and p_title<>fnd_api.g_miss_char then

527: IS
528: l_full_name hz_person_profiles.person_name%TYPE;
529: BEGIN
530: if p_title is not null
531: and p_title<>fnd_api.g_miss_char then
532: l_full_name:=l_full_name||p_title;
533: end if;
534:
535: if p_first_name is not null

Line 536: and p_first_name<>fnd_api.g_miss_char then

532: l_full_name:=l_full_name||p_title;
533: end if;
534:
535: if p_first_name is not null
536: and p_first_name<>fnd_api.g_miss_char then
537: l_full_name:=l_full_name||' '||p_first_name;
538: end if;
539:
540: if p_middle_name is not null

Line 541: and p_middle_name<>fnd_api.g_miss_char then

537: l_full_name:=l_full_name||' '||p_first_name;
538: end if;
539:
540: if p_middle_name is not null
541: and p_middle_name<>fnd_api.g_miss_char then
542: l_full_name:=l_full_name||' '||p_middle_name;
543: end if;
544:
545: if p_last_name is not null

Line 546: and p_last_name<>fnd_api.g_miss_char then

542: l_full_name:=l_full_name||' '||p_middle_name;
543: end if;
544:
545: if p_last_name is not null
546: and p_last_name<>fnd_api.g_miss_char then
547: l_full_name:=l_full_name||' '||p_last_name;
548: end if;
549:
550: if p_suffix is not null

Line 551: and p_suffix<>fnd_api.g_miss_char then

547: l_full_name:=l_full_name||' '||p_last_name;
548: end if;
549:
550: if p_suffix is not null
551: and p_suffix<>fnd_api.g_miss_char then
552: l_full_name:=l_full_name||' '||p_suffix;
553: end if;
554:
555: return l_full_name;

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

569: l_full_name hz_person_profiles.person_name%TYPE;
570: BEGIN
571: IF (p_leg_code = 'JP') THEN
572: IF (p_last_name is not null
573: and p_last_name<>fnd_api.g_miss_char) THEN
574: l_full_name := l_full_name || p_last_name ;
575: END IF;
576:
577: if (p_first_name is not null

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

574: l_full_name := l_full_name || p_last_name ;
575: END IF;
576:
577: if (p_first_name is not null
578: and p_first_name<>fnd_api.g_miss_char) then
579: l_full_name:=l_full_name||' '||p_first_name;
580: end if;
581:
582: IF (p_last_name is not null ) or (p_first_name is not null) THEN

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

583: l_full_name := l_full_name ||' /';
584: END IF;
585:
586: IF (p_jp_lname is not null
587: and p_jp_lname <> fnd_api.g_miss_char) THEN
588: l_full_name := l_full_name ||' '|| p_jp_lname ;
589: END IF;
590:
591: IF (p_jp_fname is not null

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

588: l_full_name := l_full_name ||' '|| p_jp_lname ;
589: END IF;
590:
591: IF (p_jp_fname is not null
592: and p_jp_fname <> fnd_api.g_miss_char) THEN
593: l_full_name := l_full_name ||' '|| p_jp_fname ;
594: END IF;
595:
596:

Line 600: and p_title<>fnd_api.g_miss_char then

596:
597: ELSE
598:
599: if p_title is not null
600: and p_title<>fnd_api.g_miss_char then
601: l_full_name:=l_full_name||p_title;
602: end if;
603:
604: if p_first_name is not null

Line 605: and p_first_name<>fnd_api.g_miss_char then

601: l_full_name:=l_full_name||p_title;
602: end if;
603:
604: if p_first_name is not null
605: and p_first_name<>fnd_api.g_miss_char then
606: l_full_name:=l_full_name||' '||p_first_name;
607: end if;
608:
609: if p_middle_name is not null

Line 610: and p_middle_name<>fnd_api.g_miss_char then

606: l_full_name:=l_full_name||' '||p_first_name;
607: end if;
608:
609: if p_middle_name is not null
610: and p_middle_name<>fnd_api.g_miss_char then
611: l_full_name:=l_full_name||' '||p_middle_name;
612: end if;
613:
614: if p_last_name is not null

Line 615: and p_last_name<>fnd_api.g_miss_char then

611: l_full_name:=l_full_name||' '||p_middle_name;
612: end if;
613:
614: if p_last_name is not null
615: and p_last_name<>fnd_api.g_miss_char then
616: l_full_name:=l_full_name||' '||p_last_name;
617: end if;
618:
619: if p_suffix is not null

Line 620: and p_suffix<>fnd_api.g_miss_char then

616: l_full_name:=l_full_name||' '||p_last_name;
617: end if;
618:
619: if p_suffix is not null
620: and p_suffix<>fnd_api.g_miss_char then
621: l_full_name:=l_full_name||' '||p_suffix;
622: end if;
623:
624: END IF;