APPS.IGS_PS_GEN_002 dependencies on IGS_EN_STDNT_PS_ATT

Line 100: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

96: || to fetch program length and program length measurement by removing
97: || references to std_ft_completion_time.
98: ----------------------------------------------------------------------------*/
99:
100: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
102: SELECT sca.cal_type, sca.version_number,sca.location_cd,sca.attendance_mode,sca.attendance_type
103: FROM igs_en_stdnt_ps_att sca
104: WHERE sca.person_id = cp_person_id

Line 101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

97: || references to std_ft_completion_time.
98: ----------------------------------------------------------------------------*/
99:
100: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
102: SELECT sca.cal_type, sca.version_number,sca.location_cd,sca.attendance_mode,sca.attendance_type
103: FROM igs_en_stdnt_ps_att sca
104: WHERE sca.person_id = cp_person_id
105: AND sca.course_cd = cp_course_cd;

Line 103: FROM igs_en_stdnt_ps_att sca

99:
100: CURSOR c_stu_crs_atmpt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
101: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
102: SELECT sca.cal_type, sca.version_number,sca.location_cd,sca.attendance_mode,sca.attendance_type
103: FROM igs_en_stdnt_ps_att sca
104: WHERE sca.person_id = cp_person_id
105: AND sca.course_cd = cp_course_cd;
106: --
107:

Line 108: CURSOR c_stu_crs_atmpt_from_appl (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

104: WHERE sca.person_id = cp_person_id
105: AND sca.course_cd = cp_course_cd;
106: --
107:
108: CURSOR c_stu_crs_atmpt_from_appl (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
109: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
110: SELECT aav.acad_cal_type, acai.crv_version_number , acai.location_cd,acai.attendance_mode,acai.attendance_type
111: FROM igs_ad_appl aav,
112: igs_ad_ps_appl_inst acai

Line 109: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS

105: AND sca.course_cd = cp_course_cd;
106: --
107:
108: CURSOR c_stu_crs_atmpt_from_appl (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
109: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
110: SELECT aav.acad_cal_type, acai.crv_version_number , acai.location_cd,acai.attendance_mode,acai.attendance_type
111: FROM igs_ad_appl aav,
112: igs_ad_ps_appl_inst acai
113: WHERE acai.person_id=cp_person_id AND acai.course_cd=cp_course_cd AND

Line 135: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;

131: program_length IS NOT NULL AND
132: program_length_measurement IS NOT NULL;
133: l_program_length igs_ps_ofr_opt_all.program_length%TYPE;
134: l_program_length_measurement igs_ps_ofr_opt_all.program_length_measurement%TYPE;
135: l_version_number igs_en_stdnt_ps_att.version_number%TYPE;
136: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
137: l_message_name fnd_new_messages.message_name%TYPE;
138: l_ret_value NUMBER := 0;
139: l_total_eftd NUMBER := 0;