DBA Data[Home] [Help]

APPS.WIP_WS_PTPKPI_UTIL dependencies on MRP_CALENDAR

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

522: begin
523: if (n < 1) then
524: return null;
525: end if;
526: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
527: for i in 1..(n-1) loop
528: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
529: end loop;
530: return day;

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

524: return null;
525: end if;
526: day := mrp_calendar.PREV_WORK_DAY(p_org_id,1,trunc(p_date));
527: for i in 1..(n-1) loop
528: day := mrp_calendar.PREV_WORK_DAY(207,1,day-1);
529: end loop;
530: return day;
531: end get_n_previous_working_day;
532: