[Home] [Help]
1943: FROM mtl_system_items
1944: WHERE inventory_item_id = l_component_id
1945: AND organization_id = l_tp_organization_id;
1946:
1947: l_ordered_uom:= JMF_SHIKYU_UTIL.Get_UOM_Code(l_po_uom);
1948:
1949: IF l_primary_uom <> l_ordered_uom
1950: THEN
1951: l_primary_uom_qty := INV_CONVERT.inv_um_convert
2385: INTO l_osa_tbl(i).uom_code
2386: FROM mtl_units_of_measure_vl
2387: WHERE unit_of_measure = l_osa_tbl(i).unit_of_measure;
2388:
2389: l_osa_tbl(i).primary_uom_code := JMF_SHIKYU_UTIL.Get_Primary_Uom_Code
2390: ( l_osa_tbl(i).osa_item_id
2391: , l_osa_tbl(i).tp_organization_id
2392: );
2393:
3207: , po_lines_all pla
3208: WHERE plla.line_location_id = l_osa_tbl(i).subcontract_po_shipment_id
3209: AND plla.po_line_id = pla.po_line_id;
3210:
3211: l_primary_uom:= JMF_SHIKYU_UTIL.Get_Primary_UOM
3212: (l_osa_tbl(i).osa_item_id
3213: ,l_osa_tbl(i).tp_organization_id);
3214:
3215: -- Check if Purchasing UOM is different than the primary UOM of the item
3380: --=================
3381:
3382: TYPE t_osa_TabTyp IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
3383: l_osa_tbl t_osa_TabTyp;
3384: l_request_tbl JMF_SHIKYU_UTIL.g_request_tbl_type;
3385: l_batch_size NUMBER;
3386: l_curr_index NUMBER := 0;
3387: l_count NUMBER := 0;
3388: l_batch_id NUMBER;
3516:
3517: -- Invoke the worker to process the bunch of transactions that
3518: -- are grouped after generating a new batch id.
3519:
3520: JMF_SHIKYU_UTIL.Submit_Worker
3521: ( p_batch_id => l_batch_id
3522: , p_request_count => NVL(p_max_workers,1)
3523: , p_cp_short_name => 'JMFSKIWP'
3524: , p_cp_product_code => 'JMF'
3576: || 'l_request_tbl COUNT = ' || l_request_tbl.COUNT
3577: );
3578: END IF;
3579:
3580: jmf_shikyu_util.wait_for_all_workers(p_workers => l_request_tbl );
3581:
3582: IF g_log_enabled AND
3583: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3584: THEN