APPS.OKE_WORKFLOW_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

   PROCEDURE Update_Chg_Status_Apv(ITEMTYPE          IN  VARCHAR2
                              ,ITEMKEY           IN  VARCHAR2
                              ,ACTID             IN  NUMBER
                              ,FUNCMODE          IN  VARCHAR2
                              ,RESULTOUT         OUT NOCOPY VARCHAR2
                              ) IS

      l_chg_request_id  number;

Line: 25

      l_last_updated_id number;

Line: 36

         l_last_updated_id:=wf_engine.getitemattrtext(itemtype => itemtype
                                                 ,itemkey  => itemkey
                                                 ,aname    => 'LAST_UPDATED_BY'
                                                 );

Line: 46

         update OKE_CHG_REQUESTS
            set CHG_STATUS_CODE ='APPROVED'
               ,LAST_UPDATED_BY =l_last_updated_id
               ,LAST_UPDATE_DATE=sysdate
          where CHG_REQUEST_ID  =l_chg_request_id;

Line: 64

   END Update_Chg_Status_Apv;

Line: 66

   PROCEDURE Update_Chg_Status_Rej(ITEMTYPE          IN  VARCHAR2
                              ,ITEMKEY           IN  VARCHAR2
                              ,ACTID             IN  NUMBER
                              ,FUNCMODE          IN  VARCHAR2
                              ,RESULTOUT         OUT NOCOPY VARCHAR2
                              ) IS

      l_chg_request_id  number;

Line: 74

      l_last_updated_id number;

Line: 85

         l_last_updated_id:=wf_engine.getitemattrtext(itemtype => itemtype
                                                 ,itemkey  => itemkey
                                                 ,aname    => 'LAST_UPDATED_BY'
                                                 );

Line: 95

         update OKE_CHG_REQUESTS
            set CHG_STATUS_CODE ='REJECTED'
               ,LAST_UPDATED_BY =l_last_updated_id
               ,LAST_UPDATE_DATE=sysdate
          where CHG_REQUEST_ID  =l_chg_request_id;

Line: 113

   END Update_Chg_Status_Rej;