eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_CHG_REQUESTS_WF SQL Statements

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

Line: 11


  SELECT User_Name
  FROM   fnd_user
  WHERE  employee_id = Emp_ID;

Line: 31


  SELECT Chg_Status_Code
  FROM   oke_chg_statuses_b
  WHERE  Chg_Status_Type_Code = StsTypeCode
  AND    Default_Status = 'Y';

Line: 75


    SELECT chg_status_name
    FROM   oke_chg_statuses_vl
    WHERE  chg_status_code = C_Chg_Status_Code;

Line: 83


    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type         = C_Lookup_Type
    AND    lookup_code         = C_Lookup_Code
    AND    view_application_id = C_View_Appl_ID;

Line: 210


PROCEDURE Select_Next_Approver
( ItemType            IN      VARCHAR2
, ItemKey             IN      VARCHAR2
, ActID               IN      NUMBER
, FuncMode            IN      VARCHAR2
, ResultOut           OUT NOCOPY     VARCHAR2
) IS

LastAppr       VARCHAR2(240) := NULL;

Line: 285


                 , 'SELECT_NEXT_APPROVER'
                 , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );

Line: 289


END Select_Next_Approver;

Line: 307


PROCEDURE Select_Next_Informed
( ItemType            IN      VARCHAR2
, ItemKey             IN      VARCHAR2
, ActID               IN      NUMBER
, FuncMode            IN      VARCHAR2
, ResultOut           OUT NOCOPY     VARCHAR2
) IS

LastInformed       VARCHAR2(240) := NULL;

Line: 366


                 , 'SELECT_NEXT_INFORMED'
                 , ItemType , ItemKey , to_char(ActID) , FuncMode , ResultOut );

Line: 370


END Select_Next_Informed;

Line: 529


    SELECT  *
    FROM oke_chg_requests
    WHERE chg_request_id =p_CHG_REQUEST_ID ;

Line: 550


    OKE_CHG_REQUESTS_PKG.UPDATE_ROW
  ( X_CHG_REQUEST_ID            => L_Chg_Request_ID
  , X_LAST_UPDATE_DATE          => sysdate
  , X_LAST_UPDATED_BY           => c_rec.LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN         => c_rec.LAST_UPDATE_LOGIN
  , X_K_HEADER_ID               => c_rec.K_HEADER_ID
  , X_CHG_REQUEST_NUM           => c_rec.CHG_REQUEST_NUM
  , X_CHG_TYPE_CODE             => c_rec.CHG_TYPE_CODE
  , X_CHG_STATUS_CODE           => L_Approved_Status
  , X_CHG_REASON_CODE           => c_rec.CHG_REASON_CODE
  , X_IMPACT_FUNDING_FLAG       =>c_rec.IMPACT_FUNDING_FLAG
  , X_EFFECTIVE_DATE            => c_rec.EFFECTIVE_DATE
  , X_REQUESTED_BY_PERSON_ID    => c_rec.REQUESTED_BY_PERSON_ID
  , X_REQUESTED_DATE            => c_rec.REQUESTED_DATE
  , X_RECEIVE_DATE              => c_rec.RECEIVE_DATE
  , X_APPROVE_DATE              => c_rec.APPROVE_DATE
  , X_IMPLEMENT_DATE            => c_rec.IMPLEMENT_DATE
  , X_PREV_VERSION              => c_rec.PREV_VERSION
  , X_NEW_VERSION               => c_rec.NEW_VERSION
  , X_DESCRIPTION               =>c_rec.DESCRIPTION
  , X_CHG_TEXT                  => c_rec.CHG_TEXT
  , X_LAST_CHG_LOG_ID           => c_rec.LAST_CHG_LOG_ID
  , X_ATTRIBUTE_CATEGORY        =>c_rec.ATTRIBUTE_CATEGORY
  , X_ATTRIBUTE1                => c_rec.ATTRIBUTE1
  , X_ATTRIBUTE2                => c_rec.ATTRIBUTE2
  , X_ATTRIBUTE3                => c_rec.ATTRIBUTE3
  , X_ATTRIBUTE4                => c_rec.ATTRIBUTE4
  , X_ATTRIBUTE5                => c_rec.ATTRIBUTE5
  , X_ATTRIBUTE6                => c_rec.ATTRIBUTE6
  , X_ATTRIBUTE7                => c_rec.ATTRIBUTE7
  , X_ATTRIBUTE8                => c_rec.ATTRIBUTE8
  , X_ATTRIBUTE9                => c_rec.ATTRIBUTE9
  , X_ATTRIBUTE10               => c_rec.ATTRIBUTE10
  , X_ATTRIBUTE11               => c_rec.ATTRIBUTE11
  , X_ATTRIBUTE12               => c_rec.ATTRIBUTE12
  , X_ATTRIBUTE13               => c_rec.ATTRIBUTE13
  , X_ATTRIBUTE14               => c_rec.ATTRIBUTE14
  , X_ATTRIBUTE15               => c_rec.ATTRIBUTE15
  );

Line: 592


       /* UPDATE oke_chg_requests
    SET    chg_status_code = L_Approved_Status
    ,      last_update_date = sysdate
    WHERE  chg_request_id  = L_Chg_Request_ID;*/ --skuchima  bug12414859

Line: 667


    SELECT  *
    FROM oke_chg_requests
    WHERE chg_request_id =p_CHG_REQUEST_ID ;

Line: 689


    OKE_CHG_REQUESTS_PKG.UPDATE_ROW
  ( X_CHG_REQUEST_ID            => L_Chg_Request_ID
  , X_LAST_UPDATE_DATE          => sysdate
  , X_LAST_UPDATED_BY           => c_rec.LAST_UPDATED_BY
  , X_LAST_UPDATE_LOGIN         => c_rec.LAST_UPDATE_LOGIN
  , X_K_HEADER_ID               => c_rec.K_HEADER_ID
  , X_CHG_REQUEST_NUM           => c_rec.CHG_REQUEST_NUM
  , X_CHG_TYPE_CODE             => c_rec.CHG_TYPE_CODE
  , X_CHG_STATUS_CODE           => L_Rejected_Status
  , X_CHG_REASON_CODE           => c_rec.CHG_REASON_CODE
  , X_IMPACT_FUNDING_FLAG       =>c_rec.IMPACT_FUNDING_FLAG
  , X_EFFECTIVE_DATE            => c_rec.EFFECTIVE_DATE
  , X_REQUESTED_BY_PERSON_ID    => c_rec.REQUESTED_BY_PERSON_ID
  , X_REQUESTED_DATE            => c_rec.REQUESTED_DATE
  , X_RECEIVE_DATE              => c_rec.RECEIVE_DATE
  , X_APPROVE_DATE              => c_rec.APPROVE_DATE
  , X_IMPLEMENT_DATE            => c_rec.IMPLEMENT_DATE
  , X_PREV_VERSION              => c_rec.PREV_VERSION
  , X_NEW_VERSION               => c_rec.NEW_VERSION
  , X_DESCRIPTION               =>c_rec.DESCRIPTION
  , X_CHG_TEXT                  => c_rec.CHG_TEXT
  , X_LAST_CHG_LOG_ID           => c_rec.LAST_CHG_LOG_ID
  , X_ATTRIBUTE_CATEGORY        =>c_rec.ATTRIBUTE_CATEGORY
  , X_ATTRIBUTE1                => c_rec.ATTRIBUTE1
  , X_ATTRIBUTE2                => c_rec.ATTRIBUTE2
  , X_ATTRIBUTE3                => c_rec.ATTRIBUTE3
  , X_ATTRIBUTE4                => c_rec.ATTRIBUTE4
  , X_ATTRIBUTE5                => c_rec.ATTRIBUTE5
  , X_ATTRIBUTE6                => c_rec.ATTRIBUTE6
  , X_ATTRIBUTE7                => c_rec.ATTRIBUTE7
  , X_ATTRIBUTE8                => c_rec.ATTRIBUTE8
  , X_ATTRIBUTE9                => c_rec.ATTRIBUTE9
  , X_ATTRIBUTE10               => c_rec.ATTRIBUTE10
  , X_ATTRIBUTE11               => c_rec.ATTRIBUTE11
  , X_ATTRIBUTE12               => c_rec.ATTRIBUTE12
  , X_ATTRIBUTE13               => c_rec.ATTRIBUTE13
  , X_ATTRIBUTE14               => c_rec.ATTRIBUTE14
  , X_ATTRIBUTE15               => c_rec.ATTRIBUTE15
  );

Line: 732


   /* UPDATE oke_chg_requests
    SET    chg_status_code = L_Rejected_Status
    ,      last_update_date = sysdate
    WHERE  chg_request_id  = L_Chg_Request_ID;*/    --skuchima bug12414859