APPS.OKE_COMM_ACT_UTILS SQL Statements

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

Line: 9

PROCEDURE Update_Text(
             X_k_header_id                NUMBER,
             X_communication_num          VARCHAR2,
             X_text                       VARCHAR2
  ) is

begin

  update OKE_K_COMMUNICATIONS
  set text = X_text
  where k_header_id = X_k_header_id
  and communication_num = X_communication_num;

Line: 22

end Update_Text;

Line: 48

, P_Updated_By         IN  NUMBER
, P_Update_Date        IN  DATE
, P_Login_ID           IN  NUMBER
, P_WF_ITEM_KEY        OUT NOCOPY VARCHAR2
) IS

  CURSOR kh IS
    SELECT k_number
          ,k_type
          ,authoring_org_id
    FROM   oke_k_headers_full_v
    WHERE  k_header_id = P_K_Header_ID;

Line: 62

    SELECT line_number
    FROM   oke_k_lines_full_v
    WHERE  k_line_id = P_K_Line_ID;

Line: 67

    SELECT deliverable_num
    FROM   oke_k_deliverables_vl
    WHERE  Deliverable_id = P_Deliverable_ID;

Line: 72

    SELECT user_name
    FROM   fnd_user
    WHERE  user_id = P_Updated_By;

Line: 77

    SELECT wf_item_type
    ,      wf_process
    ,      comm_action_name
    FROM   oke_comm_actions_vl
    WHERE  comm_action_code = P_New_Action_Code;

Line: 92

    SELECT name, display_name
    FROM   wf_roles
    WHERE  orig_system = 'PER'
    AND    orig_system_id = P_Owner;

Line: 154

        SELECT full_name into l_action_owner
        FROM   per_all_people_f
        WHERE  person_id = P_Owner
        AND    sysdate between effective_start_date and effective_end_date;

Line: 328

, P_Updated_By         IN  NUMBER
, P_Update_Date        IN  DATE
, P_Login_ID           IN  NUMBER
, P_WF_ITEM_KEY        OUT NOCOPY VARCHAR2
) IS

  CURSOR kh IS
    SELECT k_number
          ,k_type
    FROM   oke_k_headers_full_v
    WHERE  k_header_id = P_K_Header_ID;

Line: 341

    SELECT line_number
    FROM   oke_k_lines_full_v
    WHERE  k_line_id = P_K_Line_ID;

Line: 346

    SELECT deliverable_num
    FROM   oke_k_deliverables_vl
    WHERE  Deliverable_id = P_Deliverable_ID;

Line: 351

    SELECT user_name
    FROM   fnd_user
    WHERE  user_id = P_Updated_By;

Line: 356

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type='COMMUNICATION_TYPE'
    AND    lookup_code=P_TYPE
    AND    view_application_id=777;

Line: 363

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type='COMMUNICATION_REASON_CODE'
    AND    lookup_code=P_REASON_CODE
    AND    view_application_id=777;

Line: 370

    SELECT wf_item_type
    ,      wf_process
    ,      comm_action_name
    FROM   oke_comm_actions_vl
    WHERE  comm_action_code = P_New_Action_Code;

Line: 385

    SELECT name, display_name
    FROM   wf_roles
    WHERE  orig_system = 'PER'
    AND    orig_system_id = P_Owner;

Line: 391

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type='COMMUNICATION_PRIORITY'
    AND    lookup_code=P_PRIORITY_CODE
    AND    view_application_id=777;

Line: 427

  SELECT JTOT_Object1_Code
        ,      Object1_ID1
        ,      Object1_ID2
        ,      Role
  FROM   okc_k_party_roles_v
  WHERE  ID = P_K_Party_ID;

Line: 487

        SELECT full_name into l_action_owner
        FROM   per_all_people_f
        WHERE  person_id = P_Owner
        AND    sysdate between effective_start_date and effective_end_date;