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

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

819:
820: l_rulv_tbl rulv_tbl_type;
821: i NUMBER := 0;
822:
823: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
824: SELECT orig_system_id1
825: FROM okc_k_lines_v
826: WHERE id = p_cle_id;
827:

Line 825: FROM okc_k_lines_v

821: i NUMBER := 0;
822:
823: CURSOR orig_cle_csr(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
824: SELECT orig_system_id1
825: FROM okc_k_lines_v
826: WHERE id = p_cle_id;
827:
828: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
829: p_rgp_id NUMBER) IS

Line 981: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,

977: x_return_status OUT NOCOPY VARCHAR2,
978: x_msg_count OUT NOCOPY NUMBER,
979: x_msg_data OUT NOCOPY VARCHAR2,
980: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
981: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,
982: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
983: ) IS
984:
985: link_failed EXCEPTION;

Line 988: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

984:
985: link_failed EXCEPTION;
986:
987: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
988: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
989: SELECT id,
990: cle_id
991: FROM okc_rule_groups_v
992: WHERE dnz_chr_id = p_chr_id

Line 997: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

993: AND cle_id = p_cle_id
994: AND rgd_code = 'LALEVL';
995:
996: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
997: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
998: SELECT id
999: FROM okc_rule_groups_v
1000: WHERE dnz_chr_id = p_chr_id
1001: AND rgd_code = 'LALEVL'

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

1003: OR ( cle_id IS NULL
1004: AND
1005: p_cle_id IS NULL));
1006:
1007: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1008: SELECT orig_system_id1
1009: FROM OKC_K_LINES_V
1010: WHERE id = p_cle_id;
1011:

Line 1009: FROM OKC_K_LINES_V

1005: p_cle_id IS NULL));
1006:
1007: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1008: SELECT orig_system_id1
1009: FROM OKC_K_LINES_V
1010: WHERE id = p_cle_id;
1011:
1012: l_old_lalevl_id NUMBER;
1013: l_new_lalevl_id NUMBER;

Line 1014: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

1010: WHERE id = p_cle_id;
1011:
1012: l_old_lalevl_id NUMBER;
1013: l_new_lalevl_id NUMBER;
1014: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
1015: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
1016:
1017: BEGIN
1018:

Line 1015: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

1011:
1012: l_old_lalevl_id NUMBER;
1013: l_new_lalevl_id NUMBER;
1014: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
1015: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
1016:
1017: BEGIN
1018:
1019: -- get into the loop if lalevl entries found for the new contract

Line 1075: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

1071: AND cle_id IS NULL -- Bug 2376998
1072: AND rgd_code = 'LALEVL';
1073:
1074: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1075: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1076: SELECT id
1077: FROM okc_rule_groups_v
1078: WHERE dnz_chr_id = p_chr_id
1079: AND rgd_code = 'LALEVL'

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

1081: OR ( cle_id IS NULL
1082: AND
1083: p_cle_id IS NULL));
1084:
1085: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1086: SELECT orig_system_id1
1087: FROM OKC_K_LINES_V
1088: WHERE id = p_cle_id;
1089:

Line 1087: FROM OKC_K_LINES_V

1083: p_cle_id IS NULL));
1084:
1085: CURSOR old_line_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1086: SELECT orig_system_id1
1087: FROM OKC_K_LINES_V
1088: WHERE id = p_cle_id;
1089:
1090: l_old_lalevl_id NUMBER;
1091: l_new_lalevl_id NUMBER;

Line 1092: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

1088: WHERE id = p_cle_id;
1089:
1090: l_old_lalevl_id NUMBER;
1091: l_new_lalevl_id NUMBER;
1092: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
1093: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
1094:
1095: BEGIN
1096:

Line 1093: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

1089:
1090: l_old_lalevl_id NUMBER;
1091: l_new_lalevl_id NUMBER;
1092: l_old_cle_id OKC_K_LINES_V.ID%TYPE;
1093: l_new_cle_id OKC_K_LINES_V.ID%TYPE;
1094:
1095: BEGIN
1096:
1097: FOR new_lalevl_rec IN lalevl_csr(p_new_chr_id)