[Home] [Help]
1877: funcmode in varchar2,
1878: resultout out nocopy varchar2 ) is
1879:
1880: CURSOR contract_info(p_id NUMBER) IS
1881: SELECT contract_number from okc_k_headers_b
1882: WHERE id = p_id;
1883:
1884: CURSOR user_info(p_id NUMBER) IS
1885: SELECT user_name from fnd_user
2241:
2242: current_billing_info_rec current_billing_info%rowtype;
2243:
2244: -- parameters set in the procedure
2245: l_contract_number okc_k_headers_b.contract_number%type;
2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2586: resultout out nocopy varchar2 )
2587: IS
2588:
2589: CURSOR contract_info_cur( p_chr_id IN NUMBER) IS
2590: SELECT contract_number from okc_k_headers_b
2591: WHERE id = p_chr_id;
2592:
2593: CURSOR policy_info_cur(p_pol_id IN NUMBER) IS
2594: SELECT policy_number, iss_code, cancellation_date, khr_id
3049: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3050: p_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3051:
3052: CURSOR contract_info(p_id NUMBER) IS
3053: SELECT object_version_number, currency_code from okc_k_headers_b
3054: WHERE id = p_id;
3055:
3056: CURSOR user_info(p_id NUMBER) IS
3057: SELECT user_name from fnd_user
3146: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3147: p_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3148:
3149: CURSOR contract_info(p_id NUMBER) IS
3150: SELECT object_version_number, currency_code from okc_k_headers_b
3151: WHERE id = p_id;
3152:
3153: CURSOR user_info(p_id NUMBER) IS
3154: SELECT user_name from fnd_user
3692: resultout out nocopy varchar2 )
3693: IS
3694:
3695: CURSOR contract_info_cur( p_khr_id IN NUMBER) IS
3696: SELECT contract_number from okc_k_headers_b
3697: WHERE id = p_khr_id;
3698:
3699: CURSOR quote_info_cur(p_qte_id IN NUMBER) IS
3700: SELECT quote_number, quote_type_description,