[02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getConnection(): Resource id #1 [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'SAFARI' AND BROWSER_VERSION = '604' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200300251' AND ACCESS_CODE = '50293761' [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200300251' AND ACCESS_CODE = '50293761' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000143973' [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getPatientReportsDetail() entered [02 Aug 2020 12:15:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200300251', 'M0100000143973', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:15:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200300251', 'M0100000143973', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:15:23] (index) p_Stop=N [02 Aug 2020 12:15:23] (index) p_Alert= [02 Aug 2020 12:15:23] (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 [02 Aug 2020 12:15:23] (index) database connection response [02 Aug 2020 12:15:23] (index) getConnectionClose() called.... [02 Aug 2020 12:15:23] (index) getConnectionClose() called.... [02 Aug 2020 12:15:59] (viewOnlineReports) database connection response [02 Aug 2020 12:15:59] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:15:59] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:15:59] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:15:59] (viewOnlineReports) p_Alert= [02 Aug 2020 12:15:59] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:15:59] (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', '200363455', 'M01', '047', '1', '001000000000085025', 'M0100000143973_M01HEM20009996_1.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:15:59] (viewOnlineReports) database connection response [02 Aug 2020 12:15:59] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Aug 2020 12:15:59] (viewOnlineReports) database connection response [02 Aug 2020 12:15:59] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:15:59] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:15:59] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:15:59] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200724\M01\M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:15:59] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596352559M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:15:59] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596352559M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:15:59] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:15:59] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01HEM20009996_1.jpg [02 Aug 2020 12:15:59] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596352559M0100000143973_M01HEM20009996_1.PDF ../../TEMP_PDF/200363455/M0100000143973_M01HEM20009996_1.jpg [02 Aug 2020 12:15:59] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/0123456789ACDEFGHIJKLMNOPQRSTUVWXYZ1596352559M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:17:55] (viewOnlineReports) database connection response [02 Aug 2020 12:17:55] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:17:55] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '1', '001000000000085025', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:17:55] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:17:55] (viewOnlineReports) p_Alert= [02 Aug 2020 12:17:55] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:17: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', '200363455', 'M01', '047', '1', '001000000000085025', 'M0100000143973_M01HEM20009996_1.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:17:55] (viewOnlineReports) database connection response [02 Aug 2020 12:17:55] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '1' [02 Aug 2020 12:17:55] (viewOnlineReports) database connection response [02 Aug 2020 12:17:55] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:17:55] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:17:55] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:17:55] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200724\M01\M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:17:55] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596352675M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:17:55] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596352675M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:17:55] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:17:55] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01HEM20009996_1.jpg [02 Aug 2020 12:17:55] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596352675M0100000143973_M01HEM20009996_1.PDF ../../TEMP_PDF/200363455/M0100000143973_M01HEM20009996_1.jpg [02 Aug 2020 12:17:55] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/0123456789ABCDEFGHJKLMNOPQRSTUVWXYZ1596352675M0100000143973_M01HEM20009996_1.PDF [02 Aug 2020 12:19:22] (viewOnlineReports) database connection response [02 Aug 2020 12:19:22] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:19:22] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '14', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:19:22] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:19:22] (viewOnlineReports) p_Alert= [02 Aug 2020 12:19:22] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:19: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', '200363455', 'M01', '047', '14', '001000000000086900', 'M0100000143973_M01BBK20001697_1.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:19:22] (viewOnlineReports) database connection response [02 Aug 2020 12:19:22] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '14' [02 Aug 2020 12:19:22] (viewOnlineReports) database connection response [02 Aug 2020 12:19:22] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:19:22] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:19:22] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:19:22] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200723\M01\M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:19:22] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352762M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:19:22] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352762M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:19:22] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:19:22] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01BBK20001697_1.jpg [02 Aug 2020 12:19:22] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352762M0100000143973_M01BBK20001697_1.PDF ../../TEMP_PDF/200363455/M0100000143973_M01BBK20001697_1.jpg [02 Aug 2020 12:19:22] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/012346789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352762M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:19:50] (viewOnlineReports) database connection response [02 Aug 2020 12:19:50] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:19:50] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '4', '001000000000087100', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:19:50] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:19:50] (viewOnlineReports) p_Alert= [02 Aug 2020 12:19:50] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:19:50] (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', '200363455', 'M01', '047', '4', '001000000000087100', 'M0100000143973_M01MIC20005296_1.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:19:50] (viewOnlineReports) database connection response [02 Aug 2020 12:19:50] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '4' [02 Aug 2020 12:19:50] (viewOnlineReports) database connection response [02 Aug 2020 12:19:50] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:19:50] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:19:50] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:19:50] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200723\M01\M0100000143973_M01MIC20005296_1.PDF [02 Aug 2020 12:19:50] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352790M0100000143973_M01MIC20005296_1.PDF [02 Aug 2020 12:19:50] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352790M0100000143973_M01MIC20005296_1.PDF [02 Aug 2020 12:19:50] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:19:50] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01MIC20005296_1.jpg [02 Aug 2020 12:19:50] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352790M0100000143973_M01MIC20005296_1.PDF ../../TEMP_PDF/200363455/M0100000143973_M01MIC20005296_1.jpg [02 Aug 2020 12:19:50] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/023456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352790M0100000143973_M01MIC20005296_1.PDF [02 Aug 2020 12:21:34] (viewOnlineReports) database connection response [02 Aug 2020 12:21:34] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:21:34] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '14', '001000000000086900', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:21:34] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:21:34] (viewOnlineReports) p_Alert= [02 Aug 2020 12:21:34] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:21:34] (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', '200363455', 'M01', '047', '14', '001000000000086900', 'M0100000143973_M01BBK20001697_1.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:21:34] (viewOnlineReports) database connection response [02 Aug 2020 12:21:34] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '14' [02 Aug 2020 12:21:34] (viewOnlineReports) database connection response [02 Aug 2020 12:21:34] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:21:34] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:21:34] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:21:34] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200723\M01\M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:21:34] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352894M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:21:34] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352894M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:21:34] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:21:34] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01BBK20001697_1.jpg [02 Aug 2020 12:21:34] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352894M0100000143973_M01BBK20001697_1.PDF ../../TEMP_PDF/200363455/M0100000143973_M01BBK20001697_1.jpg [02 Aug 2020 12:21:34] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/013456789ABCDEFGHIJKLMNOPQRSTUVWXYZ1596352894M0100000143973_M01BBK20001697_1.PDF [02 Aug 2020 12:21:45] (viewOnlineReports) database connection response [02 Aug 2020 12:21:45] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:21:45] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '12', '001000000000086762', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:21:45] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:21:45] (viewOnlineReports) p_Alert= [02 Aug 2020 12:21:45] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:21:45] (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', '200363455', 'M01', '047', '12', '001000000000086762', 'M0100000143973_M01SCH20007427_7.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:21:45] (viewOnlineReports) database connection response [02 Aug 2020 12:21:45] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '12' [02 Aug 2020 12:21:45] (viewOnlineReports) database connection response [02 Aug 2020 12:21:45] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:21:45] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:21:45] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:21:45] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200723\M01\M0100000143973_M01SCH20007427_7.PDF [02 Aug 2020 12:21:45] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596352905M0100000143973_M01SCH20007427_7.PDF [02 Aug 2020 12:21:45] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596352905M0100000143973_M01SCH20007427_7.PDF [02 Aug 2020 12:21:45] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:21:45] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01SCH20007427_7.jpg [02 Aug 2020 12:21:45] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596352905M0100000143973_M01SCH20007427_7.PDF ../../TEMP_PDF/200363455/M0100000143973_M01SCH20007427_7.jpg [02 Aug 2020 12:21:45] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNPQRSTUVWXYZ1596352905M0100000143973_M01SCH20007427_7.PDF [02 Aug 2020 12:22:21] (viewOnlineReports) database connection response [02 Aug 2020 12:22:21] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:22:21] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '7', '001000000000086302', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:22:21] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:22:21] (viewOnlineReports) p_Alert= [02 Aug 2020 12:22:21] (viewOnlineReports) Flag = 1 [02 Aug 2020 12:22:21] (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', '200363455', 'M01', '047', '7', '001000000000086302', 'M0100000143973_M01SCH20007427_4.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:22:21] (viewOnlineReports) database connection response [02 Aug 2020 12:22:21] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '7' [02 Aug 2020 12:22:21] (viewOnlineReports) database connection response [02 Aug 2020 12:22:21] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:22:21] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:22:21] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:22:21] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200723\M01\M0100000143973_M01SCH20007427_4.PDF [02 Aug 2020 12:22:21] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596352941M0100000143973_M01SCH20007427_4.PDF [02 Aug 2020 12:22:21] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596352941M0100000143973_M01SCH20007427_4.PDF [02 Aug 2020 12:22:21] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:22:21] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01SCH20007427_4.jpg [02 Aug 2020 12:22:21] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596352941M0100000143973_M01SCH20007427_4.PDF ../../TEMP_PDF/200363455/M0100000143973_M01SCH20007427_4.jpg [02 Aug 2020 12:22:21] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOQRSTUVWXYZ1596352941M0100000143973_M01SCH20007427_4.PDF [02 Aug 2020 12:22:32] (viewOnlineReports) database connection response [02 Aug 2020 12:22:32] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 12:22:32] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '047', 'M0100000143973', '001', '200363455', '9', '001000000000086777', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 12:22:32] (viewOnlineReports) p_Stop=N [02 Aug 2020 12:22:32] (viewOnlineReports) p_Alert= [02 Aug 2020 12:22:32] (viewOnlineReports) Flag = 1 [02 Aug 2020 12: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', '200363455', 'M01', '047', '9', '001000000000086777', 'M0100000143973_M01SCH20007427_9.PDF', 'M0100000143973', SYSDATE) [02 Aug 2020 12:22:32] (viewOnlineReports) database connection response [02 Aug 2020 12:22:32] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200363455' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '047' AND TRANSACTION_NO = '9' [02 Aug 2020 12:22:32] (viewOnlineReports) database connection response [02 Aug 2020 12:22:32] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 12:22:32] (viewOnlineReports) creating directory structure../../TEMP_PDF/200363455/ [02 Aug 2020 12:22:32] (viewOnlineReports) directory structure created ../../TEMP_PDF/200363455/ [02 Aug 2020 12:22:32] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200728\M01\M0100000143973_M01SCH20007427_9.PDF [02 Aug 2020 12:22:32] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596352952M0100000143973_M01SCH20007427_9.PDF [02 Aug 2020 12:22:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596352952M0100000143973_M01SCH20007427_9.PDF [02 Aug 2020 12:22:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> JPG [02 Aug 2020 12:22:33] (viewOnlineReports) Converting PDF to JPG with name as M0100000143973_M01SCH20007427_9.jpg [02 Aug 2020 12:22:33] (viewOnlineReports) D:\Zend_new\Apache2\htdocs\online\downloadreports Command = "C:\ImageMagick\convert.exe" ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596352952M0100000143973_M01SCH20007427_9.PDF ../../TEMP_PDF/200363455/M0100000143973_M01SCH20007427_9.jpg [02 Aug 2020 12:22:33] (viewOnlineReports) System is unable to create or load JPG file. Loading PDF format... PDF URL = ../../TEMP_PDF/200363455/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596352952M0100000143973_M01SCH20007427_9.PDF [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getConnection(): Resource id #1 [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getPatientReportsDetail() entered [02 Aug 2020 15:51:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 15:51:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 15:51:28] (index) p_Stop=N [02 Aug 2020 15:51:28] (index) p_Alert= [02 Aug 2020 15:51:28] (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 [02 Aug 2020 15:51:28] (index) database connection response [02 Aug 2020 15:51:28] (index) getConnectionClose() called.... [02 Aug 2020 15:51:28] (index) getConnectionClose() called.... [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getConnection(): Resource id #1 [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getPatientReportsDetail() entered [02 Aug 2020 16:38:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 16:38:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 16:38:22] (index) p_Stop=N [02 Aug 2020 16:38:22] (index) p_Alert= [02 Aug 2020 16:38:22] (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 [02 Aug 2020 16:38:22] (index) database connection response [02 Aug 2020 16:38:22] (index) getConnectionClose() called.... [02 Aug 2020 16:38:22] (index) getConnectionClose() called.... [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getConnection(): Resource id #1 [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getPatientReportsDetail() entered [02 Aug 2020 17:20:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 17:20:41] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 17:20:41] (index) p_Stop=N [02 Aug 2020 17:20:41] (index) p_Alert= [02 Aug 2020 17:20: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 [02 Aug 2020 17:20:41] (index) database connection response [02 Aug 2020 17:20:41] (index) getConnectionClose() called.... [02 Aug 2020 17:20:41] (index) getConnectionClose() called.... [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getConnection(): Resource id #1 [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getPatientReportsDetail() entered [02 Aug 2020 17:39:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 17:39:24] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 17:39:24] (index) p_Stop=N [02 Aug 2020 17:39:24] (index) p_Alert= [02 Aug 2020 17:39:24] (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 [02 Aug 2020 17:39:24] (index) database connection response [02 Aug 2020 17:39:24] (index) getConnectionClose() called.... [02 Aug 2020 17:39:24] (index) getConnectionClose() called.... [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getConnection(): Resource id #1 [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getPatientReportsDetail() entered [02 Aug 2020 23:03:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:03:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:03:28] (index) p_Stop=N [02 Aug 2020 23:03:28] (index) p_Alert= [02 Aug 2020 23:03:28] (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 [02 Aug 2020 23:03:28] (index) database connection response [02 Aug 2020 23:03:28] (index) getConnectionClose() called.... [02 Aug 2020 23:03:28] (index) getConnectionClose() called.... [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getConnection(): Resource id #1 [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = '' AND BROWSER_VERSION = '' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getPatientReportsDetail() entered [02 Aug 2020 23:05:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:05:00] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:05:00] (index) p_Stop=N [02 Aug 2020 23:05:00] (index) p_Alert= [02 Aug 2020 23:05:00] (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 [02 Aug 2020 23:05:00] (index) database connection response [02 Aug 2020 23:05:00] (index) getConnectionClose() called.... [02 Aug 2020 23:05:00] (index) getConnectionClose() called.... [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getConnection(): Resource id #1 [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getPatientReportsDetail() entered [02 Aug 2020 23:07:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:07:42] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:07:42] (index) p_Stop=N [02 Aug 2020 23:07:42] (index) p_Alert= [02 Aug 2020 23:07: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 [02 Aug 2020 23:07:42] (index) database connection response [02 Aug 2020 23:07:42] (index) getConnectionClose() called.... [02 Aug 2020 23:07:42] (index) getConnectionClose() called.... [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:10] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:10] (index) p_Stop=N [02 Aug 2020 23:08:10] (index) p_Alert= [02 Aug 2020 23:08:10] (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 [02 Aug 2020 23:08:10] (index) database connection response [02 Aug 2020 23:08:10] (index) getConnectionClose() called.... [02 Aug 2020 23:08:10] (index) getConnectionClose() called.... [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:21] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:21] (index) p_Stop=N [02 Aug 2020 23:08:21] (index) p_Alert= [02 Aug 2020 23:08:21] (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 [02 Aug 2020 23:08:21] (index) database connection response [02 Aug 2020 23:08:21] (index) getConnectionClose() called.... [02 Aug 2020 23:08:21] (index) getConnectionClose() called.... [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:23] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:23] (index) p_Stop=N [02 Aug 2020 23:08:23] (index) p_Alert= [02 Aug 2020 23:08:23] (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 [02 Aug 2020 23:08:23] (index) database connection response [02 Aug 2020 23:08:23] (index) getConnectionClose() called.... [02 Aug 2020 23:08:23] (index) getConnectionClose() called.... [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:27] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:27] (index) p_Stop=N [02 Aug 2020 23:08:27] (index) p_Alert= [02 Aug 2020 23:08:27] (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 [02 Aug 2020 23:08:27] (index) database connection response [02 Aug 2020 23:08:27] (index) getConnectionClose() called.... [02 Aug 2020 23:08:27] (index) getConnectionClose() called.... [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:28] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:28] (index) p_Stop=N [02 Aug 2020 23:08:28] (index) p_Alert= [02 Aug 2020 23:08:28] (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 [02 Aug 2020 23:08:28] (index) database connection response [02 Aug 2020 23:08:28] (index) getConnectionClose() called.... [02 Aug 2020 23:08:28] (index) getConnectionClose() called.... [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getConnection(): Resource id #1 [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getPatientReportsDetail() entered [02 Aug 2020 23:08:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:35] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:35] (index) p_Stop=N [02 Aug 2020 23:08:35] (index) p_Alert= [02 Aug 2020 23:08:35] (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 [02 Aug 2020 23:08:35] (index) database connection response [02 Aug 2020 23:08:35] (index) getConnectionClose() called.... [02 Aug 2020 23:08:35] (index) getConnectionClose() called.... [02 Aug 2020 23:08:39] (viewOnlineReports) database connection response [02 Aug 2020 23:08:39] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:08:39] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:39] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:08:39] (viewOnlineReports) p_Alert= [02 Aug 2020 23:08:39] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:08:39] (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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:08:39] (viewOnlineReports) database connection response [02 Aug 2020 23:08:39] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:08:39] (viewOnlineReports) database connection response [02 Aug 2020 23:08:39] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:08:39] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:08:39] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:08:39] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:39] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596391719M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:39] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596391719M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:39] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:08:39] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/012345689ABCDEFGHIJKLMNOPQRSTUVWXYZ1596391719M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:57] (viewOnlineReports) database connection response [02 Aug 2020 23:08:57] (viewOnlineReports) getConnection(): Resource id #7 [02 Aug 2020 23:08:57] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:08:57] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:08:57] (viewOnlineReports) p_Alert= [02 Aug 2020 23:08:57] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:08: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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:08:57] (viewOnlineReports) database connection response [02 Aug 2020 23:08:57] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:08:57] (viewOnlineReports) database connection response [02 Aug 2020 23:08:57] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:08:57] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:08:57] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:08:57] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:57] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596391737M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:57] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596391737M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:08:57] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:08:57] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKMNOPQRSTUVWXYZ1596391737M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:11] (viewOnlineReports) database connection response [02 Aug 2020 23:09:11] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:09:11] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:09:11] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:09:11] (viewOnlineReports) p_Alert= [02 Aug 2020 23:09:11] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:09:11] (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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:09:11] (viewOnlineReports) database connection response [02 Aug 2020 23:09:11] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:09:11] (viewOnlineReports) database connection response [02 Aug 2020 23:09:11] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:09:11] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:11] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:11] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:11] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596391751M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:11] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596391751M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:11] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:09:11] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/0123456789ABCEFGHIJKLMNOPQRSTUVWXYZ1596391751M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:24] (viewOnlineReports) database connection response [02 Aug 2020 23:09:24] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:09:24] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:09:24] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:09:24] (viewOnlineReports) p_Alert= [02 Aug 2020 23:09:24] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:09:24] (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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:09:24] (viewOnlineReports) database connection response [02 Aug 2020 23:09:24] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:09:24] (viewOnlineReports) database connection response [02 Aug 2020 23:09:24] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:09:24] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:24] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:24] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:24] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391764M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:24] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391764M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:24] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:09:24] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391764M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:33] (viewOnlineReports) database connection response [02 Aug 2020 23:09:33] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:09:33] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:09:33] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:09:33] (viewOnlineReports) p_Alert= [02 Aug 2020 23:09:33] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:09: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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:09:33] (viewOnlineReports) database connection response [02 Aug 2020 23:09:33] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:09:33] (viewOnlineReports) database connection response [02 Aug 2020 23:09:33] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:09:33] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:33] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:33] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:33] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596391773M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:33] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596391773M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:33] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:09:33] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQSTUVWXYZ1596391773M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:47] (viewOnlineReports) database connection response [02 Aug 2020 23:09:47] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:09:47] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:09:47] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:09:47] (viewOnlineReports) p_Alert= [02 Aug 2020 23:09:47] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:09: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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:09:47] (viewOnlineReports) database connection response [02 Aug 2020 23:09:47] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:09:47] (viewOnlineReports) database connection response [02 Aug 2020 23:09:47] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:09:47] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:47] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:47] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:47] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391787M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:47] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391787M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:47] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> PDF [02 Aug 2020 23:09:47] (viewOnlineReports) Opening PDF URL in new window ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLNOPQRSTUVWXYZ1596391787M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:58] (viewOnlineReports) database connection response [02 Aug 2020 23:09:58] (viewOnlineReports) getConnection(): Resource id #1 [02 Aug 2020 23:09:58] (viewOnlineReports) BEGIN HIS.REPORT_ACCESS_ALLOWED ('Y', 'M01', '027', 'M0100000158877', '001', '200366247', '2', '001000000000087630', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.REPORT_ACCESS_ALLOWED procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:09:58] (viewOnlineReports) p_Stop=N [02 Aug 2020 23:09:58] (viewOnlineReports) p_Alert= [02 Aug 2020 23:09:58] (viewOnlineReports) Flag = 1 [02 Aug 2020 23:09:58] (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', '200366247', 'M01', '027', '2', '001000000000087630', 'M0100000158877_M01MOL20006777_1.PDF', 'M0100000158877', SYSDATE) [02 Aug 2020 23:09:58] (viewOnlineReports) database connection response [02 Aug 2020 23:09:58] (viewOnlineReports) insertRow(): UPDATE CCWEB.ONLINE_REPORTS SET VIEWED = 'Y', LAST_VIEW_DATE = SYSDATE WHERE ORDER_TYPE_ID = '001' AND ORDER_NO = '200366247' AND LOCATION_ID = 'M01' AND ORDER_LOCATION_ID = '027' AND TRANSACTION_NO = '2' [02 Aug 2020 23:09:58] (viewOnlineReports) database connection response [02 Aug 2020 23:09:58] (viewOnlineReports) getConnectionClose() called.... [02 Aug 2020 23:09:58] (viewOnlineReports) creating directory structure../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:58] (viewOnlineReports) directory structure created ../../TEMP_PDF/200366247/ [02 Aug 2020 23:09:58] (viewOnlineReports) copying file from source server\\172.16.3.244\PATHOLOGY\REPORTS\PDF\20200802\M01\M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:58] (viewOnlineReports) copying file at destination server../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596391798M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:58] (viewOnlineReports) File copied successfully ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596391798M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:09:58] (viewOnlineReports) User selectedFormat >>>>>>>>>>>>>>>>> DOWNLOAD [02 Aug 2020 23:09:58] (viewOnlineReports) Downloading file ../../TEMP_PDF/200366247/0123456789ABCDEFGHIJKLMNOPQRSTUVWXZ1596391798M0100000158877_M01MOL20006777_1.PDF [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getConnection(): Resource id #1 [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'POP-UP' [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'PLUG-IN' [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT INSTRUCTIONS FROM CCWEB.BROWSER_WISE_INSTRUCTIONS WHERE UPPER(BROWSER_NAME) = 'CHROME' AND BROWSER_VERSION = '84' AND INSTRUCTION_TYPE = 'DOWNLOAD PDF' [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT INVOICE_NO, MRNO, TO_CHAR(INVOICE_DATE, 'DD-MM-RRRR') AS INVOICE_DATE FROM BILLING.INVOICE_MASTER WHERE INVOICE_NO = 'M01200311713' AND ACCESS_CODE = '26092576' AND INVOICE_DATE > ADD_MONTHS(SYSDATE, -6) [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getQueryExecuted(): SELECT SUBSTR(MRNO, 4, LENGTH(MRNO)) AS DISPLAY_MRNO, MRNO, NAME FROM REGISTRATION.PATIENT WHERE MRNO = 'M0100000158877' [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getPatientReportsDetail() entered [02 Aug 2020 23:58:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:58:22] (index) BEGIN HIS.VIEW_REPORTS_LIST ('', '', 'PATIENT', 'M01200311713', 'M0100000158877', '', '', '', 'WCCIS', 'WCCIS', '', 'WCCIS', 'WCCIS - HIS.VIEW_REPORTS_LIST procedure called from Search Report for patient', :p_Stop , :p_Alert ); END; [02 Aug 2020 23:58:22] (index) p_Stop=N [02 Aug 2020 23:58:22] (index) p_Alert= [02 Aug 2020 23:58:22] (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 [02 Aug 2020 23:58:22] (index) database connection response [02 Aug 2020 23:58:22] (index) getConnectionClose() called.... [02 Aug 2020 23:58:22] (index) getConnectionClose() called....