DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CURRENCY

Line 2253: pa_currency.round_trans_currency_amt(

2249: and nvl(dii.credit_process_flag,'N') = 'Y' ;
2250:
2251: update pa_draft_invoice_items dii
2252: set credit_amount =
2253: pa_currency.round_trans_currency_amt(
2254: (inv_amount * (p_total_credit_amount/l_inv_amount)),
2255: rtrim(l_inv_currency_code))
2256: where project_id = p_project_id
2257: and draft_invoice_num = p_draft_invoice_num

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

2385: /* In old model there will be only one retention line for an invoice. So credit amount is stamped on that line */
2386:
2387: update pa_draft_invoice_items
2388: set credit_amount =
2389: pa_currency.round_trans_currency_amt(l_retn_credit_amount, rtrim(l_inv_currency_code))
2390: where project_id = p_project_id
2391: and draft_invoice_num = p_draft_invoice_num
2392: and invoice_line_type = 'RETENTION';
2393:

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

2582: on currency code we multiply by -1 and round the amount based on inv_currency_code
2583: */
2584: update pa_draft_invoice_items
2585: set credit_amount =
2586: pa_currency.round_trans_currency_amt(credit_amount, rtrim(l_inv_currency_code)) * -1
2587: where project_id = p_project_id
2588: and draft_invoice_num = p_draft_invoice_num
2589: and invoice_line_type = 'RETENTION';
2590: