DBA Data[Home] [Help]

APPS.MRP_WB_BUCKET_DATES dependencies on MRP_CALENDAR

Line 46: mrp_calendar.select_calendar_defaults(arg_organization_id,

42:
43: -- -------------------------
44: -- Get the calendat defaults
45: -- -------------------------
46: mrp_calendar.select_calendar_defaults(arg_organization_id,
47: var_calendar_code,
48: var_exception_set_id);
49:
50: -- ----------------------------------------------

Line 196: var_the_date := mrp_calendar.prev_work_day(arg_organization_id,

192:
193: IF counter = 0 THEN
194:
195: dbms_output.put_line('Weeks only');
196: var_the_date := mrp_calendar.prev_work_day(arg_organization_id,
197: WEEKLY_BUCKET,
198: var_the_date);
199: dbms_output.put_line('Reset var_the_date to:'||var_the_date);
200: END IF;

Line 238: var_the_date := mrp_calendar.prev_work_day(arg_organization_id,

234: BEGIN
235:
236: IF counter = 0 THEN
237: dbms_output.put_line('Periodic only');
238: var_the_date := mrp_calendar.prev_work_day(arg_organization_id,
239: PERIODIC_BUCKET,
240: var_the_date);
241: dbms_output.put_line('Reset var_the_date to:'||var_the_date);
242: END IF;

Line 402: var_plan_start_date := mrp_calendar.next_work_day(arg_organization_id,

398: FROM mrp_plans
399: WHERE compile_designator = arg_compile_designator
400: AND organization_id = arg_organization_id;
401:
402: var_plan_start_date := mrp_calendar.next_work_day(arg_organization_id,
403: DAILY_BUCKET,
404: var_plan_start_date);
405:
406: dbms_output.put_line('Plan start date is: '||var_plan_start_date);