1250: WHERE orchestration_id = c_orchestration_id;
1251:
1252: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1253: SELECT wip_entity_id
1254: FROM po_requisition_lines_all
1255: WHERE requisition_header_id = c_requisition_header_id;
1256:
1257: BEGIN
1258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Purchase_Req...');
1297: csd_repairs dra,
1298: wip_entities we,
1299: po_requisition_headers_all porh,
1300: csd_repair_job_xref xref,
1301: po_requisition_lines_all porl
1302: where
1303: dra.repair_line_id = xref.repair_line_id and
1304: porh.type_lookup_code = 'PURCHASE' and
1305: we.wip_entity_id = xref.wip_entity_id and
1564: WHERE orchestration_id = c_orchestration_id;
1565:
1566: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1567: SELECT wip_entity_id
1568: FROM po_requisition_lines_all
1569: WHERE requisition_header_id = c_requisition_header_id;
1570:
1571: CURSOR c_get_order_header_id(c_requisition_header_id NUMBER,
1572: c_repair_line_id NUMBER) IS