APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_AD_ROOM

Line 5791: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS

5787: WHERE building_cd = cp_building_cd
5788: AND location_cd = cp_location_cd;
5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
5791: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
5792: SELECT room_id
5793: FROM igs_ad_room_all
5794: WHERE room_cd = cp_room_cd
5795: AND building_id = cp_building_id;

Line 5793: FROM igs_ad_room_all

5789:
5790: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
5791: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
5792: SELECT room_id
5793: FROM igs_ad_room_all
5794: WHERE room_cd = cp_room_cd
5795: AND building_id = cp_building_id;
5796:
5797:

Line 5899: FROM igs_ad_room

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
5898: SELECT room_id
5899: FROM igs_ad_room
5900: WHERE room_cd=cp_room_cd
5901: AND building_id=cp_building_id;
5902:
5903: BEGIN

Line 5980: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_id ) THEN

5976: END IF;
5977:
5978: -- Check for the existence of Rooms
5979: IF l_n_room_id IS NOT NULL THEN
5980: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_id ) THEN
5981: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);
5982: p_usec_assmnt_rec.status := 'E';
5983: END IF;
5984: END IF;

Line 8127: FROM igs_ad_room

8123: AND building_cd=cp_building_code;
8124:
8125: CURSOR cur_room(cp_building_id IN VARCHAR2,cp_room_cd IN VARCHAR2) IS
8126: SELECT room_id
8127: FROM igs_ad_room
8128: WHERE building_id=cp_building_id
8129: AND room_cd= cp_room_cd;
8130:
8131: BEGIN

Line 8253: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_id ) THEN

8249: p_usec_plus_hr_rec.status := 'E';
8250: END IF;
8251:
8252: -- Check for existence of Room Code Code
8253: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_id ) THEN
8254: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);
8255: p_usec_plus_hr_rec.status := 'E';
8256: END IF;
8257: