APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_FAC_INT

Line 505: INSERT INTO IGS_PS_SCH_FAC_INT (

501:
502: END LOOP;
503:
504: FOR c_fac_rec IN c_fac(p_pat_cur_rec.unit_cd,p_pat_cur_rec.version_number) LOOP
505: INSERT INTO IGS_PS_SCH_FAC_INT (
506: int_fac_id ,
507: int_pat_id ,
508: media_code ,
509: media_description ,

Line 517: (IGS_PS_SCH_FAC_INT_S.NEXTVAL,

513: last_update_date ,
514: last_update_login
515: )
516: VALUES
517: (IGS_PS_SCH_FAC_INT_S.NEXTVAL,
518: p_int_pat_id,
519: c_fac_rec.media_code,
520: c_fac_rec.media_description,
521: g_n_user_id,

Line 4191: DELETE FROM igs_ps_sch_fac_int WHERE int_pat_id=rec_pat.int_pat_id;

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;
4195: