APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_US_UNSCHED_CL

Line 8190: IF igs_ps_us_unsched_cl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

8186: BEGIN
8187:
8188: IF p_insert_update = 'I' THEN
8189: -- Unique Key Validation
8190: IF igs_ps_us_unsched_cl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
8191: x_activity_type_id => l_n_activity_id,
8192: x_location_cd => p_usec_plus_hr_rec.activity_location_cd,
8193: x_building_id => l_n_building_id,
8194: x_room_id => l_n_room_id ) THEN

Line 8204: igs_ps_us_unsched_cl_pkg.check_constraints('NUMBER_OF_STUDENTS', p_usec_plus_hr_rec.number_of_students);

8200:
8201: -- Check Constraints
8202:
8203: BEGIN
8204: igs_ps_us_unsched_cl_pkg.check_constraints('NUMBER_OF_STUDENTS', p_usec_plus_hr_rec.number_of_students);
8205: EXCEPTION
8206: WHEN OTHERS THEN
8207: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999999999','NUMBER_OF_STUDENTS','LEGACY_TOKENS',TRUE);
8208: p_usec_plus_hr_rec.status :='E';

Line 8212: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_STUDENT', p_usec_plus_hr_rec.hours_per_student);

8208: p_usec_plus_hr_rec.status :='E';
8209: END;
8210:
8211: BEGIN
8212: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_STUDENT', p_usec_plus_hr_rec.hours_per_student);
8213: EXCEPTION
8214: WHEN OTHERS THEN
8215: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','HOURS_PER_STUDENT','LEGACY_TOKENS',TRUE);
8216: p_usec_plus_hr_rec.status :='E';

Line 8220: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_FACULTY', p_usec_plus_hr_rec.hours_per_faculty);

8216: p_usec_plus_hr_rec.status :='E';
8217: END;
8218:
8219: BEGIN
8220: igs_ps_us_unsched_cl_pkg.check_constraints('HOURS_PER_FACULTY', p_usec_plus_hr_rec.hours_per_faculty);
8221: EXCEPTION
8222: WHEN OTHERS THEN
8223: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_999D99','HOURS_PER_FACULTY','LEGACY_TOKENS',TRUE);
8224: p_usec_plus_hr_rec.status :='E';

Line 8274: FROM igs_ps_us_unsched_cl

8270: FUNCTION check_insert_update ( p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) RETURN VARCHAR2 IS
8271:
8272: CURSOR c_plus_hr IS
8273: SELECT 'X'
8274: FROM igs_ps_us_unsched_cl
8275: WHERE uoo_id = l_n_uoo_id
8276: AND activity_type_id = l_n_activity_id
8277: AND location_cd = p_usec_plus_hr_rec.activity_location_cd
8278: AND building_id = l_n_building_id

Line 8301: FROM IGS_PS_US_UNSCHED_CL

8297:
8298: PROCEDURE Assign_default(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type,p_insert_update IN VARCHAR2) AS
8299: CURSOR cur_plus_hr IS
8300: SELECT *
8301: FROM IGS_PS_US_UNSCHED_CL
8302: WHERE uoo_id = l_n_uoo_id
8303: AND activity_type_id = l_n_activity_id
8304: AND location_cd = p_usec_plus_hr_rec.activity_location_cd
8305: AND building_id = l_n_building_id

Line 8482: INSERT INTO IGS_PS_US_UNSCHED_CL(

8478:
8479: IF p_usec_plus_hr_tbl(I).status = 'S' THEN
8480:
8481: IF l_insert_update = 'I' THEN
8482: INSERT INTO IGS_PS_US_UNSCHED_CL(
8483: us_unscheduled_cl_id,
8484: uoo_id,
8485: activity_type_id,
8486: location_cd,

Line 8499: igs_ps_us_unsched_cl_s.NEXTVAL,

8495: last_updated_by,
8496: last_update_date,
8497: last_update_login )
8498: VALUES (
8499: igs_ps_us_unsched_cl_s.NEXTVAL,
8500: l_n_uoo_id,
8501: l_n_activity_id,
8502: p_usec_plus_hr_tbl(I).activity_location_cd,
8503: l_n_building_id,

Line 8527: UPDATE IGS_PS_US_UNSCHED_CL SET

8523: END IF;
8524:
8525: ELSE
8526:
8527: UPDATE IGS_PS_US_UNSCHED_CL SET
8528: number_of_students = p_usec_plus_hr_tbl(I).number_of_students,
8529: hours_per_student = p_usec_plus_hr_tbl(I).hours_per_student,
8530: hours_per_faculty = p_usec_plus_hr_tbl(I).hours_per_faculty,
8531: instructor_id = l_n_ins_id,