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_RELEASE_PVT dependencies on OKL_CONTRACT_PUB

Line 58: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;

54: INDEX BY BINARY_INTEGER;
55: TYPE g_asset_num_tbl IS TABLE OF OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE
56: INDEX BY BINARY_INTEGER;
57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;
58: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
59: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
60: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
61: -------------------------------------------------------------------------------------------------
62: ------------------------------------------------------------------------------

Line 304: OKL_CONTRACT_PUB.delete_contract_line(

300:
301: --Remove all the usage lines without any assets associated with it.
302: FOR non_linked_usage_rec In non_linked_usage_csr(p_chr_id) LOOP
303:
304: OKL_CONTRACT_PUB.delete_contract_line(
305: p_api_version =>p_api_version,
306: p_init_msg_list => p_init_msg_list,
307: x_return_status => x_return_status,
308: x_msg_count => x_msg_count,

Line 332: OKL_CONTRACT_PUB.update_contract_line(

328: lp_clev_rec.id := usage_rec.usage_line_id;
329: lp_clev_rec.start_date := p_release_date;
330: lp_klev_rec.id := usage_rec.usage_line_id;
331:
332: OKL_CONTRACT_PUB.update_contract_line(
333: p_api_version => p_api_version,
334: p_init_msg_list => p_init_msg_list,
335: x_return_status => x_return_status,
336: x_msg_count => x_msg_count,

Line 358: OKL_CONTRACT_PUB.update_contract_line(

354: lp_clev_rec.id := link_asset_rec.id;
355: lp_clev_rec.start_date := p_release_date;
356: lp_klev_rec.id := link_asset_rec.id;
357:
358: OKL_CONTRACT_PUB.update_contract_line(
359: p_api_version => p_api_version,
360: p_init_msg_list => p_init_msg_list,
361: x_return_status => x_return_status,
362: x_msg_count => x_msg_count,

Line 2504: l_finast_klev_rec okl_contract_pub.klev_rec_type;

2500: l_model_clev_rec okc_contract_pub.clev_rec_type;
2501: lx_model_clev_rec okc_contract_pub.clev_rec_type;
2502: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2503: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2504: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2505: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2506: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2507: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2508: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;

Line 2505: lx_finast_klev_rec okl_contract_pub.klev_rec_type;

2501: lx_model_clev_rec okc_contract_pub.clev_rec_type;
2502: l_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2503: lx_finast_clev_rec okl_okc_migration_pvt.clev_rec_type;
2504: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2505: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2506: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2507: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2508: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2509: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;

Line 2508: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;

2504: l_finast_klev_rec okl_contract_pub.klev_rec_type;
2505: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2506: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2507: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2508: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2509: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2510:
2511: --cursor to fetch new contract currency
2512: cursor l_new_chr_hdr_csr (p_chr_id in number) is

Line 2509: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;

2505: lx_finast_klev_rec okl_contract_pub.klev_rec_type;
2506: l_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2507: lx_finast_clev_rec2 okl_okc_migration_pvt.clev_rec_type;
2508: l_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2509: lx_finast_klev_rec2 okl_contract_pub.klev_rec_type;
2510:
2511: --cursor to fetch new contract currency
2512: cursor l_new_chr_hdr_csr (p_chr_id in number) is
2513: select currency_code

Line 3003: OKL_CONTRACT_PUB.update_contract_line

2999: l_finast_clev_rec.id := l_exp_cost_rec.new_cle_id;
3000: l_finast_klev_rec.id := l_exp_cost_rec.new_cle_id;
3001: l_finast_klev_rec.oec := l_expected_cost;
3002:
3003: OKL_CONTRACT_PUB.update_contract_line
3004: (p_api_version => p_api_version,
3005: p_init_msg_list => p_init_msg_list,
3006: x_return_status => x_return_status,
3007: x_msg_count => x_msg_count,

Line 3058: OKL_CONTRACT_PUB.update_contract_line

3054: l_finast_klev_rec2.capital_amount := (l_capital_amount - l_capitalized_interest);
3055: l_finast_klev_rec2.id := l_exp_cost_rec.new_cle_id;
3056: l_finast_clev_rec2.id := l_exp_cost_rec.new_cle_id;
3057:
3058: OKL_CONTRACT_PUB.update_contract_line
3059: (p_api_version => p_api_version,
3060: p_init_msg_list => p_init_msg_list,
3061: x_return_status => x_return_status,
3062: x_msg_count => x_msg_count,

Line 4354: OKL_CONTRACT_PUB.delete_contract_line(

4350: if (contract_fee_rec.end_date < p_release_date) or
4351: (contract_fee_rec.ste_code IN ('TERMINATED', 'EXPIRED', 'CANCELLED')) or
4352: (orig_cle_sts_rec.ste_code IN ('TERMINATED', 'EXPIRED', 'CANCELLED')) then
4353:
4354: OKL_CONTRACT_PUB.delete_contract_line(
4355: p_api_version => p_api_version,
4356: p_init_msg_list => p_init_msg_list,
4357: x_return_status => x_return_status,
4358: x_msg_count => x_msg_count,

Line 4394: OKL_CONTRACT_PUB.delete_contract_line(

4390: -- No Covered assets associated with Fee
4391: if (l_subline_present = 'N') then
4392:
4393: -- Delete Capitalized Fee line if no Covered Assets are present
4394: OKL_CONTRACT_PUB.delete_contract_line(
4395: p_api_version => p_api_version,
4396: p_init_msg_list => p_init_msg_list,
4397: x_return_status => x_return_status,
4398: x_msg_count => x_msg_count,

Line 4422: OKL_CONTRACT_PUB.update_contract_line(

4418: lp_klev_rec.id := contract_fee_rec.id;
4419: lp_klev_rec.amount :=l_sub_cap_amt;
4420: lp_klev_rec.capital_amount := l_sub_cap_amt;
4421:
4422: OKL_CONTRACT_PUB.update_contract_line(
4423: p_api_version => p_api_version,
4424: p_init_msg_list => p_init_msg_list,
4425: x_return_status => x_return_status,
4426: x_msg_count => x_msg_count,

Line 4468: OKL_CONTRACT_PUB.update_contract_line(

4464:
4465: lp_klev_rec.id := contract_fee_rec.id;
4466: lp_klev_rec.amount :=l_rlvr_sub_total;
4467:
4468: OKL_CONTRACT_PUB.update_contract_line(
4469: p_api_version => p_api_version,
4470: p_init_msg_list => p_init_msg_list,
4471: x_return_status => x_return_status,
4472: x_msg_count => x_msg_count,

Line 4526: OKL_CONTRACT_PUB.delete_contract_line(

4522: -- No Covered assets associated with Fee
4523: if (l_subline_present = 'N') then
4524:
4525: -- Delete Capitalized Fee line if no Covered Assets are present
4526: OKL_CONTRACT_PUB.delete_contract_line(
4527: p_api_version => p_api_version,
4528: p_init_msg_list => p_init_msg_list,
4529: x_return_status => x_return_status,
4530: x_msg_count => x_msg_count,

Line 4558: OKL_CONTRACT_PUB.update_contract_line(

4554: end if;
4555:
4556: -- Set Fee Top Line Start Date equal to Release Date
4557: -- and Amount equal to sum of capital_amounts
4558: OKL_CONTRACT_PUB.update_contract_line(
4559: p_api_version => p_api_version,
4560: p_init_msg_list => p_init_msg_list,
4561: x_return_status => x_return_status,
4562: x_msg_count => x_msg_count,

Line 4577: OKL_CONTRACT_PUB.update_contract_line(

4573: RAISE OKL_API.G_EXCEPTION_ERROR;
4574: END IF;
4575:
4576: -- Set Covered Asset line Start Dates equal to Release Date
4577: OKL_CONTRACT_PUB.update_contract_line(
4578: p_api_version => p_api_version,
4579: p_init_msg_list => p_init_msg_list,
4580: x_return_status => x_return_status,
4581: x_msg_count => x_msg_count,

Line 4615: OKL_CONTRACT_PUB.delete_contract_line(

4611:
4612: if (l_fee_type <> 'ROLLOVER') then
4613:
4614: -- Delete Fee line if no Payments or Expenses are present
4615: OKL_CONTRACT_PUB.delete_contract_line(
4616: p_api_version => p_api_version,
4617: p_init_msg_list => p_init_msg_list,
4618: x_return_status => x_return_status,
4619: x_msg_count => x_msg_count,

Line 4685: OKL_CONTRACT_PUB.update_contract_line(

4681:
4682: if (l_subline_present = 'Y') then
4683: -- Set Covered Asset line Start Dates equal to Release Date
4684: -- and Amount proportionate to the new fee amount
4685: OKL_CONTRACT_PUB.update_contract_line(
4686: p_api_version => p_api_version,
4687: p_init_msg_list => p_init_msg_list,
4688: x_return_status => x_return_status,
4689: x_msg_count => x_msg_count,

Line 4712: OKL_CONTRACT_PUB.update_contract_line(

4708:
4709: -- Set Fee Top Line Start Date equal to Release Date
4710: -- Retain Fee Amount equal to the amount from original contract
4711: -- Set IDC to Null, as no Expenses present
4712: OKL_CONTRACT_PUB.update_contract_line(
4713: p_api_version => p_api_version,
4714: p_init_msg_list => p_init_msg_list,
4715: x_return_status => x_return_status,
4716: x_msg_count => x_msg_count,

Line 4733: OKL_CONTRACT_PUB.delete_contract_line(

4729:
4730: else --sublines not found
4731:
4732: -- Delete Fee line if no Payments or Expenses are present
4733: OKL_CONTRACT_PUB.delete_contract_line(
4734: p_api_version => p_api_version,
4735: p_init_msg_list => p_init_msg_list,
4736: x_return_status => x_return_status,
4737: x_msg_count => x_msg_count,

Line 4881: OKL_CONTRACT_PUB.update_contract_line(

4877:
4878: if (l_subline_present = 'Y') then
4879: -- Set Covered Asset line Start Dates equal to Release Date
4880: -- and Amount proportionate to the new fee amount
4881: OKL_CONTRACT_PUB.update_contract_line(
4882: p_api_version => p_api_version,
4883: p_init_msg_list => p_init_msg_list,
4884: x_return_status => x_return_status,
4885: x_msg_count => x_msg_count,

Line 4911: OKL_CONTRACT_PUB.update_contract_line(

4907:
4908: -- Set Fee Top Line Start Date equal to Release Date
4909: -- Retain Fee Amount equal to the amount from original contract
4910: -- Set IDC to Null, as no Expenses present
4911: OKL_CONTRACT_PUB.update_contract_line(
4912: p_api_version => p_api_version,
4913: p_init_msg_list => p_init_msg_list,
4914: x_return_status => x_return_status,
4915: x_msg_count => x_msg_count,

Line 5045: OKL_CONTRACT_PUB.update_contract_line(

5041: end if; -- Miscellaneous Fee
5042:
5043: -- Set Fee Top Line Start Date equal to Release Date
5044: -- and Amount equal to Expense per period Amount * New No. of periods
5045: OKL_CONTRACT_PUB.update_contract_line(
5046: p_api_version => p_api_version,
5047: p_init_msg_list => p_init_msg_list,
5048: x_return_status => x_return_status,
5049: x_msg_count => x_msg_count,

Line 5076: OKL_CONTRACT_PUB.delete_contract_line(

5072: if ( l_pymt_exists = 'N') then
5073:
5074: -- Delete Fee line if Expenses are complete
5075: -- and no Payments present
5076: OKL_CONTRACT_PUB.delete_contract_line(
5077: p_api_version => p_api_version,
5078: p_init_msg_list => p_init_msg_list,
5079: x_return_status => x_return_status,
5080: x_msg_count => x_msg_count,

Line 5238: OKL_CONTRACT_PUB.update_contract_line(

5234: end if; -- Fee Type - Miscellaneous / Financed
5235:
5236: -- Set Fee Top Line Start Date equal to Release Date
5237: -- Retain Amount equal to the amount from original contract
5238: OKL_CONTRACT_PUB.update_contract_line(
5239: p_api_version => p_api_version,
5240: p_init_msg_list => p_init_msg_list,
5241: x_return_status => x_return_status,
5242: x_msg_count => x_msg_count,

Line 5536: OKL_CONTRACT_PUB.delete_contract_line(

5532: if (contract_service_rec.end_date < p_release_date) or
5533: (contract_service_rec.ste_code IN ('TERMINATED','EXPIRED','CANCELLED')) or
5534: (orig_cle_sts_rec.ste_code IN ('TERMINATED', 'EXPIRED', 'CANCELLED')) then
5535:
5536: OKL_CONTRACT_PUB.delete_contract_line(
5537: p_api_version => p_api_version,
5538: p_init_msg_list => p_init_msg_list,
5539: x_return_status => x_return_status,
5540: x_msg_count => x_msg_count,

Line 5623: OKL_CONTRACT_PUB.update_contract_line(

5619: lp_klev_rec.id := contract_service_rec.id;
5620: lp_klev_rec.amount := l_new_service_amount;
5621:
5622: -- Set Service Top Line Amount equal to sum of capital_amounts
5623: OKL_CONTRACT_PUB.update_contract_line(
5624: p_api_version => p_api_version,
5625: p_init_msg_list => p_init_msg_list,
5626: x_return_status => x_return_status,
5627: x_msg_count => x_msg_count,

Line 5776: OKL_CONTRACT_PUB.update_contract_line(

5772: lp_klev_rec.amount := l_new_service_amount;
5773:
5774: -- Set Service Top Line Start Date equal to Release Date
5775: -- and Amount equal to sum of capital_amounts
5776: OKL_CONTRACT_PUB.update_contract_line(
5777: p_api_version => p_api_version,
5778: p_init_msg_list => p_init_msg_list,
5779: x_return_status => x_return_status,
5780: x_msg_count => x_msg_count,

Line 5795: OKL_CONTRACT_PUB.update_contract_line(

5791: RAISE OKL_API.G_EXCEPTION_ERROR;
5792: END IF;
5793:
5794: -- Set Covered Asset line Start Dates equal to Release Date
5795: OKL_CONTRACT_PUB.update_contract_line(
5796: p_api_version => p_api_version,
5797: p_init_msg_list => p_init_msg_list,
5798: x_return_status => x_return_status,
5799: x_msg_count => x_msg_count,

Line 5831: OKL_CONTRACT_PUB.update_contract_line(

5827: lp_klev_rec.id := contract_service_rec.id;
5828:
5829: -- Set Service Top Line Start Date equal to Release Date
5830: -- and retain Amount equal to the Amount from original contract
5831: OKL_CONTRACT_PUB.update_contract_line(
5832: p_api_version => p_api_version,
5833: p_init_msg_list => p_init_msg_list,
5834: x_return_status => x_return_status,
5835: x_msg_count => x_msg_count,

Line 5888: OKL_CONTRACT_PUB.update_contract_line(

5884: lp_klev_rec.amount := l_new_service_amount;
5885:
5886: -- Set Service Top Line Start Date equal to Release Date
5887: -- and Amount equal to Expense per period Amount * New No. of periods
5888: OKL_CONTRACT_PUB.update_contract_line(
5889: p_api_version => p_api_version,
5890: p_init_msg_list => p_init_msg_list,
5891: x_return_status => x_return_status,
5892: x_msg_count => x_msg_count,

Line 5919: OKL_CONTRACT_PUB.update_contract_line(

5915: lp_klev_rec.id := contract_service_rec.id;
5916:
5917: -- Set Service Top Line Start Date equal to Release Date
5918: -- and retin Amount equal to the Amount from original contract
5919: OKL_CONTRACT_PUB.update_contract_line(
5920: p_api_version => p_api_version,
5921: p_init_msg_list => p_init_msg_list,
5922: x_return_status => x_return_status,
5923: x_msg_count => x_msg_count,

Line 6760: OKL_CONTRACT_PUB.delete_contract_line(

6756: if (contract_fin_asset_rec.ste_code IN ('TERMINATED', 'EXPIRED', 'CANCELLED'))
6757: or ( orig_cle_sts_rec.ste_code IN ('TERMINATED', 'EXPIRED', 'CANCELLED')) then
6758:
6759: -- Delete Lines which are not Active
6760: OKL_CONTRACT_PUB.delete_contract_line(
6761: p_api_version => p_api_version,
6762: p_init_msg_list => p_init_msg_list,
6763: x_return_status => x_return_status,
6764: x_msg_count => x_msg_count,

Line 6920: OKL_CONTRACT_PUB.delete_contract_line(

6916: -- Subsidy Line
6917: if lse_rec.lty_code = 'SUBSIDY' then
6918:
6919: -- Delete Subsidy Lines
6920: OKL_CONTRACT_PUB.delete_contract_line(
6921: p_api_version => p_api_version,
6922: p_init_msg_list => p_init_msg_list,
6923: x_return_status => x_return_status,
6924: x_msg_count => x_msg_count,

Line 6977: OKL_CONTRACT_PUB.update_contract_line

6973:
6974: --Bug# 4631549 : Update Expected asset cost (cost of the asset expected after re-lease)
6975: lp_klev_rec.expected_asset_cost := l_expected_cost;
6976:
6977: OKL_CONTRACT_PUB.update_contract_line
6978: (p_api_version => p_api_version,
6979: p_init_msg_list => p_init_msg_list,
6980: x_return_status => x_return_status,
6981: x_msg_count => x_msg_count,

Line 7021: OKL_CONTRACT_PUB.update_contract_line

7017:
7018: lp_cimv_rec.id := modelline_rec.model_cim_id;
7019: lp_cimv_rec.number_of_items := txl_asset_rec.current_units;
7020:
7021: OKL_CONTRACT_PUB.update_contract_line
7022: (p_api_version => p_api_version,
7023: p_init_msg_list => p_init_msg_list,
7024: x_return_status => x_return_status,
7025: x_msg_count => x_msg_count,

Line 7061: OKL_CONTRACT_PUB.update_contract_line(

7057: lp_clev_rec.start_date := p_release_date;
7058: end if;
7059:
7060: -- Set Line Start Date equal to Release Date
7061: OKL_CONTRACT_PUB.update_contract_line(
7062: p_api_version => p_api_version,
7063: p_init_msg_list => p_init_msg_list,
7064: x_return_status => x_return_status,
7065: x_msg_count => x_msg_count,

Line 7747: OKL_CONTRACT_PUB.update_contract_line(

7743: lp_clev_rec.bill_to_site_use_id := taa_lines_rec.source_value_3;
7744:
7745: lp_klev_rec.id := taa_lines_rec.id;
7746:
7747: OKL_CONTRACT_PUB.update_contract_line(
7748: p_api_version => p_api_version,
7749: p_init_msg_list => p_init_msg_list,
7750: x_return_status => x_return_status,
7751: x_msg_count => x_msg_count,

Line 7957: l_fin_klev_rec okl_contract_pub.klev_rec_type;

7953: and cleb.lse_id = 33; --financial asset line id
7954:
7955: l_finast_rec l_finast_csr%ROWTYPE;
7956: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
7957: l_fin_klev_rec okl_contract_pub.klev_rec_type;
7958: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
7959: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
7960: --End Bug# 4631549
7961:

Line 7959: lx_fin_klev_rec okl_contract_pub.klev_rec_type;

7955: l_finast_rec l_finast_csr%ROWTYPE;
7956: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
7957: l_fin_klev_rec okl_contract_pub.klev_rec_type;
7958: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
7959: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
7960: --End Bug# 4631549
7961:
7962: BEGIN
7963: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8142: OKL_CONTRACT_PUB.delete_contract_line(

8138: for taa_lines_rec in taa_lines_csr
8139: (p_new_chr_id => x_new_chrv_rec.id,
8140: p_source_trx_id => p_source_trx_id)
8141: loop
8142: OKL_CONTRACT_PUB.delete_contract_line(
8143: p_api_version => p_api_version,
8144: p_init_msg_list => p_init_msg_list,
8145: x_return_status => x_return_status,
8146: x_msg_count => x_msg_count,

Line 8162: OKL_CONTRACT_PUB.delete_contract_line(

8158: -- Delete Fee and Service lines not having Covered Assets
8159: for taa_fee_serv_rec in taa_fee_serv_csr
8160: (p_new_chr_id => x_new_chrv_rec.id)
8161: loop
8162: OKL_CONTRACT_PUB.delete_contract_line(
8163: p_api_version => p_api_version,
8164: p_init_msg_list => p_init_msg_list,
8165: x_return_status => x_return_status,
8166: x_msg_count => x_msg_count,

Line 8317: OKL_CONTRACT_PUB.update_contract_line

8313:
8314: l_fin_clev_rec.id := l_finast_rec.id;
8315: l_fin_klev_rec.id := l_finast_rec.id;
8316:
8317: OKL_CONTRACT_PUB.update_contract_line
8318: (p_api_version => p_api_version,
8319: p_init_msg_list => p_init_msg_list,
8320: x_return_status => x_return_status,
8321: x_msg_count => x_msg_count,