APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_AS

Line 5694: l_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE;

5690: l_insert_update VARCHAR2(1);
5691: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5692: l_n_building_id NUMBER;
5693: l_n_room_id NUMBER;
5694: l_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE;
5695: l_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE;
5696:
5697: /* Private Procedures for create_usec_assmnt */
5698: PROCEDURE trim_values ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS

Line 5695: l_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE;

5691: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5692: l_n_building_id NUMBER;
5693: l_n_room_id NUMBER;
5694: l_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE;
5695: l_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE;
5696:
5697: /* Private Procedures for create_usec_assmnt */
5698: PROCEDURE trim_values ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5699: BEGIN

Line 5764: FROM igs_ps_usec_as

5760: -- Check for Update
5761: FUNCTION check_insert_update ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) RETURN VARCHAR2 IS
5762: CURSOR c_usec_as(cp_n_uoo_id NUMBER) IS
5763: SELECT 'X'
5764: FROM igs_ps_usec_as
5765: WHERE uoo_id = cp_n_uoo_id;
5766:
5767: c_usec_as_rec c_usec_as%ROWTYPE;
5768: BEGIN

Line 5893: FROM igs_ps_usec_as

5889:
5890: PROCEDURE assign_defaults ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type, p_insert IN VARCHAR2) IS
5891: CURSOR cur_usec_exam ( cp_uoo_id IN NUMBER) IS
5892: SELECT *
5893: FROM igs_ps_usec_as
5894: WHERE uoo_id = cp_uoo_id;
5895: l_cur_usec_exam cur_usec_exam%ROWTYPE;
5896:
5897: CURSOR cur_room (cp_building_id IN NUMBER, cp_room_cd IN VARCHAR2) IS

Line 5948: IF igs_ps_usec_as_pkg.get_uk_for_validation (x_building_code =>l_n_building_id,

5944:
5945: BEGIN
5946: IF (p_insert_update = 'I') THEN
5947: /* Unique Key Validation */
5948: IF igs_ps_usec_as_pkg.get_uk_for_validation (x_building_code =>l_n_building_id,
5949: x_final_exam_date =>p_usec_assmnt_rec.final_exam_date,
5950: x_location_cd =>p_usec_assmnt_rec.exam_location_cd,
5951: x_room_code =>l_n_room_id,
5952: x_uoo_id =>l_n_uoo_id) THEN

Line 6111: INSERT INTO igs_ps_usec_as

6107: IF p_usec_assmnt_tbl(I).status = 'S' THEN
6108: IF l_insert_update = 'I' THEN
6109: /* Insert Record */
6110:
6111: INSERT INTO igs_ps_usec_as
6112: (unit_section_assessment_id,
6113: uoo_id,
6114: final_exam_date,
6115: exam_start_time,

Line 6127: (igs_ps_usec_as_s.nextval,

6123: last_update_date,
6124: last_update_login
6125: )
6126: VALUES
6127: (igs_ps_usec_as_s.nextval,
6128: l_n_uoo_id,
6129: p_usec_assmnt_tbl(I).final_exam_date,
6130: l_d_exam_start_time,--p_usec_assmnt_tbl(I).final_exam_date,
6131: l_d_exam_end_time,--p_usec_assmnt_tbl(I).exam_start_time,

Line 6153: UPDATE igs_ps_usec_as

6149:
6150: ELSE
6151:
6152: /*Update record*/
6153: UPDATE igs_ps_usec_as
6154: SET final_exam_date = p_usec_assmnt_tbl(I).final_exam_date,
6155: exam_start_time=l_d_exam_start_time,--p_usec_assmnt_tbl(I).exam_start_time,
6156: exam_end_time=l_d_exam_end_time,--p_usec_assmnt_tbl(I).exam_end_time,
6157: location_cd=p_usec_assmnt_tbl(I).exam_location_cd,