DBA Data[Home] [Help]

APPS.OKL_K_PARTY_ROLES_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 30: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,

26: p_init_msg_list IN VARCHAR2,
27: x_return_status OUT NOCOPY VARCHAR2,
28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
31: p_kplv_rec IN kplv_rec_type,
32: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
33: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
34:

Line 32: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,

28: x_msg_count OUT NOCOPY NUMBER,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
31: p_kplv_rec IN kplv_rec_type,
32: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
33: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
34:
35: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
36: l_kplv_rec kplv_rec_type;

Line 35: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

31: p_kplv_rec IN kplv_rec_type,
32: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
33: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
34:
35: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
36: l_kplv_rec kplv_rec_type;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_PARTY_ROLE';
38: l_api_version CONSTANT NUMBER := 1.0;
39: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 83: okl_okc_migration_pvt.create_k_party_role(

79:
80: l_kplv_rec := p_kplv_rec;
81: l_cplv_rec := p_cplv_rec;
82:
83: okl_okc_migration_pvt.create_k_party_role(
84: p_api_version => p_api_version,
85: p_init_msg_list => p_init_msg_list,
86: x_return_status => x_return_status,
87: x_msg_count => x_msg_count,

Line 165: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,

161: p_init_msg_list IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,
166: p_kplv_tbl IN kplv_tbl_type,
167: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,
168: x_kplv_tbl OUT NOCOPY kplv_tbl_type) IS
169:

Line 167: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,

163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,
166: p_kplv_tbl IN kplv_tbl_type,
167: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,
168: x_kplv_tbl OUT NOCOPY kplv_tbl_type) IS
169:
170: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_PARTY_ROLE';
171: l_api_version CONSTANT NUMBER := 1.0;

Line 282: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,

278: p_init_msg_list IN VARCHAR2,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
283: p_kplv_rec IN kplv_rec_type,
284: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
285: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
286:

Line 284: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,

280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
283: p_kplv_rec IN kplv_rec_type,
284: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
285: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
286:
287: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
288: l_kplv_rec kplv_rec_type;

Line 287: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

283: p_kplv_rec IN kplv_rec_type,
284: x_cplv_rec OUT NOCOPY okl_okc_migration_pvt.cplv_rec_type,
285: x_kplv_rec OUT NOCOPY kplv_rec_type) IS
286:
287: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
288: l_kplv_rec kplv_rec_type;
289:
290: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_PARTY_ROLE';
291: l_api_version CONSTANT NUMBER := 1.0;

Line 300: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

296: from OKL_K_PARTY_ROLES_V
297: where id = l_id;
298: l_dummy_var VARCHAR2(1) := '?';
299:
300: lx_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
301:
302: --Bug# 4959361
303: CURSOR l_cpl_csr(p_cpl_id IN NUMBER) IS
304: SELECT cle_id

Line 356: okl_okc_migration_pvt.update_k_party_role

352:
353: l_kplv_rec := p_kplv_rec;
354: l_cplv_rec := p_cplv_rec;
355:
356: okl_okc_migration_pvt.update_k_party_role
357: (
358: p_api_version => p_api_version,
359: p_init_msg_list => p_init_msg_list,
360: x_return_status => x_return_status,

Line 465: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,

461: p_init_msg_list IN VARCHAR2,
462: x_return_status OUT NOCOPY VARCHAR2,
463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,
466: p_kplv_tbl IN kplv_tbl_type,
467: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,
468: x_kplv_tbl OUT NOCOPY kplv_tbl_type) IS
469:

Line 467: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,

463: x_msg_count OUT NOCOPY NUMBER,
464: x_msg_data OUT NOCOPY VARCHAR2,
465: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,
466: p_kplv_tbl IN kplv_tbl_type,
467: x_cplv_tbl OUT NOCOPY okl_okc_migration_pvt.cplv_tbl_type,
468: x_kplv_tbl OUT NOCOPY kplv_tbl_type) IS
469:
470: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_PARTY_ROLE';
471: l_api_version CONSTANT NUMBER := 1.0;

Line 576: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,

572: p_init_msg_list IN VARCHAR2,
573: x_return_status OUT NOCOPY VARCHAR2,
574: x_msg_count OUT NOCOPY NUMBER,
575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
577: p_kplv_rec IN kplv_rec_type) IS
578:
579: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
580: l_kplv_rec kplv_rec_type;

Line 579: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

575: x_msg_data OUT NOCOPY VARCHAR2,
576: p_cplv_rec IN okl_okc_migration_pvt.cplv_rec_type,
577: p_kplv_rec IN kplv_rec_type) IS
578:
579: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
580: l_kplv_rec kplv_rec_type;
581:
582: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_PARTY_ROLE';
583: l_api_version CONSTANT NUMBER := 1.0;

Line 643: okl_okc_migration_pvt.delete_k_party_role(

639:
640: --
641: -- call procedure in complex API
642: --
643: okl_okc_migration_pvt.delete_k_party_role(
644: p_api_version => p_api_version,
645: p_init_msg_list => p_init_msg_list,
646: x_return_status => x_return_status,
647: x_msg_count => x_msg_count,

Line 719: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,

715: p_init_msg_list IN VARCHAR2,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,
719: p_cplv_tbl IN okl_okc_migration_pvt.cplv_tbl_type,
720: p_kplv_tbl IN kplv_tbl_type) IS
721:
722: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_PARTY_ROLE';
723: l_api_version CONSTANT NUMBER := 1.0;