APPS.OKC_REPORT_PVT dependencies on OKC_REPORT_XML

Line 423: okc_report_xml_v M

419: pp_sql_id number,
420: pp_sql_date date) is
421: select '!'
422: from
423: okc_report_xml_v M
424: where M.CHR_ID = pp_chr_id
425: and M.MAJOR_VERSION = pp_major_version
426: and M.MINOR_VERSION = pp_minor_version
427: and M.SQL_ID = pp_sql_id

Line 438: okc_report_xml_v M

434: pp_sql_id number,
435: pp_sql_date date) is
436: select M.XML_TEXT
437: from
438: okc_report_xml_v M
439: where M.CHR_ID = pp_chr_id
440: and M.MAJOR_VERSION = pp_major_version
441: and M.MINOR_VERSION = pp_minor_version
442: and M.SQL_ID = pp_sql_id

Line 490: delete from okc_report_xml M

486: --
487: -- obsolete? - lock cache, update everything but clob
488: --
489: begin
490: delete from okc_report_xml M
491: where M.CHR_ID = G_kid
492: and M.MAJOR_VERSION = G_vid
493: and M.LANGUAGE = userenv('LANG')
494: and M.SQL_ID = l_sql_id

Line 498: insert into okc_report_xml

494: and M.SQL_ID = l_sql_id
495: ;
496: exception when others then NULL;
497: end;
498: insert into okc_report_xml
499: ( CHR_ID
500: ,MAJOR_VERSION
501: ,LANGUAGE
502: ,SQL_ID

Line 524: from okc_report_xml

520: sysdate,
521: fnd_global.login_id
522: );
523: select XML_TEXT into x_xml_text
524: from okc_report_xml
525: where CHR_ID = G_kid
526: and MAJOR_VERSION = G_vid
527: and LANGUAGE = userenv('LANG')
528: and SQL_ID = l_sql_id