APPS.OKL_CONTRACT_PVT dependencies on OKL_K_PARTY_ROLES

Line 4526: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;

4522: FROM OKC_K_PARTY_ROLES_V
4523: WHERE dnz_chr_id = p_id;
4524:
4525: --Bug# 4558486
4526: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;
4527: Begin
4528:
4529: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4530:

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

4531: FOR rec IN l_cplv_csr(p_chr_id)
4532: LOOP
4533: l_cplv_tbl_in(1).ID := rec.id;
4534:
4535: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4536: -- to delete records in tables
4537: -- okc_k_party_roles_b and okl_k_party_roles
4538:
4539: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;

Line 4537: -- okc_k_party_roles_b and okl_k_party_roles

4533: l_cplv_tbl_in(1).ID := rec.id;
4534:
4535: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4536: -- to delete records in tables
4537: -- okc_k_party_roles_b and okl_k_party_roles
4538:
4539: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4540: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4541: p_api_version => p_api_version,

Line 4540: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (

4536: -- to delete records in tables
4537: -- okc_k_party_roles_b and okl_k_party_roles
4538:
4539: l_kplv_tbl_in(1).ID := l_cplv_tbl_in(1).ID;
4540: OKL_K_PARTY_ROLES_PVT.DELETE_K_PARTY_ROLE (
4541: p_api_version => p_api_version,
4542: p_init_msg_list => p_init_msg_list,
4543: x_return_status => x_return_status,
4544: x_msg_count => x_msg_count,

Line 7488: FROM okl_k_party_roles kpl,

7484: --Bug# 4558486
7485: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
7486: p_khr_id IN NUMBER) is
7487: SELECT kpl.id
7488: FROM okl_k_party_roles kpl,
7489: okc_k_party_roles_b cpl
7490: WHERE kpl.id = cpl.id
7491: AND cpl.cle_id = p_kle_id
7492: AND cpl.dnz_chr_id = p_khr_id;

Line 7764: -- Delete records from okl_k_party_roles

7760: End If;
7761: -- Passthru Bug 4350255
7762:
7763: --Bug# 4558486
7764: -- Delete records from okl_k_party_roles
7765: i := 0;
7766: For l_kpl_rec in l_kpl_csr(p_kle_id => l_clev_rec.id,
7767: p_khr_id => l_dnz_chr_id)
7768: Loop

Line 8348: FROM okl_k_party_roles kpl,

8344: --Bug# 4558486
8345: CURSOR l_kpl_csr(p_kle_id IN NUMBER,
8346: p_khr_id IN NUMBER) is
8347: SELECT kpl.id
8348: FROM okl_k_party_roles kpl,
8349: okc_k_party_roles_b cpl
8350: WHERE kpl.id = cpl.id
8351: AND cpl.cle_id = p_kle_id
8352: AND cpl.dnz_chr_id = p_khr_id;

Line 8732: -- Delete records from okl_k_party_roles

8728: End If;
8729: -- Passthru Bug 4350255
8730:
8731: --Bug# 4558486
8732: -- Delete records from okl_k_party_roles
8733: i := 0;
8734: For l_klev_count in l_klev_tbl_in.FIRST..l_klev_tbl_in.LAST
8735: Loop
8736: For l_kpl_rec in l_kpl_csr(p_kle_id => l_klev_tbl_in(l_klev_count).ID,