APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_UNIT_SCHEDULES_S

Line 2006: AHL_UNIT_SCHEDULES_S.NEXTVAL,

2002: ATTRIBUTE14,
2003: ATTRIBUTE15
2004: ) VALUES
2005: (
2006: AHL_UNIT_SCHEDULES_S.NEXTVAL,
2007: p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2008: p_x_flight_schedules_tbl(i).SEGMENT,
2009: p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,
2010: p_x_flight_schedules_tbl(i).DEPARTURE_ORG_ID,

Line 2043: SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;

2039: p_x_flight_schedules_tbl(i).ATTRIBUTE13,
2040: p_x_flight_schedules_tbl(i).ATTRIBUTE14,
2041: p_x_flight_schedules_tbl(i).ATTRIBUTE15
2042: );
2043: SELECT AHL_UNIT_SCHEDULES_S.CURRVAL INTO p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID FROM DUAL ;
2044: END IF;
2045:
2046: -- Check if overlaps are occurring. If there is any overlap, show warning.
2047: l_overlap_us_count := 0;

Line 2359: UPDATE AHL_UNIT_SCHEDULES SET

2355: OPEN old_flight_rec_csr(p_x_flight_schedules_tbl(i).unit_schedule_id);
2356: FETCH old_flight_rec_csr INTO l_old_flight_rec;
2357:
2358: -- Update the record
2359: UPDATE AHL_UNIT_SCHEDULES SET
2360: UNIT_SCHEDULE_ID = p_x_flight_schedules_tbl(i).UNIT_SCHEDULE_ID,
2361: FLIGHT_NUMBER = p_x_flight_schedules_tbl(i).FLIGHT_NUMBER,
2362: SEGMENT = p_x_flight_schedules_tbl(i).SEGMENT,
2363: DEPARTURE_DEPT_ID = p_x_flight_schedules_tbl(i).DEPARTURE_DEPT_ID,