APPS.MSC_ATP_ALLOC dependencies on MSC_CALENDAR

Line 165: SELECT MSC_CALENDAR.NEXT_WORK_DAY(p_organization_id, p_instance_id, 1, TRUNC(sysdate))

161: x_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163:
164: -- Get next working day from sysdate required for compute_allocation_details.
165: SELECT MSC_CALENDAR.NEXT_WORK_DAY(p_organization_id, p_instance_id, 1, TRUNC(sysdate))
166: INTO l_request_date
167: FROM dual;
168:
169: IF (l_request_date = NULL) THEN

Line 1022: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

1018: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
1019: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
1020:
1021: -- Bug 3823042
1022: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
1023: l_calendar_code,
1024: p_instance_id,
1025: TRUNC(sysdate));
1026:

Line 1081: -- Bug 3823042: optimized plan, donot use msc_calendar_dates

1077: -- time_phased_atp changes end
1078: ELSE
1079:
1080: IF ( MSC_ATP_PVT.G_OPTIMIZED_PLAN = 1) THEN
1081: -- Bug 3823042: optimized plan, donot use msc_calendar_dates
1082:
1083: IF PG_DEBUG in ('Y', 'C') THEN
1084: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'User defined demand class, Optimized plan');
1085: END IF;

Line 1300: --Bug 3823042, donot use msc_calendar_dates

1296: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col24 --bug3263368
1297:
1298: FROM
1299: MSC_DEMANDS D,
1300: --Bug 3823042, donot use msc_calendar_dates
1301: --MSC_CALENDAR_DATES C,
1302: MSC_ALLOC_TEMP TEMP,
1303: MSC_TRADING_PARTNERS MTP, --bug3263368
1304: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 1301: --MSC_CALENDAR_DATES C,

1297:
1298: FROM
1299: MSC_DEMANDS D,
1300: --Bug 3823042, donot use msc_calendar_dates
1301: --MSC_CALENDAR_DATES C,
1302: MSC_ALLOC_TEMP TEMP,
1303: MSC_TRADING_PARTNERS MTP, --bug3263368
1304: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
1305: WHERE

Line 1340: -- Bug 3823042, donot use msc_calendar_dates

1336: AND C.SEQ_NUM IS NOT NULL) OR
1337: ( D.ORIGINATION_TYPE <> 4))
1338: AND C.PRIOR_DATE < NVL(p_infinite_time_fence_date, C.PRIOR_DATE + 1)
1339: */
1340: -- Bug 3823042, donot use msc_calendar_dates
1341: AND TRUNC(DECODE(RECORD_SOURCE,
1342: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
1343: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
1344: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))),

Line 1424: --MSC_CALENDAR_DATES C,

1420: l_null_char col23, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
1421: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
1422: FROM
1423: -- Bug 3823042
1424: --MSC_CALENDAR_DATES C,
1425: MSC_SUPPLIES S,
1426: MSC_ALLOC_TEMP TEMP
1427: WHERE
1428: S.PLAN_ID = p_plan_id

Line 1454: -- Bug 3823042: Unoptimized Plan, Use msc_calendar_dates

1450: );
1451: l_insert_count := SQL%ROWCOUNT;
1452:
1453: ELSE -- Else of Optimized plan
1454: -- Bug 3823042: Unoptimized Plan, Use msc_calendar_dates
1455:
1456: IF PG_DEBUG in ('Y', 'C') THEN
1457: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'User defined demand class, Unoptimized plan');
1458: END IF;

Line 1611: MSC_CALENDAR_DATES C,

1607: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col24 --bug3263368
1608:
1609: FROM
1610: MSC_DEMANDS D,
1611: MSC_CALENDAR_DATES C,
1612: MSC_ALLOC_TEMP TEMP,
1613: MSC_TRADING_PARTNERS MTP, --bug3263368
1614: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
1615: WHERE

Line 1716: MSC_CALENDAR_DATES C,

1712: l_null_char col22, --bug3263368 ORIG_CUSTOMER_NAME --Bug 3875786
1713: l_null_char col23, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
1714: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
1715: FROM
1716: MSC_CALENDAR_DATES C,
1717: MSC_SUPPLIES S,
1718: MSC_ALLOC_TEMP TEMP
1719: WHERE
1720: S.PLAN_ID = p_plan_id

Line 1967: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(

1963: l_default_demand_class := MSC_ATP_PVT.G_ORG_INFO_REC.default_demand_class;
1964: l_org_code := MSC_ATP_PVT.G_ORG_INFO_REC.org_code;
1965:
1966: -- Bug 3823042
1967: l_sys_next_date := MSC_CALENDAR.NEXT_WORK_DAY(
1968: l_calendar_code,
1969: p_instance_id,
1970: TRUNC(sysdate));
1971:

Line 2064: -- Bug 3823042: optimized plan, donot use msc_calendar_dates

2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;
2062: ELSE
2063: IF (MSC_ATP_PVT.G_OPTIMIZED_PLAN = 1) THEN
2064: -- Bug 3823042: optimized plan, donot use msc_calendar_dates
2065:
2066: IF PG_DEBUG in ('Y', 'C') THEN
2067: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'User defined customer class, Optimized plan');
2068: END IF;

Line 2283: --MSC_CALENDAR_DATES C,

2279: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col29 --bug3263368
2280: FROM
2281: MSC_DEMANDS D,
2282: -- Bug 3823042
2283: --MSC_CALENDAR_DATES C,
2284: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2285: MSC_TRADING_PARTNERS MTP,--bug3263368
2286: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2287:

Line 2406: --MSC_CALENDAR_DATES C,

2402: l_null_char col28, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
2403: l_null_date COL29 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
2404: FROM
2405: -- Bug 3823042
2406: --MSC_CALENDAR_DATES C,
2407: MSC_SUPPLIES S,
2408: MSC_ALLOC_HIERARCHY_TEMP TEMP
2409: WHERE
2410: S.PLAN_ID = p_plan_id

Line 2593: MSC_CALENDAR_DATES C,

2589: DECODE(D.ORDER_DATE_TYPE_CODE,2,
2590: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col29 --bug3263368
2591: FROM
2592: MSC_DEMANDS D,
2593: MSC_CALENDAR_DATES C,
2594: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2595: MSC_TRADING_PARTNERS MTP,--bug3263368
2596: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2597:

Line 2708: MSC_CALENDAR_DATES C,

2704: l_null_char col27, --bug3263368 ORIG_CUSTOMER_NAME --Bug 3875786
2705: l_null_char col28, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
2706: l_null_date COL29 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
2707: FROM
2708: MSC_CALENDAR_DATES C,
2709: MSC_SUPPLIES S,
2710: MSC_ALLOC_HIERARCHY_TEMP TEMP
2711: WHERE
2712: S.PLAN_ID = p_plan_id