eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_OA_WF SQL Statements

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

Line: 59


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

Line: 65


    SELECT user_name, description
      FROM fnd_user
     WHERE user_id = cp_user_id;

Line: 90


    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;

Line: 126


     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: 183


                     ''|| 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: 216

SELECT id ,contract_number FROM okc_k_headers_b WHERE id = cp_chr_id;

Line: 223

SELECT APPLICATION_ID FROM FND_APPLICATION WHERE APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 230

SELECT transaction_type_id, fnd_application_id FROM AME_TRANSACTION_TYPES_V where transaction_type_id = cp_trx_type;

Line: 355

l_parameter_list.DELETE;

Line: 438

SELECT USER_NAME FROM FND_USER WHERE user_id = p_user_id;

Line: 500

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: 508

l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_agrmnt_status';

Line: 509

l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';

Line: 517

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

Line: 533

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: 545

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

Line: 554

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: 566

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

Line: 588

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

Line: 595

END update_agrmnt_status;