DBA Data[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_MATERIAL_DETAILS

Line 109: ,p_material_detail_rec IN gme_material_details%ROWTYPE

105: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
106: ,x_message_count OUT NOCOPY NUMBER
107: ,x_message_list OUT NOCOPY VARCHAR2
108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,p_material_detail_rec IN gme_material_details%ROWTYPE
110: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
111: ,p_batch_no IN VARCHAR2 DEFAULT NULL
112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
113: ,p_validity_rule_id IN NUMBER

Line 112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

108: ,x_return_status OUT NOCOPY VARCHAR2
109: ,p_material_detail_rec IN gme_material_details%ROWTYPE
110: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
111: ,p_batch_no IN VARCHAR2 DEFAULT NULL
112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
113: ,p_validity_rule_id IN NUMBER
114: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
115: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
116: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

Line 223: ,p_material_detail_rec IN gme_material_details%ROWTYPE

219: ,x_message_count OUT NOCOPY NUMBER
220: ,x_message_list OUT NOCOPY VARCHAR2
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
223: ,p_material_detail_rec IN gme_material_details%ROWTYPE
224: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
225: ,p_trans_id IN NUMBER
226: ,x_transacted OUT NOCOPY VARCHAR2
227: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);

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

223: ,p_material_detail_rec IN gme_material_details%ROWTYPE
224: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
225: ,p_trans_id IN NUMBER
226: ,x_transacted OUT NOCOPY VARCHAR2
227: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
228:
229: -- following called from form... streamlined: step record not required
230: PROCEDURE insert_material_line (
231: p_validation_level IN NUMBER

Line 238: ,p_material_detail_rec IN gme_material_details%ROWTYPE

234: ,x_message_count OUT NOCOPY NUMBER
235: ,x_message_list OUT NOCOPY VARCHAR2
236: ,x_return_status OUT NOCOPY VARCHAR2
237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
238: ,p_material_detail_rec IN gme_material_details%ROWTYPE
239: ,p_batch_step_id IN NUMBER := NULL
240: ,p_trans_id IN NUMBER
241: ,x_transacted OUT NOCOPY VARCHAR2
242: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);

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

238: ,p_material_detail_rec IN gme_material_details%ROWTYPE
239: ,p_batch_step_id IN NUMBER := NULL
240: ,p_trans_id IN NUMBER
241: ,x_transacted OUT NOCOPY VARCHAR2
242: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
243:
244: /*================================================================================
245: Procedure
246: update_material_line

Line 281: ,p_material_detail_rec IN gme_material_details%ROWTYPE

277: ,x_message_count OUT NOCOPY NUMBER
278: ,x_message_list OUT NOCOPY VARCHAR2
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
281: ,p_material_detail_rec IN gme_material_details%ROWTYPE
282: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
283: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
284: ,p_scale_phantom IN VARCHAR2
285: := fnd_api.g_false

Line 282: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

278: ,x_message_list OUT NOCOPY VARCHAR2
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
281: ,p_material_detail_rec IN gme_material_details%ROWTYPE
282: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
283: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
284: ,p_scale_phantom IN VARCHAR2
285: := fnd_api.g_false
286: ,p_trans_id IN NUMBER

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

284: ,p_scale_phantom IN VARCHAR2
285: := fnd_api.g_false
286: ,p_trans_id IN NUMBER
287: ,x_transacted OUT NOCOPY VARCHAR2
288: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
289:
290: -- following called from form... streamlined: step record and stored matl dtl record not required
291: PROCEDURE update_material_line (
292: p_validation_level IN NUMBER

Line 300: ,p_material_detail_rec IN gme_material_details%ROWTYPE

296: ,x_message_count OUT NOCOPY NUMBER
297: ,x_message_list OUT NOCOPY VARCHAR2
298: ,x_return_status OUT NOCOPY VARCHAR2
299: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
300: ,p_material_detail_rec IN gme_material_details%ROWTYPE
301: ,p_batch_step_id IN NUMBER DEFAULT NULL
302: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
303: ,p_trans_id IN NUMBER
304: ,x_transacted OUT NOCOPY VARCHAR2

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

301: ,p_batch_step_id IN NUMBER DEFAULT NULL
302: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
303: ,p_trans_id IN NUMBER
304: ,x_transacted OUT NOCOPY VARCHAR2
305: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE);
306:
307: /*================================================================================
308: Procedure
309: delete_material_line

Line 336: ,p_material_detail_rec IN gme_material_details%ROWTYPE

332: ,x_message_count OUT NOCOPY NUMBER
333: ,x_message_list OUT NOCOPY VARCHAR2
334: ,x_return_status OUT NOCOPY VARCHAR2
335: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
336: ,p_material_detail_rec IN gme_material_details%ROWTYPE
337: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
338: ,x_transacted OUT NOCOPY VARCHAR2);
339:
340: -- following called from form... streamlined: step record not required

Line 349: ,p_material_detail_rec IN gme_material_details%ROWTYPE

345: ,x_message_count OUT NOCOPY NUMBER
346: ,x_message_list OUT NOCOPY VARCHAR2
347: ,x_return_status OUT NOCOPY VARCHAR2
348: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
349: ,p_material_detail_rec IN gme_material_details%ROWTYPE
350: ,p_batch_step_id IN NUMBER := NULL
351: ,p_bypass_gmf IN VARCHAR2 := 'N' -- Bug 13070352
352: ,x_transacted OUT NOCOPY VARCHAR2);
353:

Line 476: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE

472: V - Inventory shortage exists
473: ================================================================================*/
474: PROCEDURE create_line_reservations (
475: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
476: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE
477: ,x_message_count OUT NOCOPY NUMBER
478: ,x_message_list OUT NOCOPY VARCHAR2
479: ,x_return_status OUT NOCOPY VARCHAR2);
480:

Line 860: ,p_material_detail_rec IN gme_material_details%ROWTYPE

856: ,x_message_count OUT NOCOPY NUMBER
857: ,x_message_list OUT NOCOPY VARCHAR2
858: ,x_return_status OUT NOCOPY VARCHAR2
859: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
860: ,p_material_detail_rec IN gme_material_details%ROWTYPE
861: ,p_qty IN NUMBER
862: ,p_qty_type IN NUMBER
863: ,p_trans_date IN DATE
864: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

Line 1036: ,p_material_detail_rec IN gme_material_details%ROWTYPE);

1032: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1033: ,x_message_count OUT NOCOPY NUMBER
1034: ,x_message_list OUT NOCOPY VARCHAR2
1035: ,x_return_status OUT NOCOPY VARCHAR2
1036: ,p_material_detail_rec IN gme_material_details%ROWTYPE);
1037:
1038: /*================================================================================
1039: Procedure
1040: auto_detail_batch