APPS.MSC_RP_RELEASE_PUB dependencies on MSC_CALENDAR

Line 529: trunc(msc_calendar.date_offset(p_org_id,p_inst_id,1,p_implement_Date,

525: -- the date after offsetting
526: -- the lead time from the implement_date
527: lv_date := p_implement_date -
528: (trunc(p_implement_Date)-
529: trunc(msc_calendar.date_offset(p_org_id,p_inst_id,1,p_implement_Date,
530: -1 * ln_pp_lead_time)));
531:
532: --if the Receiving calendar is not null
533: --validate the date against the Receiving Calendar

Line 537: lv_date := lv_date - (trunc(lv_date) - trunc(msc_calendar.PREV_WORK_DAY(p_receiving_calendar,p_inst_id, trunc(lv_date))));

533: --validate the date against the Receiving Calendar
534: --else validate the date against the
535: -- Org Manufacturing Calendar
536: if p_receiving_calendar is not null then
537: lv_date := lv_date - (trunc(lv_date) - trunc(msc_calendar.PREV_WORK_DAY(p_receiving_calendar,p_inst_id, trunc(lv_date))));
538: else
539: lv_date := msc_calendar.PREV_WORK_DAY(p_org_id,p_inst_id,1,trunc(lv_date));
540: end if;
541: return greatest(trunc(sysdate),lv_date);

Line 539: lv_date := msc_calendar.PREV_WORK_DAY(p_org_id,p_inst_id,1,trunc(lv_date));

535: -- Org Manufacturing Calendar
536: if p_receiving_calendar is not null then
537: lv_date := lv_date - (trunc(lv_date) - trunc(msc_calendar.PREV_WORK_DAY(p_receiving_calendar,p_inst_id, trunc(lv_date))));
538: else
539: lv_date := msc_calendar.PREV_WORK_DAY(p_org_id,p_inst_id,1,trunc(lv_date));
540: end if;
541: return greatest(trunc(sysdate),lv_date);
542: exception when others then
543: return null;

Line 606: trunc(msc_calendar.date_offset(p_org_id,p_inst_id,1,

602: -- after offsetting the lead time from the
603: --implement_dock_date
604: lv_date := p_implement_Dock_Date-
605: (trunc(p_implement_dock_date)-
606: trunc(msc_calendar.date_offset(p_org_id,p_inst_id,1,
607: p_implement_dock_date,-1 * x_intransit_lead_time)));
608: -- if intransit calendar is not null then validate the
609: -- date against the intransit calendar
610: -- else validate the date against the shipping calendar.

Line 613: trunc(msc_calendar.PREV_WORK_DAY(p_intransit_calendar, p_inst_id, trunc(lv_date))));

609: -- date against the intransit calendar
610: -- else validate the date against the shipping calendar.
611: if p_intransit_calendar is not null then
612: lv_date := lv_date - (trunc(lv_date) -
613: trunc(msc_calendar.PREV_WORK_DAY(p_intransit_calendar, p_inst_id, trunc(lv_date))));
614: else
615: lv_date := lv_date - (trunc(lv_date) -
616: trunc(msc_calendar.PREV_WORK_DAY(p_ship_calendar, p_inst_id, trunc(lv_date))));
617: end if;

Line 616: trunc(msc_calendar.PREV_WORK_DAY(p_ship_calendar, p_inst_id, trunc(lv_date))));

612: lv_date := lv_date - (trunc(lv_date) -
613: trunc(msc_calendar.PREV_WORK_DAY(p_intransit_calendar, p_inst_id, trunc(lv_date))));
614: else
615: lv_date := lv_date - (trunc(lv_date) -
616: trunc(msc_calendar.PREV_WORK_DAY(p_ship_calendar, p_inst_id, trunc(lv_date))));
617: end if;
618: return greatest(trunc(sysdate),lv_date);
619: else
620: return null;