APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_LOC_INT

Line 472: INSERT INTO IGS_PS_SCH_LOC_INT(

468: -- If sections does not exists for the pattern then insert the location and facilities
469: IF p_unit_status IS NOT NULL THEN
470:
471: FOR c_loc_rec IN c_loc(p_pat_cur_rec.unit_cd,p_pat_cur_rec.version_number) LOOP
472: INSERT INTO IGS_PS_SCH_LOC_INT(
473: int_loc_id ,
474: int_pat_id ,
475: location_code ,
476: location_description,

Line 487: (IGS_PS_SCH_LOC_INT_S.NEXTVAL,

483: last_updated_by ,
484: last_update_date ,
485: last_update_login )
486: VALUES
487: (IGS_PS_SCH_LOC_INT_S.NEXTVAL,
488: p_int_pat_id,
489: c_loc_rec.location_cd,
490: c_loc_rec.location_description,
491: c_loc_rec.building_cd,

Line 4190: DELETE FROM igs_ps_sch_loc_int WHERE int_pat_id=rec_pat.int_pat_id;

4186: END IF;
4187:
4188:
4189: -- Deleting the child of patterns
4190: DELETE FROM igs_ps_sch_loc_int WHERE int_pat_id=rec_pat.int_pat_id;
4191: DELETE FROM igs_ps_sch_fac_int WHERE int_pat_id=rec_pat.int_pat_id;
4192:
4193: -- Deleting pattern record
4194: DELETE FROM igs_ps_sch_pat_int WHERE int_pat_id=rec_pat.int_pat_id;