APPS.OKE_HOLD_UTILS SQL Statements

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

Line: 27

, P_Updated_By       IN  NUMBER
, P_Update_Date      IN  DATE
, P_Login_ID         IN  NUMBER
) IS

  CURSOR sts IS
    SELECT wf_item_type
    ,      wf_process
    ,      hold_status_name
    FROM   oke_hold_statuses_vl
    WHERE  hold_status_code = P_New_Status_Code;

Line: 40

    SELECT hold_status_name
    FROM   oke_hold_statuses_vl
    WHERE  hold_status_code = P_Old_Status_Code;

Line: 45

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type      = 'APPLY_HOLD_REASON'
      AND  lookup_code      = P_Hold_reason_Code;

Line: 51

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type      = 'REMOVE_HOLD_REASON'
      AND  lookup_code      = P_Remove_reason_Code;

Line: 57

    SELECT meaning
    FROM   fnd_lookup_values_vl
    WHERE  lookup_type      = 'HOLD_TYPE'
      AND  lookup_code      = P_Hold_type_Code;

Line: 63

    SELECT user_name
    FROM   fnd_user
    WHERE  user_id = P_Updated_By;

Line: 68

    SELECT H.k_number_disp    k_number
    ,      T.k_type_name      k_type
    ,      hdr.org_id           org_id
    FROM   oke_k_headers        H
    ,      oke_k_types_vl       T
    ,      okc_k_headers_all_B    HDR
    WHERE  H.k_header_id = P_K_Header_ID
    AND    T.k_type_code = H.k_type_code
    AND    H.k_header_id = HDR.ID;

Line: 79

    SELECT L.line_number
    FROM   okc_k_lines_b L
    WHERE  L.id = P_K_Line_ID;

Line: 84

    SELECT D.deliverable_num
    FROM   oke_k_deliverables_b D
    ,      okc_k_lines_b L
    WHERE  D.deliverable_id = P_dts_ID
    AND    L.id = D.K_Line_ID;

Line: 266

                             , aname    => 'LAST_UPDATED_BY'
                             , avalue   => P_Updated_by );