DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CURRENCY

Line 2125: pa_currency.round_trans_currency_amt(

2121: and nvl(dii.credit_process_flag,'N') = 'Y' ;
2122:
2123: update pa_draft_invoice_items dii
2124: set credit_amount =
2125: pa_currency.round_trans_currency_amt(
2126: (inv_amount * (p_total_credit_amount/l_inv_amount)),
2127: rtrim(l_inv_currency_code))
2128: where project_id = p_project_id
2129: and draft_invoice_num = p_draft_invoice_num

Line 2261: pa_currency.round_trans_currency_amt(l_retn_credit_amount, rtrim(l_inv_currency_code))

2257: /* In old model there will be only one retention line for an invoice. So credit amount is stamped on that line */
2258:
2259: update pa_draft_invoice_items
2260: set credit_amount =
2261: pa_currency.round_trans_currency_amt(l_retn_credit_amount, rtrim(l_inv_currency_code))
2262: where project_id = p_project_id
2263: and draft_invoice_num = p_draft_invoice_num
2264: and invoice_line_type = 'RETENTION';
2265:

Line 2458: pa_currency.round_trans_currency_amt(credit_amount, rtrim(l_inv_currency_code)) * -1

2454: on currency code we multiply by -1 and round the amount based on inv_currency_code
2455: */
2456: update pa_draft_invoice_items
2457: set credit_amount =
2458: pa_currency.round_trans_currency_amt(credit_amount, rtrim(l_inv_currency_code)) * -1
2459: where project_id = p_project_id
2460: and draft_invoice_num = p_draft_invoice_num
2461: and invoice_line_type = 'RETENTION';
2462: