APPS.OKL_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES

Line 4441: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;

4437: FROM OKC_K_PARTY_ROLES_V
4438: WHERE dnz_chr_id = p_id;
4439:
4440: --Bug# 4558486
4441: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;
4442: Begin
4443:
4444: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4445:

Line 4450: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api

4446: FOR rec IN l_cplv_csr(p_chr_id)
4447: LOOP
4448: l_cplv_tbl_in(1).ID := rec.id;
4449:
4450: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4451: -- to delete records in tables
4452: -- okc_k_party_roles_b and okl_k_party_roles
4453:
4454: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;

Line 4452: -- okc_k_party_roles_b and okl_k_party_roles

4448: l_cplv_tbl_in(1).ID := rec.id;
4449:
4450: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4451: -- to delete records in tables
4452: -- okc_k_party_roles_b and okl_k_party_roles
4453:
4454: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4455: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4456: p_api_version => p_api_version,

Line 4455: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (

4451: -- to delete records in tables
4452: -- okc_k_party_roles_b and okl_k_party_roles
4453:
4454: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4455: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4456: p_api_version => p_api_version,
4457: p_init_msg_list => p_init_msg_list,
4458: x_return_status => x_return_status,
4459: x_msg_count => x_msg_count,

Line 7386: FROM okl_k_party_roles kpl,

7382: --Bug# 4558486
7383: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
7384: p_khr_id IN NUMBER) is
7385: SELECT kpl.id
7386: FROM okl_k_party_roles kpl,
7387: okc_k_party_roles_b cpl
7388: WHERE kpl.id = cpl.id
7389: AND cpl.cle_id = p_kle_id
7390: AND cpl.dnz_chr_id = p_khr_id;

Line 7662: -- Delete records from okl_k_party_roles

7658: End If;
7659: -- Passthru Bug 4350255
7660:
7661: --Bug# 4558486
7662: -- Delete records from okl_k_party_roles
7663: i := 0;
7664: For l_kpl_rec in l_kpl_csr(p_kle_id => l_clev_rec.id,
7665: p_khr_id => l_dnz_chr_id)
7666: Loop

Line 8246: FROM okl_k_party_roles kpl,

8242: --Bug# 4558486
8243: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
8244: p_khr_id IN NUMBER) is
8245: SELECT kpl.id
8246: FROM okl_k_party_roles kpl,
8247: okc_k_party_roles_b cpl
8248: WHERE kpl.id = cpl.id
8249: AND cpl.cle_id = p_kle_id
8250: AND cpl.dnz_chr_id = p_khr_id;

Line 8630: -- Delete records from okl_k_party_roles

8626: End If;
8627: -- Passthru Bug 4350255
8628:
8629: --Bug# 4558486
8630: -- Delete records from okl_k_party_roles
8631: i := 0;
8632: For l_klev_count in l_klev_tbl_in.FIRST..l_klev_tbl_in.LAST
8633: Loop
8634: For l_kpl_rec in l_kpl_csr(p_kle_id => l_klev_tbl_in(l_klev_count).ID,