eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 200: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,

196: --------------------------------------------------------------------------------
197: PROCEDURE Fill_up_defaults(x_return_status OUT NOCOPY VARCHAR2,
198: p_asb_rec IN asb_rec_type,
199: p_db_asb_rec IN asb_rec_type,
200: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,
201: x_klev_rec OUT NOCOPY OKL_CONTRACT_PUB.klev_rec_type,
202: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is
203:
204: l_asb_rec asb_rec_type;

Line 202: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is

198: p_asb_rec IN asb_rec_type,
199: p_db_asb_rec IN asb_rec_type,
200: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,
201: x_klev_rec OUT NOCOPY OKL_CONTRACT_PUB.klev_rec_type,
202: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is
203:
204: l_asb_rec asb_rec_type;
205: l_db_asb_rec asb_rec_type;
206:

Line 244: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

240: where vendor_name = ltrim(rtrim(p_vend_name,' '),' ');
241:
242: l_vendor_id number;
243:
244: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
245: l_klev_rec okl_contract_pub.klev_rec_type;
246: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
247:
248: l_temp_sub_id Number;

Line 246: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

242: l_vendor_id number;
243:
244: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
245: l_klev_rec okl_contract_pub.klev_rec_type;
246: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
247:
248: l_temp_sub_id Number;
249:
250: --cursor to get subsidy id from subsidy name

Line 412: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,

408: -- creation of asset subsidy line
409: --------------------------------------------------------------------------------
410: PROCEDURE Initialize_records(x_return_status OUT NOCOPY VARCHAR2,
411: p_asb_rec IN asb_rec_type,
412: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,
413: x_klev_rec OUT NOCOPY OKL_CONTRACT_PUB.klev_rec_type,
414: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is
415:
416: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

Line 414: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is

410: PROCEDURE Initialize_records(x_return_status OUT NOCOPY VARCHAR2,
411: p_asb_rec IN asb_rec_type,
412: x_clev_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.clev_rec_type,
413: x_klev_rec OUT NOCOPY OKL_CONTRACT_PUB.klev_rec_type,
414: x_cplv_rec OUT NOCOPY OKL_OKC_MIGRATION_PVT.cplv_rec_type) is
415:
416: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
417: l_api_name CONSTANT varchar2(30) := 'INITIALIZE_RECORDS';
418: l_api_version CONSTANT NUMBER := 1.0;

Line 421: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

417: l_api_name CONSTANT varchar2(30) := 'INITIALIZE_RECORDS';
418: l_api_version CONSTANT NUMBER := 1.0;
419:
420: l_asb_rec asb_rec_type;
421: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
422: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
423: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
424:
425: --cursor to get effectivity dates and stream type

Line 423: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

419:
420: l_asb_rec asb_rec_type;
421: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
422: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
423: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
424:
425: --cursor to get effectivity dates and stream type
426: cursor l_sub_csr (p_sub_id in number) is
427: select subb.stream_type_id,

Line 701: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

697:
698: l_sub_oec number;
699: l_sub_cap_amount number;
700:
701: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
702: l_klev_rec okl_contract_pub.klev_rec_type;
703: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
704: lx_klev_rec okl_contract_pub.klev_rec_type;
705:

Line 703: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

699: l_sub_cap_amount number;
700:
701: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
702: l_klev_rec okl_contract_pub.klev_rec_type;
703: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
704: lx_klev_rec okl_contract_pub.klev_rec_type;
705:
706: --cursor to fetch asset number for exception
707: cursor l_clet_csr (p_cle_id in number) is

Line 901: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

897: l_asb_rec asb_rec_type;
898: l_subsidy_amount number;
899:
900:
901: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
902: l_sub_klev_rec okl_contract_pub.klev_rec_type;
903: lx_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
904: lx_sub_klev_rec okl_contract_pub.klev_rec_type;
905:

Line 903: lx_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;

899:
900:
901: l_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
902: l_sub_klev_rec okl_contract_pub.klev_rec_type;
903: lx_sub_clev_rec okl_okc_migration_pvt.clev_rec_type;
904: lx_sub_klev_rec okl_contract_pub.klev_rec_type;
905:
906: lv_subsidy_amount NUMBER;
907:

Line 4520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

4516:
4517: l_asb_rec asb_rec_type;
4518: lx_calc_asb_rec asb_rec_type;
4519:
4520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4521: l_klev_rec okl_contract_pub.klev_rec_type;
4522: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4523:
4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4522: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4518: lx_calc_asb_rec asb_rec_type;
4519:
4520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4521: l_klev_rec okl_contract_pub.klev_rec_type;
4522: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4523:
4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4525: lx_klev_rec okl_contract_pub.klev_rec_type;
4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

4520: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4521: l_klev_rec okl_contract_pub.klev_rec_type;
4522: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4523:
4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4525: lx_klev_rec okl_contract_pub.klev_rec_type;
4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4527:
4528: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4522: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4523:
4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4525: lx_klev_rec okl_contract_pub.klev_rec_type;
4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4527:
4528: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4529: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4530: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4528: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

4524: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4525: lx_klev_rec okl_contract_pub.klev_rec_type;
4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4527:
4528: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4529: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4530: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4531:
4532: --cursor to get vendor name

Line 4530: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4526: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4527:
4528: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4529: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4530: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4531:
4532: --cursor to get vendor name
4533: cursor l_vendor_csr(p_vendor_id in number) is
4534: select pov.vendor_name

Line 4687: okl_okc_migration_pvt.create_k_party_role(

4683: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
4684: -- to create records in tables
4685: -- okc_k_party_roles_b and okl_k_party_roles
4686: /*
4687: okl_okc_migration_pvt.create_k_party_role(
4688: p_api_version => p_api_version,
4689: p_init_msg_list => p_init_msg_list,
4690: x_return_status => x_return_status,
4691: x_msg_count => x_msg_count,

Line 4962: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

4958: l_db_asb_rec asb_rec_type;
4959: lx_calc_asb_rec asb_rec_type;
4960:
4961:
4962: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4963: l_klev_rec okl_contract_pub.klev_rec_type;
4964: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4965:
4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4964: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4960:
4961:
4962: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4963: l_klev_rec okl_contract_pub.klev_rec_type;
4964: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4965:
4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4967: lx_klev_rec okl_contract_pub.klev_rec_type;
4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

4962: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4963: l_klev_rec okl_contract_pub.klev_rec_type;
4964: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4965:
4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4967: lx_klev_rec okl_contract_pub.klev_rec_type;
4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4969:
4970: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4964: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4965:
4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4967: lx_klev_rec okl_contract_pub.klev_rec_type;
4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4969:
4970: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4971: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4972: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4970: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

4966: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4967: lx_klev_rec okl_contract_pub.klev_rec_type;
4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4969:
4970: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4971: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4972: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4973:
4974: l_row_notfound BOOLEAN := TRUE;

Line 4972: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4968: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4969:
4970: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4971: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4972: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4973:
4974: l_row_notfound BOOLEAN := TRUE;
4975:
4976: --cursor to get vendor name

Line 5237: okl_okc_migration_pvt.create_k_party_role(

5233: -- to create records in tables
5234: -- okc_k_party_roles_b and okl_k_party_roles
5235:
5236: /*
5237: okl_okc_migration_pvt.create_k_party_role(
5238: p_api_version => p_api_version,
5239: p_init_msg_list => p_init_msg_list,
5240: x_return_status => x_return_status,
5241: x_msg_count => x_msg_count,

Line 5270: okl_okc_migration_pvt.update_k_party_role(

5266: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5267: -- to update records in tables
5268: -- okc_k_party_roles_b and okl_k_party_roles
5269: /*
5270: okl_okc_migration_pvt.update_k_party_role(
5271: p_api_version => p_api_version,
5272: p_init_msg_list => p_init_msg_list,
5273: x_return_status => x_return_status,
5274: x_msg_count => x_msg_count,

Line 5506: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

5502: l_asb_rec asb_rec_type;
5503: l_db_asb_rec asb_rec_type;
5504: l_row_notfound BOOLEAN := TRUE;
5505:
5506: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5507: l_klev_rec okl_contract_pub.klev_rec_type;
5508: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
5509:
5510: --cursor to fetch party refund details record

Line 5508: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

5504: l_row_notfound BOOLEAN := TRUE;
5505:
5506: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5507: l_klev_rec okl_contract_pub.klev_rec_type;
5508: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
5509:
5510: --cursor to fetch party refund details record
5511: cursor l_ppyd_csr (p_cpl_id in number) is
5512: select ppyd.id

Line 5635: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

5631: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
5632: -- to delete records in tables
5633: -- okc_k_party_roles_b and okl_k_party_roles
5634: /*
5635: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
5636: p_api_version => p_api_version,
5637: p_init_msg_list => p_init_msg_list,
5638: x_return_status => x_return_status,
5639: x_msg_count => x_msg_count,