1 PACKAGE MSC_AATP_PVT AUTHID CURRENT_USER AS
2 /* $Header: MSCAATPS.pls 120.1 2007/12/12 10:03:19 sbnaik ship $ */
3
4 G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
5
6 PROCEDURE Atp_Demand_Class_Consume(
7 p_current_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
8 p_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
9 p_atf_date IN DATE := NULL); -- time_phased_atp
10
11
12 PROCEDURE Add_to_Next_Steal_Atp(
13 p_current_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info, --rajjain AATP Forward Consumption
14 p_next_steal_atp IN OUT NOCOPY MRP_ATP_PVT.ATP_Info);
15
16
17 PROCEDURE Item_Alloc_Cum_Atp(
18 p_plan_id IN NUMBER,
19 p_level IN NUMBER,
20 p_identifier IN NUMBER,
21 p_scenario_id IN NUMBER,
22 p_inventory_item_id IN NUMBER,
23 p_organization_id IN NUMBER,
24 p_instance_id IN NUMBER,
25 p_demand_class IN VARCHAR2,
26 p_request_date IN DATE,
27 p_insert_flag IN NUMBER,
28 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
29 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
30 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ,
31 p_get_mat_in_rec IN MSC_ATP_REQ.get_mat_in_rec,
32 p_request_item_id IN NUMBER, -- For time_phased_atp
33 p_atf_date IN DATE -- For time_phased_atp
34 );
35
36
37 PROCEDURE Res_Alloc_Cum_Atp(
38 p_plan_id IN NUMBER,
39 p_level IN NUMBER,
40 p_identifier IN NUMBER,
41 p_scenario_id IN NUMBER,
42 p_department_id IN NUMBER,
43 p_resource_id IN NUMBER,
44 p_organization_id IN NUMBER,
45 p_instance_id IN NUMBER,
46 p_demand_class IN VARCHAR2,
47 p_request_date IN DATE,
48 p_insert_flag IN NUMBER,
49 p_max_capacity IN NUMBER,
50 p_batchable_flag IN NUMBER,
51 p_res_conversion_rate IN NUMBER,
52 p_res_uom_type IN NUMBER,
53 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
54 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
55 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
56
57 /* spec changed as part of ship_rec_cal changes
58 various input parameters passed in a record atp_info_rec
59 */
60 PROCEDURE Supplier_Alloc_Cum_Atp(
61 p_sup_atp_info_rec IN MSC_ATP_REQ.ATP_Info_Rec,
62 p_identifier IN NUMBER,
63 p_request_date IN DATE,
64 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
65 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
66 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ
67 );
68
69
70 PROCEDURE Get_DC_Info(
71 p_instance_id IN NUMBER,
72 p_inv_item_id IN NUMBER,
73 p_org_id IN NUMBER,
74 p_dept_id IN NUMBER,
75 p_res_id IN NUMBER,
76 p_demand_class IN VARCHAR2,
77 p_request_date IN DATE,
78 x_level_id OUT NoCopy NUMBER,
79 x_priority OUT NoCopy NUMBER,
80 x_alloc_percent OUT NoCopy NUMBER,
81 x_return_status OUT NoCopy VARCHAR2);
82
83
84 PROCEDURE View_Allocation(
85 p_session_id IN NUMBER,
86 p_inventory_item_id IN NUMBER,
87 p_instance_id IN NUMBER,
88 p_organization_id IN NUMBER,
89 p_department_id IN NUMBER,
90 p_resource_id IN NUMBER,
91 p_demand_class IN VARCHAR2,
92 x_return_status OUT NoCopy VARCHAR2);
93
94 PROCEDURE Stealing (
95 p_atp_record IN OUT NoCopy MRP_ATP_PVT.AtpRec,
96 p_parent_pegging_id IN NUMBER,
97 p_scenario_id IN NUMBER,
98 p_level IN NUMBER,
99 p_search IN NUMBER,
100 p_plan_id IN NUMBER,
101 p_net_demand IN OUT NoCopy NUMBER,
102 x_total_mem_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
103 x_total_pf_stealing_qty OUT NOCOPY NUMBER, -- For time_phased_atp
104 x_atp_supply_demand OUT NOCOPY MRP_ATP_PUB.ATP_Supply_Demand_Typ,
105 x_atp_period OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
106 x_return_status OUT NoCopy VARCHAR2,
107 p_refresh_number IN NUMBER -- For summary enhancement
108 );
109
110
111 END MSC_AATP_PVT;