APPS.LNS_BILLING_BATCH_PUB dependencies on FND_CURRENCY

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

1613: if l_Count5 = 1 then
1614: l_orig_line_amount := l_trx_lines_tbl(l_Count1).unit_selling_price;
1615: l_split_flag := 'Y';
1616:
1617: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,
1618: PRECISION => l_precision,
1619: EXT_PRECISION => l_ext_precision,
1620: MIN_ACCT_UNIT => l_min_acct_unit);
1621:

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

1738: if l_Count5 = 1 then
1739: l_orig_line_amount := l_trx_lines_tbl(l_Count1).unit_selling_price;
1740: l_split_flag := 'Y';
1741:
1742: fnd_currency.GET_INFO(CURRENCY_CODE => P_LOAN_REC.LOAN_CURRENCY,
1743: PRECISION => l_precision,
1744: EXT_PRECISION => l_ext_precision,
1745: MIN_ACCT_UNIT => l_min_acct_unit);
1746:

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

2862: CURSOR loan_cur(P_LOAN_ID number, P_PRIN_AMOUNT_DUE number, P_INT_AMOUNT_DUE number, P_FEE_AMOUNT_DUE number) IS
2863: select party.party_name,
2864: loan.loan_number,
2865: loan.LOAN_CURRENCY,
2866: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,

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

2863: select party.party_name,
2864: loan.loan_number,
2865: loan.LOAN_CURRENCY,
2866: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,
2871: hz_parties party

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

2864: loan.loan_number,
2865: loan.LOAN_CURRENCY,
2866: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,
2871: hz_parties party
2872: where party.party_id = loan.PRIMARY_BORROWER_ID and

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

2865: loan.LOAN_CURRENCY,
2866: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,
2871: hz_parties party
2872: where party.party_id = loan.PRIMARY_BORROWER_ID and
2873: loan.loan_id = P_LOAN_ID;

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

3144: | Cursor Declarations |
3145: +-----------------------------------------------------------------------*/
3146:
3147: CURSOR c_get_currency_format_mask(pLoanId Number) is
3148: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask
3149: from lns_loan_headers_all loan
3150: where loan.loan_id = pLoanId;
3151:
3152: BEGIN

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

7716:
7717: l_type := 'LINE';
7718:
7719: -- fix for bug 7712669
7720: fnd_currency.GET_INFO(CURRENCY_CODE => l_currency,
7721: PRECISION => l_precision,
7722: EXT_PRECISION => l_ext_precision,
7723: MIN_ACCT_UNIT => l_min_acct_unit);
7724: l_requested_amount := round(l_original_amount * (l_forgiveness_percent/100), l_precision);