APPS.OKL_PARTY_PAYMENTS_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 25: FROM okc_k_party_roles_b cpl

21: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
22:
23: CURSOR chr_party_role_csr (p_chr_id IN NUMBER, p_vendor_id IN NUMBER) IS
24: SELECT '1'
25: FROM okc_k_party_roles_b cpl
26: WHERE cpl.chr_id = p_chr_id
27: AND cpl.rle_code='OKL_VENDOR'
28: AND cpl.object1_id1 = p_vendor_id;
29:

Line 57: -- okc_k_party_roles_b and okl_k_party_roles

53: l_cplv_rec.rle_code := 'OKL_VENDOR';
54:
55: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
56: -- to create records in tables
57: -- okc_k_party_roles_b and okl_k_party_roles
58: /*
59: Okl_Okc_Migration_Pvt.create_k_party_role(
60: p_api_version => 1.0,
61: p_init_msg_list => Okl_Api.G_FALSE,

Line 137: FROM okc_k_party_roles_b cpl

133: lx_cle_tbl evg_cle_tbl_type;
134:
135: CURSOR chr_party_role_csr (p_chr_id IN NUMBER, p_vendor_id IN NUMBER) IS
136: SELECT '1'
137: FROM okc_k_party_roles_b cpl
138: WHERE cpl.chr_id = p_chr_id
139: AND cpl.rle_code='OKL_VENDOR'
140: AND cpl.object1_id1 = p_vendor_id;
141:

Line 164: FROM okc_k_party_roles_b

160: l_line_tbl line_tbl_type;
161:
162: CURSOR cle_party_role_csr (p_chr_id IN NUMBER, p_cle_id IN NUMBER,p_vendor_id IN NUMBER) IS
163: SELECT id
164: FROM okc_k_party_roles_b
165: WHERE dnz_chr_id = p_chr_id
166: AND cle_id = p_cle_id
167: AND rle_code='OKL_VENDOR'
168: AND object1_id1 = p_vendor_id;

Line 195: -- okc_k_party_roles_b and okl_k_party_roles

191: l_cplv_rec.rle_code := 'OKL_VENDOR';
192:
193: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
194: -- to create records in tables
195: -- okc_k_party_roles_b and okl_k_party_roles
196: /*
197: Okl_Okc_Migration_Pvt.create_k_party_role(
198: p_api_version => 1.0,
199: p_init_msg_list => Okl_Api.G_FALSE,

Line 251: -- okc_k_party_roles_b and okl_k_party_roles

247: l_cplv_rec.rle_code := 'OKL_VENDOR';
248:
249: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
250: -- to create records in tables
251: -- okc_k_party_roles_b and okl_k_party_roles
252: /*
253: Okl_Okc_Migration_Pvt.create_k_party_role(
254: p_api_version => 1.0,
255: p_init_msg_list => Okl_Api.G_FALSE,

Line 1695: FROM okc_k_party_roles_b cplb

1691: --cursor to find if vendor id is proper party --
1692: CURSOR l_cplb_csr(p_vendor_id IN NUMBER,
1693: p_cpl_id IN NUMBER) IS
1694: SELECT 'Y'
1695: FROM okc_k_party_roles_b cplb
1696: WHERE id = p_cpl_id
1697: AND object1_id1 = TO_CHAR(p_vendor_id);
1698:
1699: l_exists VARCHAR2(1) DEFAULT 'N';