DBA Data[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_ATP_REQ

Line 3708: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,

3704: p_insert_flag IN NUMBER,
3705: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
3706: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
3707: x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
3708: p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
3709: p_request_item_id IN NUMBER, -- For time_phased_atp
3710: p_atf_date IN DATE) -- For time_phased_atp
3711: IS
3712: l_infinite_time_fence_date DATE;

Line 8620: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,

8616: /* spec changed as part of ship_rec_cal changes
8617: various input parameters passed in a record atp_info_rec
8618: */
8619: PROCEDURE Supplier_Alloc_Cum_Atp(
8620: p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,
8621: p_identifier IN NUMBER,
8622: p_request_date IN DATE,
8623: x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
8624: x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,

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

9106: 0)) quantity
9107: -- Supplier Capacity (SCLT) Changes Begin
9108: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9109: WHERE (p.order_type IN (5, 2)
9110: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = trunc(MSC_ATP_REQ.G_PROMISE_DATE) --4135752
9111: AND p.order_type = 1 AND p.promised_date IS NULL))
9112: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9113: -- WHERE p.order_type IN (5, 1, 2)
9114: AND p.plan_id = p_sup_atp_info_rec.plan_id

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

9267: 0)) quantity
9268: -- Supplier Capacity (SCLT) Changes Begin
9269: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9270: WHERE (p.order_type IN (5, 2)
9271: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9272: AND p.order_type = 1 AND p.promised_date IS NULL))
9273: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9274: -- WHERE p.order_type IN (5, 1, 2)
9275: AND p.plan_id = p_sup_atp_info_rec.plan_id

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

9550: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9551: -- Supplier Capacity (SCLT) Changes Begin
9552: FROM msc_supplies p,msc_item_hierarchy_mv MIHM
9553: WHERE (p.order_type IN (5, 2)
9554: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9555: AND p.order_type = 1 AND p.promised_date IS NULL))
9556:
9557: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9558: -- WHERE p.order_type IN (5, 1, 2)

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

9833: (NVL(p.implement_quantity,0) - p.new_order_quantity)
9834: -- Supplier Capacity (SCLT) Changes Begin
9835: FROM msc_supplies p ,msc_item_hierarchy_mv MIHM
9836: WHERE (p.order_type IN (5, 2)
9837: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
9838: AND p.order_type = 1 AND p.promised_date IS NULL))
9839:
9840: -- Supplier Capacity (SCLT) Accumulation Ignore Purchase Orders
9841: -- WHERE p.order_type IN (5, 1, 2)

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

10308: END IF;
10309: RAISE FND_API.G_EXC_ERROR;
10310: END IF;
10311:
10312: --4055719 , moved this code to MSC_ATP_REQ.get_supplier_atp_info
10313: -- get the infinite time fence date if it exists
10314: /*l_infinite_time_fence_date := MSC_ATP_FUNC.get_infinite_time_fence_date(null, --4055719
10315: null,null, p_sup_atp_info_rec.plan_id);
10316:

Line 10586: l_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;

10582: l_res_uom_type NUMBER;
10583: l_plan_info_rec MSC_ATP_PVT.plan_info_rec; -- added for bug 2392456
10584:
10585: --diag_atp
10586: l_get_mat_in_rec MSC_ATP_REQ.get_mat_in_rec;
10587:
10588:
10589: -- Agilent Allocated ATP Based on Planning Details changes Begin
10590: l_demand_class VARCHAR2(80);

Line 11184: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;

11180:
11181: -- Agilent Allocated ATP Based on Planning Details changes
11182: l_stealing_quantity NUMBER;
11183: --diag_atp
11184: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;
11185: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;
11186:
11187: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
11188:

Line 11185: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;

11181: -- Agilent Allocated ATP Based on Planning Details changes
11182: l_stealing_quantity NUMBER;
11183: --diag_atp
11184: L_GET_MAT_IN_REC MSC_ATP_REQ.GET_MAT_IN_REC;
11185: l_get_mat_out_rec MSC_ATP_REQ.get_mat_out_rec;
11186:
11187: l_item_info_rec MSC_ATP_PVT.item_attribute_rec;
11188:
11189: -- time_phased_atp

Line 11195: l_mat_atp_info_rec MSC_ATP_REQ.Atp_Info_Rec;

11191: l_mem_stealing_qty NUMBER := 0;
11192: l_pf_stealing_qty NUMBER := 0;
11193: l_atf_date_qty NUMBER;
11194: l_pf_item_id NUMBER;
11195: l_mat_atp_info_rec MSC_ATP_REQ.Atp_Info_Rec;
11196: l_process_item_id NUMBER;
11197: l_return_status VARCHAR2(1);
11198: l_item_to_use NUMBER;
11199:

Line 11474: MSC_ATP_REQ.Get_Material_Atp_Info(

11470: l_mat_atp_info_rec.atf_date := p_atp_record.atf_date; -- For time_phased_atp
11471: l_mat_atp_info_rec.refresh_number := p_refresh_number; -- For summary enhancement
11472: l_mat_atp_info_rec.shipping_cal_code := p_atp_record.shipping_cal_code; -- Bug 3371817
11473:
11474: MSC_ATP_REQ.Get_Material_Atp_Info(
11475: l_mat_atp_info_rec,
11476: l_atp_period,
11477: l_atp_supply_demand,
11478: x_return_status);