DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_BATCH_HEADER

Line 7: (p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 16: (p_batch_header_rec IN gme_batch_header%ROWTYPE

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 (

Line 21: 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);

Line 32: p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 53: p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 64: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE

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:

Line 181: p_batch_header_rec IN gme_batch_header%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

Line 194: p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 202: p_batch_header_rec IN gme_batch_header%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:

Line 212: p_batch_header_rec IN gme_batch_header%ROWTYPE

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);