DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_SATP_FUNC

Line 69: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, l_return_status);

65: END IF;
66:
67: -- add one more entry to indicate infinite time fence date
68: -- and quantity.
69: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, l_return_status);
70: j := x_atp_period.Level.COUNT;
71:
72: IF j > 1 THEN
73: x_atp_period.Period_End_Date(j-1) := p_infinite_time_fence_date - 1;

Line 1757: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);

1753: IF p_atp_period.level.COUNT > 0 THEN
1754:
1755: l_count := x_atp_period.level.COUNT;
1756: FOR l_period_count in 1..p_atp_period.level.COUNT LOOP
1757: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);
1758:
1759: x_atp_period.Level(l_count + l_period_count) :=
1760: p_atp_period.Level(l_period_count);
1761: x_atp_period.Inventory_Item_Id(l_count + l_period_count) :=

Line 1820: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,

1816: IF p_atp_supply_demand.level.COUNT > 0 THEN
1817: l_count := x_atp_supply_demand.level.COUNT;
1818:
1819: FOR l_sd_count in 1..p_atp_supply_demand.level.COUNT LOOP
1820: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,
1821: x_return_status);
1822: x_atp_supply_demand.Level(l_count + l_sd_count):=
1823: p_atp_supply_demand.Level(l_sd_count);
1824: x_atp_supply_demand.Inventory_Item_Id(l_count+l_sd_count):=

Line 1955: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);

1951:
1952: IF (p_atp_period.identifier(l_period_count) = p_identifier) AND
1953: (p_atp_period.Scenario_Id(l_period_count) = p_scenario_id) THEN
1954: l_count := x_atp_period.level.COUNT + 1;
1955: MSC_SATP_FUNC.Extend_Atp_Period(x_atp_period, x_return_status);
1956: x_atp_period.Level(l_count) :=
1957: p_atp_period.Level(l_period_count);
1958: x_atp_period.Inventory_Item_Id(l_count) :=
1959: p_atp_period.Inventory_Item_Id(l_period_count);

Line 2015: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,

2011: FOR l_sd_count in 1..p_atp_supply_demand.Level.COUNT LOOP
2012: IF (p_atp_supply_demand.identifier(l_sd_count) = p_identifier) AND
2013: (p_atp_supply_demand.Scenario_Id(l_sd_count)= p_scenario_id) THEN
2014: l_count := x_atp_supply_demand.level.COUNT + 1;
2015: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,
2016: x_return_status);
2017: x_atp_supply_demand.Level(l_count):=
2018: p_atp_supply_demand.Level(l_sd_count);
2019: x_atp_supply_demand.Inventory_Item_Id(l_count):=

Line 5001: MSC_SATP_FUNC.Get_Regions (

4997: x_return_status := FND_API.G_RET_STS_SUCCESS;
4998:
4999: -- Call Get Regions to pipulate Region level data
5000:
5001: MSC_SATP_FUNC.Get_Regions (
5002: p_to_customer_site_id,
5003: p_calling_module,
5004: p_to_instance_id,
5005: p_session_id,

Line 5205: l_from_location_id := MSC_SATP_FUNC.src_location_id (p_from_organization_id,

5201: msc_sch_wb.atp_debug ('Customer ID specified ');
5202: END IF;
5203: -- First get the location corresponding to the customer
5204: BEGIN
5205: l_from_location_id := MSC_SATP_FUNC.src_location_id (p_from_organization_id,
5206: NULL,
5207: NULL);
5208: l_to_location_id := MSC_SATP_FUNC.src_location_id (NULL,
5209: p_to_customer_id,

Line 5208: l_to_location_id := MSC_SATP_FUNC.src_location_id (NULL,

5204: BEGIN
5205: l_from_location_id := MSC_SATP_FUNC.src_location_id (p_from_organization_id,
5206: NULL,
5207: NULL);
5208: l_to_location_id := MSC_SATP_FUNC.src_location_id (NULL,
5209: p_to_customer_id,
5210: p_to_customer_site_id);
5211: EXCEPTION
5212: when NO_DATA_FOUND then

Line 5396: MSC_SATP_FUNC.Get_Regions_Shipping(

5392: IF PG_DEBUG in ('Y','C') then
5393: msc_sch_wb.atp_debug ('Location ID : ' || l_to_location_id);
5394: end if;
5395:
5396: MSC_SATP_FUNC.Get_Regions_Shipping(
5397: p_to_customer_site_id, -- customer_site_id
5398: -1, -- not destination(724)
5399: NULL, -- no instance id
5400: p_session_id,

Line 5405: MSC_SATP_FUNC.get_src_transit_time(

5401: NULL, -- dblink
5402: x_return_status
5403: );
5404:
5405: MSC_SATP_FUNC.get_src_transit_time(
5406: NULL, -- from org
5407: p_from_loc_id,
5408: NULL, -- to org
5409: l_to_location_id,

Line 8114: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

8110: END IF;
8111:
8112: ELSIF p_src_dest = 'S' THEN
8113: IF G_is_ship_set THEN
8114: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8115: p_set.shipping_cal_code(l_start),
8116: l_group_date);
8117: ELSE
8118: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

Line 8118: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

8114: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8115: p_set.shipping_cal_code(l_start),
8116: l_group_date);
8117: ELSE
8118: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8119: p_set.receiving_cal_code(l_start),
8120: l_group_date);
8121: END IF;
8122: END IF;

Line 8166: p_set.group_arrival_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(

8162: p_set.receiving_cal_code(i), 1, p_set.instance_id(i))) -- bug 8539537
8163: + (l_group_date - trunc(l_group_date)); --4460369 --4967040
8164:
8165: else
8166: p_set.group_arrival_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(
8167: l_group_date, null, 0, -- pass null to make sure no validation on ship cal as
8168: -- l_group_date has already been validated on ship cal
8169: p_set.intransit_cal_code(i), nvl(p_set.delivery_lead_time(i), 0), 1,
8170: p_set.receiving_cal_code(i), 1))

Line 8191: p_set.group_ship_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(

8187: p_set.shipping_cal_code(i), -1, p_set.instance_id(i))) -- bug 8539537
8188: + (l_group_date - trunc(l_group_date)); --4460369 --4967040
8189:
8190: else
8191: p_set.group_ship_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(
8192: l_group_date, null, 0, -- pass null to make sure no validation on receiving cal as
8193: -- l_group_date has already been validated on receiving cal
8194: p_set.intransit_cal_code(i), -1 * nvl(p_set.delivery_lead_time(i), 0), -1,
8195: p_set.shipping_cal_code(i), -1))

Line 9048: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id

9044: return;
9045: END IF;
9046: END LOOP;
9047:
9048: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id
9049: p_calling_module, -- p_calling_module
9050: p_instance_id, -- p_instance_id
9051: MSC_ATP_PVT.G_SESSION_ID, -- p_session_id
9052: NULL, -- p_dblink

Line 9153: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id

9149: ELSE
9150: IF PG_DEBUG in ('Y', 'C') THEN
9151: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': supp-org case');
9152: END IF;
9153: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id
9154: 724, -- p_calling_module
9155: p_from_instance_id, -- p_instance_id
9156: p_session_id, -- p_session_id
9157: NULL, -- p_dblink

Line 9185: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id

9181: IF PG_DEBUG in ('Y', 'C') THEN
9182: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': org-cust case');
9183: END IF;
9184: IF p_src_dest = 1 THEN
9185: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id
9186: -1, -- p_calling_module (not 724)
9187: NULL, -- p_instance_id
9188: p_session_id, -- p_session_id
9189: NULL, -- p_dblink

Line 9196: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id

9192: 'HZ', -- p_location_source
9193: NULL -- p_supplier_site_id
9194: );
9195:
9196: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id
9197: p_from_loc_id, -- p_from_loc_id
9198: NULL, -- p_to_org_id
9199: p_to_loc_id, -- p_to_loc_id
9200: p_session_id, -- p_session_id

Line 9206: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id

9202: p_ship_method, -- x_ship_method
9203: x_intransit_lead_time -- x_intransit_time
9204: );
9205: ELSE
9206: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id
9207: 724, -- p_calling_module
9208: p_from_instance_id, -- p_instance_id
9209: p_session_id, -- p_session_id
9210: NULL, -- p_dblink

Line 9238: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id

9234: IF PG_DEBUG in ('Y', 'C') THEN
9235: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': org-org case');
9236: END IF;
9237: IF p_src_dest = 1 THEN
9238: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id
9239: p_from_loc_id, -- p_from_loc_id
9240: p_to_org_id, -- p_to_org_id
9241: p_to_loc_id, -- p_to_loc_id
9242: p_session_id, -- p_session_id