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 4541: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

4537:
4538: l_asb_rec asb_rec_type;
4539: lx_calc_asb_rec asb_rec_type;
4540:
4541: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4542: l_klev_rec okl_contract_pub.klev_rec_type;
4543: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4544:
4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4543: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4539: lx_calc_asb_rec asb_rec_type;
4540:
4541: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4542: l_klev_rec okl_contract_pub.klev_rec_type;
4543: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4544:
4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4546: lx_klev_rec okl_contract_pub.klev_rec_type;
4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

4541: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4542: l_klev_rec okl_contract_pub.klev_rec_type;
4543: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4544:
4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4546: lx_klev_rec okl_contract_pub.klev_rec_type;
4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4548:
4549: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4543: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4544:
4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4546: lx_klev_rec okl_contract_pub.klev_rec_type;
4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4548:
4549: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4550: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4551: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4549: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

4545: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4546: lx_klev_rec okl_contract_pub.klev_rec_type;
4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4548:
4549: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4550: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4551: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4552:
4553: --cursor to get vendor name

Line 4551: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4547: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4548:
4549: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4550: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4551: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4552:
4553: --cursor to get vendor name
4554: cursor l_vendor_csr(p_vendor_id in number) is
4555: select pov.vendor_name

Line 4708: okl_okc_migration_pvt.create_k_party_role(

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,
4711: x_return_status => x_return_status,
4712: x_msg_count => x_msg_count,

Line 4983: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

4979: l_db_asb_rec asb_rec_type;
4980: lx_calc_asb_rec asb_rec_type;
4981:
4982:
4983: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4984: l_klev_rec okl_contract_pub.klev_rec_type;
4985: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4986:
4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4985: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4981:
4982:
4983: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4984: l_klev_rec okl_contract_pub.klev_rec_type;
4985: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4986:
4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4988: lx_klev_rec okl_contract_pub.klev_rec_type;
4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

4983: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4984: l_klev_rec okl_contract_pub.klev_rec_type;
4985: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4986:
4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4988: lx_klev_rec okl_contract_pub.klev_rec_type;
4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4990:
4991: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4985: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4986:
4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4988: lx_klev_rec okl_contract_pub.klev_rec_type;
4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4990:
4991: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4992: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4993: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

Line 4991: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;

4987: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4988: lx_klev_rec okl_contract_pub.klev_rec_type;
4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4990:
4991: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4992: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4993: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4994:
4995: l_row_notfound BOOLEAN := TRUE;

Line 4993: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

4989: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4990:
4991: lx_def_clev_rec okl_okc_migration_pvt.clev_rec_type;
4992: lx_def_klev_rec okl_contract_pub.klev_rec_type;
4993: lx_def_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
4994:
4995: l_row_notfound BOOLEAN := TRUE;
4996:
4997: --cursor to get vendor name

Line 5258: okl_okc_migration_pvt.create_k_party_role(

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,
5260: p_init_msg_list => p_init_msg_list,
5261: x_return_status => x_return_status,
5262: x_msg_count => x_msg_count,

Line 5291: okl_okc_migration_pvt.update_k_party_role(

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,
5294: x_return_status => x_return_status,
5295: x_msg_count => x_msg_count,

Line 5527: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

5523: l_asb_rec asb_rec_type;
5524: l_db_asb_rec asb_rec_type;
5525: l_row_notfound BOOLEAN := TRUE;
5526:
5527: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5528: l_klev_rec okl_contract_pub.klev_rec_type;
5529: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
5530:
5531: --cursor to fetch party refund details record

Line 5529: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;

5525: l_row_notfound BOOLEAN := TRUE;
5526:
5527: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5528: l_klev_rec okl_contract_pub.klev_rec_type;
5529: l_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
5530:
5531: --cursor to fetch party refund details record
5532: cursor l_ppyd_csr (p_cpl_id in number) is
5533: select ppyd.id

Line 5656: OKL_OKC_MIGRATION_PVT.delete_k_party_role(

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,
5659: x_return_status => x_return_status,
5660: x_msg_count => x_msg_count,