/*UPDATE SYSTEM_EVENTS 
SET SERVICE_CODE = 'poic_default_ejb', comp_type = 'EJB', comp_name = 'SalePersonIC' 
WHERE OBJ_NAME = 'slpers' AND EVENT_CODE = 'post_item_change';




UPDATE SYSTEM_EVENTS 
SET SERVICE_CODE = 'prv_default_ejb', comp_type = 'EJB', comp_name = 'SalePersonIC' 
WHERE OBJ_NAME = 'slpers' AND EVENT_CODE = 'pre_validate';*/


update system_events set comp_name='SalePersonIC' ,comp_type='EJB' ,service_code='poic_default_ejb' where obj_name='slpers' and event_code='post_item_change';

update system_events set comp_name='SalePersonIC' ,comp_type='EJB' ,service_code='prv_default_ejb' where obj_name='slpers' and event_code='pre_validate';

INSERT INTO OBJ_ITEMCHANGE (OBJ_NAME, FORM_NO, FIELD_NAME, mandatory) VALUES ('slpers', '1', 'tran_code', 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 ('VTDUSALPER','Invalid Sales Person','Invalid Sales Person,Sales Person already exist in master','E','Y',NULL,NULL,NULL,SYSDATE,'BASE','BASE',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 ('VMEMTTYPE','Empty Type','Empty Type,Type should not be blank','E','Y',NULL,NULL,NULL,SYSDATE,'BASE','BASE',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 ('VTCRTMEMP','Empty Credit Term','Empty Credit Term,Credit Term should not be blank','E','Y',NULL,NULL,NULL,SYSDATE,'BASE','BASE',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 ('VTCURREMP','Empty Currency Code','Empty Currency Code,Currency Code should not be blank','E','Y',NULL,NULL,NULL,SYSDATE,'BASE','BASE',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 ('VTCONCDEMP','Empty Contact Code','Empty Contact Code,Contact Code should not be blank','E','Y',NULL,NULL,NULL,SYSDATE,'BASE','BASE',NULL,NULL);






