APPS.OKC_REPORT_PVT dependencies on OKC_REPORT_SQL_V

Line 226: -- "?" -> okc_report_sql_v.name

222: -- PURPOSE
223: -- returns help text for XSL designer in format
224: --
225: --

229: --        okc_report_sql_v.help_text

230: --        '&' and '<' replaced with '&'||'amp;' and '&'||'lt;'


Line 229: -- okc_report_sql_v.help_text


225: -- 


228: -- 


229: --        okc_report_sql_v.help_text

230: --        '&' and '<' replaced with '&'||'amp;' and '&'||'lt;'

231: --      


232: -- 

233: --


Line 243: from okc_report_sql_v


239: l_name varchar2(150);

240: l_clob clob;

241: cursor c_clob(p_sql number) is

242: select name, help_text

243: from okc_report_sql_v

244: where id = p_sql;

245: l_message varchar2(2000);

246: begin

247: if (p_sql_id is NULL) then


Line 412: from OKC_REPORT_SQL_V S, OKC_REPORT_XST T


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,


Line 565: OKC_REPORT_SQL_V Q


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

569: open last_update_csr(p_xst_id);


Line 1416: select name from okc_report_sql_v


1412: ) return varchar2 is

1413: l_message varchar2(2000);

1414: l_token varchar2(150);

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;


Line 1485: OKC_REPORT_SQL_V Q


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

1487: and not(sysdate between Q.START_DATE and NVL(Q.END_DATE,sysdate))

1488: ;

1489: cursor profile_options_csr is


Line 1746: cursor sql_csr is select name from okc_report_sql_v


1742: -- PURPOSE

1743: -- for internal use only

1744: --

1745: function get_sql_name(p_sql_id number) return varchar2 is

1746: cursor sql_csr is select name from okc_report_sql_v

1747: where id=p_sql_id;

1748: l_name varchar2(150);

1749: begin

1750: if p_sql_id is null then return NULL; end if;


Line 1808: from okc_report_sql_v


1804: 

1805: function check_name_uk(p_entity varchar2) return varchar2 is

1806: cursor sql_csr is

1807: select name

1808: from okc_report_sql_v

1809: where nvl(end_date,sysdate)>=sysdate

1810: group by name

1811: having count(1)>1;

1812: cursor xsl_csr is


Line 2166: okc_report_sql_v Q,


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

2170: and T.xsl_id = S.id;