DBA Data[Home] [Help]

APPS.IGS_EN_GEN_011 dependencies on IGS_SS_ENR_DETAILS

Line 96: -- modified to call the function igs_ss_enr_details.get_notification,

92: --svenkata 28-10-2002 Added new parameters to the call of fn eval_min_cp . Enrollment Eligibility and Valdns build - Bug# 2616692.
93: -- Changed the signature of the routine enrpl_upd_sua_uoo to pass details of academic calendar.
94: --Nishikant 01NOV2002 SEVIS Build. Enh Bug#2641905.
95: -- The notification flag was being fetched from cursor earlier. now its
96: -- modified to call the function igs_ss_enr_details.get_notification,
97: -- to get the value for it and to make the way common across all the packages.
98: --svenkata 20-NOV-2002 Modified the call to the function igs_en_val_sua.enrp_val_sua_discont to add value 'N' for the parameter
99: -- p_legacy. Bug#2661533.
100: --bdeviset 11-Apr-2005 Modified cursor c_sca in procedure Enrp_Prc_Sca_Blk_Trn for bug# 3701057

Line 2738: -- added to the calls igs_ss_enr_details.get_notification.

2734: --svenkata 28-Oct-02 Calculate the Total enrolled Credit points of the student before Transfer .
2735: -- Modify the call to the fn eval_min_cp to pass the total enr CP.
2736: -- The signature of the routine enrpl_upd_sua_uoo has been modified to add Acad Cal dtls.
2737: --Nishikant 01NOV2002 SEVIS Build. Enh Bug#2641905. Two new parameters p_person_id, p_message
2738: -- added to the calls igs_ss_enr_details.get_notification.
2739: --svenkata 22-Dec-02 Bug # 2686793 - Added a call to routine igs_en_elgbl_program.eval_unit_forced_type to enforce
2740: -- to enforce Attendance Type validations on transferring a unit.The validation is done after the
2741: -- unit is dropped.If validation fails(ERROR),transferred record is rolled back.If a warning is encountered,
2742: -- the warning message is logged.Transfer is completed successfully.

Line 3337: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3333: p_course_cd);
3334: IF l_waitlist_ind IN ('N','Y') THEN
3335: IF p_enforce_val = 'Y' AND l_reserved_seating_allowed ='Y' AND l_waitlist_ind = 'N' THEN
3336: -- getting the notification flag of reserve seat step
3337: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3338: v_message_name := NULL;
3339: l_notification_flag := NULL;
3340: l_notification_flag := igs_ss_enr_details.get_notification(
3341: p_person_type => p_person_type,

Line 3340: l_notification_flag := igs_ss_enr_details.get_notification(

3336: -- getting the notification flag of reserve seat step
3337: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3338: v_message_name := NULL;
3339: l_notification_flag := NULL;
3340: l_notification_flag := igs_ss_enr_details.get_notification(
3341: p_person_type => p_person_type,
3342: p_enrollment_category => p_enrolment_cat,
3343: p_comm_type => p_commencement_type,
3344: p_enr_method_type => p_enroll_meth,

Line 3639: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3635: END IF;
3636: END IF;
3637: --Validating the destination unit section incompatibility rule
3638: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
3639: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3640: v_message_name := NULL;
3641: l_notification_flag := NULL;
3642: l_notification_flag := igs_ss_enr_details.get_notification(
3643: p_person_type => p_person_type,

Line 3642: l_notification_flag := igs_ss_enr_details.get_notification(

3638: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
3639: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3640: v_message_name := NULL;
3641: l_notification_flag := NULL;
3642: l_notification_flag := igs_ss_enr_details.get_notification(
3643: p_person_type => p_person_type,
3644: p_enrollment_category => p_enrolment_cat,
3645: p_comm_type => p_commencement_type,
3646: p_enr_method_type => p_enroll_meth,

Line 3699: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3695: END IF;
3696: END IF;
3697: --Validating the special permission for destination unit section
3698: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3699: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3700: v_message_name := NULL;
3701: l_notification_flag := NULL;
3702: l_notification_flag := igs_ss_enr_details.get_notification(
3703: p_person_type => p_person_type,

Line 3702: l_notification_flag := igs_ss_enr_details.get_notification(

3698: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3699: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3700: v_message_name := NULL;
3701: l_notification_flag := NULL;
3702: l_notification_flag := igs_ss_enr_details.get_notification(
3703: p_person_type => p_person_type,
3704: p_enrollment_category => p_enrolment_cat,
3705: p_comm_type => p_commencement_type,
3706: p_enr_method_type => p_enroll_meth,

Line 3758: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3754: END IF;
3755: END IF;
3756: --Validating the Audit permission for destination unit section
3757: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3758: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3759: v_message_name := NULL;
3760: l_notification_flag := NULL;
3761: l_notification_flag := igs_ss_enr_details.get_notification(
3762: p_person_type => p_person_type,

Line 3761: l_notification_flag := igs_ss_enr_details.get_notification(

3757: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3758: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3759: v_message_name := NULL;
3760: l_notification_flag := NULL;
3761: l_notification_flag := igs_ss_enr_details.get_notification(
3762: p_person_type => p_person_type,
3763: p_enrollment_category => p_enrolment_cat,
3764: p_comm_type => p_commencement_type,
3765: p_enr_method_type => p_enroll_meth,

Line 3818: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3814:
3815:
3816: --Validating the Time conflict for destination unit section
3817: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3818: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3819: v_message_name := NULL;
3820: l_notification_flag := NULL;
3821: l_notification_flag := igs_ss_enr_details.get_notification(
3822: p_person_type => p_person_type,

Line 3821: l_notification_flag := igs_ss_enr_details.get_notification(

3817: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
3818: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3819: v_message_name := NULL;
3820: l_notification_flag := NULL;
3821: l_notification_flag := igs_ss_enr_details.get_notification(
3822: p_person_type => p_person_type,
3823: p_enrollment_category => p_enrolment_cat,
3824: p_comm_type => p_commencement_type,
3825: p_enr_method_type => p_enroll_meth,

Line 3879: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3875: END IF;
3876: END IF;
3877: --Validating the repeat unit validation for the unit attempt
3878: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
3879: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3880: v_message_name := NULL;
3881: l_notification_flag := NULL;
3882: l_notification_flag := igs_ss_enr_details.get_notification(
3883: p_person_type => p_person_type,

Line 3882: l_notification_flag := igs_ss_enr_details.get_notification(

3878: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
3879: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3880: v_message_name := NULL;
3881: l_notification_flag := NULL;
3882: l_notification_flag := igs_ss_enr_details.get_notification(
3883: p_person_type => p_person_type,
3884: p_enrollment_category => p_enrolment_cat,
3885: p_comm_type => p_commencement_type,
3886: p_enr_method_type => p_enroll_meth,

Line 3942: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

3938: END IF;
3939: END IF;
3940: --Validating the MAX CP validation for the Program Attempt
3941: IF ((v_update_uoo) AND (p_enforce_val = 'Y') AND p_unit_attempt_status NOT IN (cst_unconfirm,cst_waitlisted)) THEN
3942: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3943: v_message_name := NULL;
3944: l_notification_flag := NULL;
3945: l_notification_flag := igs_ss_enr_details.get_notification(
3946: p_person_type => p_person_type,

Line 3945: l_notification_flag := igs_ss_enr_details.get_notification(

3941: IF ((v_update_uoo) AND (p_enforce_val = 'Y') AND p_unit_attempt_status NOT IN (cst_unconfirm,cst_waitlisted)) THEN
3942: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
3943: v_message_name := NULL;
3944: l_notification_flag := NULL;
3945: l_notification_flag := igs_ss_enr_details.get_notification(
3946: p_person_type => p_person_type,
3947: p_enrollment_category => p_enrolment_cat,
3948: p_comm_type => p_commencement_type,
3949: p_enr_method_type => p_enroll_meth,

Line 4500: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

4496: END IF; --If superior
4497:
4498: --Validating the reenrollment unit validation for the unit attempt
4499: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
4500: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4501: v_message_name := NULL;
4502: l_notification_flag := NULL;
4503: l_notification_flag := igs_ss_enr_details.get_notification(
4504: p_person_type => p_person_type,

Line 4503: l_notification_flag := igs_ss_enr_details.get_notification(

4499: IF ((v_update_uoo) AND (p_enforce_val = 'Y')) THEN
4500: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4501: v_message_name := NULL;
4502: l_notification_flag := NULL;
4503: l_notification_flag := igs_ss_enr_details.get_notification(
4504: p_person_type => p_person_type,
4505: p_enrollment_category => p_enrolment_cat,
4506: p_comm_type => p_commencement_type,
4507: p_enr_method_type => p_enroll_meth,

Line 4560: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

4556: END IF;
4557: END IF;
4558: --Validating the MIN CP validation for the Program Attempt
4559: IF ((v_update_uoo) AND (p_enforce_val = 'Y') AND p_unit_attempt_status NOT IN (cst_unconfirm,cst_waitlisted)) THEN
4560: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4561: v_message_name := NULL;
4562: l_notification_flag := NULL;
4563: l_notification_flag := igs_ss_enr_details.get_notification(
4564: p_person_type => p_person_type,

Line 4563: l_notification_flag := igs_ss_enr_details.get_notification(

4559: IF ((v_update_uoo) AND (p_enforce_val = 'Y') AND p_unit_attempt_status NOT IN (cst_unconfirm,cst_waitlisted)) THEN
4560: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4561: v_message_name := NULL;
4562: l_notification_flag := NULL;
4563: l_notification_flag := igs_ss_enr_details.get_notification(
4564: p_person_type => p_person_type,
4565: p_enrollment_category => p_enrolment_cat,
4566: p_comm_type => p_commencement_type,
4567: p_enr_method_type => p_enroll_meth,

Line 4630: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

4626: p_sua_warn_count := p_sua_warn_count + 1;
4627: END IF;
4628: END IF; ---l_notification_flag
4629: IF (v_update_uoo) THEN
4630: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4631: v_message_name := NULL;
4632: l_notification_flag := NULL;
4633: l_notification_flag := igs_ss_enr_details.get_notification(
4634: p_person_type => p_person_type,

Line 4633: l_notification_flag := igs_ss_enr_details.get_notification(

4629: IF (v_update_uoo) THEN
4630: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4631: v_message_name := NULL;
4632: l_notification_flag := NULL;
4633: l_notification_flag := igs_ss_enr_details.get_notification(
4634: p_person_type => p_person_type,
4635: p_enrollment_category => p_enrolment_cat,
4636: p_comm_type => p_commencement_type,
4637: p_enr_method_type => p_enroll_meth,

Line 4700: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.

4696: END IF;
4697: END IF; -- IF (v_update_uoo)
4698: IF (v_update_uoo) THEN
4699: -- Validate Cross Location credit points
4700: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4701: v_message_name := NULL;
4702: l_notification_flag := NULL;
4703: l_notification_flag := igs_ss_enr_details.get_notification(
4704: p_person_type => p_person_type,

Line 4703: l_notification_flag := igs_ss_enr_details.get_notification(

4699: -- Validate Cross Location credit points
4700: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4701: v_message_name := NULL;
4702: l_notification_flag := NULL;
4703: l_notification_flag := igs_ss_enr_details.get_notification(
4704: p_person_type => p_person_type,
4705: p_enrollment_category => p_enrolment_cat,
4706: p_comm_type => p_commencement_type,
4707: p_enr_method_type => p_enroll_meth,

Line 4762: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.

4758: END IF ;
4759: END IF; -- IF (v_update_uoo)
4760: IF (v_update_uoo) THEN
4761: -- Validate Cross Mode credit points
4762: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4763: v_message_name := NULL;
4764: l_notification_flag := NULL;
4765: l_notification_flag := igs_ss_enr_details.get_notification(
4766: p_person_type => p_person_type,

Line 4765: l_notification_flag := igs_ss_enr_details.get_notification(

4761: -- Validate Cross Mode credit points
4762: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4763: v_message_name := NULL;
4764: l_notification_flag := NULL;
4765: l_notification_flag := igs_ss_enr_details.get_notification(
4766: p_person_type => p_person_type,
4767: p_enrollment_category => p_enrolment_cat,
4768: p_comm_type => p_commencement_type,
4769: p_enr_method_type => p_enroll_meth,

Line 4827: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.

4823: END IF ;
4824: END IF; -- IF (v_update_uoo)
4825: IF (v_update_uoo) THEN
4826: -- Validate Cross Faculty credit points
4827: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4828: v_message_name := NULL;
4829: l_notification_flag := NULL;
4830: l_notification_flag := igs_ss_enr_details.get_notification(
4831: p_person_type => p_person_type,

Line 4830: l_notification_flag := igs_ss_enr_details.get_notification(

4826: -- Validate Cross Faculty credit points
4827: --Igs_Ss_Enr_Details.get_notification returns NULL means that Program step is not defined.
4828: v_message_name := NULL;
4829: l_notification_flag := NULL;
4830: l_notification_flag := igs_ss_enr_details.get_notification(
4831: p_person_type => p_person_type,
4832: p_enrollment_category => p_enrolment_cat,
4833: p_comm_type => p_commencement_type,
4834: p_enr_method_type => p_enroll_meth,

Line 4895: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

4891:
4892: --Validating unit coreq unit section rule.
4893: IF ((v_update_uoo) AND (p_enforce_val = 'Y') AND (p_unit_attempt_status <> cst_unconfirm)) THEN
4894: -- getting the notification flag for evaluate COREQ unit validation
4895: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4896: v_message_name := NULL;
4897: l_notification_flag := NULL;
4898: l_notification_flag := igs_ss_enr_details.get_notification(
4899: p_person_type => p_person_type,

Line 4898: l_notification_flag := igs_ss_enr_details.get_notification(

4894: -- getting the notification flag for evaluate COREQ unit validation
4895: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4896: v_message_name := NULL;
4897: l_notification_flag := NULL;
4898: l_notification_flag := igs_ss_enr_details.get_notification(
4899: p_person_type => p_person_type,
4900: p_enrollment_category => p_enrolment_cat,
4901: p_comm_type => p_commencement_type,
4902: p_enr_method_type => p_enroll_meth,

Line 4958: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.

4954:
4955: --Validating unit pre-req unit section rule.
4956: IF ((v_update_uoo) AND (p_enforce_val = 'Y') ) THEN
4957: -- getting the notification flag for evaluate Pre-REQ unit validation
4958: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4959: v_message_name := NULL;
4960: l_notification_flag := NULL;
4961: l_notification_flag := igs_ss_enr_details.get_notification(
4962: p_person_type => p_person_type,

Line 4961: l_notification_flag := igs_ss_enr_details.get_notification(

4957: -- getting the notification flag for evaluate Pre-REQ unit validation
4958: --Igs_Ss_Enr_Details.get_notification returns NULL means that unit step is not defined.
4959: v_message_name := NULL;
4960: l_notification_flag := NULL;
4961: l_notification_flag := igs_ss_enr_details.get_notification(
4962: p_person_type => p_person_type,
4963: p_enrollment_category => p_enrolment_cat,
4964: p_comm_type => p_commencement_type,
4965: p_enr_method_type => p_enroll_meth,