DBA Data[Home] [Help]

APPS.OKL_VP_PA_WF SQL Statements

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

Line: 62

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

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

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;
Line: 129

     SELECT agreement.contract_number agreement_number
           ,subclass.meaning agreement_category
           ,vendors.vendor_name vendor_name
           ,agreement.id agreement_id
           ,agreement.description
           ,agreement.start_date
           ,agreement.end_date
      FROM okc_k_headers_v agreement
           ,okc_subclasses_v subclass
           ,po_vendors vendors
           ,okc_k_party_roles_b party_roles
     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 = cp_chr_id;
Line: 186

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

    SELECT id
          ,contract_number
      FROM okc_k_headers_b
     WHERE id = cp_chr_id;
Line: 226

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

    SELECT transaction_type_id,
           fnd_application_id
      FROM AME_CALLING_APPS
     WHERE application_name = cp_trx_type;
Line: 357

      l_parameter_list.DELETE;
Line: 439

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

  PROCEDURE update_agrmnt_status(itemtype	  IN VARCHAR2
                                ,itemkey   IN VARCHAR2
                                ,actid		   IN NUMBER
                                ,funcmode  IN VARCHAR2
                                ,resultout OUT NOCOPY VARCHAR2) IS
    x_return_status VARCHAR2(10);
Line: 509

    l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_agrmnt_status';
Line: 510

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.UPDATE_AGRMNT_STATUS';
Line: 518

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');
Line: 534

        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_ACTIVE_STS_CODE
                                                      ,p_chr_id        => lv_agreement_id
                                                       );
Line: 546

                                  'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                  );
Line: 555

        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_DECLINED_STS_CODE
                                                      ,p_chr_id        => lv_agreement_id
                                                       );
Line: 567

                                  'okl_contract_status_pub.update_contract_status G_DECLINED_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                  );
Line: 589

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_agrmnt_status');
Line: 596

  END update_agrmnt_status;