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_GEN_001 dependencies on IGS_PS_USEC_OCCURS_ALL

Line 2462: CURSOR cur_occur_new (cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,

2458:
2459: FOR usec_occurs_rec IN usec_occurs (p_old_uoo_Id ) LOOP
2460: DECLARE
2461:
2462: CURSOR cur_occur_new (cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,
2463: cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE) IS
2464: SELECT 'X'
2465: FROM igs_ps_usec_occurs_all
2466: WHERE uoo_id = cp_uoo_id

Line 2463: cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE) IS

2459: FOR usec_occurs_rec IN usec_occurs (p_old_uoo_Id ) LOOP
2460: DECLARE
2461:
2462: CURSOR cur_occur_new (cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,
2463: cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE) IS
2464: SELECT 'X'
2465: FROM igs_ps_usec_occurs_all
2466: WHERE uoo_id = cp_uoo_id
2467: AND occurrence_identifier=cp_occurrence_identifier

Line 2465: FROM igs_ps_usec_occurs_all

2461:
2462: CURSOR cur_occur_new (cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,
2463: cp_occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE) IS
2464: SELECT 'X'
2465: FROM igs_ps_usec_occurs_all
2466: WHERE uoo_id = cp_uoo_id
2467: AND occurrence_identifier=cp_occurrence_identifier
2468: AND ROWNUM = 1 ;
2469: l_cur_occur_new cur_occur_new%ROWTYPE;

Line 2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;

2476: l_n_num_st_days NUMBER;
2477: l_n_num_end_days NUMBER;
2478:
2479:
2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

Line 2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;

2477: l_n_num_end_days NUMBER;
2478:
2479:
2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

Line 2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;

2478:
2479:
2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

Line 2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;

2479:
2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;

Line 2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;

2480: l_c_monday igs_ps_usec_occurs_all.monday%TYPE;
2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;

Line 2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;

2481: l_c_tuesday igs_ps_usec_occurs_all.tuesday%TYPE;
2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;

Line 2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;

2482: l_c_wednesday igs_ps_usec_occurs_all.wednesday%TYPE;
2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;

Line 2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;

2483: l_c_thursday igs_ps_usec_occurs_all.thursday%TYPE;
2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;

Line 2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;

2484: l_c_friday igs_ps_usec_occurs_all.friday%TYPE;
2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;

Line 2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;

2485: l_c_saturday igs_ps_usec_occurs_all.saturday%TYPE;
2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;

Line 2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;

2486: l_c_sunday igs_ps_usec_occurs_all.sunday%TYPE;
2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;

Line 2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;

2487: l_d_start_time igs_ps_usec_occurs_all.start_time%TYPE;
2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;

Line 2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;

2488: l_d_end_time igs_ps_usec_occurs_all.end_time%TYPE;
2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;

Line 2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;

2489: l_c_building_code igs_ps_usec_occurs_all.building_code%TYPE;
2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;

Line 2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;

2490: l_c_room_code igs_ps_usec_occurs_all.room_code%TYPE;
2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;

Line 2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;

2491: l_c_dedicated_building_code igs_ps_usec_occurs_all.dedicated_building_code%TYPE;
2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;

Line 2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;

2492: l_c_dedicated_room_code igs_ps_usec_occurs_all.dedicated_room_code%TYPE;
2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;

Line 2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;

2493: l_c_preferred_building_code igs_ps_usec_occurs_all.preferred_building_code%TYPE;
2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;

Line 2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;

2494: l_c_preferred_room_code igs_ps_usec_occurs_all.preferred_room_code%TYPE;
2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;

Line 2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;

2495: l_c_preferred_region_code igs_ps_usec_occurs_all.preferred_region_code%TYPE;
2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;

Line 2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;

2496: l_c_inst_change_notify igs_ps_usec_occurs_all.inst_notify_ind%TYPE;
2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;

Line 2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;

2497: l_c_attribute_category igs_ps_usec_occurs_all.attribute_category%TYPE;
2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;

Line 2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;

2498: l_c_attribute1 igs_ps_usec_occurs_all.attribute1%TYPE;
2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;

Line 2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;

2499: l_c_attribute2 igs_ps_usec_occurs_all.attribute2%TYPE;
2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;

Line 2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;

2500: l_c_attribute3 igs_ps_usec_occurs_all.attribute3%TYPE;
2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;

Line 2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;

2501: l_c_attribute4 igs_ps_usec_occurs_all.attribute4%TYPE;
2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;

Line 2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;

2502: l_c_attribute5 igs_ps_usec_occurs_all.attribute5%TYPE;
2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;

Line 2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;

2503: l_c_attribute6 igs_ps_usec_occurs_all.attribute6%TYPE;
2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;

Line 2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;

2504: l_c_attribute7 igs_ps_usec_occurs_all.attribute7%TYPE;
2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;

Line 2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;

2505: l_c_attribute8 igs_ps_usec_occurs_all.attribute8%TYPE;
2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;

Line 2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;

2506: l_c_attribute9 igs_ps_usec_occurs_all.attribute9%TYPE;
2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;

Line 2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;

2507: l_c_attribute10 igs_ps_usec_occurs_all.attribute10%TYPE;
2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;

Line 2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;

2508: l_c_attribute11 igs_ps_usec_occurs_all.attribute11%TYPE;
2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;

Line 2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;

2509: l_c_attribute12 igs_ps_usec_occurs_all.attribute12%TYPE;
2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;

Line 2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;

2510: l_c_attribute13 igs_ps_usec_occurs_all.attribute13%TYPE;
2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;
2518: l_occur_roll_allowed BOOLEAN;

Line 2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;

2511: l_c_attribute14 igs_ps_usec_occurs_all.attribute14%TYPE;
2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;
2518: l_occur_roll_allowed BOOLEAN;
2519: BEGIN

Line 2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;

2512: l_c_attribute15 igs_ps_usec_occurs_all.attribute15%TYPE;
2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;
2518: l_occur_roll_allowed BOOLEAN;
2519: BEGIN
2520: l_org_id := igs_ge_gen_003.get_org_id;

Line 2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;

2513: l_c_attribute16 igs_ps_usec_occurs_all.attribute16%TYPE;
2514: l_c_attribute17 igs_ps_usec_occurs_all.attribute17%TYPE;
2515: l_c_attribute18 igs_ps_usec_occurs_all.attribute18%TYPE;
2516: l_c_attribute19 igs_ps_usec_occurs_all.attribute19%TYPE;
2517: l_c_attribute20 igs_ps_usec_occurs_all.attribute20%TYPE;
2518: l_occur_roll_allowed BOOLEAN;
2519: BEGIN
2520: l_org_id := igs_ge_gen_003.get_org_id;
2521:

Line 3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS

3268: AND instructor_id = cp_instructor_id
3269: AND ROWNUM = 1;
3270: l_cur_usec_tchr_new cur_usec_tchr_new%ROWTYPE;
3271:
3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS
3273: SELECT 'X'
3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b
3275: WHERE a.UNIT_SECTION_OCCURRENCE_ID = b.UNIT_SECTION_OCCURRENCE_ID
3276: AND a.uoo_id = cp_uoo_id

Line 3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b

3270: l_cur_usec_tchr_new cur_usec_tchr_new%ROWTYPE;
3271:
3272: CURSOR c_tch_ins(cp_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE,cp_ins_id igs_ps_uso_instrctrs.instructor_id%TYPE) IS
3273: SELECT 'X'
3274: FROM igs_ps_usec_occurs_all a,igs_ps_uso_instrctrs b
3275: WHERE a.UNIT_SECTION_OCCURRENCE_ID = b.UNIT_SECTION_OCCURRENCE_ID
3276: AND a.uoo_id = cp_uoo_id
3277: AND b.instructor_id= cp_ins_id;
3278: c_tch_ins_rec c_tch_ins%ROWTYPE;