Friday, April 25, 2014

How to change the status of Expenditure Batch

select EXPENDITURE_GROUP,EXPENDITURE_GROUP_STATUS_CODE,SYSTEM_LINKAGE_FUNCTION,ORG_ID
   from pa_expenditure_groups_all
   where expenditure_group in (<Expenditure Batch Name>)
   and org_id=:p_org_id;

       
update pa_expenditure_groups_all
          set EXPENDITURE_GROUP_STATUS_CODE = 'SUBMITTED',
          last_update_date = SYSDATE,
          last_updated_by = :p_user_id
          where EXPENDITURE_GROUP = :P_EXPENDITURE_GROUP
         and ORG_ID = :P_ORG_ID
         returning EXPENDITURE_GROUP_STATUS_CODE
         into lc_status ;

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home