APPS.OKC_TAG_PVT dependencies on OKC_REPORT_XSL_B

Line 258: SELECT '!' FROM OKC_REPORT_XSL_B

254: E_Resource_Busy EXCEPTION;
255: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
256:
257: CURSOR xsl_csr (p IN NUMBER) IS
258: SELECT '!' FROM OKC_REPORT_XSL_B
259: WHERE ID = p FOR UPDATE OF LAST_UPDATE_DATE;
260: l_dummy varchar2(1) := '?';
261:
262: begin

Line 266: update okc_report_xsl_b set LAST_UPDATE_DATE = sysdate

262: begin
263: open xsl_csr(p_xsl_id);
264: fetch xsl_csr into l_dummy;
265: close xsl_csr;
266: update okc_report_xsl_b set LAST_UPDATE_DATE = sysdate
267: where id = p_xsl_id;
268: EXCEPTION
269: WHEN E_Resource_Busy THEN
270: IF (xsl_csr%ISOPEN) THEN