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

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

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

Line 826: FROM okc_k_lines_v

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

Line 982: p_new_cle_id IN OKC_K_LINES_V.ID%TYPE,

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

Line 989: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

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

Line 998: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

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

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

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

Line 1010: FROM OKC_K_LINES_V

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

Line 1015: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

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

Line 1016: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

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

Line 1076: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

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

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

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

Line 1088: FROM OKC_K_LINES_V

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

Line 1093: l_old_cle_id OKC_K_LINES_V.ID%TYPE;

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

Line 1094: l_new_cle_id OKC_K_LINES_V.ID%TYPE;

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