APPS.OKC_PRM_PVT dependencies on OKC_REPORT_SQL_B

Line 402: SELECT '!' FROM OKC_REPORT_SQL_B

398: E_Resource_Busy EXCEPTION;
399: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
400:
401: CURSOR sql_csr (p IN NUMBER) IS
402: SELECT '!' FROM OKC_REPORT_SQL_B
403: WHERE ID = p FOR UPDATE OF LAST_UPDATE_DATE;
404: l_dummy varchar2(1) := '?';
405:
406: begin

Line 410: update okc_report_sql_b set LAST_UPDATE_DATE = sysdate

406: begin
407: open sql_csr(p_sql_id);
408: fetch sql_csr into l_dummy;
409: close sql_csr;
410: update okc_report_sql_b set LAST_UPDATE_DATE = sysdate
411: where id = p_sql_id;
412: EXCEPTION
413: WHEN E_Resource_Busy THEN
414: IF (sql_csr%ISOPEN) THEN