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.PA_INVOICE_CURRENCY dependencies on PA_CURRENCY

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

538: IF ( cur_get_std_lines.credit_process_flag <> 'X' ) THEN
539: /* Added for Payroll Billing ER #11847630 - End */
540:
541: /* Convert line amount for all lines except line no: 1 */
542: l_inv_amt := pa_currency.round_trans_currency_amt(((cur_get_std_lines.amount/
543: l_denominator)* l_numerator),l_inv_currency_code);
544:
545:
546: /* Added for Payroll Billing ER #11847630 - Start */

Line 551: l_inv_amt := pa_currency.round_trans_currency_amt(

547:
548: ELSE
549: /* Convert line amount for reversl line using
550: existing rate on the line */
551: l_inv_amt := pa_currency.round_trans_currency_amt(
552: ((cur_get_std_lines.amount)* cur_get_std_lines.inv_exchange_rate),
553: l_inv_currency_code);
554:
555: END IF;

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

647: l_max_line_num := cur_get_ret_lines.line;
648:
649: end if;
650:
651: l_inv_ret_amt := pa_currency.round_trans_currency_amt(((cur_get_ret_lines.amt/
652: l_denominator)* l_numerator),l_inv_currency_code);
653:
654: /* Commented out for Retention Enhancement changes
655: l_inv_ret_amt := (-1)*pa_currency.round_trans_currency_amt(

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

651: l_inv_ret_amt := pa_currency.round_trans_currency_amt(((cur_get_ret_lines.amt/
652: l_denominator)* l_numerator),l_inv_currency_code);
653:
654: /* Commented out for Retention Enhancement changes
655: l_inv_ret_amt := (-1)*pa_currency.round_trans_currency_amt(
656: ((cur_get_ret_lines.retention/100)*
657: l_total_inv_amount),l_inv_currency_code); */
658:
659: IF g1_debug_mode = 'Y' THEN

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

679: FROM pa_draft_invoice_items
680: WHERE project_id = P_Project_Id
681: AND draft_invoice_num = P_Draft_Inv_Num
682: AND NVL(credit_process_flag ,'N') = 'X';
683: l_con_amt := pa_currency.round_trans_currency_amt((((l_tot_proj_amt/
684: l_denominator)* l_numerator)+l_conv_rev_amt),l_inv_currency_code);
685: /*Added End for Payroll Billing Integration Bug# 12383803*/
686:
687: l_total_inv_amount := l_total_inv_amount + l_total_retn_amount;

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

697: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Total Round Off Amt : ' || l_round_off_amt);
698: END IF;
699: /*Added nvl for l_round_off_amt for bug 12604419*/
700: Update PA_DRAFT_INVOICE_ITEMS dii
701: SET dii.Inv_amount = pa_currency.round_trans_currency_amt(
702: dii.Inv_amount - nvl(l_round_off_amt,0),l_inv_currency_code)
703: Where dii.project_id = P_Project_Id
704: and dii.Draft_Invoice_num = P_Draft_Inv_Num
705: and dii.Line_Num = l_max_line_num;

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

1060: l_tot_amt NUMBER )
1061: is
1062: /* commented for bug 1633744 .. select modified as below this comment
1063: select cmdii.amount amt,
1064: pa_currency.round_trans_currency_amt(((l_tot_inv_amt/l_tot_amt)
1065: *cmdii.amount),cmdi.inv_currency_code) line_amt,
1066: cmdi.retention_percentage retper,
1067: cmdi.inv_currency_code curcode,
1068: cmdii.line_num line_num

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

1077: for update of cmdii.amount
1078: order by cmdii.line_num;
1079: End of comments for bug 1633744 */
1080: select cmdii.amount amt,
1081: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
1082: cmdi.retention_percentage retper,
1083: cmdi.inv_currency_code curcode,
1084: cmdii.line_num line_num
1085: from pa_draft_invoices cmdi,

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

1113: Bug 2689348
1114: */
1115: Cursor get_mult_ret_amt is
1116: select cmdii.amount amt,
1117: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
1118: cmdii.line_num line_num
1119: from pa_draft_invoices cmdi,
1120: pa_draft_invoice_items cmdii,
1121: pa_draft_invoice_items cmdii1

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

1376: end loop;
1377:
1378: if l_retper <> 0 then /* added for 2689348 Carry on with old retention model */
1379: -- Updation of Retention Line
1380: l_ret_amt := (-1) * pa_currency.round_trans_currency_amt((l_tot_inv_cur_amt*l_retper)
1381: /100,l_curcode);
1382:
1383: open get_ret_amt;
1384:

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

1417:
1418: if l_proj_cur_amt <>0 then /* added to avoid divide by zero : 1633744 */
1419: -- Adjust Round-Off Error
1420: l_round_off_amt := l_tot_inv_cur_amt -
1421: pa_currency.round_trans_currency_amt((l_inv_cur_amt/l_proj_cur_amt)
1422: *l_tot_proj_cur_amt,l_curcode);
1423:
1424: update pa_draft_invoice_items
1425: set inv_amount = inv_amount - l_round_off_amt