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_HEADERS_V

Line 59: -- FUNCTION get_rec for: OKC_K_HEADERS_V

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

Line 154: FROM Okc_K_Headers_V

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

Line 155: WHERE okc_k_headers_v.id = p_id;

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

Line 795: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

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

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

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

Line 981: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

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

Line 983: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

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

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

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

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

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

Line 1061: p_old_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

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

Line 1062: p_new_chr_id IN OKC_K_HEADERS_V.ID%TYPE

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

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

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

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

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

Line 2582: okc_k_headers_v hdr

2578: AND chr_id = p_dest_id
2579: AND EXISTS(
2580: SELECT '1'
2581: FROM okc_rule_groups_v rg,
2582: okc_k_headers_v hdr
2583: WHERE rg.chr_id = p_vp_tmpl_id
2584: AND hdr.id = rg.chr_id
2585: AND hdr.id = rg.dnz_chr_id
2586: AND rg.cle_id IS NULL

Line 2751: okc_k_headers_v hdr

2747: -- returns vendor program rgd codes which are qualified for lease
2748: CURSOR c_src_crs(p_vp_tmpl_id IN NUMBER) IS
2749: SELECT rg.id
2750: FROM okc_rule_groups_v rg,
2751: okc_k_headers_v hdr
2752: WHERE rg.chr_id = p_vp_tmpl_id
2753: AND hdr.id = rg.chr_id
2754: AND hdr.id = rg.dnz_chr_id
2755: AND rg.cle_id IS NULL

Line 3551: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

3547: x_chr_id OUT NOCOPY NUMBER) AS
3548:
3549: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3550: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3551: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3552: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3553: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3554:
3555: CURSOR l_source_k_num_crs IS

Line 3552: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

3548:
3549: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3550: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3551: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3552: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3553: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3554:
3555: CURSOR l_source_k_num_crs IS
3556: SELECT contract_number

Line 8176: FROM OKC_STATUSES_B sts,okc_k_headers_v CHR

8172: ;
8173:
8174: CURSOR l_sts_code_csr IS
8175: SELECT CHR.sts_code
8176: FROM OKC_STATUSES_B sts,okc_k_headers_v CHR
8177: WHERE STS.CODE = CHR.STS_CODE
8178: AND CHR.id = p_durv_rec.chr_id;
8179:
8180: