1 PACKAGE MRP_AATP_PVT AUTHID CURRENT_USER AS
2 /* $Header: MRPAATPS.pls 115.12 2002/12/02 20:43:30 dsting noship $ */
3
4 PROCEDURE Atp_Demand_Class_Consume(
5 p_current_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info,
6 p_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info);
7
8 PROCEDURE Add_to_Next_Steal_Atp(
9 p_current_atp IN MRP_ATP_PVT.ATP_Info,
10 p_next_steal_atp IN OUT NoCopy MRP_ATP_PVT.ATP_Info);
11
12 FUNCTION Get_Item_Demand_Alloc_Percent(
13 p_plan_id IN NUMBER,
14 p_demand_id IN NUMBER,
15 p_demand_date IN DATE,
16 p_assembly_item_id IN NUMBER,
17 p_source_org_id IN NUMBER,
18 p_inventory_item_id IN NUMBER,
19 p_org_id IN NUMBER,
20 p_instance_id IN NUMBER,
21 p_origination_type IN NUMBER,
22 p_record_class IN VARCHAR2,
23 p_demand_class IN VARCHAR2,
24 p_level_id IN NUMBER)
25 RETURN NUMBER;
26
27 FUNCTION Get_DC_Alloc_Percent(
28 p_instance_id IN NUMBER,
29 p_inv_item_id IN NUMBER,
30 p_org_id IN NUMBER,
31 p_dept_id IN NUMBER,
32 p_res_id IN NUMBER,
33 p_demand_class IN VARCHAR2,
34 p_request_date IN DATE)
35 RETURN NUMBER;
36
37 FUNCTION Get_Res_Demand_Alloc_Percent(
38 p_demand_date IN DATE,
39 p_assembly_item_id IN NUMBER,
40 p_org_id IN NUMBER,
41 p_instance_id IN NUMBER,
42 p_dept_id IN NUMBER,
43 p_res_id IN NUMBER,
44 p_record_class IN VARCHAR2,
45 p_demand_class IN VARCHAR2)
46 RETURN NUMBER;
47
48 PROCEDURE Item_Alloc_Cum_Atp(
49 p_plan_id IN NUMBER,
50 p_level IN NUMBER,
51 p_identifier IN NUMBER,
52 p_scenario_id IN NUMBER,
53 p_inventory_item_id IN NUMBER,
54 p_organization_id IN NUMBER,
55 p_instance_id IN NUMBER,
56 p_demand_class IN VARCHAR2,
57 p_request_date IN DATE,
58 p_insert_flag IN NUMBER,
59 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
60 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
61 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
62
63 PROCEDURE Res_Alloc_Cum_Atp(
64 p_plan_id IN NUMBER,
65 p_level IN NUMBER,
66 p_identifier IN NUMBER,
67 p_scenario_id IN NUMBER,
68 p_department_id IN NUMBER,
69 p_resource_id IN NUMBER,
70 p_organization_id IN NUMBER,
71 p_instance_id IN NUMBER,
72 p_demand_class IN VARCHAR2,
73 p_request_date IN DATE,
74 p_insert_flag IN NUMBER,
75 p_max_capacity IN NUMBER,
76 p_batchable_flag IN NUMBER,
77 p_res_conversion_rate IN NUMBER,
78 p_res_uom_type IN NUMBER,
79 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
80 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
81 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
82
83 PROCEDURE Supplier_Alloc_Cum_Atp(
84 p_plan_id IN NUMBER,
85 p_level IN NUMBER,
86 p_identifier IN NUMBER,
87 p_scenario_id IN NUMBER,
88 p_supplier_id IN NUMBER,
89 p_supplier_site_id IN NUMBER,
90 p_inventory_item_id IN NUMBER,
91 p_organization_id IN NUMBER,
92 p_instance_id IN NUMBER,
93 p_demand_class IN VARCHAR2,
94 p_request_date IN DATE,
95 p_insert_flag IN NUMBER,
96 x_atp_info OUT NoCopy MRP_ATP_PVT.ATP_Info,
97 x_atp_period OUT NoCopy MRP_ATP_PUB.ATP_Period_Typ,
98 x_atp_supply_demand OUT NoCopy MRP_ATP_PUB.ATP_Supply_Demand_Typ);
99
100 PROCEDURE Get_DC_Info(
101 p_instance_id IN NUMBER,
102 p_inv_item_id IN NUMBER,
103 p_org_id IN NUMBER,
104 p_dept_id IN NUMBER,
105 p_res_id IN NUMBER,
106 p_demand_class IN VARCHAR2,
107 p_request_date IN DATE,
108 x_level_id OUT NoCopy NUMBER,
109 x_priority OUT NoCopy NUMBER,
110 x_alloc_percent OUT NoCopy NUMBER,
111 x_return_status OUT NoCopy VARCHAR2);
112
113 PROCEDURE View_Allocation(
114 p_session_id IN NUMBER,
115 p_inventory_item_id IN NUMBER,
116 p_instance_id IN NUMBER,
117 p_organization_id IN NUMBER,
118 p_department_id IN NUMBER,
119 p_resource_id IN NUMBER,
120 p_demand_class IN VARCHAR2,
121 x_return_status OUT NoCopy VARCHAR2);
122
123 FUNCTION Get_Hierarchy_Demand_Class(
124 p_partner_id IN NUMBER,
125 p_partner_site_id IN NUMBER,
126 p_inventory_item_id IN NUMBER,
127 p_organization_id IN NUMBER,
128 p_instance_id IN NUMBER,
129 p_request_date IN DATE,
130 p_level_id IN NUMBER,
131 p_demand_class IN VARCHAR2)
132 RETURN VARCHAR2;
133
134 FUNCTION Get_Allowed_Stolen_Percent(
135 p_instance_id IN NUMBER,
136 p_inv_item_id IN NUMBER,
137 p_org_id IN NUMBER,
138 p_dept_id IN NUMBER,
139 p_res_id IN NUMBER,
140 p_demand_class IN VARCHAR2,
141 p_request_date IN DATE)
142 RETURN NUMBER;
143
144 END MRP_AATP_PVT;