eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.VALIDATE_ORDIM dependencies on ORDDCM_DOCS

Line 328: select count(*) into l_num_docs from orddata.orddcm_docs

324: end;
325:
326: -- Now check whether default documents are inserted into the DICOM repository
327: begin
328: select count(*) into l_num_docs from orddata.orddcm_docs
329: where doc_name in
330: (
331: 'ordcman.xml',
332: 'ordcmcmc.xml',

Line 370: select doc_name from orddata.orddcm_docs

366: select 'ordcmui.xml' doc_name from dual
367: )
368: minus
369: (
370: select doc_name from orddata.orddcm_docs
371: where doc_name in
372: (
373: 'ordcman.xml',
374: 'ordcmcmc.xml',

Line 472: -- ordsys.orddcm_docs table will not exist for new installations

468:
469: if (l_prevDbVer = '11.1.0') and (l_status = 'UPGRADED') then
470: begin
471: -- Dynamic sql is used for compilation purposes because the
472: -- ordsys.orddcm_docs table will not exist for new installations
473: -- or if not upgrading from 11.1.0 database.
474: -- check for documents in ORDSYS schema
475: execute immediate 'select count(*) into l_num_docs from ordsys.orddcm_docs
476: where doc_name in

Line 475: execute immediate 'select count(*) into l_num_docs from ordsys.orddcm_docs

471: -- Dynamic sql is used for compilation purposes because the
472: -- ordsys.orddcm_docs table will not exist for new installations
473: -- or if not upgrading from 11.1.0 database.
474: -- check for documents in ORDSYS schema
475: execute immediate 'select count(*) into l_num_docs from ordsys.orddcm_docs
476: where doc_name in
477: (
478: ''ordcman.xml'',
479: ''ordcmcmc.xml'',

Line 510: for cur in (select doc_name from ordsys.orddcm_docs

506: --
507: -- Expect no differences between the ORDSYS and ORDDATA repos
508: --
509: l_dsql_block := 'BEGIN
510: for cur in (select doc_name from ordsys.orddcm_docs
511: minus select doc_name from orddata.orddcm_docs) loop
512: dbms_output.put_line(''ORDSYS doc: ''
513: || cur.doc_name || '' not in ORDDATA'');
514: end loop;

Line 511: minus select doc_name from orddata.orddcm_docs) loop

507: -- Expect no differences between the ORDSYS and ORDDATA repos
508: --
509: l_dsql_block := 'BEGIN
510: for cur in (select doc_name from ordsys.orddcm_docs
511: minus select doc_name from orddata.orddcm_docs) loop
512: dbms_output.put_line(''ORDSYS doc: ''
513: || cur.doc_name || '' not in ORDDATA'');
514: end loop;
515: end;';

Line 520: for cur in ( select doc_name from orddata.orddcm_docs

516:
517: execute immediate l_dsql_block;
518:
519: l_dsql_block := 'BEGIN
520: for cur in ( select doc_name from orddata.orddcm_docs
521: minus select doc_name from ordsys.orddcm_docs) loop
522: dbms_output.put_line(''ORDData doc: ''
523: || cur.doc_name || '' not in ORDSYS'');
524: end loop;

Line 521: minus select doc_name from ordsys.orddcm_docs) loop

517: execute immediate l_dsql_block;
518:
519: l_dsql_block := 'BEGIN
520: for cur in ( select doc_name from orddata.orddcm_docs
521: minus select doc_name from ordsys.orddcm_docs) loop
522: dbms_output.put_line(''ORDData doc: ''
523: || cur.doc_name || '' not in ORDSYS'');
524: end loop;
525: END;';