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

Line 447: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V

443:
444: END get_chrv_rec;
445:
446: ---------------------------------------------------------------------------
447: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
448: ---------------------------------------------------------------------------
449: FUNCTION get_khrv_rec (
450: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
451: x_return_status OUT NOCOPY VARCHAR2

Line 450: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,

446: ---------------------------------------------------------------------------
447: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
448: ---------------------------------------------------------------------------
449: FUNCTION get_khrv_rec (
450: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
451: x_return_status OUT NOCOPY VARCHAR2
452: ) RETURN khrv_rec_type IS
453: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
454: SELECT

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

449: FUNCTION get_khrv_rec (
450: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
451: x_return_status OUT NOCOPY VARCHAR2
452: ) RETURN khrv_rec_type IS
453: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
454: SELECT
455: ID,
456: OBJECT_VERSION_NUMBER,
457: ISG_ID,

Line 512: FROM OKL_K_HEADERS_V

508: EXPECTED_DELIVERY_DATE,
509: ACCEPTED_DATE,
510: PREFUNDING_ELIGIBLE_YN,
511: REVOLVING_CREDIT_YN
512: FROM OKL_K_HEADERS_V
513: WHERE OKL_K_HEADERS_V.id = p_id;
514: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
515: l_khrv_rec khrv_rec_type;
516: BEGIN

Line 513: WHERE OKL_K_HEADERS_V.id = p_id;

509: ACCEPTED_DATE,
510: PREFUNDING_ELIGIBLE_YN,
511: REVOLVING_CREDIT_YN
512: FROM OKL_K_HEADERS_V
513: WHERE OKL_K_HEADERS_V.id = p_id;
514: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
515: l_khrv_rec khrv_rec_type;
516: BEGIN
517:

Line 514: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

510: PREFUNDING_ELIGIBLE_YN,
511: REVOLVING_CREDIT_YN
512: FROM OKL_K_HEADERS_V
513: WHERE OKL_K_HEADERS_V.id = p_id;
514: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
515: l_khrv_rec khrv_rec_type;
516: BEGIN
517:
518: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 520: OPEN okl_k_headers_v_pk_csr (p_khr_id);

516: BEGIN
517:
518: x_return_status := OKL_API.G_RET_STS_SUCCESS;
519: -- Get current database values
520: OPEN okl_k_headers_v_pk_csr (p_khr_id);
521: FETCH okl_k_headers_v_pk_csr INTO
522: l_khrv_rec.ID,
523: l_khrv_rec.OBJECT_VERSION_NUMBER,
524: l_khrv_rec.ISG_ID,

Line 521: FETCH okl_k_headers_v_pk_csr INTO

517:
518: x_return_status := OKL_API.G_RET_STS_SUCCESS;
519: -- Get current database values
520: OPEN okl_k_headers_v_pk_csr (p_khr_id);
521: FETCH okl_k_headers_v_pk_csr INTO
522: l_khrv_rec.ID,
523: l_khrv_rec.OBJECT_VERSION_NUMBER,
524: l_khrv_rec.ISG_ID,
525: l_khrv_rec.KHR_ID,

Line 580: IF okl_k_headers_v_pk_csr%NOTFOUND THEN

576: l_khrv_rec.ACCEPTED_DATE,
577: l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
578: l_khrv_rec.REVOLVING_CREDIT_YN
579: ;
580: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
581: x_return_status := OKL_API.G_RET_STS_ERROR;
582: END IF;
583: CLOSE okl_k_headers_v_pk_csr;
584: RETURN(l_khrv_rec);

Line 583: CLOSE okl_k_headers_v_pk_csr;

579: ;
580: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
581: x_return_status := OKL_API.G_RET_STS_ERROR;
582: END IF;
583: CLOSE okl_k_headers_v_pk_csr;
584: RETURN(l_khrv_rec);
585: EXCEPTION
586: WHEN OTHERS THEN
587: -- store SQL error message on message stack for caller

Line 597: IF okl_k_headers_v_pk_csr%ISOPEN THEN

593: 'SQLerrm',
594: SQLERRM);
595: -- notify caller of an UNEXPECTED error
596: -- if the cursor is open
597: IF okl_k_headers_v_pk_csr%ISOPEN THEN
598: CLOSE okl_k_headers_v_pk_csr;
599: END IF;
600: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
601: END get_khrv_rec;

Line 598: CLOSE okl_k_headers_v_pk_csr;

594: SQLERRM);
595: -- notify caller of an UNEXPECTED error
596: -- if the cursor is open
597: IF okl_k_headers_v_pk_csr%ISOPEN THEN
598: CLOSE okl_k_headers_v_pk_csr;
599: END IF;
600: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
601: END get_khrv_rec;
602:

Line 818: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

814: x_return_status OUT NOCOPY VARCHAR2,
815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
818: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
819: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
820: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
821: )
822: IS

Line 819: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,

815: x_msg_count OUT NOCOPY NUMBER,
816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
818: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
819: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
820: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
821: )
822: IS
823:

Line 820: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE

816: x_msg_data OUT NOCOPY VARCHAR2,
817: p_working_copy_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
818: p_start_date IN OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
819: p_end_date IN OKL_K_HEADERS_FULL_V.END_DATE%TYPE,
820: p_term_duration IN OKL_K_HEADERS_FULL_V.TERM_DURATION%TYPE
821: )
822: IS
823:
824: l_khrv_rec khrv_rec_type;

Line 2457: FROM okl_k_headers

2453:
2454: CURSOR c_get_iir (c_khr_id NUMBER)
2455: IS
2456: SELECT implicit_interest_rate
2457: FROM okl_k_headers
2458: where id = c_khr_id;
2459:
2460: CURSOR c_get_line_iir (c_line_id NUMBER)
2461: IS

Line 3783: FROM okl_k_headers

3779: FUNCTION get_pdt_id (p_khr_id IN VARCHAR2) RETURN NUMBER IS
3780:
3781: CURSOR c_pdt IS
3782: SELECT pdt_id
3783: FROM okl_k_headers
3784: WHERE id = p_khr_id;
3785:
3786: l_pdt_id NUMBER;
3787:

Line 7164: FROM okl_k_headers_full_v

7160:
7161: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
7162: SELECT currency_code,
7163: authoring_org_id
7164: FROM okl_k_headers_full_v
7165: WHERE id = p_chr_id;
7166:
7167: CURSOR c_tran_num_csr IS
7168: SELECT okl_sif_seq.nextval