DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on STANDARD

Line 314: -- p_api_version Standard API parameter

310: -- PROCEDURE NAME: Allocate_Quantity
311: -- TYPE : PUBLIC
312: -- PARAMETERS :
313: -- IN:
314: -- p_api_version Standard API parameter
315: -- p_init_msg_list Standard API parameter
316: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
317: -- p_component_id SHIKYU Component Identifier
318: -- p_replen_so_line_id Replenishment Sales Order Line Identifier

Line 315: -- p_init_msg_list Standard API parameter

311: -- TYPE : PUBLIC
312: -- PARAMETERS :
313: -- IN:
314: -- p_api_version Standard API parameter
315: -- p_init_msg_list Standard API parameter
316: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
317: -- p_component_id SHIKYU Component Identifier
318: -- p_replen_so_line_id Replenishment Sales Order Line Identifier
319: -- p_primary_uom primary Unit Of Measure code of the

Line 323: -- x_return_status Standard API parameter

319: -- p_primary_uom primary Unit Of Measure code of the
320: -- SHIKYU Component to be allocated
321: -- p_qty_to_allocate Quantity to be allocated in primary UOM
322: -- OUT:
323: -- x_return_status Standard API parameter
324: -- x_msg_count Standard API parameter
325: -- x_msg_data Standard API parameter
326: -- x_qty_allocated Actual allocated quantity
327: --

Line 324: -- x_msg_count Standard API parameter

320: -- SHIKYU Component to be allocated
321: -- p_qty_to_allocate Quantity to be allocated in primary UOM
322: -- OUT:
323: -- x_return_status Standard API parameter
324: -- x_msg_count Standard API parameter
325: -- x_msg_data Standard API parameter
326: -- x_qty_allocated Actual allocated quantity
327: --
328: -- DESCRIPTION : Create allocations between the Subcontracting PO Shipment

Line 325: -- x_msg_data Standard API parameter

321: -- p_qty_to_allocate Quantity to be allocated in primary UOM
322: -- OUT:
323: -- x_return_status Standard API parameter
324: -- x_msg_count Standard API parameter
325: -- x_msg_data Standard API parameter
326: -- x_qty_allocated Actual allocated quantity
327: --
328: -- DESCRIPTION : Create allocations between the Subcontracting PO Shipment
329: -- and Replenishment SO Line specified by the IN parameters

Line 634: -- p_api_version Standard API parameter

630: -- PROCEDURE NAME: Allocate_Quantity
631: -- TYPE : PUBLIC
632: -- PARAMETERS :
633: -- IN:
634: -- p_api_version Standard API parameter
635: -- p_init_msg_list Standard API parameter
636: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
637: -- p_component_id SHIKYU Component Identifier
638: -- p_qty_to_allocate Quantity to be allocated in primary UOM

Line 635: -- p_init_msg_list Standard API parameter

631: -- TYPE : PUBLIC
632: -- PARAMETERS :
633: -- IN:
634: -- p_api_version Standard API parameter
635: -- p_init_msg_list Standard API parameter
636: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
637: -- p_component_id SHIKYU Component Identifier
638: -- p_qty_to_allocate Quantity to be allocated in primary UOM
639: -- p_available_replen_tbl PL/SQL table containing the replenishment

Line 643: -- x_return_status Standard API parameter

639: -- p_available_replen_tbl PL/SQL table containing the replenishment
640: -- SO Lines available for allocations to
641: -- the Subcontracting PO shipment specified
642: -- OUT:
643: -- x_return_status Standard API parameter
644: -- x_msg_count Standard API parameter
645: -- x_msg_data Standard API parameter
646: -- x_qty_allocated Actual allocated quantity
647: --

Line 644: -- x_msg_count Standard API parameter

640: -- SO Lines available for allocations to
641: -- the Subcontracting PO shipment specified
642: -- OUT:
643: -- x_return_status Standard API parameter
644: -- x_msg_count Standard API parameter
645: -- x_msg_data Standard API parameter
646: -- x_qty_allocated Actual allocated quantity
647: --
648: -- DESCRIPTION : Create allocations between the Subcontracting PO Shipment

Line 645: -- x_msg_data Standard API parameter

641: -- the Subcontracting PO shipment specified
642: -- OUT:
643: -- x_return_status Standard API parameter
644: -- x_msg_count Standard API parameter
645: -- x_msg_data Standard API parameter
646: -- x_qty_allocated Actual allocated quantity
647: --
648: -- DESCRIPTION : Create allocations between the Subcontracting PO Shipment
649: -- and the list of available Replenishment SO Lines, specified

Line 763: -- p_api_version Standard API parameter

759: -- PROCEDURE NAME: Get_Available_Replenishment_So
760: -- TYPE : PUBLIC
761: -- PARAMETERS :
762: -- IN:
763: -- p_api_version Standard API parameter
764: -- p_init_msg_list Standard API parameter
765: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
766: -- p_component_id SHIKYU Component Identifier
767: -- p_qty Quantity of the specified subcontracting

Line 764: -- p_init_msg_list Standard API parameter

760: -- TYPE : PUBLIC
761: -- PARAMETERS :
762: -- IN:
763: -- p_api_version Standard API parameter
764: -- p_init_msg_list Standard API parameter
765: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
766: -- p_component_id SHIKYU Component Identifier
767: -- p_qty Quantity of the specified subcontracting
768: -- component required

Line 770: -- x_return_status Standard API parameter

766: -- p_component_id SHIKYU Component Identifier
767: -- p_qty Quantity of the specified subcontracting
768: -- component required
769: -- OUT:
770: -- x_return_status Standard API parameter
771: -- x_msg_count Standard API parameter
772: -- x_msg_data Standard API parameter
773: -- x_available_replen_tbl PL/SQL table containing records of
774: -- g_replen_so_qty_rec_type that represents

Line 771: -- x_msg_count Standard API parameter

767: -- p_qty Quantity of the specified subcontracting
768: -- component required
769: -- OUT:
770: -- x_return_status Standard API parameter
771: -- x_msg_count Standard API parameter
772: -- x_msg_data Standard API parameter
773: -- x_available_replen_tbl PL/SQL table containing records of
774: -- g_replen_so_qty_rec_type that represents
775: -- the list of Replenishment Sales Order Lines

Line 772: -- x_msg_data Standard API parameter

768: -- component required
769: -- OUT:
770: -- x_return_status Standard API parameter
771: -- x_msg_count Standard API parameter
772: -- x_msg_data Standard API parameter
773: -- x_available_replen_tbl PL/SQL table containing records of
774: -- g_replen_so_qty_rec_type that represents
775: -- the list of Replenishment Sales Order Lines
776: -- with unallocated quantity available to

Line 1196: -- p_api_version Standard API parameter

1192: -- PROCEDURE NAME: Get_Available_Replenishment_Po
1193: -- TYPE : PUBLIC
1194: -- PARAMETERS :
1195: -- IN:
1196: -- p_api_version Standard API parameter
1197: -- p_init_msg_list Standard API parameter
1198: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
1199: -- p_component_id SHIKYU Component Identifier
1200: -- p_qty Quantity of the specified subcontracting

Line 1197: -- p_init_msg_list Standard API parameter

1193: -- TYPE : PUBLIC
1194: -- PARAMETERS :
1195: -- IN:
1196: -- p_api_version Standard API parameter
1197: -- p_init_msg_list Standard API parameter
1198: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
1199: -- p_component_id SHIKYU Component Identifier
1200: -- p_qty Quantity of the specified subcontracting
1201: -- component required

Line 1203: -- x_return_status Standard API parameter

1199: -- p_component_id SHIKYU Component Identifier
1200: -- p_qty Quantity of the specified subcontracting
1201: -- component required
1202: -- OUT:
1203: -- x_return_status Standard API parameter
1204: -- x_msg_count Standard API parameter
1205: -- x_msg_data Standard API parameter
1206: -- x_available_replen_tbl PL/SQL table containing records of
1207: -- g_replen_po_qty_rec_type that represents

Line 1204: -- x_msg_count Standard API parameter

1200: -- p_qty Quantity of the specified subcontracting
1201: -- component required
1202: -- OUT:
1203: -- x_return_status Standard API parameter
1204: -- x_msg_count Standard API parameter
1205: -- x_msg_data Standard API parameter
1206: -- x_available_replen_tbl PL/SQL table containing records of
1207: -- g_replen_po_qty_rec_type that represents
1208: -- the list of Replenishment PO Shipments

Line 1205: -- x_msg_data Standard API parameter

1201: -- component required
1202: -- OUT:
1203: -- x_return_status Standard API parameter
1204: -- x_msg_count Standard API parameter
1205: -- x_msg_data Standard API parameter
1206: -- x_available_replen_tbl PL/SQL table containing records of
1207: -- g_replen_po_qty_rec_type that represents
1208: -- the list of Replenishment PO Shipments
1209: -- with remaining quantity that does not

Line 1290: AND plla.shipment_type in ('STANDARD', 'BLANKET') -- Added for bug 13549961

1286: AND plla.po_header_id = pha.po_header_id
1287: AND pla.item_id = p_component_id
1288: AND pha.approved_flag = 'Y'
1289: AND nvl(plla.approved_flag, 'N') = 'Y' -- Added for bug 13549961
1290: AND plla.shipment_type in ('STANDARD', 'BLANKET') -- Added for bug 13549961
1291: AND NVL(pha.cancel_flag, 'N') = 'N'
1292: AND NVL(pla.cancel_flag, 'N') = 'N'
1293: AND NVL(plla.cancel_flag, 'N') = 'N'
1294: AND plla.unit_meas_lookup_code = muomv.unit_of_measure

Line 2017: -- p_api_version Standard API parameter

2013: -- PROCEDURE NAME: Create_New_Allocations
2014: -- TYPE : PUBLIC
2015: -- PARAMETERS :
2016: -- IN:
2017: -- p_api_version Standard API parameter
2018: -- p_init_msg_list Standard API parameter
2019: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
2020: -- p_component_id SHIKYU Component Identifier
2021: -- p_qty Quantity of allocations to be created

Line 2018: -- p_init_msg_list Standard API parameter

2014: -- TYPE : PUBLIC
2015: -- PARAMETERS :
2016: -- IN:
2017: -- p_api_version Standard API parameter
2018: -- p_init_msg_list Standard API parameter
2019: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
2020: -- p_component_id SHIKYU Component Identifier
2021: -- p_qty Quantity of allocations to be created
2022: -- p_skip_po_replen_creation Skip creation of new Replenishment PO for

Line 2027: -- x_return_status Standard API parameter

2023: -- sync-ship component (in cases where there
2024: -- are not enough available Replenishments)
2025: -- if the value is 'Y'
2026: -- OUT:
2027: -- x_return_status Standard API parameter
2028: -- x_msg_count Standard API parameter
2029: -- x_msg_data Standard API parameter
2030: --
2031: -- DESCRIPTION : Create allocations for the Subcontracting Component and

Line 2028: -- x_msg_count Standard API parameter

2024: -- are not enough available Replenishments)
2025: -- if the value is 'Y'
2026: -- OUT:
2027: -- x_return_status Standard API parameter
2028: -- x_msg_count Standard API parameter
2029: -- x_msg_data Standard API parameter
2030: --
2031: -- DESCRIPTION : Create allocations for the Subcontracting Component and
2032: -- the quantity specified by the IN parmeters. This procedure

Line 2029: -- x_msg_data Standard API parameter

2025: -- if the value is 'Y'
2026: -- OUT:
2027: -- x_return_status Standard API parameter
2028: -- x_msg_count Standard API parameter
2029: -- x_msg_data Standard API parameter
2030: --
2031: -- DESCRIPTION : Create allocations for the Subcontracting Component and
2032: -- the quantity specified by the IN parmeters. This procedure
2033: -- determines whether the SHIKYU component is Pre-positioned

Line 2639: -- p_api_version Standard API parameter

2635: -- PROCEDURE NAME: Reduce_Allocations
2636: -- TYPE : PUBLIC
2637: -- PARAMETERS :
2638: -- IN:
2639: -- p_api_version Standard API parameter
2640: -- p_init_msg_list Standard API parameter
2641: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
2642: -- p_component_id SHIKYU Component Identifier
2643: -- p_replen_so_line_id Replenishment Sales Order Line Identifier

Line 2640: -- p_init_msg_list Standard API parameter

2636: -- TYPE : PUBLIC
2637: -- PARAMETERS :
2638: -- IN:
2639: -- p_api_version Standard API parameter
2640: -- p_init_msg_list Standard API parameter
2641: -- p_subcontract_po_shipment_id Subcontract Order Shipment Identifier
2642: -- p_component_id SHIKYU Component Identifier
2643: -- p_replen_so_line_id Replenishment Sales Order Line Identifier
2644: -- p_qty_to_reduce Quantity to be deallocated

Line 2646: -- x_return_status Standard API parameter

2642: -- p_component_id SHIKYU Component Identifier
2643: -- p_replen_so_line_id Replenishment Sales Order Line Identifier
2644: -- p_qty_to_reduce Quantity to be deallocated
2645: -- OUT:
2646: -- x_return_status Standard API parameter
2647: -- x_msg_count Standard API parameter
2648: -- x_msg_data Standard API parameter
2649: -- x_actual_reduced_qty The actual quantity that was deallocated
2650: -- x_reduced_allocations_tbl PL/SQL Table containing information such

Line 2647: -- x_msg_count Standard API parameter

2643: -- p_replen_so_line_id Replenishment Sales Order Line Identifier
2644: -- p_qty_to_reduce Quantity to be deallocated
2645: -- OUT:
2646: -- x_return_status Standard API parameter
2647: -- x_msg_count Standard API parameter
2648: -- x_msg_data Standard API parameter
2649: -- x_actual_reduced_qty The actual quantity that was deallocated
2650: -- x_reduced_allocations_tbl PL/SQL Table containing information such
2651: -- as the actual deallocated quantity from

Line 2648: -- x_msg_data Standard API parameter

2644: -- p_qty_to_reduce Quantity to be deallocated
2645: -- OUT:
2646: -- x_return_status Standard API parameter
2647: -- x_msg_count Standard API parameter
2648: -- x_msg_data Standard API parameter
2649: -- x_actual_reduced_qty The actual quantity that was deallocated
2650: -- x_reduced_allocations_tbl PL/SQL Table containing information such
2651: -- as the actual deallocated quantity from
2652: -- the allocations being reduced.