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