APPS.IGS_PS_GEN_001 dependencies on IGS_PS_US_UNSCHED_CL

Line 2296: FROM igs_ps_us_unsched_cl

2292:
2293: -- 21
2294: CURSOR usec_plushr (cp_uoo_id NUMBER) IS
2295: SELECT *
2296: FROM igs_ps_us_unsched_cl
2297: WHERE uoo_id = cp_uoo_id;
2298:
2299: --22
2300: CURSOR usec_tro (cp_uoo_id NUMBER) IS

Line 3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,

3814:
3815: -- Rollover of unit section plus hour records
3816: FOR usec_plushr_rec IN usec_plushr (p_old_uoo_id ) LOOP
3817: DECLARE
3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,
3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,
3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS

Line 3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,

3815: -- Rollover of unit section plus hour records
3816: FOR usec_plushr_rec IN usec_plushr (p_old_uoo_id ) LOOP
3817: DECLARE
3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,
3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,
3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS
3823: SELECT 'X'

Line 3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,

3816: FOR usec_plushr_rec IN usec_plushr (p_old_uoo_id ) LOOP
3817: DECLARE
3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,
3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,
3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS
3823: SELECT 'X'
3824: FROM igs_ps_us_unsched_cl

Line 3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,

3817: DECLARE
3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,
3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,
3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS
3823: SELECT 'X'
3824: FROM igs_ps_us_unsched_cl
3825: WHERE uoo_id = cp_uoo_id

Line 3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS

3818: CURSOR cur_usec_plushr_new (cp_uoo_id igs_ps_us_unsched_cl.uoo_id%TYPE,
3819: cp_activity_type_id igs_ps_us_unsched_cl.activity_type_id%TYPE,
3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS
3823: SELECT 'X'
3824: FROM igs_ps_us_unsched_cl
3825: WHERE uoo_id = cp_uoo_id
3826: AND activity_type_id = cp_activity_type_id

Line 3824: FROM igs_ps_us_unsched_cl

3820: cp_location_cd igs_ps_us_unsched_cl.location_cd%TYPE,
3821: cp_building_id igs_ps_us_unsched_cl.building_id%TYPE,
3822: cp_room_id igs_ps_us_unsched_cl.room_id%TYPE) IS
3823: SELECT 'X'
3824: FROM igs_ps_us_unsched_cl
3825: WHERE uoo_id = cp_uoo_id
3826: AND activity_type_id = cp_activity_type_id
3827: AND location_cd = cp_location_cd
3828: AND building_id = cp_building_id

Line 3840: igs_ps_us_unsched_cl_pkg.insert_row (

3836:
3837: OPEN cur_usec_plushr_new(p_new_uoo_id,usec_plushr_rec.activity_type_id,usec_plushr_rec.location_cd,usec_plushr_rec.building_id,usec_plushr_rec.room_id);
3838: FETCH cur_usec_plushr_new INTO l_cur_usec_plushr_new;
3839: IF cur_usec_plushr_new%NOTFOUND THEN
3840: igs_ps_us_unsched_cl_pkg.insert_row (
3841: x_rowid => lv_rowid,
3842: x_us_unscheduled_cl_id => l_us_unscheduled_cl_id,
3843: x_uoo_id => p_new_uoo_id,
3844: x_activity_type_id => usec_plushr_rec.activity_type_id,