eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_GEN_002 dependencies on IGS_PS_OFR_OPT_ALL

Line 117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,

113: WHERE acai.person_id=cp_person_id AND acai.course_cd=cp_course_cd AND
114: aav.person_id = acai.person_id AND aav.admission_appl_number = acai.admission_appl_number;
115:
116:
117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,

Line 118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,

114: aav.person_id = acai.person_id AND aav.admission_appl_number = acai.admission_appl_number;
115:
116:
117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS

Line 119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,

115:
116:
117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS
123: SELECT program_length, program_length_measurement

Line 120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,

116:
117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS
123: SELECT program_length, program_length_measurement
124: FROM igs_ps_ofr_opt_all

Line 121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,

117: CURSOR c_check_att_type (cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS
123: SELECT program_length, program_length_measurement
124: FROM igs_ps_ofr_opt_all
125: WHERE course_cd = cp_course_cd AND

Line 122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS

118: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
119: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS
123: SELECT program_length, program_length_measurement
124: FROM igs_ps_ofr_opt_all
125: WHERE course_cd = cp_course_cd AND
126: version_number = cp_version_number AND

Line 124: FROM igs_ps_ofr_opt_all

120: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
121: cp_location igs_ps_ofr_opt_all.location_cd%TYPE,
122: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE) IS
123: SELECT program_length, program_length_measurement
124: FROM igs_ps_ofr_opt_all
125: WHERE course_cd = cp_course_cd AND
126: version_number = cp_version_number AND
127: cal_type = cp_cal_type AND
128: attendance_type = cp_attendance_type AND

Line 133: l_program_length igs_ps_ofr_opt_all.program_length%TYPE;

129: location_cd = cp_location AND
130: attendance_mode = cp_attendance_mode AND
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;

Line 134: l_program_length_measurement igs_ps_ofr_opt_all.program_length_measurement%TYPE;

130: attendance_mode = cp_attendance_mode AND
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;

Line 141: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE;

137: l_message_name fnd_new_messages.message_name%TYPE;
138: l_ret_value NUMBER := 0;
139: l_total_eftd NUMBER := 0;
140: l_proglength_found BOOLEAN :=FALSE;
141: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE;
142: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE;
143: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE;
144: BEGIN
145: l_message_name := NULL;

Line 142: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE;

138: l_ret_value NUMBER := 0;
139: l_total_eftd NUMBER := 0;
140: l_proglength_found BOOLEAN :=FALSE;
141: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE;
142: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE;
143: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE;
144: BEGIN
145: l_message_name := NULL;
146: l_total_eftd := l_ret_value; --If returns without calculating EFTD, then p_total_eftd will be zero

Line 143: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE;

139: l_total_eftd NUMBER := 0;
140: l_proglength_found BOOLEAN :=FALSE;
141: l_location_cd igs_ps_ofr_opt_all.location_cd%TYPE;
142: l_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE;
143: l_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE;
144: BEGIN
145: l_message_name := NULL;
146: l_total_eftd := l_ret_value; --If returns without calculating EFTD, then p_total_eftd will be zero
147: