APPS.JMF_SHIKYU_WIP_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 312: l_subcontract_orders_rec JMF_SUBCONTRACT_ORDERS%ROWTYPE;

308: l_group_id NUMBER;
309: l_wip_entity_id NUMBER;
310: l_return_status VARCHAR2(1);
311: l_error VARCHAR2(2000);
312: l_subcontract_orders_rec JMF_SUBCONTRACT_ORDERS%ROWTYPE;
313: l_need_by_date DATE;
314: l_component_id NUMBER;
315: l_total_qty NUMBER;
316: l_issued_qty NUMBER;

Line 323: FROM jmf_subcontract_orders

319:
320:
321: CURSOR c_rec IS
322: SELECT *
323: FROM jmf_subcontract_orders
324: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
325:
326: CURSOR c_comp_rec IS
327: SELECT shikyu_component_id

Line 503: UPDATE jmf_subcontract_orders

499: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
500: AND l_wip_entity_id IS NOT NULL
501: THEN
502: -- Update JMF table with the wip job # if successful.
503: UPDATE jmf_subcontract_orders
504: SET wip_entity_id = l_wip_entity_id
505: , last_update_date = sysdate
506: , last_updated_by = FND_GLOBAL.user_id
507: , last_update_login = FND_GLOBAL.login_id

Line 650: , jmf_subcontract_orders jso

646: ELSE
647: SELECT wro.required_quantity
648: INTO l_quantity
649: FROM wip_requirement_operations wro
650: , jmf_subcontract_orders jso
651: WHERE wro.wip_entity_id = jso.wip_entity_id
652: AND wro.inventory_item_id = p_item_id
653: AND wro.organization_id = jso.tp_organization_id
654: AND wro.organization_id = p_organization_id