APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_MWC_ALL

Line 851: INSERT INTO igs_ps_sch_mwc_all (

847: RETURN;
848: END IF;
849: CLOSE max_enr_meet_grp;
850:
851: INSERT INTO igs_ps_sch_mwc_all (
852: mwc_group_id ,
853: meet_with_class_group_name ,
854: host_uoo_id ,
855: guest_uoo_id ,

Line 3082: tablenames_tbl(2) := 'IGS_PS_SCH_MWC_ALL';

3078: l_b_return := fnd_installation.get_app_info('IGS', l_c_status, l_c_industry, l_c_schema);
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';

Line 4153: DELETE FROM igs_ps_sch_mwc_all WHERE int_usec_id=rec_usec.int_usec_id;

4149:
4150:
4151: -- Deleting the child of unit section
4152: DELETE FROM igs_ps_sch_x_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;
4153: DELETE FROM igs_ps_sch_mwc_all WHERE int_usec_id=rec_usec.int_usec_id;
4154:
4155: -- Deleting unit section record
4156: DELETE FROM igs_ps_sch_usec_int_all WHERE int_usec_id=rec_usec.int_usec_id;
4157: