DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKL_K_PARTY_ROLES_PVT

Line 134: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

130: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PASSTHRU_PARTY';
131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
132:
133: --Bug# 4558486
134: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;
135: BEGIN
136: x_return_status := l_return_status;
137: -- Call start_activity to create savepoint, check compatibility
138: -- and initialize message list

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

178: l_ppydv_tbl.DELETE;
179: END IF;
180:
181: IF (l_cplv_rec.id IS NOT NULL) THEN
182: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
183: -- to delete records in tables
184: -- okc_k_party_roles_b and okl_k_party_roles
185: /*
186: okl_okc_migration_pvt.delete_k_party_role(

Line 196: okl_k_party_roles_pvt.delete_k_party_role(

192: p_cplv_rec => l_cplv_rec);
193: */
194:
195: l_kplv_rec.id := l_cplv_rec.id;
196: okl_k_party_roles_pvt.delete_k_party_role(
197: p_api_version => p_api_version,
198: p_init_msg_list => p_init_msg_list,
199: x_return_status => x_return_status,
200: x_msg_count => x_msg_count,

Line 2193: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

2189: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_top_line';
2190: l_api_version CONSTANT NUMBER := 1.0;
2191:
2192: --Bug# 4558486
2193: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2194: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2195:
2196: BEGIN
2197:

Line 2194: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

2190: l_api_version CONSTANT NUMBER := 1.0;
2191:
2192: --Bug# 4558486
2193: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2194: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2195:
2196: BEGIN
2197:
2198: l_chr_id := l_clev_rec.dnz_chr_id;

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

2256: l_cplv_rec.cle_id := x_clev_rec.id;
2257:
2258: If ( l_cplv_rec.object1_id1 is not null and l_cplv_rec.object1_id2 is not null) Then
2259:
2260: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2261: -- to create records in tables
2262: -- okc_k_party_roles_b and okl_k_party_roles
2263: /*
2264: okl_okc_migration_pvt.create_k_party_role(

Line 2274: okl_k_party_roles_pvt.create_k_party_role(

2270: p_cplv_rec => l_cplv_rec,
2271: x_cplv_rec => x_cplv_rec);
2272: */
2273:
2274: okl_k_party_roles_pvt.create_k_party_role(
2275: p_api_version => p_api_version,
2276: p_init_msg_list => p_init_msg_list,
2277: x_return_status => x_return_status,
2278: x_msg_count => x_msg_count,

Line 2512: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

2508: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_top_line';
2509: l_api_version CONSTANT NUMBER := 1.0;
2510:
2511: --Bug# 4558486
2512: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2513: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2514:
2515: --Bug# 4721428
2516: CURSOR fee_subline_csr (p_cle_id IN NUMBER,

Line 2513: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

2509: l_api_version CONSTANT NUMBER := 1.0;
2510:
2511: --Bug# 4558486
2512: l_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2513: x_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
2514:
2515: --Bug# 4721428
2516: CURSOR fee_subline_csr (p_cle_id IN NUMBER,
2517: p_chr_id IN NUMBER) IS

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

2627:
2628:
2629: If ( (l_cplv_rec.id is null or l_cplv_rec.id = OKC_API.G_MISS_NUM ) and ( l_cplv_rec.object1_id1 is not null )) Then
2630:
2631: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2632: -- to create records in tables
2633: -- okc_k_party_roles_b and okl_k_party_roles
2634: /*
2635: okl_okc_migration_pvt.create_k_party_role(

Line 2644: okl_k_party_roles_pvt.create_k_party_role(

2640: x_msg_data => x_msg_data,
2641: p_cplv_rec => l_cplv_rec,
2642: x_cplv_rec => x_cplv_rec);
2643: */
2644: okl_k_party_roles_pvt.create_k_party_role(
2645: p_api_version => p_api_version,
2646: p_init_msg_list => p_init_msg_list,
2647: x_return_status => x_return_status,
2648: x_msg_count => x_msg_count,

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

2660: End If;
2661:
2662: ElsIf ( l_cplv_rec.id is not null and l_cplv_rec.object1_id1 is not null ) Then
2663:
2664: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2665: -- to update records in tables
2666: -- okc_k_party_roles_b and okl_k_party_roles
2667: /*
2668: okl_okc_migration_pvt.update_k_party_role(

Line 2679: okl_k_party_roles_pvt.update_k_party_role(

2675: x_cplv_rec => x_cplv_rec);
2676: */
2677:
2678: l_kplv_rec.id := l_cplv_rec.id;
2679: okl_k_party_roles_pvt.update_k_party_role(
2680: p_api_version => p_api_version,
2681: p_init_msg_list => p_init_msg_list,
2682: x_return_status => x_return_status,
2683: x_msg_count => x_msg_count,

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

2695: End If;
2696:
2697: Elsif ( l_cplv_rec.id is not null and l_cplv_rec.object1_id1 is null ) Then
2698:
2699: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2700: -- to delete records in tables
2701: -- okc_k_party_roles_b and okl_k_party_roles
2702: /*
2703: okl_okc_migration_pvt.delete_k_party_role(

Line 2713: okl_k_party_roles_pvt.delete_k_party_role(

2709: p_cplv_rec => l_cplv_rec);
2710: */
2711:
2712: l_kplv_rec.id := l_cplv_rec.id;
2713: okl_k_party_roles_pvt.delete_k_party_role(
2714: p_api_version => p_api_version,
2715: p_init_msg_list => p_init_msg_list,
2716: x_return_status => x_return_status,
2717: x_msg_count => x_msg_count,

Line 5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

5800: l_api_version CONSTANT NUMBER := 1.0;
5801:
5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5803: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5806:
5807: Begin
5808: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

5801:
5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5803: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5806:
5807: Begin
5808: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5809: -- Call start_activity to create savepoint, check compatibility

Line 5852: okl_k_party_roles_pvt.create_k_party_role(

5848: NOT (p_kpl_rec.rle_code = 'LESSEE' OR p_kpl_rec.rle_code = 'LESSOR')) THEN
5849: lp_kplv_rec.validate_dff_yn := 'Y';
5850: END IF;
5851:
5852: okl_k_party_roles_pvt.create_k_party_role(
5853: p_api_version => p_api_version,
5854: p_init_msg_list => p_init_msg_list,
5855: x_return_status => x_return_status,
5856: x_msg_count => x_msg_count,

Line 5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

5913: l_api_version CONSTANT NUMBER := 1.0;
5914:
5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5919:
5920: Begin
5921: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;

5914:
5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5916: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5919:
5920: Begin
5921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5922: -- Call start_activity to create savepoint, check compatibility

Line 5960: okl_k_party_roles_pvt.update_k_party_role(

5956: lp_kplv_rec.attribute14 := p_kpl_rec.attribute14;
5957: lp_kplv_rec.attribute15 := p_kpl_rec.attribute15;
5958: lp_kplv_rec.validate_dff_yn := 'Y';
5959:
5960: okl_k_party_roles_pvt.update_k_party_role(
5961: p_api_version => p_api_version,
5962: p_init_msg_list => p_init_msg_list,
5963: x_return_status => x_return_status,
5964: x_msg_count => x_msg_count,