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.

[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_OCCURS

Line 23: -- igs_ps_usec_occurs_pkg.insert_row

19: -- This is as per Assessment Item Build. Bug# 2829291;
20: --
21: --sarakshi 24-Apr-2003 Enh#2858431,added procedure change_unit_section_status ,also modified the call to igs_ps_usec_ocur_ref_pkg.insert_row
22: --jbegum 21-Apr-2003 Enh bug#2833850 added columns preferred_region_code and no_set_day_ind to the call of
23: -- igs_ps_usec_occurs_pkg.insert_row
24: --sarakshi 23-Feb-2003 Enh#2797116,modified cursor gc_coo_rec in crsp_ins_crs_ver procedure.Also modified
25: -- cursor c_coo_new in crsp_ins_coi_rec procedure.
26: --vvutukur 01-Nov-2002 Enh#2636716.Modifications done in crsp_ins_unit_section.
27: --vvutukur 28-Oct-2002 Enh#2613933.Modifications done in crsp_ins_unit_section.

Line 2156: FROM igs_ps_usec_occurs

2152:
2153: --1
2154: CURSOR usec_occurs( p_uoo_id NUMBER ) IS
2155: SELECT *
2156: FROM igs_ps_usec_occurs
2157: WHERE uoo_id = p_uoo_id;
2158:
2159: --2
2160: CURSOR usec_occurs_refcd( p_usec_id NUMBER ) IS

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 2552: -- igs_ps_usec_occurs_pkg.insert_row

2548: END IF;
2549: END IF;
2550:
2551: -- As part of bug#2833850 added columns preferred_region_code and no_set_day_ind to the call of
2552: -- igs_ps_usec_occurs_pkg.insert_row
2553:
2554: --Added as a part of scheduling Enhancement IGS.M
2555: l_occur_roll_allowed := TRUE;
2556:

Line 2741: igs_ps_usec_occurs_pkg.insert_row (

2737: OPEN cur_occur_new(p_new_uoo_id,usec_occurs_rec.occurrence_identifier);
2738: FETCH cur_occur_new INTO l_cur_occur_new;
2739: IF cur_occur_new%NOTFOUND THEN
2740:
2741: igs_ps_usec_occurs_pkg.insert_row (
2742: x_rowid => lv_rowid,
2743: x_unit_section_occurrence_id=> l_usec_id,
2744: x_uoo_id => p_new_uoo_id ,
2745: x_monday => l_c_monday,

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;