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

Line 45: TYPE usec_tr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

41: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1);
42: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1);
43:
44: -- for doing certain validation at unit section level while importing unit section occurrence of instructors
45: TYPE usec_tr_rectype IS RECORD( uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
46: instr_index NUMBER);
47: TYPE usec_tr_tbltype IS TABLE OF usec_tr_rectype index by binary_integer;
48: v_tab_usec_tr usec_tr_tbltype;
49:

Line 628: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,

624: -- Validate Unit Offer Option Records before inserting them
625: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
626: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
627: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
628: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
629: p_insert_update VARCHAR2,
630: p_conc_flag OUT NOCOPY BOOLEAN)
631: AS
632: /***********************************************************************************************

Line 651: l_n_call_number igs_ps_unit_ofr_opt_all.call_number%TYPE;

647: sarakshi 22-Aug-2003 Bug#304509, added validation, Not Multiple Unit Section Flag should not be N if it N at Unit level
648: sarakshi 04-Mar-2003 Bug#2768783, addded call number validation for profile option NONE also
649: smvk 26-Dec-2002 Bug # 2721495. Using the newly created function and procedure get_party_id, validate_staff_person.
650: ********************************************************************************************** */
651: l_n_call_number igs_ps_unit_ofr_opt_all.call_number%TYPE;
652: -- Removed l_n_unit_contact_id as a part of bug # 3121311
653: l_c_message VARCHAR2(30);
654:
655: CURSOR c_location_type ( cp_location_cd igs_ad_location_all.location_cd%TYPE ) IS

Line 673: CURSOR c_anon_grd_method ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

669: AND version_number = cp_version_number
670: AND anon_unit_grading_ind = 'Y' ;
671: rec_anon_unit_grading c_anon_unit_grading%ROWTYPE;
672:
673: CURSOR c_anon_grd_method ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
674: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
675: cp_load_start_dt igs_ca_inst_all.start_dt%TYPE) IS
676: SELECT 1
677: FROM igs_ca_teach_to_load_v a,

Line 674: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

670: AND anon_unit_grading_ind = 'Y' ;
671: rec_anon_unit_grading c_anon_unit_grading%ROWTYPE;
672:
673: CURSOR c_anon_grd_method ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
674: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
675: cp_load_start_dt igs_ca_inst_all.start_dt%TYPE) IS
676: SELECT 1
677: FROM igs_ca_teach_to_load_v a,
678: igs_as_anon_method b

Line 685: CURSOR c_min_load_start_dt ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

681: AND a.load_start_dt = cp_load_start_dt
682: AND a.load_cal_type = b.load_cal_type;
683: rec_anon_grd_method c_anon_grd_method%ROWTYPE;
684:
685: CURSOR c_min_load_start_dt ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
686: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE ) IS
687: SELECT MIN(c.load_start_dt)
688: FROM igs_ca_teach_to_load_v c
689: WHERE c.teach_cal_type = cp_cal_type

Line 686: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE ) IS

682: AND a.load_cal_type = b.load_cal_type;
683: rec_anon_grd_method c_anon_grd_method%ROWTYPE;
684:
685: CURSOR c_min_load_start_dt ( cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
686: cp_ci_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE ) IS
687: SELECT MIN(c.load_start_dt)
688: FROM igs_ca_teach_to_load_v c
689: WHERE c.teach_cal_type = cp_cal_type
690: AND c.teach_ci_sequence_number = cp_ci_seq_num ;

Line 724: CURSOR c_crosslist ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

720: AND version_number = cp_version_number;
721:
722: l_same_teaching_period igs_ps_unit_ver_all.same_teaching_period%TYPE;
723:
724: CURSOR c_crosslist ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
725: SELECT 'X'
726: FROM igs_ps_usec_x_grpmem
727: WHERE uoo_id = cp_uoo_id;
728:

Line 730: CURSOR c_usec_status ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

726: FROM igs_ps_usec_x_grpmem
727: WHERE uoo_id = cp_uoo_id;
728:
729:
730: CURSOR c_usec_status ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
731: cp_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE) IS
732: SELECT 'X'
733: FROM igs_ps_unit_ofr_opt_all
734: WHERE uoo_id = cp_uoo_id

Line 731: cp_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE) IS

727: WHERE uoo_id = cp_uoo_id;
728:
729:
730: CURSOR c_usec_status ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
731: cp_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE) IS
732: SELECT 'X'
733: FROM igs_ps_unit_ofr_opt_all
734: WHERE uoo_id = cp_uoo_id
735: AND unit_section_status = cp_usec_status;

Line 733: FROM igs_ps_unit_ofr_opt_all

729:
730: CURSOR c_usec_status ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
731: cp_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE) IS
732: SELECT 'X'
733: FROM igs_ps_unit_ofr_opt_all
734: WHERE uoo_id = cp_uoo_id
735: AND unit_section_status = cp_usec_status;
736:
737: CURSOR c_relation (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

Line 737: CURSOR c_relation (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

733: FROM igs_ps_unit_ofr_opt_all
734: WHERE uoo_id = cp_uoo_id
735: AND unit_section_status = cp_usec_status;
736:
737: CURSOR c_relation (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
738: cp_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE) IS
739: SELECT 'X'
740: FROM igs_ps_unit_ofr_opt_all
741: WHERE uoo_id = cp_uoo_id

Line 738: cp_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE) IS

734: WHERE uoo_id = cp_uoo_id
735: AND unit_section_status = cp_usec_status;
736:
737: CURSOR c_relation (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
738: cp_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE) IS
739: SELECT 'X'
740: FROM igs_ps_unit_ofr_opt_all
741: WHERE uoo_id = cp_uoo_id
742: AND relation_type = cp_relation_type;

Line 740: FROM igs_ps_unit_ofr_opt_all

736:
737: CURSOR c_relation (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
738: cp_relation_type igs_ps_unit_ofr_opt_all.relation_type%TYPE) IS
739: SELECT 'X'
740: FROM igs_ps_unit_ofr_opt_all
741: WHERE uoo_id = cp_uoo_id
742: AND relation_type = cp_relation_type;
743:
744: CURSOR c_cal_seq_no(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 744: CURSOR c_cal_seq_no(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

740: FROM igs_ps_unit_ofr_opt_all
741: WHERE uoo_id = cp_uoo_id
742: AND relation_type = cp_relation_type;
743:
744: CURSOR c_cal_seq_no(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
745: SELECT uoo.cal_type,uoo.ci_sequence_number
746: FROM igs_ps_unit_ofr_opt_all uoo
747: WHERE uoo.uoo_id = cp_uoo_id;
748:

Line 746: FROM igs_ps_unit_ofr_opt_all uoo

742: AND relation_type = cp_relation_type;
743:
744: CURSOR c_cal_seq_no(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
745: SELECT uoo.cal_type,uoo.ci_sequence_number
746: FROM igs_ps_unit_ofr_opt_all uoo
747: WHERE uoo.uoo_id = cp_uoo_id;
748:
749:
750: TYPE teach_cal_rec IS RECORD(

Line 784: FROM igs_ps_unit_ofr_opt_all a

780: rec_teach_to_load c_teach_to_load%ROWTYPE;
781:
782: CURSOR c_usec IS
783: SELECT a.*, a.rowid
784: FROM igs_ps_unit_ofr_opt_all a
785: WHERE unit_cd = p_usec_rec.unit_cd
786: AND version_number = p_usec_rec.version_number
787: AND ci_sequence_number =p_n_seq_num
788: AND unit_class = p_usec_rec.unit_class

Line 826: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;

822: v_request_id NUMBER;
823:
824:
825: l_c_cal_seq_no c_cal_seq_no%ROWTYPE;
826: l_n_sup_uoo_id igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE;
827: l_c_valid_fail BOOLEAN := FALSE;
828: l_c_var VARCHAR2(1);
829:
830: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 897: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,

893: p_usec_rec.status := 'E';
894: ELSIF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
895:
896: IF p_usec_rec.call_number IS NOT NULL THEN
897: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,
898: p_teach_sequence_num => p_n_seq_num,
899: p_call_number => p_usec_rec.call_number,
900: p_rowid => null ) THEN
901: fnd_message.set_name ( 'IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER' );

Line 1103: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,

1099:
1100:
1101: IF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
1102: IF p_usec_rec.call_number IS NOT NULL THEN
1103: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_c_cal_type,
1104: p_teach_sequence_num => p_n_seq_num,
1105: p_call_number => p_usec_rec.call_number,
1106: p_rowid => c_usec_rec.rowid ) THEN
1107: fnd_message.set_name ( 'IGS', 'IGS_PS_DUPLICATE_CALL_NUMBER' );

Line 1193: igs_ps_unit_ofr_opt_pkg.check_status_transition( p_n_uoo_id => c_usec_rec.uoo_id,

1189:
1190: --Validate unit section status transition
1191: IF p_usec_rec.unit_section_status <> c_usec_rec.unit_section_status THEN
1192: BEGIN
1193: igs_ps_unit_ofr_opt_pkg.check_status_transition( p_n_uoo_id => c_usec_rec.uoo_id,
1194: p_c_old_usec_sts => c_usec_rec.unit_section_status,
1195: p_c_new_usec_sts => p_usec_rec.unit_section_status);
1196: EXCEPTION WHEN OTHERS THEN
1197: p_usec_rec.status := 'E';

Line 1291: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

1287:
1288:
1289: -- Validate Unit Section Credit Points Records before inserting them
1290: PROCEDURE validate_cps ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
1291: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1292: p_insert_update VARCHAR2) AS
1293:
1294: /***********************************************************************************************
1295: Created By : shtatiko

Line 1405: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

1401:
1402: -- Validate Unit Section Referece Records before inserting them
1403: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
1404: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,
1405: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1406: p_insert_update VARCHAR2)
1407: AS
1408: /***********************************************************************************************
1409: Created By : shtatiko

Line 1654: CURSOR c_usec_gs_count ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS

1650: Known limitations,enhancements,remarks:
1651: Change History (in reverse chronological order)
1652: Who When What
1653: ********************************************************************************************** */
1654: CURSOR c_usec_gs_count ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
1655: SELECT COUNT(*) cnt
1656: FROM igs_ps_usec_grd_schm
1657: WHERE uoo_id = cp_uoo_id
1658: AND default_flag = 'Y';

Line 1663: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b

1659: rec_usec_gs_count c_usec_gs_count%ROWTYPE;
1660:
1661: CURSOR c_uoo_id (cp_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type) IS
1662: SELECT uoo_id
1663: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1664: WHERE a.unit_cd = cp_usec_gs_rec.unit_cd
1665: AND a.version_number = cp_usec_gs_rec.version_number
1666: AND a.cal_type = b.cal_type
1667: AND a.ci_sequence_number = b.sequence_number

Line 1709: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

1705:
1706: END post_usec_grd_sch;
1707:
1708: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
1709: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1710: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
1711: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
1712: p_n_building_code IN NUMBER,
1713: p_n_room_code IN NUMBER,

Line 1739: CURSOR c_usec_dates ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS

1735: For the PSP Scheduling Enhancements TD:
1736: Added validations given in TD.
1737: ********************************************************************************************** */
1738:
1739: CURSOR c_usec_dates ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
1740: SELECT unit_section_start_date start_date,
1741: unit_section_end_date end_date
1742: FROM igs_ps_unit_ofr_opt_all
1743: WHERE

Line 1742: FROM igs_ps_unit_ofr_opt_all

1738:
1739: CURSOR c_usec_dates ( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE ) IS
1740: SELECT unit_section_start_date start_date,
1741: unit_section_end_date end_date
1742: FROM igs_ps_unit_ofr_opt_all
1743: WHERE
1744: uoo_id = cp_uoo_id ;
1745: rec_usec_dates c_usec_dates%ROWTYPE;
1746: l_message_name fnd_new_messages.message_name%TYPE;

Line 2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

2707: p_unit_class IN VARCHAR2,
2708: p_uoo_id OUT NOCOPY NUMBER,
2709: p_message OUT NOCOPY VARCHAR2
2710: )AS
2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,

Line 2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,

2708: p_uoo_id OUT NOCOPY NUMBER,
2709: p_message OUT NOCOPY VARCHAR2
2710: )AS
2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS

Line 2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,

2709: p_message OUT NOCOPY VARCHAR2
2710: )AS
2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS
2717: SELECT uoo_id

Line 2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

2710: )AS
2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS
2717: SELECT uoo_id
2718: FROM igs_ps_unit_ofr_opt_all

Line 2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,

2711: CURSOR c_uoo_id (cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS
2717: SELECT uoo_id
2718: FROM igs_ps_unit_ofr_opt_all
2719: WHERE UNIT_CD = cp_unit_cd

Line 2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS

2712: cp_ver_num IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
2713: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS
2717: SELECT uoo_id
2718: FROM igs_ps_unit_ofr_opt_all
2719: WHERE UNIT_CD = cp_unit_cd
2720: AND version_number = cp_ver_num

Line 2718: FROM igs_ps_unit_ofr_opt_all

2714: cp_seq_num IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
2715: cp_loc_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
2716: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE ) IS
2717: SELECT uoo_id
2718: FROM igs_ps_unit_ofr_opt_all
2719: WHERE UNIT_CD = cp_unit_cd
2720: AND version_number = cp_ver_num
2721: AND cal_type = cp_cal_type
2722: AND ci_sequence_number = cp_seq_num

Line 2963: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

2959:
2960: END validate_enr_lmts;
2961:
2962: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
2963: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2964: p_insert_update VARCHAR2) AS
2965:
2966: /***********************************************************************************************
2967: Created By : jbegum

Line 2984: CURSOR c_act (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2980: smvk 25-Nov-2003 Bug # 2833971. Removed the validation associated with displaying error
2981: messages IGS_PS_WLST_MAX_LESS_THAN_ACT and IGS_PS_ENR_MAX_LESS_THAN_ACT.
2982: ********************************************************************************************** */
2983:
2984: CURSOR c_act (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2985: SELECT NVL(enrollment_actual, 0) enrollment_actual,
2986: NVL(auditable_ind,'N') auditable_ind,
2987: waitlist_actual
2988: FROM igs_ps_unit_ofr_opt_all a

Line 2988: FROM igs_ps_unit_ofr_opt_all a

2984: CURSOR c_act (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2985: SELECT NVL(enrollment_actual, 0) enrollment_actual,
2986: NVL(auditable_ind,'N') auditable_ind,
2987: waitlist_actual
2988: FROM igs_ps_unit_ofr_opt_all a
2989: WHERE uoo_id = cp_n_uoo_id;
2990:
2991: CURSOR c_waitlist_allowed (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2992: SELECT waitlist_allowed

Line 2991: CURSOR c_waitlist_allowed (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

2987: waitlist_actual
2988: FROM igs_ps_unit_ofr_opt_all a
2989: WHERE uoo_id = cp_n_uoo_id;
2990:
2991: CURSOR c_waitlist_allowed (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2992: SELECT waitlist_allowed
2993: FROM igs_ps_unit_ofr_pat_all a,
2994: igs_ps_unit_ofr_opt_all b
2995: WHERE b.uoo_id = cp_n_uoo_id

Line 2994: igs_ps_unit_ofr_opt_all b

2990:
2991: CURSOR c_waitlist_allowed (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2992: SELECT waitlist_allowed
2993: FROM igs_ps_unit_ofr_pat_all a,
2994: igs_ps_unit_ofr_opt_all b
2995: WHERE b.uoo_id = cp_n_uoo_id
2996: AND a.unit_cd = b.unit_cd
2997: AND a.version_number = b.version_number
2998: AND a.cal_type = b.cal_type

Line 3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;

3040:
3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;
3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;
3047: l_request_id NUMBER;
3048:

Line 3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;

3041: l_n_enr_max IGS_PS_USEC_LIM_WLST.ENROLLMENT_MAXIMUM%TYPE;
3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;
3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;
3047: l_request_id NUMBER;
3048:
3049: BEGIN

Line 3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;

3042: l_n_wlst_max IGS_PS_USEC_LIM_WLST.MAX_STUDENTS_PER_WAITLIST%TYPE;
3043: l_c_wlst_allowed IGS_PS_USEC_LIM_WLST.WAITLIST_ALLOWED%TYPE;
3044: l_n_enr_act IGS_PS_UNIT_OFR_OPT_ALL.ENROLLMENT_ACTUAL%TYPE;
3045: l_n_wlst_act IGS_PS_UNIT_OFR_OPT_ALL.WAITLIST_ACTUAL%TYPE;
3046: l_c_usec_status IGS_PS_UNIT_OFR_OPT_ALL.UNIT_SECTION_STATUS%TYPE := NULL;
3047: l_request_id NUMBER;
3048:
3049: BEGIN
3050:

Line 3165: UPDATE igs_ps_unit_ofr_opt_all

3161: l_c_usec_status := 'OPEN';
3162: END IF;
3163: END IF;
3164: IF l_c_usec_status IS NOT NULL THEN
3165: UPDATE igs_ps_unit_ofr_opt_all
3166: SET unit_section_status = l_c_usec_status
3167: WHERE uoo_id = p_n_uoo_id;
3168: END IF;
3169: END IF;

Line 3221: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

3217: END validate_usec_el;
3218:
3219: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
3220: p_calling_context IN VARCHAR2,
3221: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3222: p_insert_update VARCHAR2) AS
3223:
3224: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3225: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max

Line 3224: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3220: p_calling_context IN VARCHAR2,
3221: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3222: p_insert_update VARCHAR2) AS
3223:
3224: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3225: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max
3226: FROM igs_ps_unit_ver_all uv,
3227: igs_ps_unit_ofr_opt_all uoo
3228: WHERE uv.unit_cd=uoo.unit_cd

Line 3227: igs_ps_unit_ofr_opt_all uoo

3223:
3224: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3225: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max
3226: FROM igs_ps_unit_ver_all uv,
3227: igs_ps_unit_ofr_opt_all uoo
3228: WHERE uv.unit_cd=uoo.unit_cd
3229: AND uv.version_number=uoo.version_number
3230: AND uoo.uoo_id=cp_uoo_id;
3231: l_c_unit cur_unit_limit%ROWTYPE;

Line 3273: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

3269:
3270: END post_usec_limits;
3271:
3272: PROCEDURE post_uso_ins (p_n_ins_id IN igs_ps_uso_instrctrs.instructor_id%TYPE,
3273: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3274: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,
3275: p_n_index IN NUMBER) AS
3276: /***********************************************************************************************
3277: Created By : jbegum

Line 3297: cp_n_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS

3293: work load is not set up for employment category of instrutor getting imported.
3294: ********************************************************************************************** */
3295:
3296: CURSOR c_check_instrctr_exists(cp_n_instructor_id IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE,
3297: cp_n_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
3298: SELECT COUNT(*)
3299: FROM igs_ps_usec_tch_resp
3300: WHERE instructor_id = cp_n_instructor_id
3301: AND uoo_id = cp_n_uoo_id

Line 3304: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS

3300: WHERE instructor_id = cp_n_instructor_id
3301: AND uoo_id = cp_n_uoo_id
3302: AND ROWNUM = 1;
3303:
3304: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS
3305: SELECT COUNT(*)
3306: FROM IGS_PS_USEC_TCH_RESP
3307: WHERE lead_instructor_flag='Y'
3308: AND uoo_id = cp_n_uoo_id

Line 3315: FROM IGS_PS_UNIT_OFR_OPT_ALL A

3311: CURSOR c_cal_inst (cp_n_uoo_id IN NUMBER) IS
3312: SELECT A.cal_type,
3313: A.ci_sequence_number,
3314: A.unit_section_status
3315: FROM IGS_PS_UNIT_OFR_OPT_ALL A
3316: WHERE A.uoo_id = cp_n_uoo_id;
3317:
3318: CURSOR c_cal_setup IS
3319: SELECT 'x'

Line 3598: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3594: ********************************************************************************************** */
3595:
3596: l_tab_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
3597:
3598: CURSOR c_count_lead (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3599: SELECT count(*)
3600: FROM IGS_PS_USEC_TCH_RESP
3601: WHERE uoo_id = cp_n_uoo_id
3602: AND lead_instructor_flag = 'Y';

Line 3604: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3600: FROM IGS_PS_USEC_TCH_RESP
3601: WHERE uoo_id = cp_n_uoo_id
3602: AND lead_instructor_flag = 'Y';
3603:
3604: CURSOR c_count_percent(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3605: SELECT SUM(PERCENTAGE_ALLOCATION)
3606: FROM IGS_PS_USEC_TCH_RESP
3607: WHERE confirmed_flag = 'Y'
3608: AND uoo_id = cp_n_uoo_id;

Line 3610: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

3606: FROM IGS_PS_USEC_TCH_RESP
3607: WHERE confirmed_flag = 'Y'
3608: AND uoo_id = cp_n_uoo_id;
3609:
3610: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3611: SELECT unit_cd,
3612: version_number
3613: FROM igs_ps_unit_ofr_opt_all
3614: WHERE uoo_id = cp_n_uoo_id

Line 3613: FROM igs_ps_unit_ofr_opt_all

3609:
3610: CURSOR c_unit_dtls (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
3611: SELECT unit_cd,
3612: version_number
3613: FROM igs_ps_unit_ofr_opt_all
3614: WHERE uoo_id = cp_n_uoo_id
3615: AND ROWNUM < 2;
3616:
3617: CURSOR c_null IS

Line 3958: FUNCTION isexists(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

3954: CLOSE C;
3955: END validate_staff_faculty;
3956:
3957:
3958: FUNCTION isexists(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3959: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN AS
3960: /***********************************************************************************************
3961: Created By : sarakshi
3962: Date Created By: 20-Jun-2005.

Line 3990: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;

3986: Who When What
3987: sommukhe 15-NOV-2005 Bug# 4721543, Included the the check for cancelled status of unit section.
3988: ***********************************************************************************************/
3989:
3990: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3994: l_c_message VARCHAR2(30);

Line 3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;

3987: sommukhe 15-NOV-2005 Bug# 4721543, Included the the check for cancelled status of unit section.
3988: ***********************************************************************************************/
3989:
3990: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3994: l_c_message VARCHAR2(30);
3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

3991: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
3992: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3993: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3994: l_c_message VARCHAR2(30);
3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3996:
3997: CURSOR c_uso_chk(p_n_uso_id NUMBER) IS
3998: SELECT schedule_status,abort_flag
3999: FROM igs_ps_usec_occurs_all

Line 4008: FROM igs_ps_unit_ofr_opt_all

4004:
4005: CURSOR c_usec_chk(cp_cal_type IN VARCHAR2,
4006: cp_seq_num IN NUMBER) IS
4007: SELECT abort_flag,unit_section_status
4008: FROM igs_ps_unit_ofr_opt_all
4009: WHERE unit_cd = p_unit_cd
4010: AND version_number = p_version_number
4011: AND cal_type = cp_cal_type
4012: AND ci_sequence_number =cp_seq_num

Line 4018: CURSOR c_pattern_chk(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

4014: AND unit_class = p_unit_class;
4015:
4016: c_usec_chk_rec c_usec_chk%ROWTYPE;
4017:
4018: CURSOR c_pattern_chk(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
4019: cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
4020: cp_version_number igs_ps_unit_ver_all.version_number%type,
4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type
4022: ) IS

Line 4019: cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

4015:
4016: c_usec_chk_rec c_usec_chk%ROWTYPE;
4017:
4018: CURSOR c_pattern_chk(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
4019: cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
4020: cp_version_number igs_ps_unit_ver_all.version_number%type,
4021: cp_unit_cd igs_ps_unit_ver_all.unit_cd%type
4022: ) IS
4023: SELECT 'X'

Line 4112: FROM igs_ps_unit_ofr_opt_all

4108: c_uso_chk_rec c_uso_chk%ROWTYPE;
4109:
4110: CURSOR c_usec_chk(cp_n_uoo_id IN NUMBER) IS
4111: SELECT abort_flag,unit_section_status
4112: FROM igs_ps_unit_ofr_opt_all
4113: WHERE uoo_id = cp_n_uoo_id;
4114: c_usec_chk_rec c_usec_chk%ROWTYPE;
4115:
4116: CURSOR c_pattern_chk(cp_n_uoo_id IN NUMBER) IS

Line 4118: FROM igs_ps_unit_ofr_pat_all pt, igs_ps_unit_ofr_opt_all uoo

4114: c_usec_chk_rec c_usec_chk%ROWTYPE;
4115:
4116: CURSOR c_pattern_chk(cp_n_uoo_id IN NUMBER) IS
4117: SELECT 'X'
4118: FROM igs_ps_unit_ofr_pat_all pt, igs_ps_unit_ofr_opt_all uoo
4119: WHERE uoo.uoo_id= cp_n_uoo_id
4120: AND uoo.unit_cd=pt.unit_cd
4121: AND uoo.version_number=pt.version_number
4122: AND uoo.cal_type= pt.cal_type

Line 4187: FROM igs_ps_unit_ofr_opt_all

4183: Who When What
4184: ***********************************************************************************************/
4185: CURSOR c_usec_chk(cp_n_uoo_id IN NUMBER) IS
4186: SELECT 'X'
4187: FROM igs_ps_unit_ofr_opt_all
4188: WHERE uoo_id = cp_n_uoo_id
4189: AND unit_section_status='NOT_OFFERED';
4190: l_c_var VARCHAR2(1);
4191: BEGIN