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.21 2011/12/06 10:02:11 vjuluri 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.21 2011/12/06 10:02:11 vjuluri 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 624: MSC_ATP_PROC.Get_Sources_Info(order_sch_wb.debug_session_id, null, l_customer_id,

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

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

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

Line 3481: MSC_ATP_PROC.Atp_Sources(l_sr_instance_id,

3477: 'l_item_sourcing_rec.match_item_id(1) : '
3478: || l_item_sourcing_rec.match_item_id(1));
3479: END IF;
3480:
3481: MSC_ATP_PROC.Atp_Sources(l_sr_instance_id,
3482: x_plan_id,
3483: NULL,
3484: l_Organization_Id,
3485: l_Customer_Id,

Line 3588: MSC_ATP_PROC.msc_calculate_source_attrib

3584: 4) Once we know region_id , we need to get all defined ship methods ( default and not default ) for a user to pick.
3585:
3586: ------------------------------------------------------------------------------*/
3587: FOR counter IN 1..l_sources.organization_id.COUNT LOOP
3588: MSC_ATP_PROC.msc_calculate_source_attrib
3589: ( l_customer_id,
3590: l_customer_site_id,
3591: l_organization_id,
3592: l_sr_instance_id,

Line 3854: MSC_ATP_PROC.insert_atp_sources(x_session_id,

3850:
3851: END LOOP;
3852:
3853: -- m2a link to put back the records into the apps table.
3854: MSC_ATP_PROC.insert_atp_sources(x_session_id,
3855: l_dblink,
3856: x_calling_inst,
3857: l_sources,l_other_cols);
3858: ELSE

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

8325: /* --bug4281663 commented and initialized below
8326: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
8327: -- New procedure for obtaining plan data : Supplier Capacity Lead Time proj.
8328: -- (SCLT)
8329: MSC_ATP_PROC.get_global_plan_info(p_set.instance_id(m),
8330: p_set.inventory_item_id(m),
8331: -- 2832497 dsting
8332: p_set.source_organization_id(m),
8333: p_set.demand_class(m));

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

9037:
9038: x_return_status := FND_API.G_RET_STS_SUCCESS;
9039:
9040: FOR l_counter IN 1..G_VENDOR_SITE_ID.COUNT LOOP
9041: IF MSC_ATP_PROC.G_VENDOR_SITE_ID(l_counter) = p_vendor_site_id THEN
9042: msc_sch_wb.atp_debug('Get_Supplier_Regions :' || 'Data for site ' || p_vendor_site_id ||
9043: ' already exists.');
9044: return;
9045: END IF;

Line 9275: END MSC_ATP_PROC;

9271: END IF;
9272: x_return_status := FND_API.G_RET_STS_ERROR;
9273: END ATP_Intransit_LT;
9274:
9275: END MSC_ATP_PROC;