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.LNS_BILLING_BATCH_PUB dependencies on FND_CURRENCY

Line 1700: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,

1696:
1697: if l_Count5 = 1 then
1698: l_orig_line_amount := l_trx_lines_tbl(l_Count1).unit_selling_price;
1699:
1700: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,
1701: PRECISION => l_precision,
1702: EXT_PRECISION => l_ext_precision,
1703: MIN_ACCT_UNIT => l_min_acct_unit);
1704:

Line 1820: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,

1816:
1817: if l_Count5 = 1 then
1818: l_orig_line_amount := l_trx_lines_tbl(l_Count1).unit_selling_price;
1819:
1820: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,
1821: PRECISION => l_precision,
1822: EXT_PRECISION => l_ext_precision,
1823: MIN_ACCT_UNIT => l_min_acct_unit);
1824:

Line 3090: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),

3086: CURSOR loan_cur(P_LOAN_ID number, P_PRIN_AMOUNT_DUE number, P_INT_AMOUNT_DUE number, P_FEE_AMOUNT_DUE number) IS
3087: select party.party_name,
3088: loan.loan_number,
3089: loan.LOAN_CURRENCY,
3090: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
3094: from lns_loan_headers loan,

Line 3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),

3087: select party.party_name,
3088: loan.loan_number,
3089: loan.LOAN_CURRENCY,
3090: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
3094: from lns_loan_headers loan,
3095: hz_parties party

Line 3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),

3088: loan.loan_number,
3089: loan.LOAN_CURRENCY,
3090: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
3094: from lns_loan_headers loan,
3095: hz_parties party
3096: where party.party_id = loan.PRIMARY_BORROWER_ID and

Line 3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))

3089: loan.LOAN_CURRENCY,
3090: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3091: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3092: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
3093: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
3094: from lns_loan_headers loan,
3095: hz_parties party
3096: where party.party_id = loan.PRIMARY_BORROWER_ID and
3097: loan.loan_id = P_LOAN_ID;

Line 3413: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask

3409: | Cursor Declarations |
3410: +-----------------------------------------------------------------------*/
3411:
3412: CURSOR c_get_currency_format_mask(pLoanId Number) is
3413: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask
3414: from lns_loan_headers_all loan
3415: where loan.loan_id = pLoanId;
3416:
3417: BEGIN

Line 8292: fnd_currency.GET_INFO(CURRENCY_CODE => l_currency,

8288: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Forgiveness percent = 0. Exiting.');
8289: return;
8290: end if;
8291:
8292: fnd_currency.GET_INFO(CURRENCY_CODE => l_currency,
8293: PRECISION => l_precision,
8294: EXT_PRECISION => l_ext_precision,
8295: MIN_ACCT_UNIT => l_min_acct_unit);
8296: X_FORGIVENESS_AMOUNT := round(P_AMOUNT * (l_forgiveness_percent/100), l_precision);

Line 8524: fnd_currency.GET_INFO(CURRENCY_CODE => l_currency,

8520: X_FORGIVENESS_AMOUNT => l_requested_amount,
8521: X_REMAINING_AMOUNT => l_remaining_amount);
8522: /*
8523: -- fix for bug 7712669
8524: fnd_currency.GET_INFO(CURRENCY_CODE => l_currency,
8525: PRECISION => l_precision,
8526: EXT_PRECISION => l_ext_precision,
8527: MIN_ACCT_UNIT => l_min_acct_unit);
8528: l_requested_amount := round(l_original_amount * (l_forgiveness_percent/100), l_precision);

Line 9588: fnd_currency.GET_INFO(CURRENCY_CODE => l_CASH_RECEIPTS_TBL(l_Count1).RECEIPT_CURRENCY,

9584:
9585: else -- if trx currency <> receipt currency
9586:
9587: -- get rc/functional currency precision
9588: fnd_currency.GET_INFO(CURRENCY_CODE => l_CASH_RECEIPTS_TBL(l_Count1).RECEIPT_CURRENCY,
9589: PRECISION => l_rc_precision,
9590: EXT_PRECISION => l_rc_ext_precision,
9591: MIN_ACCT_UNIT => l_rc_min_acct_unit);
9592:

Line 9594: fnd_currency.GET_INFO(CURRENCY_CODE => L_INVOICES_TBL(l_Count).INVOICE_CURRENCY,

9590: EXT_PRECISION => l_rc_ext_precision,
9591: MIN_ACCT_UNIT => l_rc_min_acct_unit);
9592:
9593: -- get invoice currency precision
9594: fnd_currency.GET_INFO(CURRENCY_CODE => L_INVOICES_TBL(l_Count).INVOICE_CURRENCY,
9595: PRECISION => l_inv_precision,
9596: EXT_PRECISION => l_inv_ext_precision,
9597: MIN_ACCT_UNIT => l_inv_min_acct_unit);
9598: