
----Entry for BankMaster column entry--

---IS_INTEGRATED

ALTER TABLE BANK ADD  IS_INTEGRATED CHAR(1);

---PAY_INT_SERVICE

ALTER TABLE BANK
ADD PAY_INT_SERVICE VARCHAR2(60);

----EVENT_NOTIFY_EMAIL

ALTER TABLE BANK
ADD EVENT_NOTIFY_EMAIL VARCHAR2(75);

----EVENT_NOTIFY_EMAIL

ALTER TABLE BANK
ADD PAY_INT_ARGS VARCHAR2(500);


---Execute message queris date :30 Nov 23

Insert into MESSAGES (MSG_NO,MSG_STR,MSG_DESCR,MSG_TYPE,MSG_OPT,MSG_TIME,ALARM,ERR_SOURCE,CHG_DATE,CHG_USER,CHG_TERM,OVERRIDE_INPUT,MAIL_OPTION) 
values ('VLDMAIL  ','INVALID EMAIL','Please Enter Valid Email','E','Y',null,null,null,to_date('30-OCT-23','DD-MON-RR'),'AMS     ','HDP',null,null);
 

Insert into MESSAGES (MSG_NO,MSG_STR,MSG_DESCR,MSG_TYPE,MSG_OPT,MSG_TIME,ALARM,ERR_SOURCE,CHG_DATE,CHG_USER,CHG_TERM,OVERRIDE_INPUT,MAIL_OPTION) 
values ('VLDSRVCE','INVALID SERVICE CODE','Please Enter Valid Service Code','E','Y',null,null,null,to_date('30-OCT-23','DD-MON-RR'),'AMS     ','HDP',null,null);


