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_USEC_SCHEDULE dependencies on IGS_AD_ROOM

Line 2263: FROM igs_ad_room

2259:
2260: -- Cursor to get room information to be exported to flat file
2261: CURSOR c_room IS
2262: SELECT room_id,building_id,room_cd,description,primary_use_cd,capacity,closed_ind
2263: FROM igs_ad_room
2264: ORDER BY 1;
2265:
2266: -- Cursor to get building information to be exported to flat file
2267: CURSOR c_building IS

Line 2684: CURSOR c_room_exists (cp_n_room_id igs_ad_room_all.room_id%TYPE) IS

2680: FROM igs_ad_building_all
2681: WHERE building_id = cp_n_building_id
2682: AND ROWNUM < 2 ;
2683:
2684: CURSOR c_room_exists (cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
2685: SELECT 'x'
2686: FROM igs_ad_room_all
2687: WHERE room_id = cp_n_room_id
2688: AND ROWNUM < 2 ;

Line 2686: FROM igs_ad_room_all

2682: AND ROWNUM < 2 ;
2683:
2684: CURSOR c_room_exists (cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
2685: SELECT 'x'
2686: FROM igs_ad_room_all
2687: WHERE room_id = cp_n_room_id
2688: AND ROWNUM < 2 ;
2689:
2690: CURSOR c_bldg_room_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE,

Line 2691: cp_n_room_id igs_ad_room_all.room_id%TYPE) IS

2687: WHERE room_id = cp_n_room_id
2688: AND ROWNUM < 2 ;
2689:
2690: CURSOR c_bldg_room_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE,
2691: cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
2692: SELECT 'x'
2693: FROM igs_ad_room_all
2694: WHERE building_id = cp_n_building_id
2695: AND room_id = cp_n_room_id

Line 2693: FROM igs_ad_room_all

2689:
2690: CURSOR c_bldg_room_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE,
2691: cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
2692: SELECT 'x'
2693: FROM igs_ad_room_all
2694: WHERE building_id = cp_n_building_id
2695: AND room_id = cp_n_room_id
2696: AND ROWNUM < 2 ;
2697:

Line 4398: CURSOR rom_desc(cp_rom_code igs_ad_room_all.room_id%TYPE) IS

4394: SELECT description
4395: FROM igs_ad_building_all
4396: WHERE building_id = cp_bld_code;
4397:
4398: CURSOR rom_desc(cp_rom_code igs_ad_room_all.room_id%TYPE) IS
4399: SELECT description
4400: FROM igs_ad_room_all
4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;

Line 4400: FROM igs_ad_room_all

4396: WHERE building_id = cp_bld_code;
4397:
4398: CURSOR rom_desc(cp_rom_code igs_ad_room_all.room_id%TYPE) IS
4399: SELECT description
4400: FROM igs_ad_room_all
4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;

Line 4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;

4399: SELECT description
4400: FROM igs_ad_room_all
4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;
4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;

Line 4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;

4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;
4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;
4408:
4409: CURSOR cur_lookup_meaning (cp_lookup_type igs_lookup_values.lookup_type%TYPE,

Line 4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;

4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;
4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;
4408:
4409: CURSOR cur_lookup_meaning (cp_lookup_type igs_lookup_values.lookup_type%TYPE,
4410: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
4411: SELECT meaning