APPS.MSC_ATP_PROC dependencies on MSC_CALENDAR

Line 2974: MSC_CALENDAR_DATES C,

2970: NVL(MB.assembly_quantity,1)) quantity
2971: FROM MSC_SYSTEM_ITEMS I,
2972: MSC_BOMS MB,
2973: MSC_BOM_COMPONENTS MBC,
2974: MSC_CALENDAR_DATES C,
2975: MSC_TRADING_PARTNERS TP
2976: WHERE I.plan_id = p_plan_id and
2977: I.sr_instance_id = p_instance_id and
2978: I.organization_id = p_org_id and

Line 4799: FROM msc_calendar_dates c2,

4795:
4796: -- Obtain the ITF the normal way.
4797: SELECT c2.calendar_date, r.rule_name
4798: INTO l_infinite_time_fence_date, x_atp_rule_name
4799: FROM msc_calendar_dates c2,
4800: msc_calendar_dates c1,
4801: msc_atp_rules r,
4802: msc_trading_partners tp,
4803: msc_system_items i

Line 4800: msc_calendar_dates c1,

4796: -- Obtain the ITF the normal way.
4797: SELECT c2.calendar_date, r.rule_name
4798: INTO l_infinite_time_fence_date, x_atp_rule_name
4799: FROM msc_calendar_dates c2,
4800: msc_calendar_dates c1,
4801: msc_atp_rules r,
4802: msc_trading_partners tp,
4803: msc_system_items i
4804: WHERE i.sr_inventory_item_id = p_inventory_item_id

Line 4843: FROM msc_calendar_dates c2,

4839:
4840: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4841: SELECT c2.calendar_date, r.rule_name
4842: INTO l_infinite_time_fence_date, x_atp_rule_name
4843: FROM msc_calendar_dates c2,
4844: msc_calendar_dates c1,
4845: msc_atp_rules r,
4846: msc_trading_partners tp,
4847: msc_department_resources dep_res

Line 4844: msc_calendar_dates c1,

4840: ELSE -- Bug 3036513 obtain infinite_time_fence_date for resource.
4841: SELECT c2.calendar_date, r.rule_name
4842: INTO l_infinite_time_fence_date, x_atp_rule_name
4843: FROM msc_calendar_dates c2,
4844: msc_calendar_dates c1,
4845: msc_atp_rules r,
4846: msc_trading_partners tp,
4847: msc_department_resources dep_res
4848: WHERE dep_res.resource_id = p_resource_id

Line 8101: l_group_work_date := MSC_CALENDAR.next_work_day(

8097: THEN
8098: IF p_src_dest = 'D' THEN
8099:
8100: IF G_is_ship_set THEN
8101: l_group_work_date := MSC_CALENDAR.next_work_day(
8102: p_set.shipping_cal_code(l_start),
8103: p_set.instance_id(l_start),
8104: l_group_date );
8105: ELSE

Line 8106: l_group_work_date := MSC_CALENDAR.next_work_day(

8102: p_set.shipping_cal_code(l_start),
8103: p_set.instance_id(l_start),
8104: l_group_date );
8105: ELSE
8106: l_group_work_date := MSC_CALENDAR.next_work_day(
8107: p_set.receiving_cal_code(l_start),
8108: p_set.instance_id(l_start),
8109: l_group_date );
8110: END IF;

Line 8158: p_set.group_arrival_date(i) := TRUNC(MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(

8154: p_set.group_arrival_date(i) := p_set.arrival_date(i);
8155: elsif p_src_dest = 'D' then
8156:
8157: /* ship_rec_cal changes begin */
8158: p_set.group_arrival_date(i) := TRUNC(MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(
8159: l_group_date, null, 0, -- pass null to make sure no validation on ship cal as
8160: -- l_group_date has already been validated on ship cal
8161: p_set.intransit_cal_code(i), nvl(p_set.delivery_lead_time(i), 0), 1,
8162: p_set.receiving_cal_code(i), 1, p_set.instance_id(i))) -- bug 8539537

Line 8183: p_set.group_ship_date(i) := TRUNC(MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(

8179: elsif p_set.arrival_date(i) = l_group_date then
8180: p_set.group_ship_date(i) := p_set.ship_date(i);
8181: elsif p_src_dest = 'D' then
8182: /* ship_rec_cal changes begin */
8183: p_set.group_ship_date(i) := TRUNC(MSC_CALENDAR.THREE_STEP_CAL_OFFSET_DATE(
8184: l_group_date, null, 0, -- pass null to make sure no validation on receiving cal as
8185: -- l_group_date has already been validated on receiving cal
8186: p_set.intransit_cal_code(i), -1 * nvl(p_set.delivery_lead_time(i), 0), -1,
8187: p_set.shipping_cal_code(i), -1, p_set.instance_id(i))) -- bug 8539537

Line 8374: l_sd_date := MSC_CALENDAR.DATE_OFFSET(

8370: l_sd_date := p_set.ship_date(m);
8371: ELSIF nvl(p_set.atp_lead_time(m), 0) <> 0 THEN
8372: -- For ship_rec_cal, this is fine because date_offset from non-working day or working day
8373: -- gives the same result.
8374: l_sd_date := MSC_CALENDAR.DATE_OFFSET(
8375: p_set.source_organization_id(m),
8376: p_set.instance_id(m),
8377: 1,
8378: p_set.group_ship_date(m),