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 81: --Functions to fetch data from okc_k_headers_v, okc_k_lines_v,

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

Line 534: -- FUNCTION get_rec for: OKC_K_LINES_V

530: BEGIN
531: RETURN(get_khrv_rec(p_khrv_id, l_row_notfound));
532: END get_khrv_rec;
533: ---------------------------------------------------------------------------
534: -- FUNCTION get_rec for: OKC_K_LINES_V
535: ---------------------------------------------------------------------------
536: FUNCTION get_clev_rec (
537: p_clev_id IN NUMBER,
538: x_no_data_found OUT NOCOPY BOOLEAN

Line 637: FROM Okc_K_Lines_V

633: ,INV_RULE_ID
634: ,LINE_RENEWAL_TYPE_CODE
635: ,SHIP_TO_SITE_USE_ID
636: ,PAYMENT_TERM_ID
637: FROM Okc_K_Lines_V
638: WHERE okc_k_lines_v.id = p_id;
639: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
640: l_clev_rec clev_rec_type;
641: BEGIN

Line 638: WHERE okc_k_lines_v.id = p_id;

634: ,LINE_RENEWAL_TYPE_CODE
635: ,SHIP_TO_SITE_USE_ID
636: ,PAYMENT_TERM_ID
637: FROM Okc_K_Lines_V
638: WHERE okc_k_lines_v.id = p_id;
639: l_okc_clev_pk okc_clev_pk_csr%ROWTYPE;
640: l_clev_rec clev_rec_type;
641: BEGIN
642: x_no_data_found := TRUE;

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

2218:
2219: l_rulv_tbl rulv_tbl_type;
2220: i NUMBER := 0;
2221:
2222: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2223: SELECT orig_system_id1
2224: FROM okc_k_lines_v
2225: WHERE id = p_cle_id;
2226:

Line 2224: FROM okc_k_lines_v

2220: i NUMBER := 0;
2221:
2222: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2223: SELECT orig_system_id1
2224: FROM okc_k_lines_v
2225: WHERE id = p_cle_id;
2226:
2227: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2228: p_rgp_id NUMBER) IS

Line 2388: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,

2384: x_return_status OUT NOCOPY VARCHAR2,
2385: x_msg_count OUT NOCOPY NUMBER,
2386: x_msg_data OUT NOCOPY VARCHAR2,
2387: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2388: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
2389: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
2390: ) IS
2391:
2392: link_failed EXCEPTION;

Line 2395: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2391:
2392: link_failed EXCEPTION;
2393:
2394: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2395: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2396: SELECT id,
2397: cle_id
2398: FROM okc_rule_groups_v
2399: WHERE dnz_chr_id = p_chr_id

Line 2404: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2400: AND cle_id = p_cle_id
2401: AND rgd_code = 'LALEVL';
2402:
2403: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2404: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2405: SELECT id
2406: FROM okc_rule_groups_v
2407: WHERE dnz_chr_id = p_chr_id
2408: AND rgd_code = 'LALEVL'

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

2410: OR ( cle_id IS NULL
2411: AND
2412: p_cle_id IS NULL));
2413:
2414: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2415: SELECT orig_system_id1
2416: FROM OKC_K_LINES_V
2417: WHERE id = p_cle_id;
2418:

Line 2416: FROM OKC_K_LINES_V

2412: p_cle_id IS NULL));
2413:
2414: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2415: SELECT orig_system_id1
2416: FROM OKC_K_LINES_V
2417: WHERE id = p_cle_id;
2418:
2419: l_old_lalevl_id NUMBER;
2420: l_new_lalevl_id NUMBER;

Line 2421: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

2417: WHERE id = p_cle_id;
2418:
2419: l_old_lalevl_id NUMBER;
2420: l_new_lalevl_id NUMBER;
2421: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2422: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2423:
2424: BEGIN
2425:

Line 2422: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

2418:
2419: l_old_lalevl_id NUMBER;
2420: l_new_lalevl_id NUMBER;
2421: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2422: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2423:
2424: BEGIN
2425:
2426: FOR new_lalevl_rec IN lalevl_csr(p_new_chr_id,

Line 2491: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2487: AND cle_id IS NULL -- Bug 2376998
2488: AND rgd_code = 'LALEVL';
2489:
2490: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2491: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2492: SELECT id
2493: FROM okc_rule_groups_v
2494: WHERE dnz_chr_id = p_chr_id
2495: AND rgd_code = 'LALEVL'

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

2497: OR ( cle_id IS NULL
2498: AND
2499: p_cle_id IS NULL));
2500:
2501: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2502: SELECT orig_system_id1
2503: FROM OKC_K_LINES_V
2504: WHERE id = p_cle_id;
2505:

Line 2503: FROM OKC_K_LINES_V

2499: p_cle_id IS NULL));
2500:
2501: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2502: SELECT orig_system_id1
2503: FROM OKC_K_LINES_V
2504: WHERE id = p_cle_id;
2505:
2506: l_old_lalevl_id NUMBER;
2507: l_new_lalevl_id NUMBER;

Line 2508: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

2504: WHERE id = p_cle_id;
2505:
2506: l_old_lalevl_id NUMBER;
2507: l_new_lalevl_id NUMBER;
2508: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2509: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2510:
2511: BEGIN
2512:

Line 2509: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

2505:
2506: l_old_lalevl_id NUMBER;
2507: l_new_lalevl_id NUMBER;
2508: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
2509: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
2510:
2511: BEGIN
2512:
2513: FOR new_lalevl_rec IN lalevl_csr(p_new_chr_id)

Line 2891: From OKC_K_LINES_V

2887: l_clev_rec_out clev_rec_type;
2888:
2889: Cursor l_clev_cur (l_chr_id IN Number) is
2890: Select Orig_System_Id1,id
2891: From OKC_K_LINES_V
2892: Where dnz_chr_id = l_chr_id;
2893:
2894: --This is modified to take care of the patch in OKC which has included
2895: --original source line id with the new line id

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

3352: CONNECT BY PRIOR id = cle_id
3353: START WITH id = p_from_cle_id;
3354: c_lines_rec c_lines%rowtype;
3355:
3356: CURSOR old_chr_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3357: SELECT cle.dnz_chr_id
3358: FROM okc_k_lines_v cle
3359: WHERE cle.id = p_cle_id;
3360:

Line 3358: FROM okc_k_lines_v cle

3354: c_lines_rec c_lines%rowtype;
3355:
3356: CURSOR old_chr_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
3357: SELECT cle.dnz_chr_id
3358: FROM okc_k_lines_v cle
3359: WHERE cle.id = p_cle_id;
3360:
3361: -----------------------------------------------------------
3362: --Bug# 3143522 : Subsidies copy party payment details