APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_PREFS_SCH_INT_ALL

Line 1083: INSERT INTO igs_ps_prefs_sch_int_all (

1079: -- Insert Ref Cd Information
1080: FOR ref_cd_rec IN ref_cd( p_usec_occur_rec.unit_section_occurrence_id ) LOOP
1081: BEGIN
1082: -- The fields which are passed as NULL are OBSOLETE columns as per the Modified Scheduling Interface DLD 1.0
1083: INSERT INTO igs_ps_prefs_sch_int_all (
1084: int_prefs_id ,
1085: int_occurs_id ,
1086: reference_cd ,
1087: reference_code_description ,

Line 3087: tablenames_tbl(7) := 'IGS_PS_PREFS_SCH_INT_ALL';

3083: tablenames_tbl(3) := 'IGS_PS_SCH_FACLT_ALL';
3084: tablenames_tbl(4) := 'IGS_PS_SCH_X_USEC_INT_ALL';
3085: tablenames_tbl(5) := 'IGS_PS_SCH_USEC_INT_ALL';
3086: tablenames_tbl(6) := 'IGS_PS_SCH_INT_ALL';
3087: tablenames_tbl(7) := 'IGS_PS_PREFS_SCH_INT_ALL';
3088: tablenames_tbl(8) := 'IGS_PS_SCH_HDR_INT_ALL';
3089:
3090: FOR i IN 1.. tablenames_tbl.LAST
3091: LOOP

Line 4112: DELETE FROM igs_ps_prefs_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;

4108: l_c_occurrence_exists:=TRUE;
4109: END IF;
4110:
4111: -- Deleting the child of the occurrence
4112: DELETE FROM igs_ps_prefs_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4113: DELETE FROM igs_ps_sch_faclt_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4114: DELETE FROM igs_ps_sch_instr_all WHERE int_occurs_id=rec_uso.int_occurs_id;
4115:
4116: --Deleting the occurrence record