DBA Data[Home] [Help]

APPS.FTE_LANE_LOADER dependencies on FTE_SCHEDULES

Line 523: p_table => 'FTE_SCHEDULES',

519:
520: ELSIF (l_action = 'DELETE') THEN
521: -- Delete a schedule and modify a lane
522: FTE_LANE_PKG.DELETE_ROW(p_id => g_schedule_tbl(g_schedule_tbl.COUNT).schedules_id,
523: p_table => 'FTE_SCHEDULES',
524: p_code => g_schedule_tbl(g_schedule_tbl.COUNT).voyage_number,
525: p_line_number => p_line_number+i+1,
526: x_status => x_status,
527: x_error_msg => x_error_msg);

Line 538: FROM FTE_SCHEDULES

534: -- to change Schedules_flag for the lane
535: l_lane_id := g_schedule_tbl(g_schedule_tbl.COUNT).lane_id;
536: SELECT COUNT(schedules_id)
537: INTO l_rows
538: FROM FTE_SCHEDULES
539: WHERE LANE_ID = l_lane_id
540: AND NVL(EDITABLE_FLAG,'Y') = 'Y';
541:
542: IF (l_rows = 0) THEN