APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SCH_PAT_INT

Line 2266: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_sch_int.int_pat_id;

2262: --Update the interface record transaction type and schedule status
2263: IF p_uso_rec.status = 'S' THEN
2264: UPDATE igs_ps_sch_int_all set transaction_type='COMPLETE',schedule_status=NVL(p_schedule_status,schedule_status),import_done_flag='Y' WHERE int_occurs_id = l_cur_sch_int.int_occurs_id;
2265: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_sch_int.int_usec_id;
2266: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_sch_int.int_pat_id;
2267: END IF;
2268:
2269: END IF;
2270: CLOSE cur_sch_int;

Line 2597: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_usec.int_pat_id;

2593: OPEN cur_int_usec(p_n_uoo_id);
2594: FETCH cur_int_usec INTO l_cur_int_usec;
2595: IF cur_int_usec%FOUND THEN
2596: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_int_usec.int_usec_id;
2597: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_usec.int_pat_id;
2598: END IF;
2599: CLOSE cur_int_usec;
2600:
2601: END IF;