DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_SATP_FUNC

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

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

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

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

Line 1819: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,

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

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

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

Line 2014: MSC_SATP_FUNC.Extend_Atp_Supply_Demand(x_atp_supply_demand,

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

Line 4992: MSC_SATP_FUNC.Get_Regions (

4988: x_return_status := FND_API.G_RET_STS_SUCCESS;
4989:
4990: -- Call Get Regions to pipulate Region level data
4991:
4992: MSC_SATP_FUNC.Get_Regions (
4993: p_to_customer_site_id,
4994: p_calling_module,
4995: p_to_instance_id,
4996: p_session_id,

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

5192: msc_sch_wb.atp_debug ('Customer ID specified ');
5193: END IF;
5194: -- First get the location corresponding to the customer
5195: BEGIN
5196: l_from_location_id := MSC_SATP_FUNC.src_location_id (p_from_organization_id,
5197: NULL,
5198: NULL);
5199: l_to_location_id := MSC_SATP_FUNC.src_location_id (NULL,
5200: p_to_customer_id,

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

5195: BEGIN
5196: l_from_location_id := MSC_SATP_FUNC.src_location_id (p_from_organization_id,
5197: NULL,
5198: NULL);
5199: l_to_location_id := MSC_SATP_FUNC.src_location_id (NULL,
5200: p_to_customer_id,
5201: p_to_customer_site_id);
5202: EXCEPTION
5203: when NO_DATA_FOUND then

Line 5387: MSC_SATP_FUNC.Get_Regions_Shipping(

5383: IF PG_DEBUG in ('Y','C') then
5384: msc_sch_wb.atp_debug ('Location ID : ' || l_to_location_id);
5385: end if;
5386:
5387: MSC_SATP_FUNC.Get_Regions_Shipping(
5388: p_to_customer_site_id, -- customer_site_id
5389: -1, -- not destination(724)
5390: NULL, -- no instance id
5391: p_session_id,

Line 5396: MSC_SATP_FUNC.get_src_transit_time(

5392: NULL, -- dblink
5393: x_return_status
5394: );
5395:
5396: MSC_SATP_FUNC.get_src_transit_time(
5397: NULL, -- from org
5398: p_from_loc_id,
5399: NULL, -- to org
5400: l_to_location_id,

Line 8103: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

8099: END IF;
8100:
8101: ELSIF p_src_dest = 'S' THEN
8102: IF G_is_ship_set THEN
8103: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8104: p_set.shipping_cal_code(l_start),
8105: l_group_date);
8106: ELSE
8107: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

Line 8107: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(

8103: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8104: p_set.shipping_cal_code(l_start),
8105: l_group_date);
8106: ELSE
8107: l_group_work_date := MSC_SATP_FUNC.src_next_work_day(
8108: p_set.receiving_cal_code(l_start),
8109: l_group_date);
8110: END IF;
8111: END IF;

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

8151: p_set.receiving_cal_code(i), 1, p_set.instance_id(i))
8152: + (l_group_date - trunc(l_group_date)); --4460369 --4967040
8153:
8154: else
8155: p_set.group_arrival_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(
8156: l_group_date, null, 0, -- pass null to make sure no validation on ship cal as
8157: -- l_group_date has already been validated on ship cal
8158: p_set.intransit_cal_code(i), nvl(p_set.delivery_lead_time(i), 0), 1,
8159: p_set.receiving_cal_code(i), 1))

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

8176: p_set.shipping_cal_code(i), -1, p_set.instance_id(i))
8177: + (l_group_date - trunc(l_group_date)); --4460369 --4967040
8178:
8179: else
8180: p_set.group_ship_date(i) := TRUNC(MSC_SATP_FUNC.SRC_THREE_STEP_CAL_OFFSET_DATE(
8181: l_group_date, null, 0, -- pass null to make sure no validation on receiving cal as
8182: -- l_group_date has already been validated on receiving cal
8183: p_set.intransit_cal_code(i), -1 * nvl(p_set.delivery_lead_time(i), 0), -1,
8184: p_set.shipping_cal_code(i), -1))

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

9031: return;
9032: END IF;
9033: END LOOP;
9034:
9035: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id
9036: p_calling_module, -- p_calling_module
9037: p_instance_id, -- p_instance_id
9038: MSC_ATP_PVT.G_SESSION_ID, -- p_session_id
9039: NULL, -- p_dblink

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

9136: ELSE
9137: IF PG_DEBUG in ('Y', 'C') THEN
9138: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': supp-org case');
9139: END IF;
9140: MSC_SATP_FUNC.Get_Regions(NULL, -- p_customer_site_id
9141: 724, -- p_calling_module
9142: p_from_instance_id, -- p_instance_id
9143: p_session_id, -- p_session_id
9144: NULL, -- p_dblink

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

9168: IF PG_DEBUG in ('Y', 'C') THEN
9169: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': org-cust case');
9170: END IF;
9171: IF p_src_dest = 1 THEN
9172: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id
9173: -1, -- p_calling_module (not 724)
9174: NULL, -- p_instance_id
9175: p_session_id, -- p_session_id
9176: NULL, -- p_dblink

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

9179: 'HZ', -- p_location_source
9180: NULL -- p_supplier_site_id
9181: );
9182:
9183: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id
9184: p_from_loc_id, -- p_from_loc_id
9185: NULL, -- p_to_org_id
9186: p_to_loc_id, -- p_to_loc_id
9187: p_session_id, -- p_session_id

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

9189: p_ship_method, -- x_ship_method
9190: x_intransit_lead_time -- x_intransit_time
9191: );
9192: ELSE
9193: MSC_SATP_FUNC.Get_Regions(p_to_customer_site_id, -- p_customer_site_id
9194: 724, -- p_calling_module
9195: p_from_instance_id, -- p_instance_id
9196: p_session_id, -- p_session_id
9197: NULL, -- p_dblink

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

9221: IF PG_DEBUG in ('Y', 'C') THEN
9222: msc_sch_wb.atp_debug('ATP_Intransit_LT: ' || ': org-org case');
9223: END IF;
9224: IF p_src_dest = 1 THEN
9225: MSC_SATP_FUNC.get_src_transit_time(p_from_org_id, -- p_from_org_id
9226: p_from_loc_id, -- p_from_loc_id
9227: p_to_org_id, -- p_to_org_id
9228: p_to_loc_id, -- p_to_loc_id
9229: p_session_id, -- p_session_id