APPS.MSC_REL_WF dependencies on MSC_CALENDAR

Line 2226: msc_calendar_dates cal1,

2222: cal2.calendar_date
2223: from msc_supplies s,
2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,
2228: msc_trading_partners mtp
2229: where s.plan_id = p_plan_id
2230: and s.transaction_id =p_transaction_id

Line 2227: msc_calendar_dates cal2,

2223: from msc_supplies s,
2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,
2228: msc_trading_partners mtp
2229: where s.plan_id = p_plan_id
2230: and s.transaction_id =p_transaction_id
2231: and s.plan_id = mp.plan_id

Line 2500: if P_calendar_code is null or p_calendar_code = MSC_CALENDAR.FOC then

2496:
2497: begin
2498:
2499:
2500: if P_calendar_code is null or p_calendar_code = MSC_CALENDAR.FOC then
2501:
2502: -- shipping/receiving calendar hierarchy [if no CRC, then 24x7]
2503: p_return_date := p_date + nvl(p_lead_time,0);
2504:

Line 2507: p_return_date := msc_calendar.date_offset

2503: p_return_date := p_date + nvl(p_lead_time,0);
2504:
2505: else
2506:
2507: p_return_date := msc_calendar.date_offset
2508: ( p_calendar_code
2509: , p_inst_id
2510: , p_date
2511: , nvl(p_lead_time,0)

Line 2515: -- msc_calendar.date_offset will remove the timestamp

2511: , nvl(p_lead_time,0)
2512: , null -- association_type
2513: );
2514:
2515: -- msc_calendar.date_offset will remove the timestamp
2516: if to_char(p_return_date,'HH24:MI:SS') = '00:00:00' and
2517: to_char(p_date,'HH24:MI:SS') <> '00:00:00' then
2518: p_return_date := to_date(to_char(p_return_date, 'MM/DD/RR')||' '||
2519: to_char(p_date,'HH24:MI:SS'),

Line 2547: v_vic_cal_code msc_calendars.calendar_code%type;

2543: v_planned_arrival_date DateArr;
2544: v_earliest_date DateArr;
2545: v_request_date DateArr;
2546: v_schedule_date DateArr;
2547: v_vic_cal_code msc_calendars.calendar_code%type;
2548: v_association_type number;
2549:
2550: cursor so_c is
2551: select order_number,

Line 2643: v_vic_cal_code := msc_calendar.get_calendar_code

2639: FETCH so_c INTO so_rec;
2640: CLOSE so_c;
2641:
2642: begin
2643: v_vic_cal_code := msc_calendar.get_calendar_code
2644: ( p_inst_id
2645: , null
2646: , null
2647: , null

Line 2652: , MSC_CALENDAR.VIC

2648: , null
2649: , 4 -- partner type [in transit]
2650: , null
2651: , so_rec.ship_method
2652: , MSC_CALENDAR.VIC
2653: , v_association_type
2654: );
2655: exception when others then
2656: v_vic_cal_code := null;

Line 3358: -- 6142627, msc_calendar.date_offset will round up offset_days

3354: p_new_date date;
3355: p_new_offset number;
3356: p_minutes number := 0;
3357: BEGIN
3358: -- 6142627, msc_calendar.date_offset will round up offset_days
3359: if ceil(p_offset_days) <> p_offset_days then
3360: p_new_offset := floor(p_offset_days);
3361: else
3362: p_new_offset := p_offset_days;

Line 3365: p_new_date := msc_calendar.date_offset(

3361: else
3362: p_new_offset := p_offset_days;
3363: end if;
3364:
3365: p_new_date := msc_calendar.date_offset(
3366: p_org_id,
3367: p_instance_id,
3368: p_bucket_type,
3369: p_date,

Line 3374: -- msc_calendar.date_offset will remove the timestamp

3370: p_new_offset);
3371:
3372: --dbms_output.put_line('p_new_date='||p_new_date);
3373:
3374: -- msc_calendar.date_offset will remove the timestamp
3375: if to_char(p_date,'HH24:MI:SS') <> '00:00:00' then
3376: p_minutes := (p_date - trunc(p_date)) *24*60;
3377: --dbms_output.put_line('timestamp: p_minutes='||p_minutes);
3378: end if;

Line 3391: msc_calendar.date_offset(

3387: if p_minutes > 0 then
3388: if p_minutes >= 24*60 then
3389: -- greater than one day, should find the next working day
3390: p_new_date :=
3391: msc_calendar.date_offset(
3392: p_org_id,
3393: p_instance_id,
3394: p_bucket_type,
3395: p_new_date,