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 1103: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

1099:
1100: larles_rec larles_csr%ROWTYPE;
1101: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1102: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1103: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1104: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1105:
1106: BEGIN
1107: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1104: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;

1100: larles_rec larles_csr%ROWTYPE;
1101: lp_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1102: lx_larles_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
1103: lp_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1104: lx_larles_rulv_rec Okl_Rule_Pub.rulv_rec_type;
1105:
1106: BEGIN
1107: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1108: -- Call start_activity to create savepoint, check compatibility

Line 1194: OKL_RULE_PUB.create_rule_group(

1190: lp_larles_rgpv_rec.dnz_chr_id := x_new_chrv_rec.id;
1191: lp_larles_rgpv_rec.chr_id := x_new_chrv_rec.id;
1192: lp_larles_rgpv_rec.rgp_type := 'KRG';
1193:
1194: OKL_RULE_PUB.create_rule_group(
1195: p_api_version => p_api_version,
1196: p_init_msg_list => p_init_msg_list,
1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,

Line 1217: OKL_RULE_PUB.create_rule(

1213: lp_larles_rulv_rec.rule_information1 := 'Y';
1214: lp_larles_rulv_rec.WARN_YN := 'N';
1215: lp_larles_rulv_rec.STD_TEMPLATE_YN := 'N';
1216:
1217: OKL_RULE_PUB.create_rule(
1218: p_api_version => p_api_version,
1219: p_init_msg_list => p_init_msg_list,
1220: x_return_status => x_return_status,
1221: x_msg_count => x_msg_count,

Line 1243: OKL_RULE_PUB.update_rule(

1239: lp_larles_rulv_rec.rule_information1 := 'Y';
1240: lp_larles_rulv_rec.WARN_YN := 'N';
1241: lp_larles_rulv_rec.STD_TEMPLATE_YN := 'N';
1242:
1243: OKL_RULE_PUB.update_rule(
1244: p_api_version => p_api_version,
1245: p_init_msg_list => p_init_msg_list,
1246: x_return_status => x_return_status,
1247: x_msg_count => x_msg_count,

Line 3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

3680: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh
3681: WHERE slh.rgp_id = rgp.id
3682: AND slh.rule_information_category = 'LASLH');
3683:
3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3687:
3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

Line 3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

3681: WHERE slh.rgp_id = rgp.id
3682: AND slh.rule_information_category = 'LASLH');
3683:
3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3687:
3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3689: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;

Line 3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

3682: AND slh.rule_information_category = 'LASLH');
3683:
3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3687:
3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3689: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3690:

Line 3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

3684: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3687:
3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3689: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3690:
3691: l_no_of_periods NUMBER;
3692: l_periods_to_skip NUMBER;

Line 3689: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;

3685: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
3686: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
3687:
3688: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
3689: l_rgpv_temp_rec OKL_RULE_PUB.rgpv_rec_type;
3690:
3691: l_no_of_periods NUMBER;
3692: l_periods_to_skip NUMBER;
3693: l_new_start_date DATE;

Line 3726: okl_rule_pub.delete_rule(

3722: -- Delete SLL where End Date is earlier than Re-lease date
3723: if ((contract_payment_rec.end_date < p_release_date)
3724: OR (contract_payment_rec.stream_type_purpose = 'DOWN_PAYMENT')) then
3725: l_rulv_rec.id := contract_payment_rec.sll_id; -- SLL Rule ID
3726: okl_rule_pub.delete_rule(
3727: p_api_version => p_api_version,
3728: p_init_msg_list => p_init_msg_list,
3729: x_return_status => x_return_status,
3730: x_msg_count => x_msg_count,

Line 3767: OKL_RULE_PUB.update_rule(

3763: l_rulv_rec.rule_information6 := NULL;
3764: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3765: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3766:
3767: OKL_RULE_PUB.update_rule(
3768: p_api_version => p_api_version,
3769: p_init_msg_list => p_init_msg_list,
3770: x_return_status => x_return_status,
3771: x_msg_count => x_msg_count,

Line 3797: OKL_RULE_PUB.delete_rule(

3793:
3794: if (l_new_start_date > contract_payment_rec.end_date) then
3795:
3796: -- No periodic payment, only stub payment needed
3797: OKL_RULE_PUB.delete_rule(
3798: p_api_version => p_api_version,
3799: p_init_msg_list => p_init_msg_list,
3800: x_return_status => x_return_status,
3801: x_msg_count => x_msg_count,

Line 3818: OKL_RULE_PUB.update_rule(

3814:
3815: l_no_of_periods := MONTHS_BETWEEN((contract_payment_rec.end_date + 1),l_new_start_date)/contract_payment_rec.factor;
3816: l_rulv_rec.rule_information3 := TO_CHAR(l_no_of_periods);
3817:
3818: OKL_RULE_PUB.update_rule(
3819: p_api_version => p_api_version,
3820: p_init_msg_list => p_init_msg_list,
3821: x_return_status => x_return_status,
3822: x_msg_count => x_msg_count,

Line 3870: OKL_RULE_PUB.create_rule(

3866: l_rulv_rec.rule_information7 := TO_CHAR(l_stub_days);
3867: l_rulv_rec.rule_information8 := TO_CHAR(l_stub_amount);
3868: l_rulv_rec.rule_information10 := contract_payment_rec.arrears_yn;
3869:
3870: OKL_RULE_PUB.create_rule(
3871: p_api_version => p_api_version,
3872: p_init_msg_list => p_init_msg_list,
3873: x_return_status => x_return_status,
3874: x_msg_count => x_msg_count,

Line 3894: okl_rule_pub.delete_rule(

3890: for slh_rec in slh_csr(p_chr_id => p_chr_id) loop
3891: l_rulv_rec := l_rulv_temp_rec;
3892:
3893: l_rulv_rec.id := slh_rec.slh_id; -- SLH Rule ID
3894: okl_rule_pub.delete_rule(
3895: p_api_version => p_api_version,
3896: p_init_msg_list => p_init_msg_list,
3897: x_return_status => x_return_status,
3898: x_msg_count => x_msg_count,

Line 3913: okl_rule_pub.delete_rule_group(

3909: for rgp_rec in rgp_csr(p_chr_id => p_chr_id) loop
3910: l_rgpv_rec := l_rgpv_temp_rec;
3911:
3912: l_rgpv_rec.id := rgp_rec.rgp_id; -- Rule Group ID
3913: okl_rule_pub.delete_rule_group(
3914: p_api_version => p_api_version,
3915: p_init_msg_list => p_init_msg_list,
3916: x_return_status => x_return_status,
3917: x_msg_count => x_msg_count,

Line 4255: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

4251: pymt_details_rec pymt_details_csr%ROWTYPE;
4252:
4253: l_pymt_amount NUMBER;
4254:
4255: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4256: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4257:
4258: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4259:

Line 4256: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

4252:
4253: l_pymt_amount NUMBER;
4254:
4255: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4256: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4257:
4258: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4259:
4260: l_periods_bef_release NUMBER;

Line 4258: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

4254:
4255: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4256: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
4257:
4258: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
4259:
4260: l_periods_bef_release NUMBER;
4261: l_orig_no_of_periods NUMBER;
4262: l_new_no_of_periods NUMBER;

Line 4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

4284: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
4285: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
4286: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
4287: lp_cimv_temp_rec okl_okc_migration_pvt.cimv_rec_type;
4288: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
4289:
4290: l_subline_present VARCHAR2(1);
4291: l_sub_cap_amt NUMBER;
4292: i NUMBER;

Line 5071: OKL_RULE_PUB.update_rule(

5067: l_rulv_rec.id := fee_expense_rec.rul_lafexp_id;
5068: l_rulv_rec.rule_information1 := TO_CHAR(l_new_no_of_periods);
5069:
5070: -- Set Expense periods equal to New No. of periods
5071: OKL_RULE_PUB.update_rule(
5072: p_api_version => p_api_version,
5073: p_init_msg_list => p_init_msg_list,
5074: x_return_status => x_return_status,
5075: x_msg_count => x_msg_count,

Line 5272: OKL_RULE_PUB.update_rule(

5268: l_rulv_rec.rule_information2 := TO_CHAR(lp_klev_rec.amount);
5269:
5270: -- Set Expense periods equal to 1 and
5271: -- Amount equal to Closing principal balance
5272: OKL_RULE_PUB.update_rule(
5273: p_api_version => p_api_version,
5274: p_init_msg_list => p_init_msg_list,
5275: x_return_status => x_return_status,
5276: x_msg_count => x_msg_count,

Line 5528: OKL_RULE_PUB.update_rule(

5524: --Bug# 9927005
5525:
5526: -- Set Expense periods equal to 1 and
5527: -- Amount equal to Closing principal balance
5528: OKL_RULE_PUB.update_rule(
5529: p_api_version => p_api_version,
5530: p_init_msg_list => p_init_msg_list,
5531: x_return_status => x_return_status,
5532: x_msg_count => x_msg_count,

Line 5568: OKL_RULE_PUB.delete_rule_group(

5564:
5565: if (contract_fee_rec.fee_type <> 'FINANCED') then
5566: -- Delete Expense Rules as No. of periods is <= 0
5567: l_rgpv_rec.id := fee_expense_rec.rgp_id; -- LAFEXP Rule Group ID
5568: OKL_RULE_PUB.delete_rule_group(
5569: p_api_version => p_api_version,
5570: p_init_msg_list => p_init_msg_list,
5571: x_return_status => x_return_status,
5572: x_msg_count => x_msg_count,

Line 5750: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5746: AND rgp.rgd_code = 'LALEVL';
5747:
5748: l_pymt_exists VARCHAR2(30);
5749:
5750: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5751: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5752:
5753: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5754:

Line 5751: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

5747:
5748: l_pymt_exists VARCHAR2(30);
5749:
5750: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5751: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5752:
5753: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5754:
5755: l_periods_bef_release NUMBER;

Line 5753: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

5749:
5750: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5751: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
5752:
5753: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
5754:
5755: l_periods_bef_release NUMBER;
5756: l_orig_no_of_periods NUMBER;
5757: l_new_no_of_periods NUMBER;

Line 5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;

5775: lp_clev_temp_tbl okl_okc_migration_pvt.clev_tbl_type;
5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5781:
5782: l_subline_present VARCHAR2(1);
5783: l_sub_cap_amt NUMBER;

Line 5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;

5776: lp_clev_temp_rec okl_okc_migration_pvt.clev_rec_type;
5777: lp_klev_temp_tbl okl_kle_pvt.klev_tbl_type;
5778: lp_klev_temp_rec okl_kle_pvt.klev_rec_type;
5779: l_rulv_temp_rec okl_rule_pub.rulv_rec_type;
5780: l_rgpv_temp_rec okl_rule_pub.rgpv_rec_type;
5781:
5782: l_subline_present VARCHAR2(1);
5783: l_sub_cap_amt NUMBER;
5784: l_capital_amount NUMBER;

Line 5905: OKL_RULE_PUB.update_rule(

5901: l_rulv_rec.rule_information2 := TO_CHAR(l_per_period_amount);
5902:
5903: -- Set Per period Amount equal to Rounded value of
5904: -- (Sum of Covered Asset Capital Amounts / No. of periods)
5905: OKL_RULE_PUB.update_rule(
5906: p_api_version => p_api_version,
5907: p_init_msg_list => p_init_msg_list,
5908: x_return_status => x_return_status,
5909: x_msg_count => x_msg_count,

Line 6032: OKL_RULE_PUB.update_rule(

6028:
6029: -- Set Expense periods equal to New No. of periods and
6030: -- per period Amount equal to Rounded value of
6031: -- (Sum of Covered Asset Capital Amounts / New No. of periods)
6032: OKL_RULE_PUB.update_rule(
6033: p_api_version => p_api_version,
6034: p_init_msg_list => p_init_msg_list,
6035: x_return_status => x_return_status,
6036: x_msg_count => x_msg_count,

Line 6054: OKL_RULE_PUB.delete_rule_group(

6050: l_new_service_amount := l_sub_cap_amt;
6051:
6052: -- Delete Expense Rules as No. of periods is <= 0
6053: l_rgpv_rec.id := service_expense_rec.rgp_id; -- LAFEXP Rule Group ID
6054: OKL_RULE_PUB.delete_rule_group(
6055: p_api_version => p_api_version,
6056: p_init_msg_list => p_init_msg_list,
6057: x_return_status => x_return_status,
6058: x_msg_count => x_msg_count,

Line 6174: OKL_RULE_PUB.update_rule(

6170: l_rulv_rec.id := service_expense_rec.rul_lafexp_id;
6171: l_rulv_rec.rule_information1 := TO_CHAR(l_new_no_of_periods);
6172:
6173: -- Set Expense periods equal to New No. of periods
6174: OKL_RULE_PUB.update_rule(
6175: p_api_version => p_api_version,
6176: p_init_msg_list => p_init_msg_list,
6177: x_return_status => x_return_status,
6178: x_msg_count => x_msg_count,

Line 6248: OKL_RULE_PUB.delete_rule_group(

6244: END IF;
6245:
6246: -- Delete Expense Rules as No. of periods is <= 0
6247: l_rgpv_rec.id := service_expense_rec.rgp_id; -- LAFEXP Rule Group ID
6248: OKL_RULE_PUB.delete_rule_group(
6249: p_api_version => p_api_version,
6250: p_init_msg_list => p_init_msg_list,
6251: x_return_status => x_return_status,
6252: x_msg_count => x_msg_count,

Line 6401: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

6397: WHERE id = p_chr_id;
6398:
6399: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6400:
6401: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6402: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6403:
6404: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6405:

Line 6402: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

6398:
6399: l_currency_code OKC_K_LINES_B.CURRENCY_CODE%TYPE;
6400:
6401: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6402: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6403:
6404: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6405:
6406: l_amount NUMBER;

Line 6404: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;

6400:
6401: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6402: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
6403:
6404: l_rulv_temp_rec OKL_RULE_PUB.rulv_rec_type;
6405:
6406: l_amount NUMBER;
6407:
6408: BEGIN

Line 6469: OKL_RULE_PUB.update_rule(

6465: else
6466: l_rulv_rec.rule_information8 := TO_CHAR(l_amount);
6467: end if;
6468:
6469: OKL_RULE_PUB.update_rule(
6470: p_api_version => p_api_version,
6471: p_init_msg_list => p_init_msg_list,
6472: x_return_status => x_return_status,
6473: x_msg_count => x_msg_count,

Line 7534: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;

7530: and rgp.chr_id = p_chr_id
7531: and rul.dnz_chr_id = p_chr_id;
7532:
7533: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7534: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7535: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7536: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7537:
7538: --sechawla 26-may-09 6826580

Line 7535: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;

7531: and rul.dnz_chr_id = p_chr_id;
7532:
7533: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7534: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7535: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7536: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7537:
7538: --sechawla 26-may-09 6826580
7539: /* CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS

Line 7536: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;

7532:
7533: hdr_rules_rec hdr_rules_csr%ROWTYPE;
7534: lp_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7535: lx_rulv_rec Okl_Rule_Pub.rulv_rec_type;
7536: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7537:
7538: --sechawla 26-may-09 6826580
7539: /* CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS
7540: SELECT name

Line 7774: OKL_RULE_PUB.update_rule(

7770: lp_rulv_rec.jtot_object1_code := 'OKX_CUSTBKAC';
7771: lp_rulv_rec.warn_yn := 'N';
7772: lp_rulv_rec.std_template_yn := 'N';
7773:
7774: OKL_RULE_PUB.update_rule(
7775: p_api_version => p_api_version,
7776: p_init_msg_list => p_init_msg_list,
7777: x_return_status => x_return_status,
7778: x_msg_count => x_msg_count,

Line 7814: OKL_RULE_PUB.update_rule(

7810: lp_rulv_rec.jtot_object1_code := 'OKX_RCPTMTH';
7811: lp_rulv_rec.warn_yn := 'N';
7812: lp_rulv_rec.std_template_yn := 'N';
7813:
7814: OKL_RULE_PUB.update_rule(
7815: p_api_version => p_api_version,
7816: p_init_msg_list => p_init_msg_list,
7817: x_return_status => x_return_status,
7818: x_msg_count => x_msg_count,

Line 7862: OKL_RULE_PUB.update_rule(

7858:
7859: lp_rulv_rec.warn_yn := 'N';
7860: lp_rulv_rec.std_template_yn := 'N';
7861:
7862: OKL_RULE_PUB.update_rule(
7863: p_api_version => p_api_version,
7864: p_init_msg_list => p_init_msg_list,
7865: x_return_status => x_return_status,
7866: x_msg_count => x_msg_count,