APPS.PA_INVOICE_CURRENCY dependencies on PA_CURRENCY

Line 475: l_inv_amt := pa_currency.round_trans_currency_amt(((cur_get_std_lines.amount/

471:
472: else
473:
474: /* Convert line amount for all lines except line no: 1 */
475: l_inv_amt := pa_currency.round_trans_currency_amt(((cur_get_std_lines.amount/
476: l_denominator)* l_numerator),l_inv_currency_code);
477:
478:
479: end if;

Line 518: l_inv_ret_amt := pa_currency.round_trans_currency_amt(((cur_get_ret_lines.amt/

514: l_max_line_num := cur_get_ret_lines.line;
515:
516: end if;
517:
518: l_inv_ret_amt := pa_currency.round_trans_currency_amt(((cur_get_ret_lines.amt/
519: l_denominator)* l_numerator),l_inv_currency_code);
520:
521: /* Commented out for Retention Enhancement changes
522: l_inv_ret_amt := (-1)*pa_currency.round_trans_currency_amt(

Line 522: l_inv_ret_amt := (-1)*pa_currency.round_trans_currency_amt(

518: l_inv_ret_amt := pa_currency.round_trans_currency_amt(((cur_get_ret_lines.amt/
519: l_denominator)* l_numerator),l_inv_currency_code);
520:
521: /* Commented out for Retention Enhancement changes
522: l_inv_ret_amt := (-1)*pa_currency.round_trans_currency_amt(
523: ((cur_get_ret_lines.retention/100)*
524: l_total_inv_amount),l_inv_currency_code); */
525:
526: IF g1_debug_mode = 'Y' THEN

Line 542: l_con_amt := pa_currency.round_trans_currency_amt(((l_tot_proj_amt/

538: end loop;
539:
540: /* Adjust Round Off Error */
541: l_tot_proj_amt := l_tot_proj_amt + l_ret_amt;
542: l_con_amt := pa_currency.round_trans_currency_amt(((l_tot_proj_amt/
543: l_denominator)* l_numerator),l_inv_currency_code);
544:
545: l_total_inv_amount := l_total_inv_amount + l_total_retn_amount;
546:

Line 559: SET dii.Inv_amount = pa_currency.round_trans_currency_amt(

555: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Total Round Off Amt : ' || l_round_off_amt);
556: END IF;
557:
558: Update PA_DRAFT_INVOICE_ITEMS dii
559: SET dii.Inv_amount = pa_currency.round_trans_currency_amt(
560: dii.Inv_amount - l_round_off_amt,l_inv_currency_code)
561: Where dii.project_id = P_Project_Id
562: and dii.Draft_Invoice_num = P_Draft_Inv_Num
563: and dii.Line_Num = l_max_line_num;

Line 921: pa_currency.round_trans_currency_amt(((l_tot_inv_amt/l_tot_amt)

917: l_tot_amt NUMBER )
918: is
919: /* commented for bug 1633744 .. select modified as below this comment
920: select cmdii.amount amt,
921: pa_currency.round_trans_currency_amt(((l_tot_inv_amt/l_tot_amt)
922: *cmdii.amount),cmdi.inv_currency_code) line_amt,
923: cmdi.retention_percentage retper,
924: cmdi.inv_currency_code curcode,
925: cmdii.line_num line_num

Line 938: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,

934: for update of cmdii.amount
935: order by cmdii.line_num;
936: End of comments for bug 1633744 */
937: select cmdii.amount amt,
938: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
939: cmdi.retention_percentage retper,
940: cmdi.inv_currency_code curcode,
941: cmdii.line_num line_num
942: from pa_draft_invoices cmdi,

Line 974: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,

970: Bug 2689348
971: */
972: Cursor get_mult_ret_amt is
973: select cmdii.amount amt,
974: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
975: cmdii.line_num line_num
976: from pa_draft_invoices cmdi,
977: pa_draft_invoice_items cmdii,
978: pa_draft_invoice_items cmdii1

Line 1216: l_ret_amt := (-1) * pa_currency.round_trans_currency_amt((l_tot_inv_cur_amt*l_retper)

1212: end loop;
1213:
1214: if l_retper <> 0 then /* added for 2689348 Carry on with old retention model */
1215: -- Updation of Retention Line
1216: l_ret_amt := (-1) * pa_currency.round_trans_currency_amt((l_tot_inv_cur_amt*l_retper)
1217: /100,l_curcode);
1218:
1219: open get_ret_amt;
1220:

Line 1257: pa_currency.round_trans_currency_amt((l_inv_cur_amt/l_proj_cur_amt)

1253:
1254: if l_proj_cur_amt <>0 then /* added to avoid divide by zero : 1633744 */
1255: -- Adjust Round-Off Error
1256: l_round_off_amt := l_tot_inv_cur_amt -
1257: pa_currency.round_trans_currency_amt((l_inv_cur_amt/l_proj_cur_amt)
1258: *l_tot_proj_cur_amt,l_curcode);
1259:
1260: update pa_draft_invoice_items
1261: set inv_amount = inv_amount - l_round_off_amt