[Home] [Help]
1760: resultout out nocopy varchar2) IS
1761:
1762: CURSOR c_vnd_pgm(p_ctr_id IN NUMBER) IS
1763: SELECT khr_id
1764: FROM okl_k_headers_v
1765: where id = p_ctr_id ;
1766:
1767: CURSOR c_contact_role(p_contract_id IN NUMBER) IS
1768: SELECT co.object1_id1,
2897: IS
2898: CURSOR products_csr(c_contract_id NUMBER)
2899: IS
2900: SELECT b.id,b.name,b.description
2901: FROM okl_k_headers a,okl_products b
2902: WHERE a.pdt_id=b.id
2903: AND a.pdt_id is not null
2904: AND a.id=c_contract_id;
2905: BEGIN