APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SCH_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 1842: l_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;

1838: WHERE uoo_Id=cp_uoo_id
1839: AND abort_flag='N';
1840: l_cur_int_usec cur_int_usec%ROWTYPE;
1841:
1842: l_transaction_type igs_ps_sch_int_all.transaction_type%TYPE;
1843:
1844: --
1845: BEGIN
1846:

Line 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;

2260: END IF;
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: