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: 541

    UPDATE oke_chg_requests
    SET    chg_status_code = L_Approved_Status
    ,      last_update_date = sysdate
    WHERE  chg_request_id  = L_Chg_Request_ID;

Line: 628

    UPDATE oke_chg_requests
    SET    chg_status_code = L_Rejected_Status
    ,      last_update_date = sysdate
    WHERE  chg_request_id  = L_Chg_Request_ID;