DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PVT dependencies on OKC_K_HEADERS_B

Line 227: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

223: l_return_status VARCHAR2(1);
224: l_msg_count NUMBER;
225: l_msg_data VARCHAR2(2000);
226:
227: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
228: l_cntr_num NUMBER;
229: l_amount NUMBER;
230: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
231: l_kle_id OKC_K_LINES_B.ID%TYPE;

Line 230: l_khr_id OKC_K_HEADERS_B.ID%TYPE;

226:
227: l_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
228: l_cntr_num NUMBER;
229: l_amount NUMBER;
230: l_khr_id OKC_K_HEADERS_B.ID%TYPE;
231: l_kle_id OKC_K_LINES_B.ID%TYPE;
232: l_try_id okl_trx_types_tl.ID%TYPE;
233: l_clg_id NUMBER;
234: l_asset_name okc_k_lines_v.name%type; --added by dkagrawa for bug#6015684

Line 280: FROM OKC_K_HEADERS_B HDR

276:
277:
278: CURSOR l_khr_cur(l_contract_num IN VARCHAR2) IS
279: SELECT HDR.ID KHR_ID
280: FROM OKC_K_HEADERS_B HDR
281: WHERE CONTRACT_NUMBER = l_contract_num;
282:
283: --dkagrawa modified the following cursor for bug#6015684
284: CURSOR l_lines_cur(l_asset_name IN VARCHAR2,l_chr_id in number) IS