APPS.MRP_LAUNCH_PLAN_PK dependencies on MRP_CALENDAR

Line 45: var_new_date := MRP_CALENDAR.NEXT_WORK_DAY(arg_org_id,1,

41:
42: IF arg_plan_horizon IS NULL THEN
43: months := fnd_profile.value('MRP_CUTOFF_DATE_OFFSET');
44:
45: var_new_date := MRP_CALENDAR.NEXT_WORK_DAY(arg_org_id,1,
46: TO_DATE(TO_CHAR(add_months(sysdate, NVL(months, 12)),
47: 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')) ;
48: UPDATE mrp_plans
49: SET curr_cutoff_date = var_new_date,

Line 57: var_new_date := MRP_CALENDAR.NEXT_WORK_DAY(arg_org_id,1,TO_DATE(arg_plan_horizon, 'YYYY/MM/DD HH24:MI:SS')) ;

53: AND compile_designator = arg_compile_desig;
54: COMMIT;
55: ELSE
56:
57: var_new_date := MRP_CALENDAR.NEXT_WORK_DAY(arg_org_id,1,TO_DATE(arg_plan_horizon, 'YYYY/MM/DD HH24:MI:SS')) ;
58: UPDATE mrp_plans
59: SET curr_cutoff_date = var_new_date,
60: plan_completion_date = NULL,
61: data_completion_date = NULL