[Home] [Help]
2123: FROM mtl_system_items
2124: WHERE inventory_item_id = l_component_id
2125: AND organization_id = l_tp_organization_id;
2126:
2127: l_ordered_uom:= JMF_SHIKYU_UTIL.Get_UOM_Code(l_po_uom);
2128:
2129: --Debugging for bug 9315131
2130: IF g_log_enabled AND
2131: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2624: INTO l_osa_tbl(i).uom_code
2625: FROM mtl_units_of_measure_vl
2626: WHERE unit_of_measure = l_osa_tbl(i).unit_of_measure;
2627:
2628: l_osa_tbl(i).primary_uom_code := JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
2629: ( l_osa_tbl(i).osa_item_id
2630: , l_osa_tbl(i).tp_organization_id
2631: );
2632:
3484: , po_lines_all pla
3485: WHERE plla.line_location_id = l_osa_tbl(i).subcontract_po_shipment_id
3486: AND plla.po_line_id = pla.po_line_id;
3487:
3488: l_primary_uom:= JMF_SHIKYU_UTIL.Get_Primary_UOM
3489: (l_osa_tbl(i).osa_item_id
3490: ,l_osa_tbl(i).tp_organization_id);
3491:
3492: -- Check if Purchasing UOM is different than the primary UOM of the item
3679: --=================
3680:
3681: TYPE t_osa_TabTyp IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
3682: l_osa_tbl t_osa_TabTyp;
3683: l_request_tbl JMF_SHIKYU_UTIL.g_request_tbl_type;
3684: l_batch_size NUMBER;
3685: l_curr_index NUMBER := 0;
3686: l_count NUMBER := 0;
3687: l_batch_id NUMBER;
3819:
3820: -- Invoke the worker to process the bunch of transactions that
3821: -- are grouped after generating a new batch id.
3822:
3823: JMF_SHIKYU_UTIL.Submit_Worker
3824: ( p_batch_id => l_batch_id
3825: , p_request_count => NVL(p_max_workers,1)
3826: , p_cp_short_name => 'JMFSKIWP'
3827: , p_cp_product_code => 'JMF'
3879: || 'l_request_tbl COUNT = ' || l_request_tbl.COUNT
3880: );
3881: END IF;
3882:
3883: jmf_shikyu_util.wait_for_all_workers(p_workers => l_request_tbl );
3884:
3885: IF g_log_enabled AND
3886: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3887: THEN