57: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
58: ,x_message_count OUT NOCOPY NUMBER
59: ,x_message_list OUT NOCOPY VARCHAR2
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
62: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
63: ,p_batch_size IN NUMBER
64: ,p_batch_size_uom IN VARCHAR2
65: ,p_creation_mode IN VARCHAR2
58: ,x_message_count OUT NOCOPY NUMBER
59: ,x_message_list OUT NOCOPY VARCHAR2
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
62: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
63: ,p_batch_size IN NUMBER
64: ,p_batch_size_uom IN VARCHAR2
65: ,p_creation_mode IN VARCHAR2
66: ,p_recipe_id IN NUMBER := NULL
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
114: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
147: -- Navin Modified this APIas per GME_Scale_Batch_Theoretical_Yield_TD.
148: PROCEDURE scale_batch (
149: p_validation_level IN NUMBER
150: ,p_init_msg_list IN VARCHAR2
151: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
152: ,p_scale_factor IN NUMBER
153: ,p_primaries IN VARCHAR2
154: ,p_qty_type IN NUMBER
155: ,p_recalc_dates IN VARCHAR2 -- Navin
156: ,p_use_workday_cal IN VARCHAR2
157: ,p_contiguity_override IN VARCHAR2
158: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
159: --Navin
160: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
161: ,x_message_count OUT NOCOPY NUMBER
162: ,x_message_list OUT NOCOPY VARCHAR2
163: ,x_return_status OUT NOCOPY VARCHAR2);
164:
183: ================================================================================*/
184: PROCEDURE theoretical_yield_batch (
185: p_validation_level IN NUMBER
186: ,p_init_msg_list IN VARCHAR2
187: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
188: ,p_scale_factor IN NUMBER
189: ,x_message_count OUT NOCOPY NUMBER
190: ,x_message_list OUT NOCOPY VARCHAR2
191: ,x_return_status OUT NOCOPY VARCHAR2);
218: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
233: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
276: := fnd_api.g_false
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
295: := fnd_api.g_false
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
331: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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:
344: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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);
374: ================================================================================*/
375: PROCEDURE reschedule_batch (
376: p_validation_level IN NUMBER
377: ,p_init_msg_list IN VARCHAR2
378: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
379: ,p_use_workday_cal IN VARCHAR2
380: ,p_contiguity_override IN VARCHAR2
381: ,x_message_count OUT NOCOPY NUMBER
382: ,x_message_list OUT NOCOPY VARCHAR2
380: ,p_contiguity_override IN VARCHAR2
381: ,x_message_count OUT NOCOPY NUMBER
382: ,x_message_list OUT NOCOPY VARCHAR2
383: ,x_return_status OUT NOCOPY VARCHAR2
384: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
385:
386: /*=========================================9======================================
387: Procedure
388: reschedule_step
407: ================================================================================*/
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
444: V - Inventory shortage exists
445: ================================================================================*/
446: PROCEDURE create_batch_reservations (
447: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
448: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
449: ,x_message_count OUT NOCOPY NUMBER
450: ,x_message_list OUT NOCOPY VARCHAR2
451: ,x_return_status OUT NOCOPY VARCHAR2);
452:
502: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
503: ,x_message_count OUT NOCOPY NUMBER
504: ,x_message_list OUT NOCOPY VARCHAR2
505: ,x_return_status OUT NOCOPY VARCHAR2
506: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
507: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
508: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
509: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
510:
503: ,x_message_count OUT NOCOPY NUMBER
504: ,x_message_list OUT NOCOPY VARCHAR2
505: ,x_return_status OUT NOCOPY VARCHAR2
506: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
507: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
508: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
509: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
510:
511: /*================================================================================
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
543:
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,x_message_count OUT NOCOPY NUMBER
566: ,x_message_list OUT NOCOPY VARCHAR2
567: ,x_return_status OUT NOCOPY VARCHAR2
568: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
569: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
570: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
571: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
572:
565: ,x_message_count OUT NOCOPY NUMBER
566: ,x_message_list OUT NOCOPY VARCHAR2
567: ,x_return_status OUT NOCOPY VARCHAR2
568: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
569: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
570: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
571: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
572:
573: /*================================================================================
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
605:
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
633: insert_step
648: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
672: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
673: ,x_message_count OUT NOCOPY NUMBER
674: ,x_message_list OUT NOCOPY VARCHAR2
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
677: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
678:
679: /*================================================================================
680: Procedure
673: ,x_message_count OUT NOCOPY NUMBER
674: ,x_message_list OUT NOCOPY VARCHAR2
675: ,x_return_status OUT NOCOPY VARCHAR2
676: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
677: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
678:
679: /*================================================================================
680: Procedure
681: revert_step
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:
710: /*================================================================================
731: ,p_init_msg_list IN VARCHAR2
732: ,x_message_count OUT NOCOPY NUMBER
733: ,x_message_list OUT NOCOPY VARCHAR2
734: ,x_return_status OUT NOCOPY VARCHAR2
735: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
736: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
737:
738: /*================================================================================
739: Procedure
732: ,x_message_count OUT NOCOPY NUMBER
733: ,x_message_list OUT NOCOPY VARCHAR2
734: ,x_return_status OUT NOCOPY VARCHAR2
735: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
736: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
737:
738: /*================================================================================
739: Procedure
740: close_step
761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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:
792: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
793: ,x_message_count OUT NOCOPY NUMBER
794: ,x_message_list OUT NOCOPY VARCHAR2
795: ,x_return_status OUT NOCOPY VARCHAR2
796: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
797: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
798: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
799:
800: /*================================================================================
794: ,x_message_list OUT NOCOPY VARCHAR2
795: ,x_return_status OUT NOCOPY VARCHAR2
796: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
797: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
798: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
799:
800: /*================================================================================
801: Procedure
802: reopen_step
820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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: /*================================================================================
855: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
888: p_validation_level IN NUMBER
889: := gme_common_pvt.g_max_errors
890: ,p_init_msg_list IN VARCHAR2
891: DEFAULT fnd_api.g_false
892: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
893: ,p_validity_rule_id IN NUMBER
894: ,p_use_workday_cal IN VARCHAR2
895: DEFAULT fnd_api.g_false
896: ,p_contiguity_override IN VARCHAR2
897: DEFAULT fnd_api.g_false
898: ,x_message_count OUT NOCOPY NUMBER
899: ,x_message_list OUT NOCOPY VARCHAR2
900: ,x_return_status OUT NOCOPY VARCHAR2
901: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
902:
903: /*================================================================================
904: Procedure
905: cancel_batch
923: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
924: ,x_message_count OUT NOCOPY NUMBER
925: ,x_message_list OUT NOCOPY VARCHAR2
926: ,x_return_status OUT NOCOPY VARCHAR2
927: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
928: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
929:
930: /*================================================================================
931: Procedure
924: ,x_message_count OUT NOCOPY NUMBER
925: ,x_message_list OUT NOCOPY VARCHAR2
926: ,x_return_status OUT NOCOPY VARCHAR2
927: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
928: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
929:
930: /*================================================================================
931: Procedure
932: terminate_batch
952: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
953: ,x_message_count OUT NOCOPY NUMBER
954: ,x_message_list OUT NOCOPY VARCHAR2
955: ,x_return_status OUT NOCOPY VARCHAR2
956: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
957: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
958:
959: /*================================================================================
960: Procedure
953: ,x_message_count OUT NOCOPY NUMBER
954: ,x_message_list OUT NOCOPY VARCHAR2
955: ,x_return_status OUT NOCOPY VARCHAR2
956: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
957: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
958:
959: /*================================================================================
960: Procedure
961: unrelease_batch
979: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
980: ,x_message_count OUT NOCOPY NUMBER
981: ,x_message_list OUT NOCOPY VARCHAR2
982: ,x_return_status OUT NOCOPY VARCHAR2
983: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
984: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
985: ,p_create_resv_pend_lots IN NUMBER);
986:
987: /*================================================================================
980: ,x_message_count OUT NOCOPY NUMBER
981: ,x_message_list OUT NOCOPY VARCHAR2
982: ,x_return_status OUT NOCOPY VARCHAR2
983: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
984: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
985: ,p_create_resv_pend_lots IN NUMBER);
986:
987: /*================================================================================
988: Procedure
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:
1018: /*================================================================================
1059: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1060: x_message_count OUT NOCOPY NUMBER,
1061: x_message_list OUT NOCOPY VARCHAR2,
1062: x_return_status OUT NOCOPY VARCHAR2,
1063: p_batch_rec IN gme_batch_header%ROWTYPE);
1064:
1065: /*================================================================================
1066: Procedure
1067: create_pending_product_lot