DBA Data[Home] [Help]

APPS.IEC_ADMIN_PVT dependencies on IEC_G_CAL_DAYS_B

Line 1462: select day_id into l_day_copyto_id from iec_g_cal_days_b where CALENDAR_ID = p_calendar_id

1458: cursor c_copy is
1459: select CALLABLE_REGION_CODE, START_TIME, END_TIME, TYPE_CODE from iec_g_cal_callable_rgns
1460: where DAY_ID = p_day_id;
1461: BEGIN
1462: select day_id into l_day_copyto_id from iec_g_cal_days_b where CALENDAR_ID = p_calendar_id
1463: and DAY_CODE = 'DAY_OF_WEEK' and PATTERN_CODE = p_copyto_code;
1464:
1465: delete from iec_g_cal_callable_rgns where DAY_ID = l_day_copyto_id;
1466: for v_copy in c_copy loop