APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_AD_ROOM

Line 6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS

6174: FROM igs_ad_building_all
6175: WHERE building_cd = cp_building_cd;
6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
6179: SELECT room_id
6180: FROM igs_ad_room_all
6181: WHERE
6182: room_cd = cp_room_cd AND

Line 6180: FROM igs_ad_room_all

6176:
6177: CURSOR c_room_id ( cp_building_id igs_ad_building_all.building_id%TYPE,
6178: cp_room_cd igs_ad_room_all.room_cd%TYPE ) IS
6179: SELECT room_id
6180: FROM igs_ad_room_all
6181: WHERE
6182: room_cd = cp_room_cd AND
6183: building_id = cp_building_id;
6184:

Line 6417: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_code ) THEN

6413: END IF;
6414:
6415: -- Check for the existence of Rooms, if their codes are passed
6416: IF l_n_room_code IS NOT NULL THEN
6417: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_room_code ) THEN
6418: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'ROOM_CODE', 'LEGACY_TOKENS', FALSE);
6419: p_uso_rec.status := 'E';
6420: END IF;
6421: END IF;

Line 6424: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_dedicated_room_code ) THEN

6420: END IF;
6421: END IF;
6422:
6423: IF l_n_dedicated_room_code IS NOT NULL THEN
6424: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_dedicated_room_code ) THEN
6425: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', igs_ps_validate_lgcy_pkg.get_lkup_meaning('DEDICATED', 'LEGACY_TOKENS') || ' ' ||
6426: igs_ps_validate_lgcy_pkg.get_lkup_meaning('ROOM_CODE', 'LEGACY_TOKENS'), NULL, FALSE);
6427: p_uso_rec.status := 'E';
6428: END IF;

Line 6432: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_preferred_room_code ) THEN

6428: END IF;
6429: END IF;
6430:
6431: IF l_n_preferred_room_code IS NOT NULL THEN
6432: IF NOT igs_ad_room_pkg.get_pk_for_validation ( l_n_preferred_room_code ) THEN
6433: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', igs_ps_validate_lgcy_pkg.get_lkup_meaning('PREFERRED', 'LEGACY_TOKENS') || ' ' ||
6434: igs_ps_validate_lgcy_pkg.get_lkup_meaning('ROOM_CODE', 'LEGACY_TOKENS'), NULL, FALSE);
6435: p_uso_rec.status := 'E';
6436: END IF;

Line 6489: FROM igs_ad_room

6485: l_cur_usec_ocurs cur_usec_ocurs%ROWTYPE;
6486:
6487: CURSOR cur_room (cp_building_id IN NUMBER, cp_room_cd IN VARCHAR2) IS
6488: SELECT room_id
6489: FROM igs_ad_room
6490: WHERE room_cd=cp_room_cd
6491: AND building_id=cp_building_id;
6492:
6493: BEGIN