APPS.OKE_K_APPROVAL_WF SQL Statements

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

Line: 82

  SELECT name
  FROM   oke_k_roles_v
  WHERE  role_id = K_Role_ID;

Line: 113

  SELECT nvl(max(action_sequence) , 0) + 1
  FROM   oke_approval_history
  WHERE  k_header_id = G_K_Header_ID
  AND    chg_request_id is null;

Line: 125

  INSERT INTO oke_approval_history
  ( k_header_id
  , action_sequence
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  , action_code
  , action_date
  , performer
  , approver_role_id
  , approval_path_id
  , approval_sequence
  , note )
  VALUES
  ( G_K_Header_ID
  , NextSeq
  , sysdate
  , FND_GLOBAL.user_id
  , sysdate
  , FND_GLOBAL.user_id
  , -1
  , ActionCode
  , ActionDate
  , PerformerName
  , ApproverRoleID
  , ApprovalPathID
  , ApprovalSeq
  , NoteText
  );

Line: 192

    SELECT k.k_number_disp
    ,      k.k_type_code
    ,      kt.k_type_name
    ,      kt.type_class_code
    ,      k.buy_or_sell
    ,      k.currency_code
    ,      k.k_value
    ,      k.short_description
    ,      k.description
    ,      k.authoring_org_id
    ,      k.status_code
    ,      ks.ste_code
    FROM   oke_k_headers_v k
    ,      oke_k_types_vl kt
    ,      okc_statuses_b ks
    WHERE  k.k_header_id = C_K_Header_ID
    AND    kt.k_type_code = k.k_type_code
    AND    ks.code = k.status_code;

Line: 229

    SELECT owner_role
    INTO   G_Requestor
    FROM   wf_items
    WHERE  item_type = ItemType
    AND    item_key = ItemKey;

Line: 395

  SELECT ks.ste_code
  FROM   okc_k_headers_b boa
  ,      oke_k_headers   k
  ,      okc_statuses_b  ks
  WHERE  k.k_header_id = C_K_Header_ID
  AND    boa.id = k.boa_id
  AND    ks.code = boa.sts_code;

Line: 973

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

ApprovalSeq    NUMBER;

Line: 1087

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

Line: 1091

END Select_Next_Approver;

Line: 1109

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

SignatoryRole  NUMBER;

Line: 1182

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

Line: 1186

END Select_Signatory;

Line: 1213

  SELECT message_name
  ,      recipient_role
  ,      responder
  FROM   wf_notifications
  WHERE  notification_id = WF_ENGINE.CONTEXT_NID;

Line: 1345

  SELECT KT.approval_path_id
  ,      AP.name approval_path
  ,      AP.signature_required_flag
  ,      AP.signatory_role_id
  FROM   oke_approval_paths_v  AP
  ,      oke_k_types_b         KT
  WHERE  KT.k_type_code = G_K_Type_Code
  AND    AP.approval_path_id = KT.approval_path_id;