APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_PE_PERSON_TYPES

Line 114: l_person_type igs_pe_person_types.person_type_code%TYPE;

110: l_step_override BOOLEAN;
111:
112: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
113:
114: l_person_type igs_pe_person_types.person_type_code%TYPE;
115:
116: FUNCTION vald_deny_all_hold
117: RETURN BOOLEAN
118: IS

Line 361: l_person_type igs_pe_person_types.person_type_code%TYPE;

357: l_step_override BOOLEAN;
358:
359: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
360:
361: l_person_type igs_pe_person_types.person_type_code%TYPE;
362:
363: FUNCTION vald_rev_sus_hold
364: RETURN BOOLEAN
365: IS

Line 644: l_person_type igs_pe_person_types.person_type_code%TYPE;

640: rec_vald_steps c_stud_vald_steps%ROWTYPE;
641:
642: l_vald_person_steps BOOLEAN;
643: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
644: l_person_type igs_pe_person_types.person_type_code%TYPE;
645: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE; --added by nishikant
646: l_message VARCHAR2(2000);
647: l_deny_person_steps BOOLEAN;
648: l_warn_person_steps BOOLEAN;

Line 1420: l_person_type igs_pe_person_types.person_type_code%TYPE;

1416: --
1417:
1418: l_step_override BOOLEAN;
1419:
1420: l_person_type igs_pe_person_types.person_type_code%TYPE;
1421: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
1422:
1423: FUNCTION vald_timeslot
1424: RETURN BOOLEAN

Line 1668: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS

1664: RETURN VARCHAR2 IS
1665: --
1666: -- cursor c_sys_pers_type to fetch the system person type
1667: --
1668: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1669: SELECT system_type
1670: FROM igs_pe_person_types
1671: WHERE person_type_code = cp_person_type;
1672: l_sys_pers_type igs_pe_person_types.person_type_code%TYPE;

Line 1670: FROM igs_pe_person_types

1666: -- cursor c_sys_pers_type to fetch the system person type
1667: --
1668: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1669: SELECT system_type
1670: FROM igs_pe_person_types
1671: WHERE person_type_code = cp_person_type;
1672: l_sys_pers_type igs_pe_person_types.person_type_code%TYPE;
1673:
1674:

Line 1672: l_sys_pers_type igs_pe_person_types.person_type_code%TYPE;

1668: CURSOR c_sys_pers_type (cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1669: SELECT system_type
1670: FROM igs_pe_person_types
1671: WHERE person_type_code = cp_person_type;
1672: l_sys_pers_type igs_pe_person_types.person_type_code%TYPE;
1673:
1674:
1675: BEGIN
1676: p_message := NULL;