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_HEADERS_V

Line 58: -- FUNCTION get_rec for: OKC_K_HEADERS_V

54: RETURN(l_ak_prompt);
55: END;
56:
57: ---------------------------------------------------------------------------
58: -- FUNCTION get_rec for: OKC_K_HEADERS_V
59: ---------------------------------------------------------------------------
60: FUNCTION get_rec (
61: p_chrv_rec IN chrv_rec_type,
62: x_no_data_found OUT NOCOPY BOOLEAN

Line 153: FROM Okc_K_Headers_V

149: CREATION_DATE,
150: LAST_UPDATED_BY,
151: LAST_UPDATE_DATE,
152: LAST_UPDATE_LOGIN
153: FROM Okc_K_Headers_V
154: WHERE okc_k_headers_v.id = p_id;
155: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
156: l_chrv_rec chrv_rec_type;
157: BEGIN

Line 154: WHERE okc_k_headers_v.id = p_id;

150: LAST_UPDATED_BY,
151: LAST_UPDATE_DATE,
152: LAST_UPDATE_LOGIN
153: FROM Okc_K_Headers_V
154: WHERE okc_k_headers_v.id = p_id;
155: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
156: l_chrv_rec chrv_rec_type;
157: BEGIN
158:

Line 794: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

790: PROCEDURE sync_slh_sll(
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_msg_count OUT NOCOPY NUMBER,
793: x_msg_data OUT NOCOPY VARCHAR2,
794: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
795: p_old_rgp_id IN NUMBER,
796: p_new_rgp_id IN NUMBER
797: ) IS
798:

Line 828: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,

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
830: SELECT id
831: FROM okc_rule_groups_v
832: WHERE dnz_chr_id = p_chr_id

Line 980: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

976: PROCEDURE link_slh_sll(
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:

Line 982: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

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;
986:

Line 987: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

983: ) 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

Line 996: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

992: WHERE dnz_chr_id = p_chr_id
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

Line 1060: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1056: PROCEDURE link_slh_sll(
1057: x_return_status OUT NOCOPY VARCHAR2,
1058: x_msg_count OUT NOCOPY NUMBER,
1059: x_msg_data OUT NOCOPY VARCHAR2,
1060: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1061: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1062: ) IS
1063:
1064: link_failed EXCEPTION;

Line 1061: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

1057: x_return_status OUT NOCOPY VARCHAR2,
1058: x_msg_count OUT NOCOPY NUMBER,
1059: x_msg_data OUT NOCOPY VARCHAR2,
1060: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1061: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE
1062: ) IS
1063:
1064: link_failed EXCEPTION;
1065:

Line 1066: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1062: ) IS
1063:
1064: link_failed EXCEPTION;
1065:
1066: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1067: SELECT id,
1068: cle_id
1069: FROM okc_rule_groups_v
1070: WHERE dnz_chr_id = p_chr_id

Line 1074: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

1070: WHERE dnz_chr_id = p_chr_id
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

Line 2571: okc_k_headers_v hdr

2567: AND chr_id = p_dest_id
2568: AND EXISTS(
2569: SELECT '1'
2570: FROM okc_rule_groups_v rg,
2571: okc_k_headers_v hdr
2572: WHERE rg.chr_id = p_vp_tmpl_id
2573: AND hdr.id = rg.chr_id
2574: AND hdr.id = rg.dnz_chr_id
2575: AND rg.cle_id IS NULL

Line 2731: okc_k_headers_v hdr

2727: -- returns vendor program rgd codes which are qualified for lease
2728: CURSOR c_src_crs(p_vp_tmpl_id IN NUMBER) IS
2729: SELECT rg.id
2730: FROM okc_rule_groups_v rg,
2731: okc_k_headers_v hdr
2732: WHERE rg.chr_id = p_vp_tmpl_id
2733: AND hdr.id = rg.chr_id
2734: AND hdr.id = rg.dnz_chr_id
2735: AND rg.cle_id IS NULL

Line 3531: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

3527: x_chr_id OUT NOCOPY NUMBER) AS
3528:
3529: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3530: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3531: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3532: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3533: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3534:
3535: CURSOR l_source_k_num_crs IS

Line 3532: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

3528:
3529: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3530: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3531: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3532: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3533: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3534:
3535: CURSOR l_source_k_num_crs IS
3536: SELECT contract_number

Line 8447: FROM OKC_STATUSES_B sts,okc_k_headers_v CHR

8443: ;
8444:
8445: CURSOR l_sts_code_csr IS
8446: SELECT CHR.sts_code
8447: FROM OKC_STATUSES_B sts,okc_k_headers_v CHR
8448: WHERE STS.CODE = CHR.STS_CODE
8449: AND CHR.id = p_durv_rec.chr_id;
8450:
8451: