APPS.IGS_EN_DASHBOARD dependencies on IGS_SS_ENR_DETAILS

Line 208: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_career.loadcal, rec_career.sequence_number, l_sch_dalias);

204: LOOP
205: l_schedule_available := FALSE;
206: IF rec_career.schedule_flag = 'Y' THEN
207: -- get the schedule alias value for the current term.
208: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_career.loadcal, rec_career.sequence_number, l_sch_dalias);
209: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
210: IF l_d_alias_val IS NOT NULL AND TRUNC (l_d_alias_val) <= TRUNC (SYSDATE) THEN
211: l_schedule_available := TRUE;
212: END IF;

Line 218: l_d_alias_val := igs_ss_enr_details.get_alias_val( rec_career.loadcal, rec_career.sequence_number, l_plan_dalias);

214: -- Check whether the planning sheet profile is ON and planning is allowed for the current term
215: IF rec_career.planning_flag = 'Y' AND
216: NVL(fnd_profile.value('IGS_EN_USE_PLAN'),'OFF') = 'ON' THEN
217:
218: l_d_alias_val := igs_ss_enr_details.get_alias_val( rec_career.loadcal, rec_career.sequence_number, l_plan_dalias);
219:
220: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
221: IF l_d_alias_val IS NOT NULL AND TRUNC (l_d_alias_val) <= TRUNC (SYSDATE) THEN
222: -- Add the calendar instance, career and Planning (P)/Schedule (S).

Line 291: IF igs_ss_enr_details.stu_timeslot_open (p_n_person_id, p_c_person_type,

287:
288: -- Check whether the schedule is allowed for the current term
289: IF l_schedule_available THEN
290: -- Check whether student has timeslot and
291: IF igs_ss_enr_details.stu_timeslot_open (p_n_person_id, p_c_person_type,
292: rec_career.program_cd, rec_career.loadcal, rec_career.sequence_number) THEN
293: -- Add the calendar instance, career and Planning (P)/Schedule (S).
294: i := i+1;
295: P_cal_tbl(i) := rec_career.loadcal;

Line 310: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_program.loadcal, rec_program.sequence_number, l_sch_dalias);

306: LOOP
307: l_schedule_available := FALSE;
308: IF rec_program.schedule_flag = 'Y' THEN
309: -- get the schedule alias value for the current term.
310: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_program.loadcal, rec_program.sequence_number, l_sch_dalias);
311: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
312: IF l_d_alias_val IS NOT NULL AND TRUNC(l_d_alias_val) <= TRUNC(SYSDATE) THEN
313: l_schedule_available := TRUE;
314: END IF;

Line 320: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_program.loadcal, rec_program.sequence_number, l_plan_dalias);

316: -- Check whether the planning sheet profile is ON and planning is allowed for the current term
317: IF rec_program.planning_flag = 'Y' AND NVL(fnd_profile.value('IGS_EN_USE_PLAN'),'OFF') = 'ON'
318: THEN
319: -- get the planning sheet alias value for the current term.
320: l_d_alias_val := igs_ss_enr_details.get_alias_val(rec_program.loadcal, rec_program.sequence_number, l_plan_dalias);
321: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
322: IF l_d_alias_val IS NOT NULL AND TRUNC (l_d_alias_val) <= TRUNC (SYSDATE) THEN
323: -- Add the calendar instance, career and Planning (P)/Schedule (S).
324: i:= i+1;

Line 389: IF igs_ss_enr_details.stu_timeslot_open (p_n_person_id, p_c_person_type,

385: END IF;
386: -- Check whether the schedule is allowed for the current term
387: IF l_schedule_available THEN
388: -- Check whether student has timeslot and
389: IF igs_ss_enr_details.stu_timeslot_open (p_n_person_id, p_c_person_type,
390: rec_program.program_cd, rec_program.loadcal, rec_program.sequence_number) THEN
391: -- Add the calendar instance, career and Planning (P)/Schedule (S).
392: i := i+1;
393: p_cal_tbl(i) := rec_program.loadcal;