eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_MATERIAL_DETAILS

Line 8: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 13: ,x_material_detail_rec OUT NOCOPY 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

Line 22: ,p_material_detail_rec IN gme_material_details%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:

Line 24: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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

Line 33: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 41: p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 54: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 62: p_matl_dtl_rec IN gme_material_details%ROWTYPE

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

Line 127: p_material_detail_rec IN gme_material_details%ROWTYPE

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 (

Line 153: p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 182: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 183: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 190: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);

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

Line 195: ,p_material_detail_rec IN 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);

Line 196: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

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:

Line 198: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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

Line 203: ,p_material_detail_rec IN 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 (

Line 208: 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

Line 213: ,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: