APPS.MSC_SRP_RELEASE dependencies on CSP_REPAIR_PO_HEADERS

Line 157: select requisition_number into lv_req_number from csp_repair_po_headers

153: RAISE FND_API.G_EXC_ERROR;
154: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
155: log_message('Successful in Creating Repair Req .');
156: log_output('Successful in Creating Repair Req .');
157: select requisition_number into lv_req_number from csp_repair_po_headers
158: where REQUISITION_HEADER_ID=X_requisition_header_id;
159: log_output('External Repair Requisition number :' ||lv_req_number);
160: Commit ;
161: END IF;

Line 299: select requisition_number into lv_req_number from csp_repair_po_headers

295: RAISE FND_API.G_EXC_ERROR;
296: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
297: log_message('Successful in Creating Repair Req .');
298: log_output('Successful in Creating Repair Req .');
299: select requisition_number into lv_req_number from csp_repair_po_headers
300: where REQUISITION_HEADER_ID=X_requisition_header_id;
301: log_output('External Repair Requisition number :' ||lv_req_number);
302: Commit ;
303: END IF;