APPS.OKC_REPORT_PVT dependencies on OKC_REPORT_XSL_V

Line 268: -- similar to previous method based on view okc_report_xsl_v

264: -- get_art_help
265: --
266: -- PURPOSE
267: -- returns help text for standard atricles designer
268: -- similar to previous method based on view okc_report_xsl_v
269: --
270: function get_art_help(
271: p_xsl_id number -- if null derive from OKC_WEB_REPORT prof.
272: ) return clob

Line 279: from okc_report_xsl_v

275: l_name varchar2(150);
276: l_clob clob;
277: cursor c_clob(p_xsl number) is
278: select name, help_text
279: from okc_report_xsl_v
280: where id = p_xsl;
281: l_message varchar2(2000);
282: begin
283: if (p_xsl_id is NULL) then

Line 564: OKC_REPORT_XSL_V S,

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
566: where T.XSL_ID = S.ID
567: and T.SQL_ID = Q.ID (+);
568: begin

Line 609: from OKC_REPORT_XST_V T, OKC_REPORT_XSL_V L

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);

Line 1419: select name from okc_report_xsl_v

1415: cursor c_sql(p_sql number) is
1416: select name from okc_report_sql_v
1417: where id=p_sql;
1418: cursor c_xsl(p_xsl number) is
1419: select name from okc_report_xsl_v
1420: where id=p_xsl;
1421: begin
1422: if (p_type='SQL') then
1423: open c_sql(p_id);

Line 1473: OKC_REPORT_XSL_V S

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
1475: and not(sysdate between S.START_DATE and NVL(S.END_DATE,sysdate))
1476: union all
1477: select

Line 1499: from OKC_REPORT_XST T, OKC_REPORT_XSL_V L

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

Line 1814: from okc_report_xsl_v

1810: group by name
1811: having count(1)>1;
1812: cursor xsl_csr is
1813: select name
1814: from okc_report_xsl_v
1815: where nvl(end_date,sysdate)>=sysdate
1816: group by name
1817: having count(1)>1;
1818: l_name varchar2(150);

Line 1854: from OKC_REPORT_XST T, OKC_REPORT_XSL_V L

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;

Line 2167: okc_report_xsl_v S

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
2170: and T.xsl_id = S.id;
2171: begin