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);
228:
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
287: ,x_transacted OUT NOCOPY VARCHAR2
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
341: PROCEDURE delete_material_line (
408: PROCEDURE reschedule_step (
409: p_validation_level IN NUMBER
410: ,p_init_msg_list IN VARCHAR2
411: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
412: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
413: ,p_reschedule_preceding IN VARCHAR2
414: ,p_reschedule_succeeding IN VARCHAR2
415: ,p_use_workday_cal IN VARCHAR2
416: ,p_contiguity_override IN VARCHAR2
416: ,p_contiguity_override IN VARCHAR2
417: ,x_message_count OUT NOCOPY NUMBER
418: ,x_message_list OUT NOCOPY VARCHAR2
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
421:
422: /*================================================================================
423: Procedure
424: create_batch_reservations
534: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
535: ,x_message_count OUT NOCOPY NUMBER
536: ,x_message_list OUT NOCOPY VARCHAR2
537: ,x_return_status OUT NOCOPY VARCHAR2
538: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
539: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
540: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
541: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
542: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
536: ,x_message_list OUT NOCOPY VARCHAR2
537: ,x_return_status OUT NOCOPY VARCHAR2
538: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
539: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
540: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
541: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
542: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
543:
544: /*================================================================================
596: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: ,x_message_count OUT NOCOPY NUMBER
598: ,x_message_list OUT NOCOPY VARCHAR2
599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
601: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
603: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
604: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
598: ,x_message_list OUT NOCOPY VARCHAR2
599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
601: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
603: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
604: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
605:
606: /*================================================================================
624: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
625: ,x_message_count OUT NOCOPY NUMBER
626: ,x_message_list OUT NOCOPY VARCHAR2
627: ,x_return_status OUT NOCOPY VARCHAR2
628: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
629: ,p_batch_header_rec IN gme_batch_header%ROWTYPE);
630:
631: /*================================================================================
632: Procedure
649: ,x_message_count OUT NOCOPY NUMBER
650: ,x_message_list OUT NOCOPY VARCHAR2
651: ,x_return_status OUT NOCOPY VARCHAR2
652: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
653: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
654: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE);
655: /*================================================================================
656: Procedure
657: revert_to_wip_batch
650: ,x_message_list OUT NOCOPY VARCHAR2
651: ,x_return_status OUT NOCOPY VARCHAR2
652: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
653: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
654: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE);
655: /*================================================================================
656: Procedure
657: revert_to_wip_batch
658: Description
701: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
702: ,x_message_count OUT NOCOPY NUMBER
703: ,x_message_list OUT NOCOPY VARCHAR2
704: ,x_return_status OUT NOCOPY VARCHAR2
705: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
706: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
707: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
708:
709:
703: ,x_message_list OUT NOCOPY VARCHAR2
704: ,x_return_status OUT NOCOPY VARCHAR2
705: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
706: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
707: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
708:
709:
710: /*================================================================================
711: Procedure
762: ,x_message_count OUT NOCOPY NUMBER
763: ,x_message_list OUT NOCOPY VARCHAR2
764: ,x_return_status OUT NOCOPY VARCHAR2
765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
767: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
768: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
769:
770: /*================================================================================
764: ,x_return_status OUT NOCOPY VARCHAR2
765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
767: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
768: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
769:
770: /*================================================================================
771: Procedure
772: reopen_batch
821: ,x_message_count OUT NOCOPY NUMBER
822: ,x_message_list OUT NOCOPY VARCHAR2
823: ,x_return_status OUT NOCOPY VARCHAR2
824: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
825: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
826: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
827:
828: /*================================================================================
829: Procedure
822: ,x_message_list OUT NOCOPY VARCHAR2
823: ,x_return_status OUT NOCOPY VARCHAR2
824: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
825: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
826: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
827:
828: /*================================================================================
829: Procedure
830: incremental_backflush
1009: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1010: ,x_message_count OUT NOCOPY NUMBER
1011: ,x_message_list OUT NOCOPY VARCHAR2
1012: ,x_return_status OUT NOCOPY VARCHAR2
1013: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1014: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1015: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1016: ,p_create_resv_pend_lots IN NUMBER);
1017:
1011: ,x_message_list OUT NOCOPY VARCHAR2
1012: ,x_return_status OUT NOCOPY VARCHAR2
1013: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1014: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1015: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1016: ,p_create_resv_pend_lots IN NUMBER);
1017:
1018: /*================================================================================
1019: Procedure