APPS.MSC_REL_WF dependencies on MSC_CALENDAR

Line 2477: msc_calendar_dates cal1,

2473: cal2.calendar_date
2474: from msc_supplies s,
2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,
2479: msc_trading_partners mtp
2480: where s.plan_id = p_plan_id
2481: and s.transaction_id =p_transaction_id

Line 2478: msc_calendar_dates cal2,

2474: from msc_supplies s,
2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,
2479: msc_trading_partners mtp
2480: where s.plan_id = p_plan_id
2481: and s.transaction_id =p_transaction_id
2482: and s.plan_id = mp.plan_id

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

2747:
2748: begin
2749:
2750:
2751: if P_calendar_code is null or p_calendar_code = MSC_CALENDAR.FOC then
2752:
2753: -- shipping/receiving calendar hierarchy [if no CRC, then 24x7]
2754: p_return_date := p_date + nvl(p_lead_time,0);
2755:

Line 2758: p_return_date := msc_calendar.date_offset

2754: p_return_date := p_date + nvl(p_lead_time,0);
2755:
2756: else
2757:
2758: p_return_date := msc_calendar.date_offset
2759: ( p_calendar_code
2760: , p_inst_id
2761: , p_date
2762: , nvl(p_lead_time,0)

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

2762: , nvl(p_lead_time,0)
2763: , null -- association_type
2764: );
2765:
2766: -- msc_calendar.date_offset will remove the timestamp
2767: if to_char(p_return_date,'HH24:MI:SS') = '00:00:00' and
2768: to_char(p_date,'HH24:MI:SS') <> '00:00:00' then
2769: p_return_date := to_date(to_char(p_return_date, 'MM/DD/RR')||' '||
2770: to_char(p_date,'HH24:MI:SS'),

Line 2798: v_vic_cal_code msc_calendars.calendar_code%type;

2794: v_planned_arrival_date DateArr;
2795: v_earliest_date DateArr;
2796: v_request_date DateArr;
2797: v_schedule_date DateArr;
2798: v_vic_cal_code msc_calendars.calendar_code%type;
2799: v_association_type number;
2800:
2801: cursor so_c is
2802: select order_number,

Line 2907: v_vic_cal_code := msc_calendar.get_calendar_code

2903: FETCH so_c INTO so_rec;
2904: CLOSE so_c;
2905:
2906: begin
2907: v_vic_cal_code := msc_calendar.get_calendar_code
2908: ( p_inst_id
2909: , null
2910: , null
2911: , null

Line 2916: , MSC_CALENDAR.VIC

2912: , null
2913: , 4 -- partner type [in transit]
2914: , null
2915: , so_rec.ship_method
2916: , MSC_CALENDAR.VIC
2917: , v_association_type
2918: );
2919: exception when others then
2920: v_vic_cal_code := null;

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

3644: p_new_date date;
3645: p_new_offset number;
3646: p_minutes number := 0;
3647: BEGIN
3648: -- 6142627, msc_calendar.date_offset will round up offset_days
3649: if ceil(p_offset_days) <> p_offset_days then
3650: p_new_offset := floor(p_offset_days);
3651: else
3652: p_new_offset := p_offset_days;

Line 3655: p_new_date := msc_calendar.date_offset(

3651: else
3652: p_new_offset := p_offset_days;
3653: end if;
3654:
3655: p_new_date := msc_calendar.date_offset(
3656: p_org_id,
3657: p_instance_id,
3658: p_bucket_type,
3659: p_date,

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

3660: p_new_offset);
3661:
3662: --dbms_output.put_line('p_new_date='||p_new_date);
3663:
3664: -- msc_calendar.date_offset will remove the timestamp
3665: if to_char(p_date,'HH24:MI:SS') <> '00:00:00' then
3666: p_minutes := (p_date - trunc(p_date)) *24*60;
3667: --dbms_output.put_line('timestamp: p_minutes='||p_minutes);
3668: end if;

Line 3681: msc_calendar.date_offset(

3677: if p_minutes > 0 then
3678: if p_minutes >= 24*60 then
3679: -- greater than one day, should find the next working day
3680: p_new_date :=
3681: msc_calendar.date_offset(
3682: p_org_id,
3683: p_instance_id,
3684: p_bucket_type,
3685: p_new_date,