DBA Data[Home] [Help]

APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on JMF_SHIKYU_UTIL

Line 701: select JSO.OSA_ITEM_ID, JMF_SHIKYU_UTIL.Get_Primary_Uom_Code(JSO.OSA_ITEM_ID, JSO.OEM_ORGANIZATION_ID)

697: -- These conversions to primary UOM are done in caller program to avoid same in
698: -- called programs like Misc Issue/Return or WIP Completion/Return .
699:
700: -- Get primary UOM of OSA item.
701: select JSO.OSA_ITEM_ID, JMF_SHIKYU_UTIL.Get_Primary_Uom_Code(JSO.OSA_ITEM_ID, JSO.OEM_ORGANIZATION_ID)
702: into l_osa_item_id, l_osa_item_primary_uom
703: from JMF_SUBCONTRACT_ORDERS JSO
704: where JSO.SUBCONTRACT_PO_SHIPMENT_ID = p_po_shipment_id;
705:

Line 1222: l_workers JMF_SHIKYU_UTIL.g_request_tbl_type;

1218: l_post_qty_received NUMBER;
1219:
1220: l_rtv_unsuccessful EXCEPTION;
1221:
1222: l_workers JMF_SHIKYU_UTIL.g_request_tbl_type;
1223:
1224: l_transaction_type RCV_TRANSACTIONS.TRANSACTION_TYPE%Type;
1225: l_parent_transaction_id NUMBER;
1226: l_subinventory RCV_TRANSACTIONS.SUBINVENTORY%Type;

Line 1428: IF JMF_SHIKYU_UTIL.Has_worker_completed(l_return_number) THEN

1424:
1425:
1426: -- Wait till RTV completes to perform deallocation.
1427: LOOP
1428: IF JMF_SHIKYU_UTIL.Has_worker_completed(l_return_number) THEN
1429: EXIT;
1430: ELSE
1431: DBMS_LOCK.sleep(JMF_SHIKYU_UTIL.G_SLEEP_TIME);
1432: END IF;

Line 1431: DBMS_LOCK.sleep(JMF_SHIKYU_UTIL.G_SLEEP_TIME);

1427: LOOP
1428: IF JMF_SHIKYU_UTIL.Has_worker_completed(l_return_number) THEN
1429: EXIT;
1430: ELSE
1431: DBMS_LOCK.sleep(JMF_SHIKYU_UTIL.G_SLEEP_TIME);
1432: END IF;
1433: END LOOP;
1434:
1435: -- Again search for received quantity against Replenish Po Shipment

Line 1636: l_total_allocated_Qty := JMF_SHIKYU_UTIL.Get_Subcontract_Allocated_Qty

1632: FOR l_subcontract_po_shikyu_comp IN c_subcontract_po_shikyu_comp
1633: LOOP
1634:
1635: -- Get total allocated quantity for SHIKYU Component.
1636: l_total_allocated_Qty := JMF_SHIKYU_UTIL.Get_Subcontract_Allocated_Qty
1637: (p_po_shipment_id
1638: ,l_subcontract_po_shikyu_comp.shikyu_component_id);
1639:
1640: -- Get required quantity of shikyu component.