DBA Data[Home] [Help]

APPS.OKL_VP_CR_WF SQL Statements

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

Line: 65

    SELECT name, display_name
      FROM wf_users
     WHERE orig_system_id = p_user_id
       AND orig_system = G_WF_USER_ORIG_SYSTEM_HR;
Line: 71

    SELECT user_name, description
      FROM fnd_user
     WHERE user_id = cp_user_id;
Line: 96

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;
Line: 134

     SELECT agreement.contract_number agreement_number
           ,subclass.meaning agreement_category
           ,vendors.vendor_name vendor_name
           ,agreement.description
           ,agreement.start_date
           ,agreement.end_date
           ,change.change_request_number
           ,lookups.meaning change_request_type
      FROM okc_k_headers_v agreement
           ,okc_subclasses_v subclass
           ,po_vendors vendors
           ,okc_k_party_roles_b party_roles
           ,okl_vp_change_requests change
           ,fnd_lookups lookups
           ,okl_k_headers khr
     WHERE agreement.scs_code = subclass.code
       AND party_roles.dnz_chr_id (+) = agreement.id
       AND party_roles.rle_code (+) = 'OKL_VENDOR'
       AND party_roles.object1_id1 = vendors.vendor_id(+)
       AND khr.id = agreement.id
       AND khr.crs_id = change.id
       AND change.change_type_code = 'AGREEMENT'
       AND change.change_type_code = lookups.lookup_code
       and lookups.lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
       AND change.id = p_change_request_id
     UNION
     -- this portion of select will work for ASSOCIATION type of change requests
     SELECT agreement.contract_number agreement_number
           ,subclass.meaning agreement_category
           ,vendors.vendor_name vendor_name
           ,agreement.description
           ,agreement.start_date
           ,agreement.end_date
           ,change.change_request_number
           ,lookups.meaning change_request_type
      FROM okc_k_headers_v agreement
           ,okc_subclasses_v subclass
           ,po_vendors vendors
           ,okc_k_party_roles_b party_roles
           ,okl_vp_change_requests change
           ,fnd_lookups lookups
     WHERE agreement.scs_code = subclass.code
       AND party_roles.dnz_chr_id (+) = agreement.id
       AND party_roles.rle_code (+) = 'OKL_VENDOR'
       AND party_roles.object1_id1 = vendors.vendor_id(+)
       AND agreement.id = change.chr_id
       AND change.change_type_code = 'ASSOCIATION'
       AND change.change_type_code = lookups.lookup_code
       and lookups.lookup_type = 'OKL_VP_CHANGE_REQUEST_TYPES'
       AND change.id = p_change_request_id;
Line: 236

                     ''|| Okl_Accounting_Util.Get_Message_Token(p_region_code    => 'OKL_VP_PROGRAM_UPDATE'
                                                                   ,p_attribute_code => 'OKL_DESCRIPTION')
                           ||''|| G_AMP_SIGN ||'nbsp;' || cv_get_creq_dtls.description
Line: 268

    SELECT id
          ,change_request_number
      FROM okl_vp_change_requests
     WHERE id = cp_crq_id;
Line: 275

    SELECT APPLICATION_ID
      FROM FND_APPLICATION
     WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
Line: 282

    select description transaction_type_id,
           fnd_application_id
    from   AME_TRANSACTION_TYPES_V
    where  transaction_type_id=cp_trx_type;
Line: 288

    SELECT transaction_type_id,
           fnd_application_id
      FROM AME_CALLING_APPS
     WHERE application_name = cp_trx_type; */
Line: 412

      l_parameter_list.DELETE;
Line: 492

    SELECT USER_NAME
    FROM   FND_USER
    WHERE  user_id = p_user_id;
Line: 554

  PROCEDURE update_cr_status(itemtype   IN VARCHAR2
                                ,itemkey   IN VARCHAR2
                                ,actid     IN NUMBER
                                ,funcmode  IN VARCHAR2
                                ,resultout OUT NOCOPY VARCHAR2) IS
    -- cursor to get the agreement number that was created for the change request
    CURSOR c_get_creq_chr_csr(cp_change_request_id okl_vp_change_requests.id%TYPE)IS
    SELECT CASE WHEN (cr.change_type_code = 'AGREEMENT') THEN
          (SELECT id FROM okl_k_headers WHERE crs_id = cr.id)
           ELSE cr.chr_id END creq_chr_id
          ,cr.change_type_code
      FROM okl_vp_change_requests cr
     WHERE cr.id = cp_change_request_id;
Line: 572

    l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_cr_status';
Line: 573

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.UPDATE_CR_STATUS';
Line: 583

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_cr_status');
Line: 651

        okl_vp_change_request_pvt.update_change_request_header(p_api_version   => 1.0
                                                              ,p_init_msg_list => OKL_API.G_TRUE
                                                              ,x_return_status => x_return_status
                                                              ,x_msg_count     => x_msg_count
                                                              ,x_msg_data      => x_msg_data
                                                              ,p_vcrv_rec      => lv_vcrv_rec
                                                              ,x_vcrv_rec      => x_vcrv_rec
                                                               );
Line: 666

          okl_contract_status_pub.update_contract_status(p_api_version   => 1.0
                                                        ,p_init_msg_list => OKL_API.G_TRUE
                                                        ,x_return_status => x_return_status
                                                        ,x_msg_count     => x_msg_count
                                                        ,x_msg_data      => x_msg_data
                                                        ,p_khr_status    => G_AGR_APP_REJECTED_STS_CODE
                                                        ,p_chr_id        => cv_get_creq_chr.creq_chr_id
                                                         );
Line: 693

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_cr_status');
Line: 699

  END update_cr_status;