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 553: UPDATE jmf_subcontract_orders

549: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
550: AND l_wip_entity_id IS NOT NULL
551: THEN
552: -- Update JMF table with the wip job # if successful.
553: UPDATE jmf_subcontract_orders
554: SET wip_entity_id = l_wip_entity_id
555: , last_update_date = sysdate
556: , last_updated_by = FND_GLOBAL.user_id
557: , last_update_login = FND_GLOBAL.login_id

Line 748: , jmf_subcontract_orders jso

744: ELSE
745: SELECT wro.required_quantity
746: INTO l_quantity
747: FROM wip_requirement_operations wro
748: , jmf_subcontract_orders jso
749: WHERE wro.wip_entity_id = jso.wip_entity_id
750: AND wro.inventory_item_id = p_item_id
751: AND wro.organization_id = jso.tp_organization_id
752: AND wro.organization_id = p_organization_id