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_RULE_PUB

Line 1089: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

1085:
1086: larles_rec larles_csr%ROWTYPE;
1087: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1088: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1089: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1090: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1091:
1092: BEGIN
1093: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1090: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

1086: larles_rec larles_csr%ROWTYPE;
1087: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1088: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1089: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1090: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1091:
1092: BEGIN
1093: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1094: -- Call start_activity to create savepoint, check compatibility

Line 1173: OKL_RULE_PUB.create_rule_group(

1169: lp_larles_rgpv_rec.dnz_chr_id := x_new_chrv_rec.id;
1170: lp_larles_rgpv_rec.chr_id := x_new_chrv_rec.id;
1171: lp_larles_rgpv_rec.rgp_type := 'KRG';
1172:
1173: OKL_RULE_PUB.create_rule_group(
1174: p_api_version => p_api_version,
1175: p_init_msg_list => p_init_msg_list,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,

Line 1196: OKL_RULE_PUB.create_rule(

1192: lp_larles_rulv_rec.rule_information1 := 'Y';
1193: lp_larles_rulv_rec.WARN_YN := 'N';
1194: lp_larles_rulv_rec.STD_TEMPLATE_YN := 'N';
1195:
1196: OKL_RULE_PUB.create_rule(
1197: p_api_version => p_api_version,
1198: p_init_msg_list => p_init_msg_list,
1199: x_return_status => x_return_status,
1200: x_msg_count => x_msg_count,

Line 1222: OKL_RULE_PUB.update_rule(

1218: lp_larles_rulv_rec.rule_information1 := 'Y';
1219: lp_larles_rulv_rec.WARN_YN := 'N';
1220: lp_larles_rulv_rec.STD_TEMPLATE_YN := 'N';
1221:
1222: OKL_RULE_PUB.update_rule(
1223: p_api_version => p_api_version,
1224: p_init_msg_list => p_init_msg_list,
1225: x_return_status => x_return_status,
1226: x_msg_count => x_msg_count,

Line 3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

3622: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh
3623: WHERE slh.rgp_id = rgp.id
3624: AND slh.rule_information_category = 'LASLH');
3625:
3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3629:
3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

Line 3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

3623: WHERE slh.rgp_id = rgp.id
3624: AND slh.rule_information_category = 'LASLH');
3625:
3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3629:
3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3631: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;

Line 3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

3624: AND slh.rule_information_category = 'LASLH');
3625:
3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3629:
3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3631: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3632:

Line 3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3629:
3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3631: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3632:
3633: l_no_of_periods NUMBER;
3634: l_periods_to_skip NUMBER;

Line 3631: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;

3627: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3628: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3629:
3630: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3631: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3632:
3633: l_no_of_periods NUMBER;
3634: l_periods_to_skip NUMBER;
3635: l_new_start_date DATE;

Line 3666: okl_rule_pub.delete_rule(

3662:
3663: -- Delete SLL where End Date is earlier than Re-lease date
3664: if (contract_payment_rec.end_date < p_release_date) then
3665: l_rulv_rec.id := contract_payment_rec.sll_id; -- SLL Rule ID
3666: okl_rule_pub.delete_rule(
3667: p_api_version => p_api_version,
3668: p_init_msg_list => p_init_msg_list,
3669: x_return_status => x_return_status,
3670: x_msg_count => x_msg_count,

Line 3707: OKL_RULE_PUB.update_rule(

3703: l_rulv_rec.rule_information6 := NULL;
3704: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3705: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3706:
3707: OKL_RULE_PUB.update_rule(
3708: p_api_version => p_api_version,
3709: p_init_msg_list => p_init_msg_list,
3710: x_return_status => x_return_status,
3711: x_msg_count => x_msg_count,

Line 3737: OKL_RULE_PUB.delete_rule(

3733:
3734: if (l_new_start_date > contract_payment_rec.end_date) then
3735:
3736: -- No periodic payment, only stub payment needed
3737: OKL_RULE_PUB.delete_rule(
3738: p_api_version => p_api_version,
3739: p_init_msg_list => p_init_msg_list,
3740: x_return_status => x_return_status,
3741: x_msg_count => x_msg_count,

Line 3758: OKL_RULE_PUB.update_rule(

3754:
3755: l_no_of_periods := MONTHS_BETWEEN((contract_payment_rec.end_date + 1),l_new_start_date)/contract_payment_rec.factor;
3756: l_rulv_rec.rule_information3 := TO_CHAR(l_no_of_periods);
3757:
3758: OKL_RULE_PUB.update_rule(
3759: p_api_version => p_api_version,
3760: p_init_msg_list => p_init_msg_list,
3761: x_return_status => x_return_status,
3762: x_msg_count => x_msg_count,

Line 3810: OKL_RULE_PUB.create_rule(

3806: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3807: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3808: l_rulv_rec.rule_information10 := contract_payment_rec.arrears_yn;
3809:
3810: OKL_RULE_PUB.create_rule(
3811: p_api_version => p_api_version,
3812: p_init_msg_list => p_init_msg_list,
3813: x_return_status => x_return_status,
3814: x_msg_count => x_msg_count,

Line 3834: okl_rule_pub.delete_rule(

3830: for slh_rec in slh_csr(p_chr_id => p_chr_id) loop
3831: l_rulv_rec := l_rulv_temp_rec;
3832:
3833: l_rulv_rec.id := slh_rec.slh_id; -- SLH Rule ID
3834: okl_rule_pub.delete_rule(
3835: p_api_version => p_api_version,
3836: p_init_msg_list => p_init_msg_list,
3837: x_return_status => x_return_status,
3838: x_msg_count => x_msg_count,

Line 3853: okl_rule_pub.delete_rule_group(

3849: for rgp_rec in rgp_csr(p_chr_id => p_chr_id) loop
3850: l_rgpv_rec := l_rgpv_temp_rec;
3851:
3852: l_rgpv_rec.id := rgp_rec.rgp_id; -- Rule Group ID
3853: okl_rule_pub.delete_rule_group(
3854: p_api_version => p_api_version,
3855: p_init_msg_list => p_init_msg_list,
3856: x_return_status => x_return_status,
3857: x_msg_count => x_msg_count,

Line 4195: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

4191: pymt_details_rec pymt_details_csr%ROWTYPE;
4192:
4193: l_pymt_amount NUMBER;
4194:
4195: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4196: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4197:
4198: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4199:

Line 4196: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

4192:
4193: l_pymt_amount NUMBER;
4194:
4195: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4196: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4197:
4198: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4199:
4200: l_periods_bef_release NUMBER;

Line 4198: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

4194:
4195: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4196: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4197:
4198: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4199:
4200: l_periods_bef_release NUMBER;
4201: l_orig_no_of_periods NUMBER;
4202: l_new_no_of_periods NUMBER;

Line 4228: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

4224: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4225: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4226: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4227: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4228: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4229:
4230: l_subline_present VARCHAR2(1);
4231: l_sub_cap_amt NUMBER;
4232: i NUMBER;

Line 5006: OKL_RULE_PUB.update_rule(

5002: l_rulv_rec.id := fee_expense_rec.rul_lafexp_id;
5003: l_rulv_rec.rule_information1 := TO_CHAR(l_new_no_of_periods);
5004:
5005: -- Set Expense periods equal to New No. of periods
5006: OKL_RULE_PUB.update_rule(
5007: p_api_version => p_api_version,
5008: p_init_msg_list => p_init_msg_list,
5009: x_return_status => x_return_status,
5010: x_msg_count => x_msg_count,

Line 5219: OKL_RULE_PUB.update_rule(

5215: l_rulv_rec.rule_information2 := TO_CHAR(lp_klev_rec.amount);
5216:
5217: -- Set Expense periods equal to 1 and
5218: -- Amount equal to Closing principal balance
5219: OKL_RULE_PUB.update_rule(
5220: p_api_version => p_api_version,
5221: p_init_msg_list => p_init_msg_list,
5222: x_return_status => x_return_status,
5223: x_msg_count => x_msg_count,

Line 5259: OKL_RULE_PUB.delete_rule_group(

5255:
5256: if (contract_fee_rec.fee_type <> 'FINANCED') then
5257: -- Delete Expense Rules as No. of periods is <= 0
5258: l_rgpv_rec.id := fee_expense_rec.rgp_id; -- LAFEXP Rule Group ID
5259: OKL_RULE_PUB.delete_rule_group(
5260: p_api_version => p_api_version,
5261: p_init_msg_list => p_init_msg_list,
5262: x_return_status => x_return_status,
5263: x_msg_count => x_msg_count,

Line 5441: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5437: AND rgp.rgd_code = 'LALEVL';
5438:
5439: l_pymt_exists VARCHAR2(30);
5440:
5441: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5442: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5443:
5444: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5445:

Line 5442: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5438:
5439: l_pymt_exists VARCHAR2(30);
5440:
5441: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5442: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5443:
5444: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5445:
5446: l_periods_bef_release NUMBER;

Line 5444: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

5440:
5441: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5442: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5443:
5444: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5445:
5446: l_periods_bef_release NUMBER;
5447: l_orig_no_of_periods NUMBER;
5448: l_new_no_of_periods NUMBER;

Line 5470: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

5466: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5469: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5470: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5471: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5472:
5473: l_subline_present VARCHAR2(1);
5474: l_sub_cap_amt NUMBER;

Line 5471: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;

5467: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5468: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5469: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5470: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5471: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5472:
5473: l_subline_present VARCHAR2(1);
5474: l_sub_cap_amt NUMBER;
5475: l_capital_amount NUMBER;

Line 5596: OKL_RULE_PUB.update_rule(

5592: l_rulv_rec.rule_information2 := TO_CHAR(l_per_period_amount);
5593:
5594: -- Set Per period Amount equal to Rounded value of
5595: -- (Sum of Covered Asset Capital Amounts / No. of periods)
5596: OKL_RULE_PUB.update_rule(
5597: p_api_version => p_api_version,
5598: p_init_msg_list => p_init_msg_list,
5599: x_return_status => x_return_status,
5600: x_msg_count => x_msg_count,

Line 5723: OKL_RULE_PUB.update_rule(

5719:
5720: -- Set Expense periods equal to New No. of periods and
5721: -- per period Amount equal to Rounded value of
5722: -- (Sum of Covered Asset Capital Amounts / New No. of periods)
5723: OKL_RULE_PUB.update_rule(
5724: p_api_version => p_api_version,
5725: p_init_msg_list => p_init_msg_list,
5726: x_return_status => x_return_status,
5727: x_msg_count => x_msg_count,

Line 5745: OKL_RULE_PUB.delete_rule_group(

5741: l_new_service_amount := l_sub_cap_amt;
5742:
5743: -- Delete Expense Rules as No. of periods is <= 0
5744: l_rgpv_rec.id := service_expense_rec.rgp_id; -- LAFEXP Rule Group ID
5745: OKL_RULE_PUB.delete_rule_group(
5746: p_api_version => p_api_version,
5747: p_init_msg_list => p_init_msg_list,
5748: x_return_status => x_return_status,
5749: x_msg_count => x_msg_count,

Line 5865: OKL_RULE_PUB.update_rule(

5861: l_rulv_rec.id := service_expense_rec.rul_lafexp_id;
5862: l_rulv_rec.rule_information1 := TO_CHAR(l_new_no_of_periods);
5863:
5864: -- Set Expense periods equal to New No. of periods
5865: OKL_RULE_PUB.update_rule(
5866: p_api_version => p_api_version,
5867: p_init_msg_list => p_init_msg_list,
5868: x_return_status => x_return_status,
5869: x_msg_count => x_msg_count,

Line 5939: OKL_RULE_PUB.delete_rule_group(

5935: END IF;
5936:
5937: -- Delete Expense Rules as No. of periods is <= 0
5938: l_rgpv_rec.id := service_expense_rec.rgp_id; -- LAFEXP Rule Group ID
5939: OKL_RULE_PUB.delete_rule_group(
5940: p_api_version => p_api_version,
5941: p_init_msg_list => p_init_msg_list,
5942: x_return_status => x_return_status,
5943: x_msg_count => x_msg_count,

Line 6092: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

6088: WHERE id = p_chr_id;
6089:
6090: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6091:
6092: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6093: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6094:
6095: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6096:

Line 6093: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

6089:
6090: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6091:
6092: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6093: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6094:
6095: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6096:
6097: l_amount NUMBER;

Line 6095: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

6091:
6092: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6093: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6094:
6095: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6096:
6097: l_amount NUMBER;
6098:
6099: BEGIN

Line 6160: OKL_RULE_PUB.update_rule(

6156: else
6157: l_rulv_rec.rule_information8 := TO_CHAR(l_amount);
6158: end if;
6159:
6160: OKL_RULE_PUB.update_rule(
6161: p_api_version => p_api_version,
6162: p_init_msg_list => p_init_msg_list,
6163: x_return_status => x_return_status,
6164: x_msg_count => x_msg_count,

Line 7216: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;

7212: and rgp.chr_id = p_chr_id
7213: and rul.dnz_chr_id = p_chr_id;
7214:
7215: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7216: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7217: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7218: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7219:
7220: CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS

Line 7217: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;

7213: and rul.dnz_chr_id = p_chr_id;
7214:
7215: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7216: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7217: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7218: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7219:
7220: CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS
7221: SELECT name

Line 7218: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;

7214:
7215: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7216: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7217: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7218: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7219:
7220: CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS
7221: SELECT name
7222: FROM okl_invoice_formats_v

Line 7454: OKL_RULE_PUB.update_rule(

7450: lp_rulv_rec.jtot_object1_code := 'OKX_CUSTBKAC';
7451: lp_rulv_rec.warn_yn := 'N';
7452: lp_rulv_rec.std_template_yn := 'N';
7453:
7454: OKL_RULE_PUB.update_rule(
7455: p_api_version => p_api_version,
7456: p_init_msg_list => p_init_msg_list,
7457: x_return_status => x_return_status,
7458: x_msg_count => x_msg_count,

Line 7494: OKL_RULE_PUB.update_rule(

7490: lp_rulv_rec.jtot_object1_code := 'OKX_RCPTMTH';
7491: lp_rulv_rec.warn_yn := 'N';
7492: lp_rulv_rec.std_template_yn := 'N';
7493:
7494: OKL_RULE_PUB.update_rule(
7495: p_api_version => p_api_version,
7496: p_init_msg_list => p_init_msg_list,
7497: x_return_status => x_return_status,
7498: x_msg_count => x_msg_count,

Line 7538: OKL_RULE_PUB.update_rule(

7534: lp_rulv_rec.rule_information1 := invoice_format_rec.name;
7535: lp_rulv_rec.warn_yn := 'N';
7536: lp_rulv_rec.std_template_yn := 'N';
7537:
7538: OKL_RULE_PUB.update_rule(
7539: p_api_version => p_api_version,
7540: p_init_msg_list => p_init_msg_list,
7541: x_return_status => x_return_status,
7542: x_msg_count => x_msg_count,