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_SS_ENR_DETAILS dependencies on IGS_SS_ENR_DETAILS

Line 1: PACKAGE BODY igs_ss_enr_details AS

1: PACKAGE BODY igs_ss_enr_details AS
2: /* $Header: IGSSS05B.pls 120.21 2006/04/12 23:02:49 snambaka ship $ */
3:
4: g_tba_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('SCHEDULE_TYPE', 'TBA');
5: g_nsd_desc CONSTANT igs_lookup_values.meaning%TYPE := get_meaning('LEGACY_TOKENS','NO_SET_DAY');

Line 3127: l_c_notify_flag := igs_ss_enr_details.get_notification(

3123: IF l_c_en_com = 'BOTH' THEN
3124: l_c_en_com :='ALL';
3125: END IF;
3126:
3127: l_c_notify_flag := igs_ss_enr_details.get_notification(
3128: p_person_type => p_c_person_type,
3129: p_enrollment_category => l_c_en_cat,
3130: p_comm_type => l_c_en_com,
3131: p_enr_method_type => l_c_en_meth_type,

Line 3844: l_dt_alias_val := igs_ss_enr_details.get_alias_val(cur_uv_audit_ind_rec.cal_type,

3840: IF l_audit_dt_alias IS NULL THEN
3841: RETURN 'Y';
3842: END IF;
3843:
3844: l_dt_alias_val := igs_ss_enr_details.get_alias_val(cur_uv_audit_ind_rec.cal_type,
3845: cur_uv_audit_ind_rec.ci_sequence_number, l_audit_dt_alias);
3846:
3847: -- Check whether the audit update date alias value is greater than or equal to sysdate
3848: -- smaddali modified to remove NVL handling in the if clause for bug4666977

Line 4230: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,

4226: -------------------------------------------------------------------
4227: AS
4228:
4229: CURSOR c_total_plan_credits(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
4230: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
4231: cp_term_cal_type,cp_term_seq_num)) apor_cp
4232: FROM IGS_EN_PLAN_UNITS pls
4233: WHERE pls.cart_error_flag= 'N'
4234: AND pls.person_id = p_personid

Line 4240: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,

4236: AND pls.term_cal_type = cp_term_cal_type
4237: AND pls.term_ci_sequence_number = cp_term_seq_num;
4238:
4239: CURSOR c_total_unconfirm_credits (cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
4240: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
4241: cp_term_cal_type,cp_term_seq_num)) apor_cp
4242: FROM IGS_EN_SU_ATTEMPT sua
4243: WHERE sua.unit_attempt_status = 'UNCONFIRM'
4244: AND sua.person_id = p_personid

Line 4330: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_calendar_type, p_load_cal_sequence_number, l_sch_dt_alias);

4326:
4327: --if schedule is open for the term
4328: IF l_schedule_flag = 'Y' THEN
4329: -- get the schedule alias value for the current term.
4330: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_calendar_type, p_load_cal_sequence_number, l_sch_dt_alias);
4331: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
4332: IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE) THEN
4333: -- Check whether student has timeslot
4334: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,

Line 4334: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,

4330: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_calendar_type, p_load_cal_sequence_number, l_sch_dt_alias);
4331: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
4332: IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE) THEN
4333: -- Check whether student has timeslot
4334: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,
4335: p_person_type,
4336: p_course_cd,
4337: p_load_calendar_type,
4338: p_load_cal_sequence_number) THEN

Line 4342: END IF; -- end of IF igs_ss_enr_details.stu_timeslot_open check

4338: p_load_cal_sequence_number) THEN
4339:
4340: RETURN TRUE;
4341:
4342: END IF; -- end of IF igs_ss_enr_details.stu_timeslot_open check
4343:
4344: END IF; -- end of IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE)
4345:
4346: END IF; -- end of IF l_schedule_flag = 'Y

Line 4733: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_cal_type, p_load_seq_num, l_sch_dt_alias);

4729: -- Check whether the schedule is open for the given term
4730:
4731: IF l_schedule_flag = 'Y' THEN
4732: -- get the schedule alias value for the current term.
4733: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_cal_type, p_load_seq_num, l_sch_dt_alias);
4734: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
4735: IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE) THEN
4736: -- Check whether student has timeslot and
4737: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,

Line 4737: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,

4733: l_dt_alias_val := igs_ss_enr_details.get_alias_val(p_load_cal_type, p_load_seq_num, l_sch_dt_alias);
4734: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
4735: IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE) THEN
4736: -- Check whether student has timeslot and
4737: IF igs_ss_enr_details.stu_timeslot_open (p_person_id,
4738: p_person_type,
4739: p_course_cd,
4740: p_load_cal_type,
4741: p_load_seq_num) THEN

Line 4745: END IF; -- end of IF igs_ss_enr_details.stu_timeslot_open check

4741: p_load_seq_num) THEN
4742:
4743: l_schedule_open := TRUE;
4744:
4745: END IF; -- end of IF igs_ss_enr_details.stu_timeslot_open check
4746:
4747: END IF; -- end of IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) >= TRUNC (SYSDATE)
4748:
4749: END IF; -- end of IF l_schedule_flag = 'Y

Line 4756: l_dt_alias_val := igs_ss_enr_details.get_alias_val( p_load_cal_type, p_load_seq_num,l_plan_dt_alias);

4752: -- if the plannings is allowed for the plannig sheet and IGS: Use Planning Sheet Profile is ON
4753: IF l_plan_flag = 'Y' AND NVL(fnd_profile.value('IGS_EN_USE_PLAN'),'OFF') = 'ON' THEN
4754:
4755: -- Get the planning sheet date alias value for the given load calendar.
4756: l_dt_alias_val := igs_ss_enr_details.get_alias_val( p_load_cal_type, p_load_seq_num,l_plan_dt_alias);
4757:
4758: -- Check whether the planning sheet date alias value is greater than or equal to sysdate
4759: IF l_dt_alias_val IS NOT NULL AND TRUNC (l_dt_alias_val) <= TRUNC (SYSDATE) THEN
4760:

Line 5278: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,

5274: -------------------------------------------------------------------
5275: AS
5276: --cursor to fetch the total credits from planning sheet unit attempts with cart_error_flag=Y
5277: CURSOR c_total_cart_credits(cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5278: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
5279: cp_term_cal_type,cp_term_seq_num)) apor_cp
5280: FROM IGS_EN_PLAN_UNITS pls
5281: WHERE pls.cart_error_flag= 'Y'
5282: AND pls.person_id = p_personid

Line 5289: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,

5285: AND pls.term_ci_sequence_number = cp_term_seq_num;
5286:
5287: --cursor to fetch the total credits for all unconfirmed unit attempts from student unit attempts
5288: CURSOR c_total_unconfirm_credits (cp_term_cal_type VARCHAR2, cp_term_seq_num NUMBER) IS
5289: SELECT SUM(igs_ss_enr_details.get_apor_credits ( uoo_id, override_enrolled_cp,
5290: cp_term_cal_type,cp_term_seq_num)) apor_cp
5291: FROM IGS_EN_SU_ATTEMPT sua
5292: WHERE sua.unit_attempt_status = 'UNCONFIRM'
5293: AND sua.person_id = p_personid

Line 5594: END igs_ss_enr_details;

5590: END get_total_cart_units;
5591:
5592:
5593:
5594: END igs_ss_enr_details;