1 PACKAGE MSC_AATP_REQ AS
2 /* $Header: MSCRAATS.pls 120.1 2007/12/12 10:38:10 sbnaik ship $ */
3
4
5 PROCEDURE Item_Pre_Allocated_Atp(
6 p_plan_id IN NUMBER,
7 p_level IN NUMBER,
8 p_identifier IN NUMBER,
9 p_scenario_id IN NUMBER,
10 p_inventory_item_id IN NUMBER,
11 p_organization_id IN NUMBER,
12 p_instance_id IN NUMBER,
13 p_demand_class IN VARCHAR2,
14 p_request_date IN DATE,
15 p_insert_flag IN NUMBER,
16 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
17 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
18 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
19 p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
20 p_refresh_number IN NUMBER, -- For summary enhancement
21 p_request_item_id IN NUMBER, -- For time_phased_atp
22 p_atf_date IN DATE); -- For time_phased_atp
23
24 -- 3/6/2002, added this procedure by copying from MSC_ATP_REQ.Get_Material_Atp_Info
25 -- This will be called from MSC_ATP_PVT.ATP_Check for forward scheduling instead of Get_Material_Atp_Info
26 -- only for Allocated ATP in case forward stealing needs to be done.
27
28 PROCEDURE Get_Forward_Material_Atp(
29 p_instance_id IN NUMBER,
30 p_plan_id IN NUMBER,
31 p_level IN NUMBER,
32 p_identifier IN NUMBER,
33 p_demand_source_type IN NUMBER,--cmro
34 p_scenario_id IN NUMBER,
35 p_inventory_item_id IN NUMBER,
36 p_request_item_id IN NUMBER, -- For time_phased_atp
37 p_organization_id IN NUMBER,
38 p_item_name IN VARCHAR2,
39 p_family_item_name IN VARCHAR2, -- For time_phased_atp
40 p_requested_date IN DATE,
41 p_quantity_ordered IN NUMBER,
42 p_demand_class IN VARCHAR2,
43 x_requested_date_quantity OUT NoCopy NUMBER,
44 x_atf_date_quantity OUT NoCopy NUMBER, -- For time_phased_atp
45 x_atp_date_this_level OUT NoCopy DATE,
46 x_atp_date_quantity_this_level OUT NoCopy NUMBER,
47 x_atp_pegging_tab OUT NOCOPY MRP_ATP_PUB.Number_Arr,
48 x_return_status OUT NoCopy VARCHAR2,
49 x_used_available_quantity OUT NoCopy NUMBER, --bug3409973
50 p_substitution_window IN number,
51 p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
52 x_get_mat_out_rec OUT NOCOPY MSC_ATP_REQ.get_mat_out_rec,
53 p_atf_date IN DATE, -- For time_phased_atp
54 p_order_number IN NUMBER := NULL,
55 p_refresh_number IN NUMBER := NULL,
56 p_parent_pegging_id IN NUMBER := NULL
57 );
58
59
60 END MSC_AATP_REQ;