DBA Data[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_ATP_REQ

Line 3484: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,

3480: p_insert_flag IN NUMBER,
3481: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
3482: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3483: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3484: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
3485: p_request_item_id IN NUMBER, -- For time_phased_atp
3486: p_atf_date IN DATE) -- For time_phased_atp
3487: IS
3488: l_infinite_time_fence_date DATE;

Line 8390: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,

8386: /* spec changed as part of ship_rec_cal changes
8387: various input parameters passed in a record atp_info_rec
8388: */
8389: PROCEDURE Supplier_Alloc_Cum_Atp(
8390: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,
8391: p_identifier IN NUMBER,
8392: p_request_date IN DATE,
8393: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
8394: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

Line 8879: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = trunc(MSC_ATP_REQ.G_PROMISE_DATE) --4135752

8875: 0)) quantity
8876: -- Supplier Capacity (SCLT) Changes Begin
8877: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
8878: WHERE (p.order_type IN (5, 2)
8879: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = trunc(MSC_ATP_REQ.G_PROMISE_DATE) --4135752
8880: AND p.order_type = 1 AND p.promised_date IS NULL))
8881: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
8882: -- WHERE p.order_type IN (5, 1, 2)
8883: AND p.plan_id = p_sup_atp_info_rec.plan_id

Line 9040: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

9036: 0)) quantity
9037: -- Supplier Capacity (SCLT) Changes Begin
9038: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9039: WHERE (p.order_type IN (5, 2)
9040: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9041: AND p.order_type = 1 AND p.promised_date IS NULL))
9042: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9043: -- WHERE p.order_type IN (5, 1, 2)
9044: AND p.plan_id = p_sup_atp_info_rec.plan_id

Line 9323: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

9319: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9320: -- Supplier Capacity (SCLT) Changes Begin
9321: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9322: WHERE (p.order_type IN (5, 2)
9323: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9324: AND p.order_type = 1 AND p.promised_date IS NULL))
9325:
9326: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9327: -- WHERE p.order_type IN (5, 1, 2)

Line 9606: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE

9602: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9603: -- Supplier Capacity (SCLT) Changes Begin
9604: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM
9605: WHERE (p.order_type IN (5, 2)
9606: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9607: AND p.order_type = 1 AND p.promised_date IS NULL))
9608:
9609: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9610: -- WHERE p.order_type IN (5, 1, 2)

Line 10081: --4055719 , moved this code to MSC_ATP_REQ.get_supplier_atp_info

10077: END IF;
10078: RAISE FND_API.G_EXC_ERROR;
10079: END IF;
10080:
10081: --4055719 , moved this code to MSC_ATP_REQ.get_supplier_atp_info
10082: -- get the infinite time fence date if it exists
10083: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(null, --4055719
10084: null,null, p_sup_atp_info_rec.plan_id);
10085:

Line 10355: l_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;

10351: l_res_uom_type NUMBER;
10352: l_plan_info_rec MSC_ATP_PVT.plan_info_rec; -- added for bug 2392456
10353:
10354: --diag_atp
10355: l_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;
10356:
10357:
10358: -- Agilent Allocated ATP Based on Planning Details changes Begin
10359: l_demand_class VARCHAR2(80);

Line 10953: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;

10949:
10950: -- Agilent Allocated ATP Based on Planning Details changes
10951: l_stealing_quantity NUMBER;
10952: --diag_atp
10953: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;
10954: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;
10955:
10956: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
10957:

Line 10954: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;

10950: -- Agilent Allocated ATP Based on Planning Details changes
10951: l_stealing_quantity NUMBER;
10952: --diag_atp
10953: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;
10954: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;
10955:
10956: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
10957:
10958: -- time_phased_atp

Line 10964: l_mat_atp_info_rec MSC_ATP_REQ.Atp_Info_Rec;

10960: l_mem_stealing_qty NUMBER := 0;
10961: l_pf_stealing_qty NUMBER := 0;
10962: l_atf_date_qty NUMBER;
10963: l_pf_item_id NUMBER;
10964: l_mat_atp_info_rec MSC_ATP_REQ.Atp_Info_Rec;
10965: l_process_item_id NUMBER;
10966: l_return_status VARCHAR2(1);
10967: l_item_to_use NUMBER;
10968:

Line 11243: MSC_ATP_REQ.Get_Material_Atp_Info(

11239: l_mat_atp_info_rec.atf_date := p_atp_record.atf_date; -- For time_phased_atp
11240: l_mat_atp_info_rec.refresh_number := p_refresh_number; -- For summary enhancement
11241: l_mat_atp_info_rec.shipping_cal_code := p_atp_record.shipping_cal_code; -- Bug 3371817
11242:
11243: MSC_ATP_REQ.Get_Material_Atp_Info(
11244: l_mat_atp_info_rec,
11245: l_atp_period,
11246: l_atp_supply_demand,
11247: x_return_status);