APPS.MSC_ATP_PROC dependencies on MSC_ATP_PROC

Line 1: PACKAGE BODY MSC_ATP_PROC AS

1: PACKAGE BODY MSC_ATP_PROC AS
2: /* $Header: MSCPATPB.pls 120.11 2007/12/12 10:33:45 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_PROC';
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_PROC';

1: PACKAGE BODY MSC_ATP_PROC AS
2: /* $Header: MSCPATPB.pls 120.11 2007/12/12 10:33:45 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_PROC';
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
6:
7: -- dlt dsting. replaced hash with nested table since 8i doesn't support it

Line 623: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, null, l_customer_id,

619: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ship set and receiving party is customer');
620: END IF;
621:
622: -- rmehra Replaced views by procedure for bug 2585710
623: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, null, l_customer_id,
624: p_customer_site_id, p_assign_set_id, l_count, x_atp_sources, l_return_status,
625: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
626:
627: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 802: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, l_inv_item_id, l_customer_id,

798: -- ngoel 9/26/2001, since view msc_scatp_sources_v resolves the hierarchy,
799: -- no need to have either union all or separate clause for customer site and region
800:
801: -- bug 2585710. Replaced views by procedure
802: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, l_inv_item_id, l_customer_id,
803: p_customer_site_id, p_assign_set_id, null, x_atp_sources, l_return_status,
804: p_partner_type, p_party_site_id, p_order_line_id ); --2814895
805:
806: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3472: MSC_ATP_PROC.Atp_Sources(l_sr_instance_id,

3468: 'l_item_sourcing_rec.match_item_id(1) : '
3469: || l_item_sourcing_rec.match_item_id(1));
3470: END IF;
3471:
3472: MSC_ATP_PROC.Atp_Sources(l_sr_instance_id,
3473: x_plan_id,
3474: NULL,
3475: l_Organization_Id,
3476: l_Customer_Id,

Line 3579: MSC_ATP_PROC.msc_calculate_source_attrib

3575: 4) Once we know region_id , we need to get all defined ship methods ( default and not default ) for a user to pick.
3576:
3577: ------------------------------------------------------------------------------*/
3578: FOR counter IN 1..l_sources.organization_id.COUNT LOOP
3579: MSC_ATP_PROC.msc_calculate_source_attrib
3580: ( l_customer_id,
3581: l_customer_site_id,
3582: l_organization_id,
3583: l_sr_instance_id,

Line 3845: MSC_ATP_PROC.insert_atp_sources(x_session_id,

3841:
3842: END LOOP;
3843:
3844: -- m2a link to put back the records into the apps table.
3845: MSC_ATP_PROC.insert_atp_sources(x_session_id,
3846: l_dblink,
3847: x_calling_inst,
3848: l_sources,l_other_cols);
3849: ELSE

Line 8318: MSC_ATP_PROC.get_global_plan_info(p_set.instance_id(m),

8314: /* --bug4281663 commented and initialized below
8315: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
8316: -- New procedure for obtaining plan data : Supplier Capacity Lead Time proj.
8317: -- (SCLT)
8318: MSC_ATP_PROC.get_global_plan_info(p_set.instance_id(m),
8319: p_set.inventory_item_id(m),
8320: -- 2832497 dsting
8321: p_set.source_organization_id(m),
8322: p_set.demand_class(m));

Line 9028: IF MSC_ATP_PROC.G_VENDOR_SITE_ID(l_counter) = p_vendor_site_id THEN

9024:
9025: x_return_status := FND_API.G_RET_STS_SUCCESS;
9026:
9027: FOR l_counter IN 1..G_VENDOR_SITE_ID.COUNT LOOP
9028: IF MSC_ATP_PROC.G_VENDOR_SITE_ID(l_counter) = p_vendor_site_id THEN
9029: msc_sch_wb.atp_debug('Get_Supplier_Regions :' || 'Data for site ' || p_vendor_site_id ||
9030: ' already exists.');
9031: return;
9032: END IF;

Line 9262: END MSC_ATP_PROC;

9258: END IF;
9259: x_return_status := FND_API.G_RET_STS_ERROR;
9260: END ATP_Intransit_LT;
9261:
9262: END MSC_ATP_PROC;