insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VTPRONOE','Invalid Pro Number','Range of Pro Number is exceeded for carriers','E',sysdate,'BASE','BASE');

Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('transporter','1  ','itm_defaultedit',null);
Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('site_transporter','1  ','itm_defaultedit',null);

Insert into disparm (PRD_CODE,VAR_NAME,VAR_TYPE,VAR_VALUE,DESCR,VAR_SUBS,CHG_DATE,CHG_USER,CHG_TERM) 
values ('999999','REMAIN_PRO_NO','S','50','Remaining Pro No',0,sysdate,'BASE','BASE');

insert into messages
(msg_no,msg_str,msg_descr,msg_type,chg_date,chg_user,chg_term) 
values 
('VTFWPRONR','Few pro nos ','There are only last few pro nos are remaining','W',sysdate,'BASE','BASE'); 

Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('transporter','1  ','prono_to',null);
Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('transporter','1  ','prono_from',null);

Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('site_transporter','1  ','prono_to',null);
Insert into obj_itemchange (OBJ_NAME,FORM_NO,FIELD_NAME,MANDATORY) values ('site_transporter','1  ','prono_from',null);

delete from obj_itemchange where obj_name= 'site_transporter' and field_name ='itm_defaultedit';
delete from obj_itemchange where obj_name= 'transporter' and field_name ='itm_defaultedit';
