DBA Data[Home] [Help]

APPS.MRP_WB_BUCKET_DATES_SC dependencies on MRP_CALENDAR

Line 57: mrp_calendar.select_calendar_defaults(arg_planned_organization,

53: -- Get the calendat defaults
54: -- -------------------------
55: -- dbms_output.put_line('Getting defaults');
56:
57: mrp_calendar.select_calendar_defaults(arg_planned_organization,
58: var_calendar_code,
59: var_exception_set_id);
60: --dbms_output.put_line('Got defaults');
61:

Line 248: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,

244: BEGIN
245:
246: IF counter = 0 THEN
247:
248: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,
249: WEEKLY_BUCKET,
250: var_the_date);
251: END IF;
252: OPEN WEEKS;

Line 271: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,

267: counter := counter - 1;
268: --
269: counter := 0;
270: var_the_date := var_plan_start_date;
271: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,
272: WEEKLY_BUCKET,
273: var_the_date);
274: OPEN HP_WEEKS;
275: LOOP

Line 307: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,

303:
304: BEGIN
305:
306: IF counter = 0 THEN
307: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,
308: PERIODIC_BUCKET,
309: var_the_date);
310: END IF;
311:

Line 331: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,

327: CLOSE PERIODS;
328: --
329: counter := 0;
330: var_the_date := var_plan_start_date;
331: var_the_date := mrp_calendar.prev_work_day(arg_planned_organization,
332: PERIODIC_BUCKET,
333: var_the_date);
334:
335: OPEN PERIODS;

Line 540: var_plan_start_date := mrp_calendar.next_work_day(arg_planned_organization,

536: FROM mrp_plans
537: WHERE compile_designator = arg_compile_designator
538: AND organization_id = arg_organization_id;
539:
540: var_plan_start_date := mrp_calendar.next_work_day(arg_planned_organization,
541: DAILY_BUCKET,
542: var_plan_start_date);
543:
544: