APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1297: OKC_K_PARTY_ROLES_B cplb,

1293: p_asset_cle_id in number) is
1294: select 'Y'
1295: from RA_SALESREP_TERRITORIES rst,
1296: OKC_CONTACTS cro,
1297: OKC_K_PARTY_ROLES_B cplb,
1298: OKC_K_LINES_B cleb,
1299: okl_subsidy_criteria suc
1300: Where
1301: rst.salesrep_id = cro.object1_id1

Line 3849: from okc_k_party_roles_b cplb

3845: cursor l_cplb_csr (p_subsidy_cle_id in number,
3846: p_cpl_id in number
3847: ) is
3848: select 'Y'
3849: from okc_k_party_roles_b cplb
3850: where cplb.id = p_cpl_id
3851: and cplb.cle_id = p_subsidy_cle_id
3852: and cplb.rle_code = 'OKL_VENDOR';
3853:

Line 3860: from okc_k_party_roles_b cplb

3856: --required only for lease.not for quote
3857: cursor l_vendor_csr (p_chr_id in number,
3858: p_vendor_id in number) is
3859: select 'Y'
3860: from okc_k_party_roles_b cplb
3861: where cplb.chr_id = p_chr_id
3862: and cplb.dnz_chr_id = p_chr_id
3863: and cplb.rle_code = 'OKL_VENDOR'
3864: and cplb.object1_id1 = to_char(p_vendor_id)

Line 4049: from okc_k_party_roles_b cplb

4045: cursor l_cplb_csr (p_subsidy_cle_id in number,
4046: p_cpl_id in number
4047: ) is
4048: select 'Y'
4049: from okc_k_party_roles_b cplb
4050: where cplb.id = p_cpl_id
4051: and cplb.cle_id = p_subsidy_cle_id
4052: and cplb.rle_code = 'OKL_VENDOR';
4053:

Line 4706: -- okc_k_party_roles_b and okl_k_party_roles

4702: l_cplv_rec.cle_id := lx_clev_rec.id;
4703:
4704: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4705: -- to create records in tables
4706: -- okc_k_party_roles_b and okl_k_party_roles
4707: /*
4708: okl_okc_migration_pvt.create_k_party_role(
4709: p_api_version => p_api_version,
4710: p_init_msg_list => p_init_msg_list,

Line 5255: -- okc_k_party_roles_b and okl_k_party_roles

5251: l_cplv_rec.id := OKL_API.G_MISS_NUM;
5252:
5253: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5254: -- to create records in tables
5255: -- okc_k_party_roles_b and okl_k_party_roles
5256:
5257: /*
5258: okl_okc_migration_pvt.create_k_party_role(
5259: p_api_version => p_api_version,

Line 5289: -- okc_k_party_roles_b and okl_k_party_roles

5285: Elsif l_cplv_rec.id is not null then
5286: --update
5287: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5288: -- to update records in tables
5289: -- okc_k_party_roles_b and okl_k_party_roles
5290: /*
5291: okl_okc_migration_pvt.update_k_party_role(
5292: p_api_version => p_api_version,
5293: p_init_msg_list => p_init_msg_list,

Line 5654: -- okc_k_party_roles_b and okl_k_party_roles

5650: l_cplv_rec.id := l_db_asb_rec.cpl_id;
5651:
5652: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5653: -- to delete records in tables
5654: -- okc_k_party_roles_b and okl_k_party_roles
5655: /*
5656: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
5657: p_api_version => p_api_version,
5658: p_init_msg_list => p_init_msg_list,