DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 373: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

369: IF pry_sty_csr%NOTFOUND THEN
370:
371: -- Bug 4064253
372:
373: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
374: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
375:
376: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
377: p_msg_name => 'OKL_NO_PRY_STY_FOUND',

Line 478: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

474: IF pry_sty_csr%NOTFOUND THEN
475:
476: -- Bug 4064253
477:
478: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
479: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
480:
481: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
482: p_msg_name => 'OKL_NO_PRY_STY_FOUND',

Line 586: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

582: IF dep_sty_csr%NOTFOUND THEN
583:
584: -- Bug 4064253
585:
586: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
587: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
588:
589: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
590: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 693: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

689: IF dep_sty_csr%NOTFOUND THEN
690:
691: -- Bug 4064253
692:
693: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
694: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
695:
696: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
697: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 799: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

795: IF dep_sty_csr%NOTFOUND THEN
796:
797: -- Bug 4064253
798:
799: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
800: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
801:
802: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
803: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 905: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

901: IF pry_sty_csr%NOTFOUND THEN
902:
903: -- Bug 4064253
904:
905: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
906: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
907:
908: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
909: p_msg_name => 'OKL_NO_PRY_STY_FOUND',

Line 1009: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

1005: END LOOP;
1006:
1007: -- Bug 4064253
1008: IF (x_primary_sty_id.count = 0) THEN
1009: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1010: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
1011:
1012: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1013: p_msg_name => 'OKL_NO_PRY_STY_FOUND',

Line 1112: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

1108: IF dep_sty_csr%NOTFOUND THEN
1109:
1110: -- Bug 4064253
1111:
1112: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1113: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1114:
1115: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1116: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 1216: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

1212: IF dep_sty_csr%NOTFOUND THEN
1213:
1214: -- Bug 4064253
1215:
1216: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1217: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1218:
1219: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1220: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 1521: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

1517: IF dep_sty_csr%NOTFOUND THEN
1518:
1519: -- Bug 4064253
1520:
1521: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1522: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1523:
1524: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1525: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 1628: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING

1624: FETCH dep_sty_csr INTO l_strm_rec_type;
1625: IF dep_sty_csr%NOTFOUND THEN
1626: -- Bug 4064253
1627:
1628: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1629: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1630:
1631: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1632: p_msg_name => 'OKL_NO_DEP_STY_FOUND',

Line 13682: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

13678: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
13679: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
13680: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
13681: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
13682: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
13683: p_currency_code => l_hdr_rec.currency_code) ;
13684: --The flag l_ppd_assigned is set to true.
13685: --The flag is used to track whether a stub is appearing after the Prinicpal Paydown stub
13686: l_ppd_assigned := 'Y';

Line 13782: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

13778: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
13779: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
13780: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
13781: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
13782: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
13783: p_currency_code => l_hdr_rec.currency_code) ;
13784: --The flag l_ppd_assigned is set to true.
13785: --The flag is used to track whether a stub is appearing after the Prinicpal Paydown stub
13786: l_ppd_assigned := 'Y';

Line 14032: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

14028: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14029: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
14030: --Calculating the prorated paydown amount if it is the current PPD
14031: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
14032: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
14033: p_currency_code => l_hdr_rec.currency_code) ;
14034: --The flag l_ppd_assigned is set to true.
14035: --The flag is used to track whether a payment is appearing after the Prinicpal Paydown stub
14036: l_ppd_assigned := 'Y';

Line 14396: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

14392: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14393: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14394: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
14395: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
14396: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
14397: p_currency_code => l_hdr_rec.currency_code) ;
14398: --The flag l_ppd_assigned is set to true.
14399: --The flag is used to track whether a stub is appearing after the Prinicpal Paydown stub
14400: l_ppd_assigned := 'Y';

Line 14496: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

14492: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14493: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14494: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
14495: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
14496: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
14497: p_currency_code => l_hdr_rec.currency_code) ;
14498: --The flag l_ppd_assigned is set to true.
14499: --The flag is used to track whether a stub is appearing after the Prinicpal Paydown stub
14500: l_ppd_assigned := 'Y';

Line 14745: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,

14741: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14742: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
14743: --Calculating the prorated paydown amount if it is the current PPD
14744: IF l_ppd_tbl(k).curr_paydown = 'Y' THEN
14745: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount(p_amount => (l_line_rec.oec/l_total_oec) * p_paydown_amount,
14746: p_currency_code => l_hdr_rec.currency_code) ;
14747: --The flag l_ppd_assigned is set to true.
14748: --The flag is used to track whether a payment is appearing after the Prinicpal Paydown stub
14749: l_ppd_assigned := 'Y';

Line 18309: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,

18305: l_basis_percent := (NVL(l_tax_dep_cost,0)/ln_value) * 100;
18306: END IF;
18307: IF l_basis_percent <> 0 THEN
18308: -- Now we round the Basis Percent
18309: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,
18310: p_amount => l_basis_percent);
18311: ELSIF l_basis_percent = 0 THEN
18312: l_rnd_basis_percent := 0;
18313: END IF;

Line 18384: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,

18380: l_basis_percent := (NVL(l_corp_dep_cost,0) / ln_value) * 100;
18381: END IF;
18382: IF l_basis_percent <> 0 THEN
18383: -- Now we round the Basis Percent
18384: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,
18385: p_amount => l_basis_percent);
18386: ELSIF l_basis_percent = 0 THEN
18387: l_rnd_basis_percent := 0;
18388: END IF;

Line 18475: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,

18471: l_basis_percent := (NVL(l_tax_dep_cost,0) / ln_value) * 100;
18472: END IF;
18473: IF l_basis_percent <> 0 THEN
18474: -- Now we round the Basis Percent
18475: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,
18476: p_amount => l_basis_percent);
18477: ELSIF l_basis_percent = 0 THEN
18478: l_rnd_basis_percent := 0;
18479: END IF;

Line 22607: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,

22603: -- End for bug#3388812 modification - BAKUCHIB
22604: END IF;
22605: IF l_basis_percent <> 0 THEN
22606: -- Now we round the Basis Percent
22607: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,
22608: p_amount => l_basis_percent);
22609: END IF;
22610: -- Now we are determing the Salvage value
22611: l_salvage := nvl(l_tx_rec.salvage_value,0);

Line 22703: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,

22699: l_basis_percent := l_basis_percent * 100.00;
22700: END IF;
22701: IF l_basis_percent <> 0 THEN
22702: -- Now we round the Basis Percent
22703: l_rnd_basis_percent := OKL_ACCOUNTING_UTIL.round_amount(p_currency_code => lv_currency_code,
22704: p_amount => l_basis_percent);
22705: END IF;
22706: -- Start modification Bug#3447917
22707: -- Start modification Bug#3066346