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_COPY_CONTRACT_PVT dependencies on OKC_K_LINES_V

Line 75: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,

71: End Loop;
72: Return l_lines_tbl;
73: END migrate_lines_tbl;
74: --------------------------------------------------------------------------
75: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,
76: --okl_k_headers_v and okl_k_lines_v
77: --These Functions are copy of local functions get_rec in
78: --OKC_CHR_PVT and OKL_KHR_PVT. These are repeated here since they have not
79: --been published. Any changes in in these in the original packages will

Line 528: -- FUNCTION get_rec for: OKC_K_LINES_V

524: BEGIN
525: RETURN(get_khrv_rec(p_khrv_id, l_row_notfound));
526: END get_khrv_rec;
527: ---------------------------------------------------------------------------
528: -- FUNCTION get_rec for: OKC_K_LINES_V
529: ---------------------------------------------------------------------------
530: FUNCTION get_clev_rec (
531: p_clev_id IN NUMBER,
532: x_no_data_found OUT NOCOPY BOOLEAN

Line 631: FROM Okc_K_Lines_V

627: ,INV_RULE_ID
628: ,LINE_RENEWAL_TYPE_CODE
629: ,SHIP_TO_SITE_USE_ID
630: ,PAYMENT_TERM_ID
631: FROM Okc_K_Lines_V
632: WHERE okc_k_lines_v.id = p_id;
633: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
634: l_clev_rec clev_rec_type;
635: BEGIN

Line 632: WHERE okc_k_lines_v.id = p_id;

628: ,LINE_RENEWAL_TYPE_CODE
629: ,SHIP_TO_SITE_USE_ID
630: ,PAYMENT_TERM_ID
631: FROM Okc_K_Lines_V
632: WHERE okc_k_lines_v.id = p_id;
633: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
634: l_clev_rec clev_rec_type;
635: BEGIN
636: x_no_data_found := TRUE;

Line 2185: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2181:
2182: l_rulv_tbl rulv_tbl_type;
2183: i NUMBER := 0;
2184:
2185: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2186: SELECT orig_system_id1
2187: FROM okc_k_lines_v
2188: WHERE id = p_cle_id;
2189:

Line 2187: FROM okc_k_lines_v

2183: i NUMBER := 0;
2184:
2185: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2186: SELECT orig_system_id1
2187: FROM okc_k_lines_v
2188: WHERE id = p_cle_id;
2189:
2190: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2191: p_rgp_id NUMBER) IS

Line 2351: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,

2347: x_return_status OUT NOCOPY VARCHAR2,
2348: x_msg_count OUT NOCOPY NUMBER,
2349: x_msg_data OUT NOCOPY VARCHAR2,
2350: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2351: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
2352: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2353: ) IS
2354:
2355: link_failed EXCEPTION;

Line 2358: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2354:
2355: link_failed EXCEPTION;
2356:
2357: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2358: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2359: SELECT id,
2360: cle_id
2361: FROM okc_rule_groups_v
2362: WHERE dnz_chr_id = p_chr_id

Line 2367: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2363: AND cle_id = p_cle_id
2364: AND rgd_code = 'LALEVL';
2365:
2366: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2367: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2368: SELECT id
2369: FROM okc_rule_groups_v
2370: WHERE dnz_chr_id = p_chr_id
2371: AND rgd_code = 'LALEVL'

Line 2377: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2373: OR ( cle_id IS NULL
2374: AND
2375: p_cle_id IS NULL));
2376:
2377: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2378: SELECT orig_system_id1
2379: FROM OKC_K_LINES_V
2380: WHERE id = p_cle_id;
2381:

Line 2379: FROM OKC_K_LINES_V

2375: p_cle_id IS NULL));
2376:
2377: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2378: SELECT orig_system_id1
2379: FROM OKC_K_LINES_V
2380: WHERE id = p_cle_id;
2381:
2382: l_old_lalevl_id NUMBER;
2383: l_new_lalevl_id NUMBER;

Line 2384: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

2380: WHERE id = p_cle_id;
2381:
2382: l_old_lalevl_id NUMBER;
2383: l_new_lalevl_id NUMBER;
2384: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2385: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2386:
2387: BEGIN
2388:

Line 2385: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

2381:
2382: l_old_lalevl_id NUMBER;
2383: l_new_lalevl_id NUMBER;
2384: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2385: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2386:
2387: BEGIN
2388:
2389: FOR new_lalevl_rec IN lalevl_csr(p_new_chr_id,

Line 2454: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2450: AND cle_id IS NULL -- Bug 2376998
2451: AND rgd_code = 'LALEVL';
2452:
2453: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2454: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2455: SELECT id
2456: FROM okc_rule_groups_v
2457: WHERE dnz_chr_id = p_chr_id
2458: AND rgd_code = 'LALEVL'

Line 2464: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2460: OR ( cle_id IS NULL
2461: AND
2462: p_cle_id IS NULL));
2463:
2464: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2465: SELECT orig_system_id1
2466: FROM OKC_K_LINES_V
2467: WHERE id = p_cle_id;
2468:

Line 2466: FROM OKC_K_LINES_V

2462: p_cle_id IS NULL));
2463:
2464: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2465: SELECT orig_system_id1
2466: FROM OKC_K_LINES_V
2467: WHERE id = p_cle_id;
2468:
2469: l_old_lalevl_id NUMBER;
2470: l_new_lalevl_id NUMBER;

Line 2471: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

2467: WHERE id = p_cle_id;
2468:
2469: l_old_lalevl_id NUMBER;
2470: l_new_lalevl_id NUMBER;
2471: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2472: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2473:
2474: BEGIN
2475:

Line 2472: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

2468:
2469: l_old_lalevl_id NUMBER;
2470: l_new_lalevl_id NUMBER;
2471: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2472: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2473:
2474: BEGIN
2475:
2476: FOR new_lalevl_rec IN lalevl_csr(p_new_chr_id)

Line 2854: From OKC_K_LINES_V

2850: l_clev_rec_out clev_rec_type;
2851:
2852: Cursor l_clev_cur (l_chr_id IN Number) is
2853: Select Orig_System_Id1,id
2854: From OKC_K_LINES_V
2855: Where dnz_chr_id = l_chr_id;
2856:
2857: --This is modified to take care of the patch in OKC which has included
2858: --original source line id with the new line id

Line 3319: CURSOR old_chr_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

3315: CONNECT BY PRIOR id = cle_id
3316: START WITH id = p_from_cle_id;
3317: c_lines_rec c_lines%rowtype;
3318:
3319: CURSOR old_chr_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3320: SELECT dnz_chr_id
3321: FROM okc_k_lines_v
3322: WHERE id = p_cle_id;
3323:

Line 3321: FROM okc_k_lines_v

3317: c_lines_rec c_lines%rowtype;
3318:
3319: CURSOR old_chr_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3320: SELECT dnz_chr_id
3321: FROM okc_k_lines_v
3322: WHERE id = p_cle_id;
3323:
3324: -----------------------------------------------------------
3325: --Bug# 3143522 : Subsidies copy party payment details