APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_SCH_USEC_INT_ALL

Line 3264: FROM igs_ps_sch_usec_int_all

3260: cp_seq_num IN NUMBER,
3261: cp_location_cd IN VARCHAR2,
3262: cp_unit_class IN VARCHAR2) IS
3263: SELECT *
3264: FROM igs_ps_sch_usec_int_all
3265: WHERE unit_cd=cp_unit_cd
3266: AND version_number=cp_version_number
3267: AND calendar_type =cp_cal_type
3268: AND sequence_number= cp_seq_num

Line 4030: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_int_usec.int_usec_id;

4026: IF p_calling_context = 'S' THEN
4027: OPEN cur_int_usec(p_usec_rec.unit_cd,p_usec_rec.version_number,l_c_cal_type,l_n_seq_num,p_usec_rec.location_cd, p_usec_rec.unit_class);
4028: FETCH cur_int_usec INTO l_cur_int_usec;
4029: IF cur_int_usec%FOUND THEN
4030: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_int_usec.int_usec_id;
4031: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_usec.int_pat_id;
4032: END IF;
4033:
4034: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN