APPS.MSC_ATP_PROC dependencies on MSC_CALENDAR

Line 2966: MSC_CALENDAR_DATES C,

2962: NVL(MB.assembly_quantity,1)) quantity
2963: FROM MSC_SYSTEM_ITEMS I,
2964: MSC_BOMS MB,
2965: MSC_BOM_COMPONENTS MBC,
2966: MSC_CALENDAR_DATES C,
2967: MSC_TRADING_PARTNERS TP
2968: WHERE I.plan_id = p_plan_id and
2969: I.sr_instance_id = p_instance_id and
2970: I.organization_id = p_org_id and

Line 4790: FROM msc_calendar_dates c2,

4786:
4787: -- Obtain the ITF the normal way.
4788: SELECT c2.calendar_date, r.rule_name
4789: INTO l_infinite_time_fence_date, x_atp_rule_name
4790: FROM msc_calendar_dates c2,
4791: msc_calendar_dates c1,
4792: msc_atp_rules r,
4793: msc_trading_partners tp,
4794: msc_system_items i

Line 4791: msc_calendar_dates c1,

4787: -- Obtain the ITF the normal way.
4788: SELECT c2.calendar_date, r.rule_name
4789: INTO l_infinite_time_fence_date, x_atp_rule_name
4790: FROM msc_calendar_dates c2,
4791: msc_calendar_dates c1,
4792: msc_atp_rules r,
4793: msc_trading_partners tp,
4794: msc_system_items i
4795: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 4834: FROM msc_calendar_dates c2,

4830:
4831: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4832: SELECT c2.calendar_date, r.rule_name
4833: INTO l_infinite_time_fence_date, x_atp_rule_name
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res

Line 4835: msc_calendar_dates c1,

4831: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4832: SELECT c2.calendar_date, r.rule_name
4833: INTO l_infinite_time_fence_date, x_atp_rule_name
4834: FROM msc_calendar_dates c2,
4835: msc_calendar_dates c1,
4836: msc_atp_rules r,
4837: msc_trading_partners tp,
4838: msc_department_resources dep_res
4839: WHERE dep_res.resource_id = p_resource_id

Line 8090: l_group_work_date := MSC_CALENDAR.next_work_day(

8086: THEN
8087: IF p_src_dest = 'D' THEN
8088:
8089: IF G_is_ship_set THEN
8090: l_group_work_date := MSC_CALENDAR.next_work_day(
8091: p_set.shipping_cal_code(l_start),
8092: p_set.instance_id(l_start),
8093: l_group_date );
8094: ELSE

Line 8095: l_group_work_date := MSC_CALENDAR.next_work_day(

8091: p_set.shipping_cal_code(l_start),
8092: p_set.instance_id(l_start),
8093: l_group_date );
8094: ELSE
8095: l_group_work_date := MSC_CALENDAR.next_work_day(
8096: p_set.receiving_cal_code(l_start),
8097: p_set.instance_id(l_start),
8098: l_group_date );
8099: END IF;

Line 8147: p_set.group_arrival_date(i) := MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(

8143: p_set.group_arrival_date(i) := p_set.arrival_date(i);
8144: elsif p_src_dest = 'D' then
8145:
8146: /* ship_rec_cal changes begin */
8147: p_set.group_arrival_date(i) := MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(
8148: l_group_date, null, 0, -- pass null to make sure no validation on ship cal as
8149: -- l_group_date has already been validated on ship cal
8150: p_set.intransit_cal_code(i), nvl(p_set.delivery_lead_time(i), 0), 1,
8151: p_set.receiving_cal_code(i), 1, p_set.instance_id(i))

Line 8172: p_set.group_ship_date(i) := MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(

8168: elsif p_set.arrival_date(i) = l_group_date then
8169: p_set.group_ship_date(i) := p_set.ship_date(i);
8170: elsif p_src_dest = 'D' then
8171: /* ship_rec_cal changes begin */
8172: p_set.group_ship_date(i) := MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(
8173: l_group_date, null, 0, -- pass null to make sure no validation on receiving cal as
8174: -- l_group_date has already been validated on receiving cal
8175: p_set.intransit_cal_code(i), -1 * nvl(p_set.delivery_lead_time(i), 0), -1,
8176: p_set.shipping_cal_code(i), -1, p_set.instance_id(i))

Line 8363: l_sd_date := MSC_CALENDAR.DATE_OFFSET(

8359: l_sd_date := p_set.ship_date(m);
8360: ELSIF nvl(p_set.atp_lead_time(m), 0) <> 0 THEN
8361: -- For ship_rec_cal, this is fine because date_offset from non-working day or working day
8362: -- gives the same result.
8363: l_sd_date := MSC_CALENDAR.DATE_OFFSET(
8364: p_set.source_organization_id(m),
8365: p_set.instance_id(m),
8366: 1,
8367: p_set.group_ship_date(m),