APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SCH_USEC_INT_ALL

Line 1828: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all usec

1824: l_insv_instructor_id IGS_PS_SH_USEC_OCCURS.instructor_id%TYPE;
1825:
1826: CURSOR cur_sch_int(cp_uso_id IN NUMBER) IS
1827: SELECT uso.transaction_type,uso.schedule_status,uso.int_occurs_id,uso.int_usec_id,uso.tba_status, usec.int_pat_id
1828: FROM igs_ps_sch_int_all uso, igs_ps_sch_usec_int_all usec
1829: WHERE uso.unit_section_occurrence_id=cp_uso_id
1830: AND uso.int_usec_id = usec.int_usec_id
1831: AND uso.transaction_type IN ('REQUEST','UPDATE' ,'CANCEL')
1832: AND uso.abort_flag='N';

Line 1837: FROM igs_ps_sch_usec_int_all

1833: l_cur_sch_int cur_sch_int%ROWTYPE;
1834:
1835: CURSOR cur_int_usec(cp_uoo_id IN NUMBER) IS
1836: SELECT *
1837: FROM igs_ps_sch_usec_int_all
1838: WHERE uoo_Id=cp_uoo_id
1839: AND abort_flag='N';
1840: l_cur_int_usec cur_int_usec%ROWTYPE;
1841:

Line 2265: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_sch_int.int_usec_id;

2261:
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;

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

2592:
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: