[23 Oct 2020 01:09:53] (index) database connection response [23 Oct 2020 01:09:53] (index) getConnection(): Resource id #1 [23 Oct 2020 01:09:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 01:09:53] (index) database connection response [23 Oct 2020 01:09:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 01:09:53] (index) database connection response [23 Oct 2020 01:09:53] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '64' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 01:09:53] (index) database connection response [23 Oct 2020 01:09:53] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200451033' AND ACCESS_CODE = '77795251' [23 Oct 2020 01:09:54] (index) database connection response [23 Oct 2020 01:09:54] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200451033' AND ACCESS_CODE = '77795251' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 01:09:54] (index) database connection response [23 Oct 2020 01:09:54] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000036228' [23 Oct 2020 01:09:54] (index) database connection response [23 Oct 2020 01:09:54] (index) getPatientReportsDetail() entered [23 Oct 2020 01:09:54] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200451033', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 01:09:54] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200451033', 'M0100000036228', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 01:09:54] (index) p_Stop=N [23 Oct 2020 01:09:54] (index) p_Alert= [23 Oct 2020 01:09:54] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 01:09:54] (index) database connection response [23 Oct 2020 01:09:54] (index) getConnectionClose() called.... [23 Oct 2020 01:09:54] (index) getConnectionClose() called.... [23 Oct 2020 01:10:06] (viewOnlineReports) database connection response [23 Oct 2020 01:10:06] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 01:10:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000036228', '001', '200408974', '1', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 01:10:06] (viewOnlineReports) p_Stop=N [23 Oct 2020 01:10:06] (viewOnlineReports) p_Alert= [23 Oct 2020 01:10:06] (viewOnlineReports) Flag = 1 [23 Oct 2020 01:10:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200408974', 'M01', '047', '1', '001000000000080058', 'M0100000036228_M01RCH20020102_1.PDF', 'M0100000036228', SYSDATE) [23 Oct 2020 01:10:06] (viewOnlineReports) database connection response [23 Oct 2020 01:10:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200408974' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [23 Oct 2020 01:10:06] (viewOnlineReports) database connection response [23 Oct 2020 01:10:06] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 01:10:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200408974/ [23 Oct 2020 01:10:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200408974/ [23 Oct 2020 01:10:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201021\M01\M0100000036228_M01RCH20020102_1.PDF [23 Oct 2020 01:10:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200408974/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603397406M0100000036228_M01RCH20020102_1.PDF [23 Oct 2020 01:10:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200408974/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603397406M0100000036228_M01RCH20020102_1.PDF [23 Oct 2020 01:10:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 01:10:06] (viewOnlineReports) Downloading file ../../TEMP_PDF/200408974/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603397406M0100000036228_M01RCH20020102_1.PDF [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getConnection(): Resource id #1 [23 Oct 2020 06:37:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340529' AND ACCESS_CODE = '79232340' [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340529' AND ACCESS_CODE = '79232340' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 06:37:37] (index) database connection response [23 Oct 2020 06:37:37] (index) getConnectionClose() called.... [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getConnection(): Resource id #1 [23 Oct 2020 06:38:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340529' AND ACCESS_CODE = '79232340' [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200340529' AND ACCESS_CODE = '79232340' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 06:38:29] (index) database connection response [23 Oct 2020 06:38:29] (index) getConnectionClose() called.... [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getConnection(): Resource id #1 [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200453078' AND ACCESS_CODE = '79232340' [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200453078' AND ACCESS_CODE = '79232340' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000626700' [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getPatientReportsDetail() entered [23 Oct 2020 06:39:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200453078', 'M0100000626700', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 06:39:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200453078', 'M0100000626700', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 06:39:42] (index) p_Stop=N [23 Oct 2020 06:39:42] (index) p_Alert= [23 Oct 2020 06:39:42] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 06:39:42] (index) database connection response [23 Oct 2020 06:39:42] (index) getConnectionClose() called.... [23 Oct 2020 06:39:42] (index) getConnectionClose() called.... [23 Oct 2020 06:40:13] (viewOnlineReports) database connection response [23 Oct 2020 06:40:13] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 06:40:13] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '070', 'M0100000626700', '001', '200409579', '1', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 06:40:13] (viewOnlineReports) p_Stop=N [23 Oct 2020 06:40:13] (viewOnlineReports) p_Alert= [23 Oct 2020 06:40:13] (viewOnlineReports) Flag = 1 [23 Oct 2020 06:40:13] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409579', 'M01', '070', '1', '001000000000087630', 'M0100000626700_M01MOL20011058_1.PDF', 'M0100000626700', SYSDATE) [23 Oct 2020 06:40:13] (viewOnlineReports) database connection response [23 Oct 2020 06:40:13] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409579' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '070' AND TRANSACTION_NO = '1' [23 Oct 2020 06:40:13] (viewOnlineReports) database connection response [23 Oct 2020 06:40:13] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 06:40:13] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409579/ [23 Oct 2020 06:40:13] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409579/ [23 Oct 2020 06:40:13] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626700_M01MOL20011058_1.PDF [23 Oct 2020 06:40:13] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409579/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603417213M0100000626700_M01MOL20011058_1.PDF [23 Oct 2020 06:40:13] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409579/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603417213M0100000626700_M01MOL20011058_1.PDF [23 Oct 2020 06:40:13] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [23 Oct 2020 06:40:13] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200409579/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603417213M0100000626700_M01MOL20011058_1.PDF [23 Oct 2020 10:05:39] (index) database connection response [23 Oct 2020 10:05:39] (index) getConnection(): Resource id #1 [23 Oct 2020 10:05:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 10:05:39] (index) database connection response [23 Oct 2020 10:05:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 10:05:39] (index) database connection response [23 Oct 2020 10:05:39] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 10:05:39] (index) database connection response [23 Oct 2020 10:05:39] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452868' AND ACCESS_CODE = 'M01200340365' [23 Oct 2020 10:05:40] (index) database connection response [23 Oct 2020 10:05:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452868' AND ACCESS_CODE = 'M01200340365' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 10:05:40] (index) database connection response [23 Oct 2020 10:05:40] (index) getConnectionClose() called.... [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getConnection(): Resource id #1 [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '14' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452857' AND ACCESS_CODE = '01773810' [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452857' AND ACCESS_CODE = '01773810' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000639668' [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getPatientReportsDetail() entered [23 Oct 2020 10:07:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452857', 'M0100000639668', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 10:07:40] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452857', 'M0100000639668', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 10:07:40] (index) p_Stop=N [23 Oct 2020 10:07:40] (index) p_Alert= [23 Oct 2020 10:07:40] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 10:07:40] (index) database connection response [23 Oct 2020 10:07:40] (index) getConnectionClose() called.... [23 Oct 2020 10:07:40] (index) getConnectionClose() called.... [23 Oct 2020 10:07:46] (viewOnlineReports) database connection response [23 Oct 2020 10:07:46] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 10:07:46] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639668', '001', '200409534', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 10:07:46] (viewOnlineReports) p_Stop=N [23 Oct 2020 10:07:46] (viewOnlineReports) p_Alert= [23 Oct 2020 10:07:46] (viewOnlineReports) Flag = 1 [23 Oct 2020 10:07:46] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409534', 'M01', '047', '1', '001000000000085025', 'M0100000639668_M01HEM20014952_1.PDF', 'M0100000639668', SYSDATE) [23 Oct 2020 10:07:46] (viewOnlineReports) database connection response [23 Oct 2020 10:07:46] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409534' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [23 Oct 2020 10:07:46] (viewOnlineReports) database connection response [23 Oct 2020 10:07:46] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 10:07:46] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409534/ [23 Oct 2020 10:07:46] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409534/ [23 Oct 2020 10:07:46] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:07:46] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409534/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1603429666M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:07:46] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409534/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1603429666M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:07:46] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [23 Oct 2020 10:07:46] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200409534/0123456789ABCDEFGHIJLMNOPQRSTUVWXYZ1603429666M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:08:18] (viewOnlineReports) database connection response [23 Oct 2020 10:08:18] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 10:08:18] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000639668', '001', '200409534', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 10:08:18] (viewOnlineReports) p_Stop=N [23 Oct 2020 10:08:18] (viewOnlineReports) p_Alert= [23 Oct 2020 10:08:18] (viewOnlineReports) Flag = 1 [23 Oct 2020 10:08:18] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409534', 'M01', '047', '1', '001000000000085025', 'M0100000639668_M01HEM20014952_1.PDF', 'M0100000639668', SYSDATE) [23 Oct 2020 10:08:19] (viewOnlineReports) database connection response [23 Oct 2020 10:08:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409534' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [23 Oct 2020 10:08:19] (viewOnlineReports) database connection response [23 Oct 2020 10:08:19] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 10:08:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409534/ [23 Oct 2020 10:08:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409534/ [23 Oct 2020 10:08:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:08:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409534/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603429698M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:08:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409534/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603429698M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 10:08:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 10:08:19] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409534/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603429698M0100000639668_M01HEM20014952_1.PDF [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getConnection(): Resource id #1 [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452561' AND ACCESS_CODE = '62738340' [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452561' AND ACCESS_CODE = '62738340' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000458045' [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getPatientReportsDetail() entered [23 Oct 2020 12:37:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452561', 'M0100000458045', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 12:37:04] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452561', 'M0100000458045', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 12:37:04] (index) p_Stop=N [23 Oct 2020 12:37:04] (index) p_Alert= [23 Oct 2020 12:37:04] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 12:37:04] (index) database connection response [23 Oct 2020 12:37:04] (index) getConnectionClose() called.... [23 Oct 2020 12:37:04] (index) getConnectionClose() called.... [23 Oct 2020 12:37:22] (viewOnlineReports) database connection response [23 Oct 2020 12:37:22] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 12:37:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000458045', '001', '200409420', '1', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 12:37:22] (viewOnlineReports) p_Stop=N [23 Oct 2020 12:37:22] (viewOnlineReports) p_Alert= [23 Oct 2020 12:37:22] (viewOnlineReports) Flag = 1 [23 Oct 2020 12:37:22] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409420', 'M01', '010', '1', '001000000000082306', 'M0100000458045_M01SCH20011220_1.PDF', 'M0100000458045', SYSDATE) [23 Oct 2020 12:37:22] (viewOnlineReports) database connection response [23 Oct 2020 12:37:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409420' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '1' [23 Oct 2020 12:37:22] (viewOnlineReports) database connection response [23 Oct 2020 12:37:22] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 12:37:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1603438642M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1603438642M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 12:37:22] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTUWXYZ1603438642M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:27] (viewOnlineReports) database connection response [23 Oct 2020 12:37:27] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 12:37:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000458045', '001', '200409420', '1', '001000000000082306', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 12:37:27] (viewOnlineReports) p_Stop=N [23 Oct 2020 12:37:27] (viewOnlineReports) p_Alert= [23 Oct 2020 12:37:27] (viewOnlineReports) Flag = 1 [23 Oct 2020 12:37:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409420', 'M01', '010', '1', '001000000000082306', 'M0100000458045_M01SCH20011220_1.PDF', 'M0100000458045', SYSDATE) [23 Oct 2020 12:37:27] (viewOnlineReports) database connection response [23 Oct 2020 12:37:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409420' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '1' [23 Oct 2020 12:37:27] (viewOnlineReports) database connection response [23 Oct 2020 12:37:27] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 12:37:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603438647M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603438647M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 12:37:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOPQRSTVWXYZ1603438647M0100000458045_M01SCH20011220_1.PDF [23 Oct 2020 12:37:38] (viewOnlineReports) database connection response [23 Oct 2020 12:37:38] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 12:37:38] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '010', 'M0100000458045', '001', '200409420', '3', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 12:37:38] (viewOnlineReports) p_Stop=N [23 Oct 2020 12:37:38] (viewOnlineReports) p_Alert= [23 Oct 2020 12:37:38] (viewOnlineReports) Flag = 1 [23 Oct 2020 12:37:38] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409420', 'M01', '010', '3', '001000000000081028', 'M0100000458045_M01RCH20020180_1.PDF', 'M0100000458045', SYSDATE) [23 Oct 2020 12:37:38] (viewOnlineReports) database connection response [23 Oct 2020 12:37:38] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409420' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '010' AND TRANSACTION_NO = '3' [23 Oct 2020 12:37:38] (viewOnlineReports) database connection response [23 Oct 2020 12:37:38] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 12:37:38] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:38] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409420/ [23 Oct 2020 12:37:38] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000458045_M01RCH20020180_1.PDF [23 Oct 2020 12:37:38] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1603438658M0100000458045_M01RCH20020180_1.PDF [23 Oct 2020 12:37:38] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1603438658M0100000458045_M01RCH20020180_1.PDF [23 Oct 2020 12:37:38] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 12:37:38] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409420/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1603438658M0100000458045_M01RCH20020180_1.PDF [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getConnection(): Resource id #1 [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '43' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '43' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '43' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200453386' AND ACCESS_CODE = '45747566' [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200453386' AND ACCESS_CODE = '45747566' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000626462' [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getPatientReportsDetail() entered [23 Oct 2020 14:21:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200453386', 'M0100000626462', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:21:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200453386', 'M0100000626462', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:21:41] (index) p_Stop=N [23 Oct 2020 14:21:41] (index) p_Alert= [23 Oct 2020 14:21:41] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 14:21:41] (index) database connection response [23 Oct 2020 14:21:41] (index) getConnectionClose() called.... [23 Oct 2020 14:21:41] (index) getConnectionClose() called.... [23 Oct 2020 14:22:19] (viewOnlineReports) database connection response [23 Oct 2020 14:22:19] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:22:19] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '1', '001000000000080061', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:22:19] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:22:19] (viewOnlineReports) p_Alert= [23 Oct 2020 14:22:19] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:22:19] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '1', '001000000000080061', 'M0100000626462_M01RCH20020228_2.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:22:19] (viewOnlineReports) database connection response [23 Oct 2020 14:22:19] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '1' [23 Oct 2020 14:22:19] (viewOnlineReports) database connection response [23 Oct 2020 14:22:19] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:22:19] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:19] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:19] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01RCH20020228_2.PDF [23 Oct 2020 14:22:19] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603444939M0100000626462_M01RCH20020228_2.PDF [23 Oct 2020 14:22:19] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603444939M0100000626462_M01RCH20020228_2.PDF [23 Oct 2020 14:22:19] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:22:19] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603444939M0100000626462_M01RCH20020228_2.PDF [23 Oct 2020 14:22:32] (viewOnlineReports) database connection response [23 Oct 2020 14:22:32] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:22:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '2', '001000000000083036', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:22:32] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:22:32] (viewOnlineReports) p_Alert= [23 Oct 2020 14:22:32] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:22:32] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '2', '001000000000083036', 'M0100000626462_M01RCH20020228_5.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:22:32] (viewOnlineReports) database connection response [23 Oct 2020 14:22:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [23 Oct 2020 14:22:32] (viewOnlineReports) database connection response [23 Oct 2020 14:22:32] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:22:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01RCH20020228_5.PDF [23 Oct 2020 14:22:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603444952M0100000626462_M01RCH20020228_5.PDF [23 Oct 2020 14:22:32] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603444952M0100000626462_M01RCH20020228_5.PDF [23 Oct 2020 14:22:32] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:22:32] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603444952M0100000626462_M01RCH20020228_5.PDF [23 Oct 2020 14:22:40] (viewOnlineReports) database connection response [23 Oct 2020 14:22:40] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:22:40] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '3', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:22:40] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:22:40] (viewOnlineReports) p_Alert= [23 Oct 2020 14:22:40] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:22:40] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '3', '001000000000085025', 'M0100000626462_M01HEM20014979_1.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:22:40] (viewOnlineReports) database connection response [23 Oct 2020 14:22:40] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '3' [23 Oct 2020 14:22:40] (viewOnlineReports) database connection response [23 Oct 2020 14:22:40] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:22:40] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:40] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:40] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01HEM20014979_1.PDF [23 Oct 2020 14:22:40] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444960M0100000626462_M01HEM20014979_1.PDF [23 Oct 2020 14:22:40] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444960M0100000626462_M01HEM20014979_1.PDF [23 Oct 2020 14:22:40] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:22:40] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444960M0100000626462_M01HEM20014979_1.PDF [23 Oct 2020 14:22:47] (viewOnlineReports) database connection response [23 Oct 2020 14:22:47] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:22:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '4', '001000000000081028', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:22:47] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:22:47] (viewOnlineReports) p_Alert= [23 Oct 2020 14:22:47] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:22:47] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '4', '001000000000081028', 'M0100000626462_M01RCH20020228_3.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:22:47] (viewOnlineReports) database connection response [23 Oct 2020 14:22:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '4' [23 Oct 2020 14:22:47] (viewOnlineReports) database connection response [23 Oct 2020 14:22:47] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:22:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01RCH20020228_3.PDF [23 Oct 2020 14:22:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603444967M0100000626462_M01RCH20020228_3.PDF [23 Oct 2020 14:22:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603444967M0100000626462_M01RCH20020228_3.PDF [23 Oct 2020 14:22:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:22:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1603444967M0100000626462_M01RCH20020228_3.PDF [23 Oct 2020 14:22:55] (viewOnlineReports) database connection response [23 Oct 2020 14:22:55] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:22:55] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '5', '001000000000080058', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:22:55] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:22:55] (viewOnlineReports) p_Alert= [23 Oct 2020 14:22:55] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:22:55] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '5', '001000000000080058', 'M0100000626462_M01RCH20020228_1.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:22:55] (viewOnlineReports) database connection response [23 Oct 2020 14:22:55] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '5' [23 Oct 2020 14:22:55] (viewOnlineReports) database connection response [23 Oct 2020 14:22:55] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:22:55] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:55] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:22:55] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01RCH20020228_1.PDF [23 Oct 2020 14:22:55] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603444975M0100000626462_M01RCH20020228_1.PDF [23 Oct 2020 14:22:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603444975M0100000626462_M01RCH20020228_1.PDF [23 Oct 2020 14:22:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:22:55] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603444975M0100000626462_M01RCH20020228_1.PDF [23 Oct 2020 14:23:03] (viewOnlineReports) database connection response [23 Oct 2020 14:23:03] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 14:23:03] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000626462', '001', '200409594', '6', '001000000000082947', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 14:23:03] (viewOnlineReports) p_Stop=N [23 Oct 2020 14:23:03] (viewOnlineReports) p_Alert= [23 Oct 2020 14:23:03] (viewOnlineReports) Flag = 1 [23 Oct 2020 14:23:03] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409594', 'M01', '027', '6', '001000000000082947', 'M0100000626462_M01RCH20020228_4.PDF', 'M0100000626462', SYSDATE) [23 Oct 2020 14:23:03] (viewOnlineReports) database connection response [23 Oct 2020 14:23:03] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409594' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '6' [23 Oct 2020 14:23:03] (viewOnlineReports) database connection response [23 Oct 2020 14:23:03] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 14:23:03] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409594/ [23 Oct 2020 14:23:03] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409594/ [23 Oct 2020 14:23:03] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201023\M01\M0100000626462_M01RCH20020228_4.PDF [23 Oct 2020 14:23:03] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444983M0100000626462_M01RCH20020228_4.PDF [23 Oct 2020 14:23:03] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444983M0100000626462_M01RCH20020228_4.PDF [23 Oct 2020 14:23:03] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 14:23:03] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409594/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603444983M0100000626462_M01RCH20020228_4.PDF [23 Oct 2020 19:22:28] (index) database connection response [23 Oct 2020 19:22:28] (index) getConnection(): Resource id #1 [23 Oct 2020 19:22:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 19:22:28] (index) database connection response [23 Oct 2020 19:22:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 19:22:29] (index) database connection response [23 Oct 2020 19:22:29] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 19:22:29] (index) database connection response [23 Oct 2020 19:22:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452926' AND ACCESS_CODE = '64950320' [23 Oct 2020 19:22:29] (index) database connection response [23 Oct 2020 19:22:29] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452926' AND ACCESS_CODE = '64950320' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 19:22:29] (index) database connection response [23 Oct 2020 19:22:29] (index) getConnectionClose() called.... [23 Oct 2020 19:23:16] (index) database connection response [23 Oct 2020 19:23:16] (index) getConnection(): Resource id #1 [23 Oct 2020 19:23:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'POP-UP' [23 Oct 2020 19:23:16] (index) database connection response [23 Oct 2020 19:23:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'PLUG-IN' [23 Oct 2020 19:23:16] (index) database connection response [23 Oct 2020 19:23:16] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '86' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [23 Oct 2020 19:23:16] (index) database connection response [23 Oct 2020 19:23:16] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452926' AND ACCESS_CODE = '64950327' [23 Oct 2020 19:23:17] (index) database connection response [23 Oct 2020 19:23:17] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200452926' AND ACCESS_CODE = '64950327' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [23 Oct 2020 19:23:17] (index) database connection response [23 Oct 2020 19:23:17] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000510586' [23 Oct 2020 19:23:17] (index) database connection response [23 Oct 2020 19:23:17] (index) getPatientReportsDetail() entered [23 Oct 2020 19:23:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452926', 'M0100000510586', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:17] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200452926', 'M0100000510586', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:17] (index) p_Stop=N [23 Oct 2020 19:23:17] (index) p_Alert= [23 Oct 2020 19:23:17] (index) getQueryExecuted(): SELECT REPORT_DESTINATION_ID, MRNO, NAME, CPT_DESC, LIST.CPT_ID, SUBSTR(LIST.CPT_ID, LENGTH(LIST.CPT_ID) - 6, LENGTH(LIST.CPT_ID)) AS DISPLAY_CPT_ID, PDF_FILE_PATH, PDF_FILE_NAME, PDF_SERVER_NAME, EXPECTED_REPORT_DATE, ACTUAL_REPORT_DATE, LAST_VIEW_DATE, ORDER_DATE, ORDER_NO, ORDER_TYPE_ID, LOCATION_ID, ORDER_LOCATION_ID, CPT_REPORT_ID, TRANSACTION_NO, LIST.ORDER_STATUS_ID, OS.DESCRIPTION FROM ORDERENTRY.T_REPORT_LIST LIST , ORDERENTRY.ORDER_STATUS OS WHERE LIST.ORDER_STATUS_ID = OS.ORDER_STATUS_ID [23 Oct 2020 19:23:17] (index) database connection response [23 Oct 2020 19:23:17] (index) getConnectionClose() called.... [23 Oct 2020 19:23:17] (index) getConnectionClose() called.... [23 Oct 2020 19:23:33] (viewOnlineReports) database connection response [23 Oct 2020 19:23:33] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:23:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:33] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:23:33] (viewOnlineReports) p_Alert= [23 Oct 2020 19:23:33] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:23:33] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '1', '001000000000085025', 'M0100000510586_M01HEM20014954_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:23:34] (viewOnlineReports) database connection response [23 Oct 2020 19:23:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [23 Oct 2020 19:23:34] (viewOnlineReports) database connection response [23 Oct 2020 19:23:34] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:23:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:23:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603463013M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:23:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603463013M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:23:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:23:34] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1603463013M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:23:43] (viewOnlineReports) database connection response [23 Oct 2020 19:23:43] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:23:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '3', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:43] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:23:43] (viewOnlineReports) p_Alert= [23 Oct 2020 19:23:43] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:23:43] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '3', '001000000000084460', 'M0100000510586_M01RCH20020198_3.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:23:43] (viewOnlineReports) database connection response [23 Oct 2020 19:23:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [23 Oct 2020 19:23:43] (viewOnlineReports) database connection response [23 Oct 2020 19:23:43] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:23:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:23:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463023M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:23:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463023M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:23:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:23:43] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463023M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:23:44] (viewOnlineReports) database connection response [23 Oct 2020 19:23:44] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:23:44] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:44] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:23:44] (viewOnlineReports) p_Alert= [23 Oct 2020 19:23:44] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:23:44] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '2', '001000000000085651', 'M0100000510586_M01HEM20014954_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:23:44] (viewOnlineReports) database connection response [23 Oct 2020 19:23:44] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [23 Oct 2020 19:23:44] (viewOnlineReports) database connection response [23 Oct 2020 19:23:44] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:23:44] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:44] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:44] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:23:44] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463024M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:23:44] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463024M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:23:44] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:23:44] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1603463024M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:23:48] (viewOnlineReports) database connection response [23 Oct 2020 19:23:48] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:23:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '4', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:48] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:23:48] (viewOnlineReports) p_Alert= [23 Oct 2020 19:23:48] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:23:48] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '4', '001000000000084296', 'M0100000510586_M01RCH20020198_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:23:48] (viewOnlineReports) database connection response [23 Oct 2020 19:23:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [23 Oct 2020 19:23:48] (viewOnlineReports) database connection response [23 Oct 2020 19:23:48] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:23:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:23:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603463028M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:23:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603463028M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:23:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:23:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVXYZ1603463028M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:23:53] (viewOnlineReports) database connection response [23 Oct 2020 19:23:53] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:23:53] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:23:53] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:23:53] (viewOnlineReports) p_Alert= [23 Oct 2020 19:23:53] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:23:53] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '5', '001000000000086707', 'M0100000510586_M01MIC20008185_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:23:53] (viewOnlineReports) database connection response [23 Oct 2020 19:23:53] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [23 Oct 2020 19:23:53] (viewOnlineReports) database connection response [23 Oct 2020 19:23:53] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:23:53] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:53] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:23:53] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:23:53] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1603463033M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:23:53] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1603463033M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:23:53] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:23:53] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789BCDEFGHIJKLMNOPQRSTUVWXYZ1603463033M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:24:00] (viewOnlineReports) database connection response [23 Oct 2020 19:24:00] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:24:00] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '6', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:24:00] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:24:00] (viewOnlineReports) p_Alert= [23 Oct 2020 19:24:00] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:24:00] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '6', '001000000000081256', 'M0100000510586_M01MIC20008185_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:24:00] (viewOnlineReports) database connection response [23 Oct 2020 19:24:00] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [23 Oct 2020 19:24:00] (viewOnlineReports) database connection response [23 Oct 2020 19:24:00] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:24:00] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:00] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:00] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:24:00] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603463040M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:24:00] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603463040M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:24:00] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:24:00] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1603463040M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:24:02] (viewOnlineReports) database connection response [23 Oct 2020 19:24:02] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:24:02] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '7', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:24:02] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:24:02] (viewOnlineReports) p_Alert= [23 Oct 2020 19:24:02] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:24:02] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '7', '001000000000080092', 'M0100000510586_M01SCH20011233_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:24:02] (viewOnlineReports) database connection response [23 Oct 2020 19:24:02] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [23 Oct 2020 19:24:02] (viewOnlineReports) database connection response [23 Oct 2020 19:24:02] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:24:02] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:02] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:02] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:24:02] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463042M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:24:02] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463042M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:24:02] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:24:02] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463042M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:24:08] (viewOnlineReports) database connection response [23 Oct 2020 19:24:08] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:24:08] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '8', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:24:08] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:24:08] (viewOnlineReports) p_Alert= [23 Oct 2020 19:24:08] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:24:08] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '8', '001000000000082047', 'M0100000510586_M01RCH20020198_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:24:08] (viewOnlineReports) database connection response [23 Oct 2020 19:24:08] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [23 Oct 2020 19:24:08] (viewOnlineReports) database connection response [23 Oct 2020 19:24:08] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:24:08] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:08] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:24:08] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:24:08] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603463048M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:24:08] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603463048M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:24:08] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:24:08] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPRSTUVWXYZ1603463048M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:29:10] (viewOnlineReports) database connection response [23 Oct 2020 19:29:10] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:29:10] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '8', '001000000000082047', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:29:10] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:29:10] (viewOnlineReports) p_Alert= [23 Oct 2020 19:29:10] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:29:10] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '8', '001000000000082047', 'M0100000510586_M01RCH20020198_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:29:10] (viewOnlineReports) database connection response [23 Oct 2020 19:29:10] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '8' [23 Oct 2020 19:29:10] (viewOnlineReports) database connection response [23 Oct 2020 19:29:10] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:29:10] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:10] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:10] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:29:10] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603463350M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:29:10] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603463350M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:29:10] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:29:10] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEGHIJKLMNOPQRSTUVWXYZ1603463350M0100000510586_M01RCH20020198_1.PDF [23 Oct 2020 19:29:27] (viewOnlineReports) database connection response [23 Oct 2020 19:29:27] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:29:27] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '7', '001000000000080092', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:29:27] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:29:27] (viewOnlineReports) p_Alert= [23 Oct 2020 19:29:27] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:29:27] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '7', '001000000000080092', 'M0100000510586_M01SCH20011233_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:29:27] (viewOnlineReports) database connection response [23 Oct 2020 19:29:27] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [23 Oct 2020 19:29:27] (viewOnlineReports) database connection response [23 Oct 2020 19:29:27] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:29:27] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:27] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:27] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:29:27] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603463367M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:29:27] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603463367M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:29:27] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:29:27] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMOPQRSTUVWXYZ1603463367M0100000510586_M01SCH20011233_1.PDF [23 Oct 2020 19:29:43] (viewOnlineReports) database connection response [23 Oct 2020 19:29:43] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:29:43] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '6', '001000000000081256', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:29:43] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:29:43] (viewOnlineReports) p_Alert= [23 Oct 2020 19:29:43] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:29:43] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '6', '001000000000081256', 'M0100000510586_M01MIC20008185_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:29:43] (viewOnlineReports) database connection response [23 Oct 2020 19:29:43] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '6' [23 Oct 2020 19:29:43] (viewOnlineReports) database connection response [23 Oct 2020 19:29:43] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:29:43] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:43] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:29:43] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:29:43] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1603463383M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:29:43] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1603463383M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:29:43] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:29:43] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDFGHIJKLMNOPQRSTUVWXYZ1603463383M0100000510586_M01MIC20008185_1.PDF [23 Oct 2020 19:31:15] (viewOnlineReports) database connection response [23 Oct 2020 19:31:15] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:31:15] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '5', '001000000000086707', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:31:15] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:31:15] (viewOnlineReports) p_Alert= [23 Oct 2020 19:31:15] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:31:15] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '5', '001000000000086707', 'M0100000510586_M01MIC20008185_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:31:15] (viewOnlineReports) database connection response [23 Oct 2020 19:31:15] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '5' [23 Oct 2020 19:31:15] (viewOnlineReports) database connection response [23 Oct 2020 19:31:15] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:31:15] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:31:15] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:31:15] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:31:15] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463475M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:31:15] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463475M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:31:15] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:31:15] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463475M0100000510586_M01MIC20008185_2.PDF [23 Oct 2020 19:31:42] (viewOnlineReports) database connection response [23 Oct 2020 19:31:42] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:31:42] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '4', '001000000000084296', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:31:42] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:31:42] (viewOnlineReports) p_Alert= [23 Oct 2020 19:31:42] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:31:42] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '4', '001000000000084296', 'M0100000510586_M01RCH20020198_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:31:42] (viewOnlineReports) database connection response [23 Oct 2020 19:31:42] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [23 Oct 2020 19:31:42] (viewOnlineReports) database connection response [23 Oct 2020 19:31:42] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:31:42] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:31:42] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:31:42] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:31:42] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463502M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:31:42] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463502M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:31:42] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:31:42] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/012456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463502M0100000510586_M01RCH20020198_2.PDF [23 Oct 2020 19:33:29] (viewOnlineReports) database connection response [23 Oct 2020 19:33:29] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:33:29] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '3', '001000000000084460', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:33:29] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:33:29] (viewOnlineReports) p_Alert= [23 Oct 2020 19:33:29] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:33:29] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '3', '001000000000084460', 'M0100000510586_M01RCH20020198_3.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:33:29] (viewOnlineReports) database connection response [23 Oct 2020 19:33:29] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '3' [23 Oct 2020 19:33:29] (viewOnlineReports) database connection response [23 Oct 2020 19:33:29] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:33:29] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:29] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:29] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:33:29] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463609M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:33:29] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463609M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:33:29] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:33:29] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463609M0100000510586_M01RCH20020198_3.PDF [23 Oct 2020 19:33:48] (viewOnlineReports) database connection response [23 Oct 2020 19:33:48] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:33:48] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:33:48] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:33:48] (viewOnlineReports) p_Alert= [23 Oct 2020 19:33:48] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:33:48] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '2', '001000000000085651', 'M0100000510586_M01HEM20014954_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:33:48] (viewOnlineReports) database connection response [23 Oct 2020 19:33:48] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [23 Oct 2020 19:33:48] (viewOnlineReports) database connection response [23 Oct 2020 19:33:48] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:33:48] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:48] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:48] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:48] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463628M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:48] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463628M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:48] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:33:48] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCDEFGHIJKLMNOPQRSTUVWYZ1603463628M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:57] (viewOnlineReports) database connection response [23 Oct 2020 19:33:57] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:33:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '2', '001000000000085651', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:33:57] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:33:57] (viewOnlineReports) p_Alert= [23 Oct 2020 19:33:57] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:33:57] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '2', '001000000000085651', 'M0100000510586_M01HEM20014954_2.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:33:57] (viewOnlineReports) database connection response [23 Oct 2020 19:33:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '2' [23 Oct 2020 19:33:57] (viewOnlineReports) database connection response [23 Oct 2020 19:33:57] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:33:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:33:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603463637M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603463637M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:33:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:33:57] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1603463637M0100000510586_M01HEM20014954_2.PDF [23 Oct 2020 19:34:06] (viewOnlineReports) database connection response [23 Oct 2020 19:34:06] (viewOnlineReports) getConnection(): Resource id #1 [23 Oct 2020 19:34:06] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000510586', '001', '200409551', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [23 Oct 2020 19:34:06] (viewOnlineReports) p_Stop=N [23 Oct 2020 19:34:06] (viewOnlineReports) p_Alert= [23 Oct 2020 19:34:06] (viewOnlineReports) Flag = 1 [23 Oct 2020 19:34:06] (viewOnlineReports) insertRow(): INSERT INTO CCWEB.ONLINE_REPORTS_ACCESS_HISTORY (ORDER_TYPE_ID, ORDER_NO, LOCATION_ID, ORDER_LOCATION_ID, TRANSACTION_NO, CPT_REPORT_ID, PDF_FILE_NAME, VIEWED_BY, VIEWED_DATE) VALUES ('001', '200409551', 'M01', '047', '1', '001000000000085025', 'M0100000510586_M01HEM20014954_1.PDF', 'M0100000510586', SYSDATE) [23 Oct 2020 19:34:06] (viewOnlineReports) database connection response [23 Oct 2020 19:34:06] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200409551' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [23 Oct 2020 19:34:06] (viewOnlineReports) database connection response [23 Oct 2020 19:34:06] (viewOnlineReports) getConnectionClose() called.... [23 Oct 2020 19:34:06] (viewOnlineReports) creating directory structure../../TEMP_PDF/200409551/ [23 Oct 2020 19:34:06] (viewOnlineReports) directory structure created ../../TEMP_PDF/200409551/ [23 Oct 2020 19:34:06] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20201022\M01\M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:34:06] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200409551/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463646M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:34:06] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200409551/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463646M0100000510586_M01HEM20014954_1.PDF [23 Oct 2020 19:34:06] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [23 Oct 2020 19:34:06] (viewOnlineReports) Downloading file ../../TEMP_PDF/200409551/012345679ABCDEFGHIJKLMNOPQRSTUVWXYZ1603463646M0100000510586_M01HEM20014954_1.PDF