APPS.IGS_EN_PLAN_UTILS dependencies on IGS_PE_PERSON_TYPES

Line 672: l_person_type igs_pe_person_types.person_type_code%TYPE;

668: p_term_seq_num IN NUMBER,
669: p_return_status OUT NOCOPY VARCHAR2,
670: p_message_name OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
671:
672: l_person_type igs_pe_person_types.person_type_code%TYPE;
673: l_enrollment_category igs_en_cat_prc_step.enrolment_cat%TYPE;
674: l_comm_type igs_en_cat_prc_step.s_student_comm_type%TYPE;
675: l_enr_method_type igs_en_cat_prc_step.enr_method_type%TYPE;
676: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

Line 1723: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE,

1719: WHERE unit_cd = p_unit_cd
1720: AND version_number = p_unit_ver_num;
1721:
1722: --Check if there exist any user level deadline
1723: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE,
1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1725: IS
1726: SELECT dai.alias_val alias_val
1727: FROM igs_ca_da_inst_v dai,igs_pe_usr_arg_all pua

Line 1758: FROM igs_pe_person_types

1754: -- Cursor to get the System Type corresponding to the Person Type Code
1755: -- Added as per the bug# 2364461.
1756: CURSOR cur_sys_per_typ(cp_person_type VARCHAR2) IS
1757: SELECT system_type
1758: FROM igs_pe_person_types
1759: WHERE person_type_code = cp_person_type;
1760: l_cur_sys_per_typ cur_sys_per_typ%ROWTYPE;
1761:
1762: -- Cursor to check for audit attempts

Line 1784: l_v_person_type igs_pe_person_types.person_type_code%TYPE;

1780: l_cur_chk_cp_chg_val cur_chk_cp_chg_val%ROWTYPE;
1781: l_cur_ps_unit_ofr cur_ps_unit_ofr%ROWTYPE;
1782:
1783: -- Variables
1784: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
1785: l_cp_out NUMBER;
1786:
1787: BEGIN
1788: