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_TRANSFER_ASSUMPTION_PVT dependencies on OKL_K_HEADERS

Line 59: from okl_k_headers khr

55:
56: cursor c_credit_tna (p_chr_id okc_k_headers_b.id%TYPE)
57: is
58: select NVL(khr.TOT_CL_NET_TRANSFER_AMT,0)
59: from okl_k_headers khr
60: where khr.id = p_chr_id
61: ;
62:
63:

Line 244: Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT)

240:
241: 5.4
242: IF source contract credit line exists THEN
243: get total T and A for source contract via formula CONTRACT_FINANCED_AMOUNT
244: Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT)
245: T and A for source contract's credit line
246: END IF;
247:
248: 5.5

Line 251: Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT)

247:
248: 5.5
249: IF destination contract credit line exists THEN
250: get total T and A for destination contract via formula CONTRACT_FINANCED_AMOUNT
251: Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT)
252: T and A for destination contract's credit line
253: END IF;
254:
255: */

Line 277: -- Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T for source contract's credit line

273: l_src_credit_id := OKL_CREDIT_PUB.get_creditline_by_chrid(l_src_chr_id);
274:
275: -- IF source contract credit line exists THEN
276: -- get total T for source contract via formula CONTRACT_FINANCED_AMOUNT
277: -- Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T for source contract's credit line
278: -- END IF;
279: if l_src_credit_id is not null then
280:
281: update_tna_creditline(

Line 302: -- Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T for destination contract's credit line

298: end if;
299:
300: -- IF destination contract credit line exists THEN
301: -- get total T for destination contract via formula CONTRACT_FINANCED_AMOUNT
302: -- Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T for destination contract's credit line
303: -- END IF;
304: if l_dst_credit_id is not null then
305:
306: update_tna_creditline(

Line 407: from okl_k_headers khr

403:
404: cursor c_credit_tna (p_chr_id okc_k_headers_b.id%TYPE)
405: is
406: select NVL(khr.TOT_CL_NET_TRANSFER_AMT,0)
407: from okl_k_headers khr
408: where khr.id = p_chr_id
409: ;
410:
411: -- source contarct and it's top line ids

Line 463: 5.2.1.3 Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line

459: 5.2.1 get credit line ID for source contract if any (raise error if credit line not found?)
460: IF credit line found THEN
461: 5.2.1.1 get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1
462: 5.2.1.2 get total T and A for source contract asset via formula LINE_CAP_AMOUNT
463: 5.2.1.3 Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line
464: END IF;
465:
466: end loop;
467:

Line 470: 5.3.2 Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for destination contract's credit line

466: end loop;
467:
468: IF destination credit line found THEN
469: 5.3.1 get total T and A for destination contract asset via formula LINE_CAP_AMOUNT
470: 5.3.2 Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for destination contract's credit line
471: END IF;
472:
473: */
474:

Line 490: -- Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line

486:
487: -- IF credit line found THEN
488: -- get source contract's asset top line via okc_k_lines_b.ORIG_SYSTEM_ID1
489: -- get total T and A for source contract asset via formula LINE_CAP_AMOUNT
490: -- Update (add this amount as positive to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for source contract's credit line
491: -- END IF;
492: if l_src_credit_id is not null then
493:
494: update_tna_creditline(

Line 518: -- Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for destination contract's credit line

514: -- end loop;
515:
516: -- IF destination credit line found THEN
517: -- get total T and A for destination contract asset via formula CONTRACT_CAP_AMOUNT
518: -- Update (add this amount as negative to OKL_K_HEADERS.TOT_CL_NET_TRANSFER_AMT) T and A for destination contract's credit line
519: -- END IF;
520: if l_dst_credit_id is not null then
521:
522: update_tna_creditline(