[Home] [Help]
181: l_sql_id number;
182: cursor c_sql_id is
183: select SQL_ID from (
184: select SQL_ID, XST_ID
185: from OKC_REPORT_XST
186: connect by ID = prior XST_ID
187: start with ID = fnd_profile.value('OKC_WEB_REPORT')
188: ) where SQL_ID is not NULL;
189: begin
205: is
206: l_xsl_id number;
207: cursor c_xsl_id is
208: select XSL_ID
209: from OKC_REPORT_XST
210: where ID = fnd_profile.value('OKC_WEB_REPORT');
211: begin
212: open c_xsl_id;
213: fetch c_xsl_id into l_xsl_id;
408: l_cached varchar2(1);
409: l_sql_date DATE;
410: cursor sql_csr(p_xid number) is
411: select S.CACHE_YN, S.LAST_UPDATE_DATE, S.id SQL_ID
412: from OKC_REPORT_SQL_V S, OKC_REPORT_XST T
413: where T.id = p_xid and T.sql_id = S.id
414: and sysdate between S.start_date and nvl(S.end_date,sysdate);
415: l_dummy varchar2(1);
416: cursor xml_csr( pp_chr_id number,
557: max(Q.LAST_UPDATE_DATE),
558: max(T.LAST_UPDATE_DATE)) d
559: from
560: (select SQL_ID, XSL_ID, LAST_UPDATE_DATE
561: from OKC_REPORT_XST
562: connect by ID = prior XST_ID
563: start with ID = p_xst) T,
564: OKC_REPORT_XSL_V S,
565: OKC_REPORT_SQL_V Q
605: l_cached varchar2(1);
606: l_xst_date DATE;
607: cursor xst_csr(p_xst number) is
608: select T.CACHE_YN
609: from OKC_REPORT_XST_V T, OKC_REPORT_XSL_V L
610: where T.id = p_xst
611: and T.XSL_ID = L.ID
612: and sysdate between L.start_date and nvl(L.end_date,sysdate);
613: l_dummy varchar2(1);
818: l_dummy varchar2(1) := '?';
819: cursor c2 (p_xid number) is
820: select '!'
821: from
822: okc_report_xst X,
823: okc_report_prm_v P
824: where X.ID = p_xid
825: and P.sql_id = X.sql_id
826: and P.code not in ('xid', 'kid', 'vid', 'content_type');
1466: 'XSL' TEMPLATE_TYPE,
1467: S.NAME TEMPLATE_NAME
1468: from
1469: ( select XSL_ID,SQL_ID
1470: from OKC_REPORT_XST
1471: connect by ID = prior XST_ID
1472: start with ID = fnd_profile.value('OKC_WEB_REPORT')) T,
1473: OKC_REPORT_XSL_V S
1474: where T.XSL_ID = S.ID
1478: 'SQL' TEMPLATE_TYPE,
1479: Q.NAME TEMPLATE_NAME
1480: from
1481: ( select XSL_ID,SQL_ID
1482: from OKC_REPORT_XST
1483: connect by ID = prior XST_ID
1484: start with ID = fnd_profile.value('OKC_WEB_REPORT')) T,
1485: OKC_REPORT_SQL_V Q
1486: where T.SQL_ID = Q.ID
1495:
1496: l_dummy varchar2(1):='?';
1497: cursor report_exists is
1498: select '!'
1499: from OKC_REPORT_XST T, OKC_REPORT_XSL_V L
1500: where T.ID = fnd_profile.value('OKC_WEB_REPORT')
1501: and T.XSL_ID = L.ID;
1502:
1503: begin
1785: from okc_report_xsl_b
1786: where id between 10001 and 20000-1;
1787: elsif (p_entity = 'XST') then
1788: select NVL(max(id),10000)+1 into l_n
1789: from okc_report_xst
1790: where id between 10001 and 20000-1;
1791: end if;
1792: return l_n;
1793: end if;
1850:
1851: procedure set_sql_id is
1852: cursor c_sql_id is
1853: select T.SQL_ID
1854: from OKC_REPORT_XST T, OKC_REPORT_XSL_V L
1855: where T.ID = fnd_profile.value('OKC_WEB_REPORT')
1856: and T.XSL_ID = L.ID;
1857: begin
1858: G_sql_id := null;
2052: x_description out nocopy varchar2,
2053: x_sql out nocopy varchar2) is
2054: cursor c1 is
2055: select replace(prompt,'<',fnd_global.local_chr(38)||'lt;'), lov_query
2056: from okc_report_prm_v PRM, okc_report_xst_v XST
2057: where PRM.sql_id = XST.sql_id
2058: and XST.id = fnd_profile.value('OKC_WEB_REPORT')
2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');
2060: cursor c2 is
2161:
2162: cursor c2(x varchar2) is
2163: select
2164: S.NAME
2165: from okc_report_xst T,
2166: okc_report_sql_v Q,
2167: okc_report_xsl_v S
2168: where T.id = x
2169: and T.sql_id = Q.id
2311: cursor c2(x varchar2) is
2312: select
2313: Q.NAME NAME,
2314: S.NAME DESCRIPTION
2315: from okc_report_xst T,
2316: okc_report_sql_tl Q,
2317: okc_report_xsl_tl S
2318: where T.id = x
2319: and T.sql_id = Q.id