APPS.IGS_EN_GEN_008 dependencies on IGS_PE_PERSON_TYPES

Line 76: CURSOR cur_pe_usr_adisc (cp_person_type igs_pe_person_types.person_type_code%TYPE)

72:
73: -- cursor for getting the date aliases that are defined
74: -- at the person type level for the logged on person
75: --modified cursor for bug 3696257
76: CURSOR cur_pe_usr_adisc (cp_person_type igs_pe_person_types.person_type_code%TYPE)
77: IS
78: SELECT nvl(daiv.absolute_val,
79: IGS_CA_GEN_001.calp_set_alias_value(daiv.absolute_val,
80: IGS_CA_GEN_002.cals_clc_dt_from_dai(daiv.ci_sequence_number,

Line 118: l_v_person_type igs_pe_person_types.person_type_code%TYPE;

114: l_cur_pe_usr_adisc cur_pe_usr_adisc%ROWTYPE;
115: l_cur_usec_disc_dl cur_usec_disc_dl%ROWTYPE;
116: l_cur_unit_disc_crt cur_unit_disc_crt%ROWTYPE;
117:
118: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
119:
120: -- constant return variables
121: cst_yes CONSTANT VARCHAR2(1) := 'Y';
122: cst_no CONSTANT VARCHAR2(1) := 'N';

Line 2136: igs_pe_person_types pt

2132: CURSOR cur_person_type( cp_person_id igs_pe_typ_instances.person_id%TYPE)
2133: IS
2134: SELECT pti.person_type_code
2135: FROM igs_pe_typ_instances pti,
2136: igs_pe_person_types pt
2137: WHERE pti.person_id = cp_person_id AND
2138: pti.person_type_code = pt.person_type_code AND
2139: pt.system_type = 'SS_ENROLL_STAFF' AND
2140: TRUNC(SYSDATE) BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE)

Line 2153: FROM igs_pe_person_types

2149: WHERE person_id = cp_person_id AND
2150: course_cd = NVL(p_course_cd,course_cd) AND
2151: end_date IS NULL AND
2152: person_type_code IN ( SELECT person_type_code
2153: FROM igs_pe_person_types
2154: WHERE system_type = 'STUDENT');
2155: --
2156: -- Cursor to select the Function name of home page attached to the given responsibility.
2157: --

Line 2275: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)

2271: AND unit_version_number = cp_version_number;
2272:
2273: -- Cursor for getting different grading schema's defined for the logged on person type
2274: -- Modiified cursor for performance bug 3696153
2275: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2276: IS
2277: SELECT nvl(dai.absolute_val,
2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,

Line 2320: l_v_person_type igs_pe_person_types.person_type_code%TYPE;

2316: l_cur_en_nstd_usec cur_en_nstd_usec%ROWTYPE;
2317: l_cur_en_cal_conf cur_en_cal_conf%ROWTYPE;
2318:
2319: -- Variables
2320: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
2321: l_b_grade_schema BOOLEAN ;
2322:
2323: BEGIN
2324:

Line 2508: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)

2504: AND version_number = p_unit_ver_num;
2505:
2506: --Check if there exist any user level deadline
2507: --Modified the cursor for performance bug 3696257
2508: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE)
2509: IS
2510: SELECT nvl(dai.absolute_val,
2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,

Line 2546: FROM igs_pe_person_types

2542: -- Cursor to get the System Type corresponding to the Person Type Code
2543: -- Added as per the bug# 2364461.
2544: CURSOR cur_sys_per_typ(cp_person_type VARCHAR2) IS
2545: SELECT system_type
2546: FROM igs_pe_person_types
2547: WHERE person_type_code = cp_person_type;
2548: l_cur_sys_per_typ cur_sys_per_typ%ROWTYPE;
2549:
2550: -- Cursor to check for audit attempts

Line 2572: l_v_person_type igs_pe_person_types.person_type_code%TYPE;

2568: l_cur_chk_cp_chg_val cur_chk_cp_chg_val%ROWTYPE;
2569: l_cur_ps_unit_ofr cur_ps_unit_ofr%ROWTYPE;
2570:
2571: -- Variables
2572: l_v_person_type igs_pe_person_types.person_type_code%TYPE;
2573: l_cp_out NUMBER;
2574:
2575: BEGIN
2576: