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

Line 131: okl_k_headers

127: cursor c_okl_k_hdr_csr(a_khr_id IN NUMBER)
128: IS
129: SELECT term_Duration,after_tax_yield
130: FROM
131: okl_k_headers
132: where id = a_khr_id;
133:
134: l_lease_details_tbl lease_details_tbl_type;
135:

Line 355: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V

351:
352: END get_chrv_rec;
353:
354: ---------------------------------------------------------------------------
355: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
356: ---------------------------------------------------------------------------
357: FUNCTION get_khrv_rec (
358: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
359: x_return_status OUT NOCOPY VARCHAR2

Line 358: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,

354: ---------------------------------------------------------------------------
355: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
356: ---------------------------------------------------------------------------
357: FUNCTION get_khrv_rec (
358: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
359: x_return_status OUT NOCOPY VARCHAR2
360: ) RETURN khrv_rec_type IS
361: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
362: SELECT

Line 361: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS

357: FUNCTION get_khrv_rec (
358: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
359: x_return_status OUT NOCOPY VARCHAR2
360: ) RETURN khrv_rec_type IS
361: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
362: SELECT
363: ID,
364: OBJECT_VERSION_NUMBER,
365: ISG_ID,

Line 420: FROM OKL_K_HEADERS_V

416: EXPECTED_DELIVERY_DATE,
417: ACCEPTED_DATE,
418: PREFUNDING_ELIGIBLE_YN,
419: REVOLVING_CREDIT_YN
420: FROM OKL_K_HEADERS_V
421: WHERE OKL_K_HEADERS_V.id = p_id;
422: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
423: l_khrv_rec khrv_rec_type;
424: BEGIN

Line 421: WHERE OKL_K_HEADERS_V.id = p_id;

417: ACCEPTED_DATE,
418: PREFUNDING_ELIGIBLE_YN,
419: REVOLVING_CREDIT_YN
420: FROM OKL_K_HEADERS_V
421: WHERE OKL_K_HEADERS_V.id = p_id;
422: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
423: l_khrv_rec khrv_rec_type;
424: BEGIN
425:

Line 422: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

418: PREFUNDING_ELIGIBLE_YN,
419: REVOLVING_CREDIT_YN
420: FROM OKL_K_HEADERS_V
421: WHERE OKL_K_HEADERS_V.id = p_id;
422: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
423: l_khrv_rec khrv_rec_type;
424: BEGIN
425:
426: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 428: OPEN okl_k_headers_v_pk_csr (p_khr_id);

424: BEGIN
425:
426: x_return_status := OKL_API.G_RET_STS_SUCCESS;
427: -- Get current database values
428: OPEN okl_k_headers_v_pk_csr (p_khr_id);
429: FETCH okl_k_headers_v_pk_csr INTO
430: l_khrv_rec.ID,
431: l_khrv_rec.OBJECT_VERSION_NUMBER,
432: l_khrv_rec.ISG_ID,

Line 429: FETCH okl_k_headers_v_pk_csr INTO

425:
426: x_return_status := OKL_API.G_RET_STS_SUCCESS;
427: -- Get current database values
428: OPEN okl_k_headers_v_pk_csr (p_khr_id);
429: FETCH okl_k_headers_v_pk_csr INTO
430: l_khrv_rec.ID,
431: l_khrv_rec.OBJECT_VERSION_NUMBER,
432: l_khrv_rec.ISG_ID,
433: l_khrv_rec.KHR_ID,

Line 488: IF okl_k_headers_v_pk_csr%NOTFOUND THEN

484: l_khrv_rec.ACCEPTED_DATE,
485: l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
486: l_khrv_rec.REVOLVING_CREDIT_YN
487: ;
488: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
489: x_return_status := OKL_API.G_RET_STS_ERROR;
490: END IF;
491: CLOSE okl_k_headers_v_pk_csr;
492: RETURN(l_khrv_rec);

Line 491: CLOSE okl_k_headers_v_pk_csr;

487: ;
488: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
489: x_return_status := OKL_API.G_RET_STS_ERROR;
490: END IF;
491: CLOSE okl_k_headers_v_pk_csr;
492: RETURN(l_khrv_rec);
493: EXCEPTION
494: WHEN OTHERS THEN
495: -- store SQL error message on message stack for caller

Line 505: IF okl_k_headers_v_pk_csr%ISOPEN THEN

501: 'SQLerrm',
502: SQLERRM);
503: -- notify caller of an UNEXPECTED error
504: -- if the cursor is open
505: IF okl_k_headers_v_pk_csr%ISOPEN THEN
506: CLOSE okl_k_headers_v_pk_csr;
507: END IF;
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
509: END get_khrv_rec;

Line 506: CLOSE okl_k_headers_v_pk_csr;

502: SQLERRM);
503: -- notify caller of an UNEXPECTED error
504: -- if the cursor is open
505: IF okl_k_headers_v_pk_csr%ISOPEN THEN
506: CLOSE okl_k_headers_v_pk_csr;
507: END IF;
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
509: END get_khrv_rec;
510:

Line 665: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

661: x_return_status OUT NOCOPY VARCHAR2,
662: x_msg_count OUT NOCOPY NUMBER,
663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
665: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
666: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
667: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
668: )
669: IS

Line 666: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,

662: x_msg_count OUT NOCOPY NUMBER,
663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
665: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
666: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
667: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
668: )
669: IS
670:

Line 667: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE

663: x_msg_data OUT NOCOPY VARCHAR2,
664: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
665: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
666: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
667: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
668: )
669: IS
670:
671: l_khrv_rec khrv_rec_type;