DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on MRP_CALENDAR

Line 436: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));

432: begin
433: if (n < 1) then
434: return null;
435: end if;
436: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
437: for i in 1..(n-1) loop
438: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
439: end loop;
440: return day;

Line 438: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);

434: return null;
435: end if;
436: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
437: for i in 1..(n-1) loop
438: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
439: end loop;
440: return day;
441: end get_n_previous_working_day;
442: