DBA Data[Home] [Help]

APPS.IGS_GR_GEN_001 dependencies on IGS_GE_GEN_001

Line 556: IF IGS_GE_GEN_001.genp_chk_col_upper( cst_title,

552: -- component in the Graduand name.
553: --
554: /*IF v_title IS NOT NULL THEN
555: -- IF column is forced uppercase, re-Capitalise.
556: IF IGS_GE_GEN_001.genp_chk_col_upper( cst_title,
557: cst_person) THEN
558: v_graduation_name := RTRIM(INITCAP(v_title));
559: ELSE
560: v_graduation_name := RTRIM(v_title);

Line 566: IF igs_ge_gen_001.genp_chk_col_upper (cst_given_names, cst_person) THEN

562: END IF;*/
563: --
564: IF v_given_names IS NOT NULL THEN
565: -- If column is forced uppercase, re-Capitalise.
566: IF igs_ge_gen_001.genp_chk_col_upper (cst_given_names, cst_person) THEN
567: v_graduation_name := v_graduation_name || ' ' || RTRIM (INITCAP (v_given_names));
568: ELSE
569: v_graduation_name := v_graduation_name || ' ' || RTRIM (v_given_names);
570: END IF;

Line 578: IF igs_ge_gen_001.genp_chk_col_upper (cst_surname, cst_person) THEN

574: --
575: -- If column is forced uppercase, re-Capitalise.
576: -- Allow for mid-name capitals (like McDonald).
577: --
578: IF igs_ge_gen_001.genp_chk_col_upper (cst_surname, cst_person) THEN
579: v_graduation_name := v_graduation_name || ' ' || RTRIM (grdpl_surname_initcap (v_surname));
580: ELSE
581: v_graduation_name := v_graduation_name || ' ' || RTRIM (v_surname);
582: END IF;