[Home] [Help]
1791: funcmode in varchar2,
1792: resultout out nocopy varchar2 ) is
1793:
1794: CURSOR contract_info(p_id NUMBER) IS
1795: SELECT contract_number from okc_k_headers_b
1796: WHERE id = p_id;
1797:
1798: CURSOR user_info(p_id NUMBER) IS
1799: SELECT user_name from fnd_user
2155:
2156: current_billing_info_rec current_billing_info%rowtype;
2157:
2158: -- parameters set in the procedure
2159: l_contract_number okc_k_headers_b.contract_number%type;
2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2500: resultout out nocopy varchar2 )
2501: IS
2502:
2503: CURSOR contract_info_cur( p_chr_id IN NUMBER) IS
2504: SELECT contract_number from okc_k_headers_b
2505: WHERE id = p_chr_id;
2506:
2507: CURSOR policy_info_cur(p_pol_id IN NUMBER) IS
2508: SELECT policy_number, iss_code, cancellation_date, khr_id
2963: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2964: p_trqv_rec okl_trx_requests_pub.trqv_rec_type;
2965:
2966: CURSOR contract_info(p_id NUMBER) IS
2967: SELECT object_version_number, currency_code from okc_k_headers_b
2968: WHERE id = p_id;
2969:
2970: CURSOR user_info(p_id NUMBER) IS
2971: SELECT user_name from fnd_user
3060: x_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3061: p_trqv_rec okl_trx_requests_pub.trqv_rec_type;
3062:
3063: CURSOR contract_info(p_id NUMBER) IS
3064: SELECT object_version_number, currency_code from okc_k_headers_b
3065: WHERE id = p_id;
3066:
3067: CURSOR user_info(p_id NUMBER) IS
3068: SELECT user_name from fnd_user
3606: resultout out nocopy varchar2 )
3607: IS
3608:
3609: CURSOR contract_info_cur( p_khr_id IN NUMBER) IS
3610: SELECT contract_number from okc_k_headers_b
3611: WHERE id = p_khr_id;
3612:
3613: CURSOR quote_info_cur(p_qte_id IN NUMBER) IS
3614: SELECT quote_number, quote_type_description,