
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);


update pophelp set sql_str='select TRIM(FLD_VALUE) ,DESCR from GENCODES WHERE FLD_NAME=''PRICE_LIST'' ' where field_name='PRICE_LIST' and mod_name='X';








