DBA Data[Home] [Help]

APPS.OKE_WORKFLOW_UTILS dependencies on OKE_CHG_REQUESTS

Line 46: update OKE_CHG_REQUESTS

42: ,itemkey => itemkey
43: ,aname => 'NEW_STATUS_CODE'
44: );
45:
46: update OKE_CHG_REQUESTS
47: set CHG_STATUS_CODE ='APPROVED'
48: ,LAST_UPDATED_BY =l_last_updated_id
49: ,LAST_UPDATE_DATE=sysdate
50: where CHG_REQUEST_ID =l_chg_request_id;

Line 95: update OKE_CHG_REQUESTS

91: ,itemkey => itemkey
92: ,aname => 'NEW_STATUS_CODE'
93: );
94:
95: update OKE_CHG_REQUESTS
96: set CHG_STATUS_CODE ='REJECTED'
97: ,LAST_UPDATED_BY =l_last_updated_id
98: ,LAST_UPDATE_DATE=sysdate
99: where CHG_REQUEST_ID =l_chg_request_id;