1 PACKAGE gme_material_detail_pvt AS
2 /* $Header: GMEVMTLS.pls 120.6 2006/04/18 08:48:28 sudoddap noship $ */
3
4 g_date_fmt CONSTANT VARCHAR2(25) := 'YYYY-MON-DD HH24:MI:SS';
5
6 PROCEDURE insert_material_line
7 (p_batch_header_rec IN gme_batch_header%ROWTYPE
8 ,p_material_detail_rec IN gme_material_details%ROWTYPE
9 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10 ,p_trans_id IN NUMBER
11 ,x_transacted OUT NOCOPY VARCHAR2
12 ,x_return_status OUT NOCOPY VARCHAR2
13 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
14
15 PROCEDURE validate_batch_for_matl_ins
16 (p_batch_header_rec IN gme_batch_header%ROWTYPE
17 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
18 ,x_return_status OUT NOCOPY VARCHAR2);
19
20 PROCEDURE validate_material_for_ins (
21 p_batch_header_rec IN gme_batch_header%ROWTYPE
22 ,p_material_detail_rec IN gme_material_details%ROWTYPE
23 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
24 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
25 ,x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE validate_actual_qty (
28 p_actual_qty IN NUMBER
29 ,x_return_status OUT NOCOPY VARCHAR2);
30
31 PROCEDURE open_and_process_actual_qty (
32 p_batch_header_rec IN gme_batch_header%ROWTYPE
33 ,p_material_detail_rec IN gme_material_details%ROWTYPE
34 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL
35 ,p_trans_id IN NUMBER
36 ,p_insert IN VARCHAR2
37 ,x_transacted OUT NOCOPY VARCHAR2
38 ,x_return_status OUT NOCOPY VARCHAR2);
39
40 FUNCTION open_actual_qty (
41 p_material_detail_rec IN gme_material_details%ROWTYPE
42 ,p_batch_status IN NUMBER
43 ,p_update_inventory_ind IN VARCHAR2
44 ,p_batchstep_id IN NUMBER DEFAULT NULL
45 ,p_step_status IN NUMBER DEFAULT NULL
46 ,p_lot_control_code IN NUMBER DEFAULT NULL
47 ,p_location_control_code IN NUMBER DEFAULT NULL
48 ,p_restrict_locators_code IN NUMBER DEFAULT NULL
49 ,p_insert IN VARCHAR2)
50 RETURN NUMBER;
51
52 PROCEDURE process_actual_qty (
53 p_batch_header_rec IN gme_batch_header%ROWTYPE
54 ,p_material_detail_rec IN gme_material_details%ROWTYPE
55 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
56 DEFAULT NULL
57 ,p_trans_id IN NUMBER
58 ,p_item_rec IN mtl_system_items_b%ROWTYPE
59 ,x_return_status OUT NOCOPY VARCHAR2);
60
61 PROCEDURE construct_trans_row (
62 p_matl_dtl_rec IN gme_material_details%ROWTYPE
63 ,p_item_rec IN mtl_system_items_b%ROWTYPE
64 ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
65 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
66 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
67 ,x_return_status OUT NOCOPY VARCHAR2);
68
69 PROCEDURE get_converted_qty (
70 p_org_id IN NUMBER
71 ,p_item_id IN NUMBER
72 ,p_lot_number IN VARCHAR2 DEFAULT NULL
73 ,p_qty IN NUMBER
74 ,p_from_um IN VARCHAR2
75 ,p_to_um IN VARCHAR2
76 ,x_conv_qty OUT NOCOPY NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2);
78
79 PROCEDURE get_item_rec (
80 p_org_id IN NUMBER
81 ,p_item_id IN NUMBER
82 ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
83 ,x_return_status OUT NOCOPY VARCHAR2);
84
85 PROCEDURE validate_item_id (
86 p_org_id IN NUMBER
87 ,p_item_id IN NUMBER
88 ,x_item_rec OUT NOCOPY mtl_system_items_b%ROWTYPE
89 ,x_return_status OUT NOCOPY VARCHAR2);
90
91 PROCEDURE validate_revision (
92 p_revision IN VARCHAR2
93 ,p_item_rec IN mtl_system_items_b%ROWTYPE
94 ,x_return_status OUT NOCOPY VARCHAR2);
95
96 PROCEDURE validate_line_type (
97 p_line_type IN NUMBER
98 ,x_return_status OUT NOCOPY VARCHAR2);
99 --Bug#5129153 Changed the data type of 'p_byproduct_type' to VARCHAR2.
100 PROCEDURE validate_byproduct_type (
101 p_byproduct_type IN VARCHAR2
102 ,x_return_status OUT NOCOPY VARCHAR2);
103
104 PROCEDURE validate_line_no (
105 p_line_no IN NUMBER
106 ,p_line_type IN NUMBER
107 ,p_batch_id IN NUMBER
108 ,x_line_no OUT NOCOPY NUMBER
109 ,x_return_status OUT NOCOPY VARCHAR2);
110
111 PROCEDURE validate_dtl_um (
112 p_dtl_um IN VARCHAR2
113 ,p_primary_uom IN VARCHAR2
114 ,p_item_id IN NUMBER
115 ,p_org_id IN NUMBER
116 ,x_return_status OUT NOCOPY VARCHAR2);
117
118 PROCEDURE validate_plan_qty (
119 p_plan_qty IN NUMBER
120 ,x_return_status OUT NOCOPY VARCHAR2);
121
122 PROCEDURE validate_wip_plan_qty (
123 p_wip_plan_qty IN NUMBER
124 ,x_return_status OUT NOCOPY VARCHAR2);
125
126 PROCEDURE validate_release_type (
127 p_material_detail_rec IN gme_material_details%ROWTYPE
128 ,p_release_type IN NUMBER
129 ,x_return_status OUT NOCOPY VARCHAR2);
130
131 PROCEDURE validate_scrap_factor (
132 p_scrap IN NUMBER
133 ,x_return_status OUT NOCOPY VARCHAR2);
134
135 PROCEDURE validate_scale_multiple (
136 p_scale_mult IN NUMBER
137 ,x_return_status OUT NOCOPY VARCHAR2);
138
139 PROCEDURE validate_scale_round_var (
140 p_scale_var IN NUMBER
141 ,x_return_status OUT NOCOPY VARCHAR2);
142
143 PROCEDURE validate_rounding_direction (
144 p_round_dir IN NUMBER
145 ,x_return_status OUT NOCOPY VARCHAR2);
146
147 PROCEDURE validate_scale_type (
148 p_scale_type IN NUMBER
149 ,x_return_status OUT NOCOPY VARCHAR2);
150
151 --FPBug#4524232 changed parameter to material detail record
152 PROCEDURE validate_cost_alloc(
153 p_material_detail_rec IN gme_material_details%ROWTYPE
154 ,x_return_status OUT NOCOPY VARCHAR2);
155
156 PROCEDURE validate_phantom_type (
157 p_phantom_type IN NUMBER
158 ,x_return_status OUT NOCOPY VARCHAR2);
159
160 PROCEDURE validate_contr_yield_ind (
161 p_contr_yield_ind IN VARCHAR2 --FPBug#5040865
162 ,x_return_status OUT NOCOPY VARCHAR2);
163
164 PROCEDURE validate_contr_step_qty_ind (
165 p_contr_step_qty_ind IN VARCHAR2 --FPBug#5040865
166 ,x_return_status OUT NOCOPY VARCHAR2);
167
168 PROCEDURE validate_subinventory (
169 p_subinv IN VARCHAR2
170 ,p_item_rec IN mtl_system_items_b%ROWTYPE
171 ,x_return_status OUT NOCOPY VARCHAR2);
172
173 PROCEDURE validate_locator (
174 p_subinv IN VARCHAR2
175 ,p_locator_id IN NUMBER
176 ,p_item_rec IN mtl_system_items_b%ROWTYPE
177 ,p_line_type IN NUMBER
178 ,x_return_status OUT NOCOPY VARCHAR2);
179
180 PROCEDURE update_material_line (
181 p_batch_header_rec IN gme_batch_header%ROWTYPE
182 ,p_material_detail_rec IN gme_material_details%ROWTYPE
183 ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
184 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
185 ,p_scale_phantom IN VARCHAR2
186 := fnd_api.g_false
187 ,p_trans_id IN NUMBER
188 ,x_transacted OUT NOCOPY VARCHAR2
189 ,x_return_status OUT NOCOPY VARCHAR2
190 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
191
192 --Bug#5078853 removed p_validate_flexfields parameter
193 PROCEDURE val_and_pop_material_for_upd (
194 p_batch_header_rec IN gme_batch_header%ROWTYPE
195 ,p_material_detail_rec IN gme_material_details%ROWTYPE
196 ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
197 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
198 ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
199 ,x_return_status OUT NOCOPY VARCHAR2);
200
201 PROCEDURE validate_material_for_del (
202 p_batch_header_rec IN gme_batch_header%ROWTYPE
203 ,p_material_detail_rec IN gme_material_details%ROWTYPE
204 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
205 ,x_return_status OUT NOCOPY VARCHAR2);
206
207 PROCEDURE validate_phantom_type_change (
208 p_material_detail_rec IN gme_material_details%ROWTYPE
209 ,x_return_status OUT NOCOPY VARCHAR2);
210
211 PROCEDURE delete_material_line (
212 p_batch_header_rec IN gme_batch_header%ROWTYPE
213 ,p_material_detail_rec IN gme_material_details%ROWTYPE
214 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
215 ,x_transacted OUT NOCOPY VARCHAR2
216 ,x_return_status OUT NOCOPY VARCHAR2);
217
218 END gme_material_detail_pvt;