***** Table List Required to Run TCIL ERP Gateway (* Mandatory Tables) *****
*HRD_EMP
*HRM_RESUME
*CM_DIVISION_TLOG
*CM_BRANCH_TLOG
*CM_TCIL_GATEWAY
*CM_TCIL_DOMAIN

USER_LOGIN_PROPERTY
CM_EMP_LOGIN
*USER_LOGIN@DB_TLOGFRT
*USER_LOGIN@DB_TLOGSCS
*USER_LOGIN@DB_TLOGCC
*USER_LOGIN@DB_TLOGCCS
*USER_LOGIN@DB_TLOGCON
*USER_LOGIN@INTL

CM_TCIL_GATEWAY_HISTORY
CM_TCIL_GATEWAY_USER
CT_TCIL_GATEWAY_LOG

CM_TCIL_GATEWAY_PROGRAM
CM_TCIL_PROGRAM_ALLOW
CM_TCIL_PROGRAM_BLOCK
CM_TCIL_PROGRAM_ALLOW_LIKE

TLOG_DB_ACCESS_ROLE
TLOG_DEPT_EMP_SYSTEM
TLOG_DB_SERVER_IP
TLOG_DB_ACCESS_ALERT

***** Steps to run TCIL ERP Gateway Temporary *****
1.) Comment all line below //Temp
2.) UnComment all line below //Temp to be commented
3.) DB Link required in TCICOREEQ as below
    string strDBLinkDB_TLOGFRT = "DB_QFRT", strDBLinkDB_TLOGSCS = "DB_QSCS", strDBLinkDB_TLOGCC = "", strDBLinkDB_TLOGCCS = "DB_QCCS", strDBLinkDB_TLOGCON = "DB_QCON", strDBLinkINTL = "";
4.) Run Script as below
	DROP TABLE HRD_EMP;
	CREATE TABLE HRD_EMP AS SELECT * FROM HRD_EMP@DB_QTLOG;

	DROP TABLE HRM_RESUME;
	CREATE TABLE HRM_RESUME AS SELECT * FROM HRM_RESUME@DB_QTLOG;

	DROP TABLE CM_DIVISION_TLOG;
	CREATE TABLE CM_DIVISION_TLOG AS SELECT * FROM CM_DIVISION_TLOG@DB_QTLOG;

	DROP TABLE CM_BRANCH_TLOG;
	CREATE TABLE CM_BRANCH_TLOG AS SELECT * FROM CM_BRANCH_TLOG@DB_QTLOG;

	DROP TABLE CM_TCIL_GATEWAY;
	CREATE TABLE CM_TCIL_GATEWAY AS SELECT * FROM CM_TCIL_GATEWAY@DB_QTLOG;

	DROP TABLE CM_TCIL_DOMAIN;
	CREATE TABLE CM_TCIL_DOMAIN AS SELECT * FROM CM_TCIL_DOMAIN@DB_QTLOG;
	
5.) Upload API in below servers
	www.grouptci.com
	www.tcil.com
	gateway.tcil.in
6.) No any Update/Insert allow in this Session