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_EN_ENROLL_WLST dependencies on IGS_PS_UNIT_OFR_OPT

Line 5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

1: PACKAGE BODY Igs_En_Enroll_Wlst AS
2: /* $Header: IGSEN73B.pls 120.9 2005/12/12 03:32:10 appldev ship $ */
3:
4: /*** Enrolling Persons - Called in loop for Validated filtered student PL/SQL tables **/
5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
6: p_person_id igs_pe_person.person_id%TYPE,
7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,

Line 8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,

4: /*** Enrolling Persons - Called in loop for Validated filtered student PL/SQL tables **/
5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
6: p_person_id igs_pe_person.person_id%TYPE,
7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,
10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,
11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
12: p_enrolled_yn OUT NOCOPY VARCHAR2 ,

Line 9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,

5: PROCEDURE Enroll_Persons(p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
6: p_person_id igs_pe_person.person_id%TYPE,
7: p_course_cd igs_en_su_attempt.course_cd%TYPE,
8: p_waitlist_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.waitlist_actual%TYPE,
9: p_enrollment_actual IN OUT NOCOPY igs_ps_unit_ofr_opt.enrollment_actual%TYPE,
10: p_max_quota IN igs_ps_usec_lim_wlst.enrollment_maximum%TYPE,
11: p_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE,
12: p_enrolled_yn OUT NOCOPY VARCHAR2 ,
13: p_unit_cd igs_en_su_attempt.unit_cd%TYPE,

Line 55: igs_ps_unit_ofr_opt uoo

51: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points),
52: uv.points_override_ind
53: FROM igs_ps_unit_ver uv,
54: igs_ps_usec_cps cps,
55: igs_ps_unit_ofr_opt uoo
56: WHERE uoo.uoo_id = cps.uoo_id(+) AND
57: uoo.unit_cd = uv.unit_cd AND
58: uoo.version_number = uv.version_number AND
59: uoo.uoo_id = p_uoo_id;

Line 234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,

230:
231:
232: /** Procedure to validate the unit -- All existing validations **/
233: FUNCTION validate_unit
234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

Line 235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,

231:
232: /** Procedure to validate the unit -- All existing validations **/
233: FUNCTION validate_unit
234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,

Line 236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,

232: /** Procedure to validate the unit -- All existing validations **/
233: FUNCTION validate_unit
234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,

233: FUNCTION validate_unit
234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

234: (p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
235: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
242: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,

Line 240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,

236: p_cal_type IN igs_ps_unit_ofr_opt.cal_type%TYPE,
237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
242: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
243: p_deny_warn OUT NOCOPY VARCHAR2,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE)

Line 241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

237: p_ci_sequence_number IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE,
238: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
239: p_person_id IN igs_en_su_attempt.person_id%TYPE,
240: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
241: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
242: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE,
243: p_deny_warn OUT NOCOPY VARCHAR2,
244: p_course_cd IN igs_en_su_attempt.course_cd%TYPE)
245: RETURN BOOLEAN AS

Line 443: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

439:
440: FUNCTION validate_prog (p_person_id igs_en_su_attempt.person_id%TYPE,
441: p_cal_type igs_ca_inst.cal_type%TYPE, --load calendar
442: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, --load calendar
443: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
444: p_course_cd igs_en_su_attempt.course_cd%TYPE,
445: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
446: p_message_name OUT NOCOPY VARCHAR2,
447: p_deny_warn OUT NOCOPY VARCHAR2)

Line 571: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

567:
568: FUNCTION validate_unit_steps (p_person_id igs_en_su_attempt.person_id%TYPE,
569: p_cal_type igs_ca_inst.cal_type%TYPE,
570: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
571: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
572: p_course_cd igs_en_su_attempt.course_cd%TYPE,
573: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
574: p_message_name OUT NOCOPY VARCHAR2,
575: p_deny_warn OUT NOCOPY VARCHAR2,

Line 696: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

692:
693: /**** Main function for validating prg , unit , unit steps ***/
694:
695: FUNCTION finalize_unit (p_person_id igs_en_su_attempt.person_id%TYPE,
696: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
697: p_called_from_wlst VARCHAR2,
698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,

Line 698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

694:
695: FUNCTION finalize_unit (p_person_id igs_en_su_attempt.person_id%TYPE,
696: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
697: p_called_from_wlst VARCHAR2,
698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

Line 699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

695: FUNCTION finalize_unit (p_person_id igs_en_su_attempt.person_id%TYPE,
696: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
697: p_called_from_wlst VARCHAR2,
698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

698: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
704: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
705: p_course_cd igs_en_su_attempt.course_cd%TYPE,
706: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,

Line 703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

699: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
700: p_cal_type igs_ca_inst.cal_type%TYPE,
701: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
702: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
703: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
704: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
705: p_course_cd igs_en_su_attempt.course_cd%TYPE,
706: p_rsv_seat_ext_id igs_en_su_attempt.rsv_seat_ext_id%TYPE,
707: p_message_name OUT NOCOPY VARCHAR2)

Line 720: sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter

716: enhancements,
717: remarks :
718: Change History
719: Who When What
720: sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
721: abort_flag.
722: sarakshi 22-Sep-2003 Enh#3052452, Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
723: sup_uoo_id,relation_type,default_enroll_flag.
724: vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter

Line 722: sarakshi 22-Sep-2003 Enh#3052452, Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter

718: Change History
719: Who When What
720: sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
721: abort_flag.
722: sarakshi 22-Sep-2003 Enh#3052452, Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
723: sup_uoo_id,relation_type,default_enroll_flag.
724: vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
725: not_multiple_section_flag.
726: kkillams 24-04-2003 Passing NULL/0 depending on the IGS_EN_INCL_WLST_CP profile w.r.t. bug 2889975

Line 724: vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter

720: sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
721: abort_flag.
722: sarakshi 22-Sep-2003 Enh#3052452, Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
723: sup_uoo_id,relation_type,default_enroll_flag.
724: vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter
725: not_multiple_section_flag.
726: kkillams 24-04-2003 Passing NULL/0 depending on the IGS_EN_INCL_WLST_CP profile w.r.t. bug 2889975
727: ptandon 26-06-2003 Modified to display Person Number and Unit Code instead of Person Id and Uoo Id in the log.
728: Modified to display Max CP failure Error Message once if the student fails the same. Bug# 2841584

Line 748: / Cursor for UPDATE dir enrolment /or inq_not_wlst in IGS_PS_UNIT_OFR_OPT /

744: lv_return_status VARCHAR2(10);
745: l_credit_points NUMBER(10);
746: /*** Boolean variables to decide validation state **/
747:
748: /** Cursor for UPDATE dir enrolment /or inq_not_wlst in IGS_PS_UNIT_OFR_OPT **/
749:
750: CURSOR c_unit_ofr_opt IS
751: SELECT ROWID,
752: ofr.*

Line 753: FROM igs_ps_unit_ofr_opt ofr

749:
750: CURSOR c_unit_ofr_opt IS
751: SELECT ROWID,
752: ofr.*
753: FROM igs_ps_unit_ofr_opt ofr
754: WHERE uoo_id = p_uoo_id;
755:
756:
757: v_unit_ofr_opt_rec c_unit_ofr_opt%ROWTYPE;

Line 759: / Cursor for UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT /

755:
756:
757: v_unit_ofr_opt_rec c_unit_ofr_opt%ROWTYPE;
758:
759: /** Cursor for UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT **/
760:
761:
762: /** Cursor for UPDATE actual enrolment in igs_ps_rsv_ext **/
763:

Line 799: FROM igs_ps_unit_ofr_opt uoo,

795: FROM IGS_EN_OR_UNIT_WLST
796: WHERE cal_type = p_cal_type AND
797: closed_flag = 'N' AND
798: org_unit_cd = (SELECT NVL(uoo.owner_org_unit_cd, uv.owner_org_unit_cd)
799: FROM igs_ps_unit_ofr_opt uoo,
800: igs_ps_unit_ver uv
801: WHERE uoo.uoo_id = p_uoo_id AND
802: uv.unit_cd = uoo.unit_cd AND
803: uv.version_number = uoo.version_number);

Line 1110: / UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT /

1106:
1107: IF (p_called_from_wlst = 'N') THEN
1108: IF (lb_validate_prog) THEN
1109:
1110: /** UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT **/
1111:
1112: OPEN c_unit_ofr_opt;
1113: FETCH c_unit_ofr_opt INTO v_unit_ofr_opt_rec;
1114: CLOSE c_unit_ofr_opt;

Line 1118: igs_ps_unit_ofr_opt_pkg.update_row

1114: CLOSE c_unit_ofr_opt;
1115:
1116: BEGIN
1117: -- Added auditable_ind and audit_permission_ind parameters as part of Bug# 2636716
1118: igs_ps_unit_ofr_opt_pkg.update_row
1119: (x_rowid => v_unit_ofr_opt_rec.ROWID,
1120: x_unit_cd => v_unit_ofr_opt_rec.unit_cd,
1121: x_version_number => v_unit_ofr_opt_rec.version_number ,
1122: x_cal_type => v_unit_ofr_opt_rec.cal_type,

Line 1169: / UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT /

1165: );
1166:
1167: END;
1168:
1169: /** UPDATE dir enrolment in IGS_PS_UNIT_OFR_OPT **/
1170:
1171: RETURN TRUE;
1172: END IF;
1173:

Line 1217: igs_ps_unit_ofr_opt_pkg.update_row

1213: CLOSE c_unit_ofr_opt;
1214:
1215: BEGIN
1216: -- Added auditable_ind and audit_permission_ind parameters as part of Bug# 2636716
1217: igs_ps_unit_ofr_opt_pkg.update_row
1218: (x_rowid => v_unit_ofr_opt_rec.ROWID,
1219: x_unit_cd => v_unit_ofr_opt_rec.unit_cd,
1220: x_version_number => v_unit_ofr_opt_rec.version_number ,
1221: x_cal_type => v_unit_ofr_opt_rec.cal_type,

Line 1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

1303:
1304: /** For Combined validations for Unit Steps and Units - Not used in this package for external use**/
1305: FUNCTION validate_combined_unit (
1306: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

Line 1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

1304: /** For Combined validations for Unit Steps and Units - Not used in this package for external use**/
1305: FUNCTION validate_combined_unit (
1306: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

Line 1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

1307: p_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1314: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1315: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,

Line 1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,

1308: p_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1314: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1315: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
1316: p_message_name OUT NOCOPY VARCHAR2,

Line 1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

1309: p_cal_type igs_ca_inst.cal_type%TYPE, -- load calendar
1310: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE, -- load calendar
1311: p_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
1312: p_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE,
1313: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1314: p_course_cd igs_en_su_attempt.course_cd%TYPE,
1315: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
1316: p_message_name OUT NOCOPY VARCHAR2,
1317: p_deny_warn OUT NOCOPY VARCHAR2,

Line 1327: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1323: lv_unit_steps_deny_warn VARCHAR2(100);
1324: lv_validate_unit_message fnd_new_messages.message_name%TYPE;
1325: lv_unit_deny_warn VARCHAR2(100);
1326:
1327: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1328: SELECT cal_type, ci_sequence_number
1329: FROM igs_ps_unit_ofr_opt
1330: WHERE uoo_id = cp_uoo_id;
1331:

Line 1329: FROM igs_ps_unit_ofr_opt

1325: lv_unit_deny_warn VARCHAR2(100);
1326:
1327: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1328: SELECT cal_type, ci_sequence_number
1329: FROM igs_ps_unit_ofr_opt
1330: WHERE uoo_id = cp_uoo_id;
1331:
1332: lv_teach_cal_type igs_ca_inst.cal_type%TYPE;
1333: lv_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code

1411: ptandon 05-SEP-2003 Removed the commented code. Enh. Bug No. 3052426
1412: ctyagi 10-OCT-2005 Modified for Bug 4329478
1413: */
1414: --for a Unit Section (uoo_id)
1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code
1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code

Line 1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number

1412: ctyagi 10-OCT-2005 Modified for Bug 4329478
1413: */
1414: --for a Unit Section (uoo_id)
1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code
1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class

Line 1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type

1413: */
1414: --for a Unit Section (uoo_id)
1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code
1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist

Line 1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number

1414: --for a Unit Section (uoo_id)
1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code
1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment

Line 1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code

1415: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE; --unit code
1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:

Line 1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class

1416: lv_version_number igs_ps_unit_ofr_opt.version_number%TYPE; --version number
1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:
1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota

Line 1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist

1417: lv_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE; --calendar type
1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:
1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota
1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist

Line 1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment

1418: lv_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE; --ci sequence number
1419: lv_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE; --location code
1420: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE; --unit class
1421: lv_waitlist_actual igs_ps_unit_ofr_opt.waitlist_actual%TYPE; --actual waitlist
1422: lv_enrollment_actual igs_ps_unit_ofr_opt.enrollment_actual%TYPE; --actual enrollment
1423:
1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota
1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist
1426: lv_enrolled_yn VARCHAR2(1);

Line 1428: CURSOR igs_ps_unit_ofr_opt_cur

1424: lv_max_quota igs_ps_usec_lim_wlst.enrollment_maximum%TYPE; --maximun quota
1425: lv_max_stdnts_per_wlst igs_ps_usec_lim_wlst.max_students_per_waitlist%TYPE; --maximun students per waitlist
1426: lv_enrolled_yn VARCHAR2(1);
1427: --unit section (unit offering option -uoo_id)
1428: CURSOR igs_ps_unit_ofr_opt_cur
1429: IS
1430: SELECT unit_cd,
1431: version_number,
1432: cal_type,

Line 1438: FROM igs_ps_unit_ofr_opt

1434: location_cd,
1435: unit_class,
1436: waitlist_actual,
1437: enrollment_actual
1438: FROM igs_ps_unit_ofr_opt
1439: WHERE unit_section_status = 'HOLD'
1440: AND uoo_id = p_uoo_id;
1441:
1442: --maximum quota (max_quota) and maximum students per waitlist - Will be setting it to 9999 (unlimited) if null or no row

Line 1448: igs_ps_unit_ofr_opt uoo

1444: SELECT NVL (usec.enrollment_maximum, NVL(uv.enrollment_maximum,9999) ) enrollment_maximum,
1445: usec.max_students_per_waitlist
1446: FROM igs_ps_usec_lim_wlst usec,
1447: igs_ps_unit_ver uv,
1448: igs_ps_unit_ofr_opt uoo
1449: WHERE uoo.unit_cd = uv.unit_cd
1450: AND uoo.version_number = uv.version_number
1451: AND uoo.uoo_id = usec.uoo_id (+)
1452: AND uoo.uoo_id = p_uoo_id;

Line 1546: OPEN igs_ps_unit_ofr_opt_cur;

1542: ln_tab_succ_mail_ind := 0;
1543: ln_tab_fail_mail_ind := 0;
1544: ln_nadm_val_success := 0;
1545:
1546: OPEN igs_ps_unit_ofr_opt_cur;
1547: FETCH igs_ps_unit_ofr_opt_cur INTO lv_unit_cd,
1548: lv_version_number,
1549: lv_cal_type,
1550: lv_ci_sequence_number,

Line 1547: FETCH igs_ps_unit_ofr_opt_cur INTO lv_unit_cd,

1543: ln_tab_fail_mail_ind := 0;
1544: ln_nadm_val_success := 0;
1545:
1546: OPEN igs_ps_unit_ofr_opt_cur;
1547: FETCH igs_ps_unit_ofr_opt_cur INTO lv_unit_cd,
1548: lv_version_number,
1549: lv_cal_type,
1550: lv_ci_sequence_number,
1551: lv_location_cd,

Line 1692: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

1688:
1689: -- The man Proc called from the CONC
1690: PROCEDURE enroll_from_waitlist (errbuf OUT NOCOPY VARCHAR2,
1691: retcode OUT NOCOPY NUMBER,
1692: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
1693: p_org_id IN NUMBER
1694: ) AS
1695: /******************************************************************
1696: Created By :Syam

Line 1724: CURSOR c_get_load_cal_type(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1720:
1721: --
1722: -- Cursor to get Load Calendar Type associated with a Unit Section. Enh Bug# 3052426 (ptandon)
1723: --
1724: CURSOR c_get_load_cal_type(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1725: SELECT ctl.load_cal_type
1726: FROM igs_ca_teach_to_load_v ctl,
1727: igs_ps_unit_ofr_opt uoo
1728: WHERE uoo.uoo_id = cp_uoo_id

Line 1727: igs_ps_unit_ofr_opt uoo

1723: --
1724: CURSOR c_get_load_cal_type(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1725: SELECT ctl.load_cal_type
1726: FROM igs_ca_teach_to_load_v ctl,
1727: igs_ps_unit_ofr_opt uoo
1728: WHERE uoo.uoo_id = cp_uoo_id
1729: AND ctl.teach_cal_type = uoo.cal_type
1730: AND ctl.teach_ci_sequence_number = uoo.ci_sequence_number
1731: AND ctl.load_end_dt >= TRUNC(SYSDATE)

Line 1757: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

1753:
1754: -- Routine to send mails
1755: PROCEDURE wf_send_mail_stud_adm (p_tab_succ_mail IN tab_succ_mail,
1756: p_tab_fail_mail IN tab_fail_mail,
1757: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
1758: p_org_id IN NUMBER) AS
1759:
1760: lv_fail_student_string VARCHAR2(4000);
1761:

Line 1942: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

1938: PROCEDURE ss_eval_min_or_max_cp(
1939: p_person_id IN igs_en_su_attempt.person_id%TYPE,
1940: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1941: p_load_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1942: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
1943: p_program_cd IN igs_en_su_attempt.course_cd%TYPE,
1944: p_step_type IN igs_en_cpd_ext.s_enrolment_step_type%TYPE,
1945: p_credit_points IN NUMBER,
1946: p_message_name OUT NOCOPY VARCHAR2,