DBA Data[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_MATERIAL_DETAILS

Line 108: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 111: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

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

Line 222: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

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

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

Line 237: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

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

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

Line 280: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 281: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

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

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

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

Line 299: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

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

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

Line 335: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 348: ,p_material_detail_rec IN gme_material_details%ROWTYPE

344: ,x_message_count OUT NOCOPY NUMBER
345: ,x_message_list OUT NOCOPY VARCHAR2
346: ,x_return_status OUT NOCOPY VARCHAR2
347: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
348: ,p_material_detail_rec IN gme_material_details%ROWTYPE
349: ,p_batch_step_id IN NUMBER := NULL
350: ,x_transacted OUT NOCOPY VARCHAR2);
351:
352: /*================================================================================

Line 474: ,p_matl_dtl_rec IN gme_material_details%ROWTYPE

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

Line 858: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 1034: ,p_material_detail_rec IN gme_material_details%ROWTYPE);

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