725: IS
726: SELECT calendar_type, calendar_code, decode(calendar_type,
727: 1, initcap(calendar_code),
728: calendar_code) op_cal_code
729: FROM msd_dp_calendars
730: WHERE demand_plan_id = p_demand_plan_id
731: and calendar_type <> 1; -- To Prevent the validation of Gregorian calendar because validation of Gregorian Calendar is not required
732:
733:
2258: CURSOR c_mfg_calendar
2259: IS
2260: select mdc.calendar_type
2261: from
2262: msd_dp_calendars mdc ,
2263: msd_demand_plans mdp
2264: where
2265: mdc.demand_plan_id = mdp.demand_plan_id
2266: and mdp.liab_plan_id = p_plan_id
2325:
2326: BEGIN
2327:
2328: delete from msd_time_lb where CALENDAR_CODE in
2329: ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id)
2330: ;
2331:
2332: commit ;
2333:
2355: DAY_DESCRIPTION,
2356: WORKING_DAY )
2357: select * from msd_sr_time_lb_v
2358: where CALENDAR_CODE
2359: in ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id and calendar_type <> 1 ) ;
2360:
2361: commit ;
2362:
2363: