1 PACKAGE INV_Minmax_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVMMXS.pls 120.1.12010000.2 2010/02/03 13:25:25 sanjeevs ship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_Minmax_PVT';
5
6 --
7 -- Added 3 default NULL parameters p_cust_site_id,p_vmi_enabled and p_gen_report
8 -- to the procedure as part of Patchset I enhancements Replenishment Consolidation
9 -- and Min Max Lead Time Enhancement.
10 --
11
12 PROCEDURE run_min_max_plan ( p_item_select IN VARCHAR2
13 , p_handle_rep_item IN NUMBER
14 , p_pur_revision IN NUMBER
15 , p_cat_select IN VARCHAR2
16 , p_cat_set_id IN NUMBER
17 , p_mcat_struct IN NUMBER
18 , p_level IN NUMBER
19 , p_restock IN NUMBER
20 , p_include_nonnet IN NUMBER
21 , p_include_po IN NUMBER
22 , p_include_mo IN NUMBER DEFAULT 1
23 , p_include_wip IN NUMBER
24 , p_include_if IN NUMBER
25 , p_net_rsv IN NUMBER
26 , p_net_unrsv IN NUMBER
27 , p_net_wip IN NUMBER
28 , p_org_id IN NUMBER
29 , p_user_id IN NUMBER
30 , p_employee_id IN NUMBER
31 , p_subinv IN VARCHAR2
32 , p_dd_loc_id IN NUMBER
33 , p_wip_batch_id IN NUMBER
34 , p_approval IN NUMBER
35 , p_buyer_hi IN VARCHAR2
36 , p_buyer_lo IN VARCHAR2
37 , p_range_buyer IN VARCHAR2
38 , p_cust_id IN NUMBER
39 , p_cust_site_id IN NUMBER DEFAULT NULL
40 , p_po_org_id IN NUMBER
41 , p_range_sql IN VARCHAR2
42 , p_sort IN VARCHAR2
43 , p_selection IN NUMBER
44 , p_sysdate IN DATE
45 , p_s_cutoff IN DATE
46 , p_d_cutoff IN DATE
47 , p_order_by IN VARCHAR2
48 , p_encum_flag IN VARCHAR2
49 , p_cal_code IN VARCHAR2
50 , p_exception_set_id IN NUMBER
51 , p_gen_report IN VARCHAR2 DEFAULT NULL
52 , x_return_status OUT NOCOPY VARCHAR2
53 , x_msg_data OUT NOCOPY VARCHAR2
54 , p_osfm_batch_id IN NUMBER DEFAULT NULL /* Added for Bug 6807835 */
55 );
56
57 --Bug# 2677358
58 FUNCTION get_onhand_qty( p_include_nonnet NUMBER
59 , p_level NUMBER
60 , p_org_id NUMBER
61 , p_subinv VARCHAR2
62 , p_item_id NUMBER
63 , p_sysdate DATE) RETURN NUMBER;
64
65 --
66 -- Added a default NULL parameters p_customer_site_id
67 -- to the procedure as part of Patchset I Min Max Lead Time Enhancement.
68 --
69 PROCEDURE do_restock( p_item_id IN NUMBER
70 , p_mbf IN NUMBER
71 , p_handle_repetitive_item IN NUMBER
72 , p_repetitive_planned_item IN VARCHAR2
73 , p_qty IN NUMBER
74 , p_fixed_lead_time IN NUMBER
75 , p_variable_lead_time IN NUMBER
76 , p_buying_lead_time IN NUMBER
77 , p_uom IN VARCHAR2
78 , p_accru_acct IN NUMBER
79 , p_ipv_acct IN NUMBER
80 , p_budget_acct IN NUMBER
81 , p_charge_acct IN NUMBER
82 , p_purch_flag IN VARCHAR2
83 , p_order_flag IN VARCHAR2
84 , p_transact_flag IN VARCHAR2
85 , p_unit_price IN NUMBER
86 , p_wip_id IN NUMBER
87 , p_user_id IN NUMBER
88 , p_sysd IN DATE
89 , p_organization_id IN NUMBER
90 , p_approval IN NUMBER
91 , p_build_in_wip IN VARCHAR2
92 , p_pick_components IN VARCHAR2
93 , p_src_type IN NUMBER
94 , p_encum_flag IN VARCHAR2
95 , p_customer_id IN NUMBER
96 , p_customer_site_id IN NUMBER DEFAULT NULL
97 , p_cal_code IN VARCHAR2
98 , p_except_id IN NUMBER
99 , p_employee_id IN NUMBER
100 , p_description IN VARCHAR2
101 , p_src_org IN NUMBER
102 , p_src_subinv IN VARCHAR2
103 , p_subinv IN VARCHAR2
104 , p_location_id IN NUMBER
105 , p_po_org_id IN NUMBER
106 , p_pur_revision IN NUMBER
107 , x_ret_stat OUT NOCOPY VARCHAR2
108 , x_ret_mesg OUT NOCOPY VARCHAR2
109 , p_osfm_batch_id IN NUMBER DEFAULT NULL /* Added for Bug 6807835 */
110 );
111
112 /* nsinghi MIN-MAX INVCONV start */
113 /* Procedure do_restock overloaded as part of inventory convergence to make
114 call to process parameters. */
115
116 PROCEDURE do_restock( p_item_id IN NUMBER
117 , p_mbf IN NUMBER
118 , p_handle_repetitive_item IN NUMBER
119 , p_repetitive_planned_item IN VARCHAR2
120 , p_qty IN NUMBER
121 , p_fixed_lead_time IN NUMBER
122 , p_variable_lead_time IN NUMBER
123 , p_buying_lead_time IN NUMBER
124 , p_uom IN VARCHAR2
125 , p_accru_acct IN NUMBER
126 , p_ipv_acct IN NUMBER
127 , p_budget_acct IN NUMBER
128 , p_charge_acct IN NUMBER
129 , p_purch_flag IN VARCHAR2
130 , p_order_flag IN VARCHAR2
131 , p_transact_flag IN VARCHAR2
132 , p_unit_price IN NUMBER
133 , p_wip_id IN NUMBER
134 , p_user_id IN NUMBER
135 , p_sysd IN DATE
136 , p_organization_id IN NUMBER
137 , p_approval IN NUMBER
138 , p_build_in_wip IN VARCHAR2
139 , p_pick_components IN VARCHAR2
140 , p_src_type IN NUMBER
141 , p_encum_flag IN VARCHAR2
142 , p_customer_id IN NUMBER
143 , p_customer_site_id IN NUMBER DEFAULT NULL
144 , p_cal_code IN VARCHAR2
145 , p_except_id IN NUMBER
146 , p_employee_id IN NUMBER
147 , p_description IN VARCHAR2
148 , p_src_org IN NUMBER
149 , p_src_subinv IN VARCHAR2
150 , p_subinv IN VARCHAR2
151 , p_location_id IN NUMBER
152 , p_po_org_id IN NUMBER
153 , p_pur_revision IN NUMBER
154 , p_execution_enabled IN VARCHAR2 /* Added for process orgs */
155 , p_recipe_enabled IN VARCHAR2 /* Added for process orgs */
156 , p_process_enabled IN VARCHAR2 /* Added for process orgs */
157 , x_ret_stat OUT NOCOPY VARCHAR2
158 , x_ret_mesg OUT NOCOPY VARCHAR2
159 , p_osfm_batch_id IN NUMBER DEFAULT NULL /* Added for Bug 6807835 */
160 );
161 /* nsinghi MIN-MAX INVCONV end */
162
163 FUNCTION get_shipped_qty( p_organization_id IN NUMBER
164 , p_inventory_item_id IN NUMBER
165 , p_order_line_id IN NUMBER) RETURN NUMBER;
166
167 PRAGMA RESTRICT_REFERENCES(get_shipped_qty, WNDS);
168
169
170 FUNCTION get_staged_qty( p_org_id NUMBER
171 , p_subinv VARCHAR2
172 , p_item_id NUMBER
173 , p_order_line_id NUMBER
174 , p_include_nonnet NUMBER) RETURN NUMBER;
175
176 PRAGMA RESTRICT_REFERENCES(get_staged_qty, WNDS);
177
178
179 FUNCTION get_pick_released_qty( p_org_id NUMBER
180 , p_subinv VARCHAR2
181 , p_item_id NUMBER
182 , p_order_line_id NUMBER) RETURN NUMBER;
183
184 PRAGMA RESTRICT_REFERENCES(get_pick_released_qty, WNDS);
185
186 --Bug 9122329, Function added for getting the UOM_CODE.
187 FUNCTION get_item_uom_code (p_uom_name VARCHAR2) RETURN VARCHAR2;
188 --
189 END INV_Minmax_PVT;