APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_FACLT_ALL

Line 1158: INSERT INTO igs_ps_sch_faclt_all (

1154: -- Insert Facility related Information
1155: FOR facilities_rec IN facilities ( p_usec_occur_rec.unit_section_occurrence_id ) LOOP
1156: BEGIN
1157: l_section_facility_exist := TRUE;
1158: INSERT INTO igs_ps_sch_faclt_all (
1159: facility_id ,
1160: facility_code ,
1161: facility_description ,
1162: org_id ,

Line 1189: INSERT INTO igs_ps_sch_faclt_all (

1185: --If facilities does not exist at section level then pass the unit level value
1186: IF l_section_facility_exist = FALSE THEN
1187: FOR unit_facilities_rec IN unit_facilities ( p_usec_occur_rec.unit_section_occurrence_id ) LOOP
1188: BEGIN
1189: INSERT INTO igs_ps_sch_faclt_all (
1190: facility_id ,
1191: facility_code ,
1192: facility_description ,
1193: org_id ,

Line 3083: tablenames_tbl(3) := 'IGS_PS_SCH_FACLT_ALL';

3079:
3080: -- Collect statistics of the interface table as per standards. Bug # 2710978
3081: tablenames_tbl(1) := 'IGS_PS_SCH_INSTR_ALL';
3082: tablenames_tbl(2) := 'IGS_PS_SCH_MWC_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';

Line 4113: DELETE FROM igs_ps_sch_faclt_all WHERE int_occurs_id=rec_uso.int_occurs_id;

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
4117: DELETE FROM igs_ps_sch_int_all WHERE int_occurs_id=rec_uso.int_occurs_id;