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.

[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_K_HEADERS

Line 316: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V

312:
313: END get_chrv_rec;
314:
315: ---------------------------------------------------------------------------
316: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
317: ---------------------------------------------------------------------------
318: FUNCTION get_khrv_rec (
319: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
320: x_return_status OUT NOCOPY VARCHAR2

Line 319: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,

315: ---------------------------------------------------------------------------
316: -- FUNCTION get_khrv_rec for: OKL_K_HEADERS_V
317: ---------------------------------------------------------------------------
318: FUNCTION get_khrv_rec (
319: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
320: x_return_status OUT NOCOPY VARCHAR2
321: ) RETURN khrv_rec_type IS
322: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
323: SELECT

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

318: FUNCTION get_khrv_rec (
319: p_khr_id IN OKL_K_HEADERS_V.ID%TYPE,
320: x_return_status OUT NOCOPY VARCHAR2
321: ) RETURN khrv_rec_type IS
322: CURSOR okl_k_headers_v_pk_csr (p_id IN OKL_K_HEADERS_V.ID%TYPE) IS
323: SELECT
324: ID,
325: OBJECT_VERSION_NUMBER,
326: ISG_ID,

Line 381: FROM OKL_K_HEADERS_V

377: EXPECTED_DELIVERY_DATE,
378: ACCEPTED_DATE,
379: PREFUNDING_ELIGIBLE_YN,
380: REVOLVING_CREDIT_YN
381: FROM OKL_K_HEADERS_V
382: WHERE OKL_K_HEADERS_V.id = p_id;
383: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
384: l_khrv_rec khrv_rec_type;
385: BEGIN

Line 382: WHERE OKL_K_HEADERS_V.id = p_id;

378: ACCEPTED_DATE,
379: PREFUNDING_ELIGIBLE_YN,
380: REVOLVING_CREDIT_YN
381: FROM OKL_K_HEADERS_V
382: WHERE OKL_K_HEADERS_V.id = p_id;
383: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
384: l_khrv_rec khrv_rec_type;
385: BEGIN
386:

Line 383: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;

379: PREFUNDING_ELIGIBLE_YN,
380: REVOLVING_CREDIT_YN
381: FROM OKL_K_HEADERS_V
382: WHERE OKL_K_HEADERS_V.id = p_id;
383: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
384: l_khrv_rec khrv_rec_type;
385: BEGIN
386:
387: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 389: OPEN okl_k_headers_v_pk_csr (p_khr_id);

385: BEGIN
386:
387: x_return_status := OKL_API.G_RET_STS_SUCCESS;
388: -- Get current database values
389: OPEN okl_k_headers_v_pk_csr (p_khr_id);
390: FETCH okl_k_headers_v_pk_csr INTO
391: l_khrv_rec.ID,
392: l_khrv_rec.OBJECT_VERSION_NUMBER,
393: l_khrv_rec.ISG_ID,

Line 390: FETCH okl_k_headers_v_pk_csr INTO

386:
387: x_return_status := OKL_API.G_RET_STS_SUCCESS;
388: -- Get current database values
389: OPEN okl_k_headers_v_pk_csr (p_khr_id);
390: FETCH okl_k_headers_v_pk_csr INTO
391: l_khrv_rec.ID,
392: l_khrv_rec.OBJECT_VERSION_NUMBER,
393: l_khrv_rec.ISG_ID,
394: l_khrv_rec.KHR_ID,

Line 449: IF okl_k_headers_v_pk_csr%NOTFOUND THEN

445: l_khrv_rec.ACCEPTED_DATE,
446: l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
447: l_khrv_rec.REVOLVING_CREDIT_YN
448: ;
449: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
450: x_return_status := OKL_API.G_RET_STS_ERROR;
451: END IF;
452: CLOSE okl_k_headers_v_pk_csr;
453: RETURN(l_khrv_rec);

Line 452: CLOSE okl_k_headers_v_pk_csr;

448: ;
449: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
450: x_return_status := OKL_API.G_RET_STS_ERROR;
451: END IF;
452: CLOSE okl_k_headers_v_pk_csr;
453: RETURN(l_khrv_rec);
454: EXCEPTION
455: WHEN OTHERS THEN
456: -- store SQL error message on message stack for caller

Line 466: IF okl_k_headers_v_pk_csr%ISOPEN THEN

462: 'SQLerrm',
463: SQLERRM);
464: -- notify caller of an UNEXPECTED error
465: -- if the cursor is open
466: IF okl_k_headers_v_pk_csr%ISOPEN THEN
467: CLOSE okl_k_headers_v_pk_csr;
468: END IF;
469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
470: END get_khrv_rec;

Line 467: CLOSE okl_k_headers_v_pk_csr;

463: SQLERRM);
464: -- notify caller of an UNEXPECTED error
465: -- if the cursor is open
466: IF okl_k_headers_v_pk_csr%ISOPEN THEN
467: CLOSE okl_k_headers_v_pk_csr;
468: END IF;
469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
470: END get_khrv_rec;
471:

Line 2609: FROM okl_k_headers_full_v

2605: ,date_signed
2606: ,credit_act_yn
2607: ,assignable_yn
2608: --Bug# 8652738
2609: FROM okl_k_headers_full_v
2610: WHERE id = p_chr_id;
2611:
2612: l_proc_name VARCHAR2(35) := 'SYNC_HEADER_VALUES';
2613: l_khrv_rec khrv_rec_type;

Line 6375: FROM okl_k_headers_full_v

6371: ) IS
6372: CURSOR term_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6373: SELECT term_duration,
6374: start_date
6375: FROM okl_k_headers_full_v
6376: WHERE id = p_chr_id;
6377:
6378: CURSOR date_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6379: SELECT start_date,

Line 6382: FROM okl_k_headers_full_v

6378: CURSOR date_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6379: SELECT start_date,
6380: end_date,
6381: term_duration
6382: FROM okl_k_headers_full_v
6383: WHERE id = p_chr_id;
6384:
6385: l_proc_name VARCHAR2(35) := 'CHECK_AND_UPDATE_DATE';
6386: l_chrv_rec chrv_rec_type;

Line 6391: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;

6387: x_chrv_rec chrv_rec_type;
6388: l_khrv_rec khrv_rec_type;
6389: x_khrv_rec khrv_rec_type;
6390:
6391: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6392: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6393:
6394: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6395: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

Line 6392: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;

6388: l_khrv_rec khrv_rec_type;
6389: x_khrv_rec khrv_rec_type;
6390:
6391: l_orig_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6392: l_rebook_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6393:
6394: l_orig_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6395: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6396:

Line 6399: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;

6395: l_rebook_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
6396:
6397: l_new_start_date OKC_K_HEADERS_V.START_DATE%TYPE;
6398: l_new_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
6399: l_new_term OKL_K_HEADERS.TERM_DURATION%TYPE;
6400:
6401: check_update_failed EXCEPTION;
6402:
6403: BEGIN

Line 7789: okl_k_headers khr,

7785: SELECT ktrx.date_transaction_occurred,ktrx.id,
7786: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
7787: FROM okc_k_headers_b CHR,
7788: okl_trx_contracts ktrx,
7789: okl_k_headers khr,
7790: okl_products pdt
7791: WHERE ktrx.khr_id_new = chr.id
7792: AND ktrx.tsu_code = 'ENTERED'
7793: AND ktrx.rbr_code is NOT NULL

Line 9481: okl_k_headers khr,

9477: orig_stm.kle_id,
9478: styt.name
9479: FROM okl_streams new_stm,
9480: okl_prod_strm_types psty,
9481: okl_k_headers khr,
9482: okl_streams orig_stm,
9483: okl_strm_type_tl styt
9484: WHERE khr.id = p_khr_id
9485: AND psty.pdt_id = khr.pdt_id

Line 9524: okl_k_headers khr,

9520: styt.name,
9521: cle.lse_id
9522: FROM okl_streams orig_stm,
9523: okl_prod_strm_types psty,
9524: okl_k_headers khr,
9525: okc_k_lines_b cle,
9526: okl_strm_type_tl styt
9527: WHERE khr.id = p_orig_khr_id
9528: AND psty.pdt_id = khr.pdt_id

Line 9832: okl_k_headers khr,

9828: sty.name
9829: --FROM okl_streams new_stm,
9830: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
9831: okl_prod_strm_types psty,
9832: okl_k_headers khr,
9833: --okl_streams orig_stm,
9834: okl_streams_rep_v orig_stm, -- MGAAP 7263041
9835: okl_strm_type_v sty
9836: WHERE khr.id = p_khr_id

Line 9885: okl_k_headers khr,

9881: cle.lse_id
9882: --FROM okl_streams orig_stm,
9883: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
9884: okl_prod_strm_types psty,
9885: okl_k_headers khr,
9886: okc_k_lines_b cle,
9887: okl_strm_type_v sty
9888: WHERE khr.id = p_orig_khr_id
9889: --AND psty.pdt_id = khr.pdt_id

Line 9932: FROM okl_k_headers a,

9928:
9929: -- MGAAP start 7263041
9930: CURSOR c_get_reporting_pdt_id(p_chr_id IN NUMBER) IS
9931: SELECT b.reporting_pdt_id, a.multi_gaap_yn
9932: FROM okl_k_headers a,
9933: okl_products b
9934: WHERE a.ID = p_chr_id
9935: AND a.PDT_ID = b.ID;
9936:

Line 9938: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

9934: WHERE a.ID = p_chr_id
9935: AND a.PDT_ID = b.ID;
9936:
9937: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;
9938: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
9939: l_current_mgaap_context VARCHAR2(10);
9940: -- MGAAP end 7263041
9941:
9942: BEGIN

Line 10562: l_stmv_rec_new_disb.source_table := 'OKL_K_HEADERS';

10558: l_stmv_rec_new_disb.transaction_number := l_transaction_number;
10559: l_stmv_rec_new_disb.sgn_code := 'MANL';
10560: l_stmv_rec_new_disb.sty_id := l_disb_adj_sty_id;
10561: l_stmv_rec_new_disb.source_id := l_inv_agreement_id;
10562: l_stmv_rec_new_disb.source_table := 'OKL_K_HEADERS';
10563:
10564: l_selv_tbl_new_disb(1).amount := l_disb_adj_tbl(i).disb_adj_amt + l_undisb_adj_amt_rec.amount;
10565: l_selv_tbl_new_disb(1).accrued_yn := 'Y';
10566: l_selv_tbl_new_disb(1).stream_element_date := sysdate;

Line 11176: okl_k_headers khr,

11172: sty.name
11173: --FROM okl_streams new_stm,
11174: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
11175: okl_prod_strm_types psty,
11176: okl_k_headers khr,
11177: --okl_streams orig_stm,
11178: okl_streams_rep_v orig_stm, -- MGAAP 7263041
11179: okl_strm_type_v sty
11180: WHERE khr.id = p_khr_id