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_RETENTION_PKG dependencies on PA_CURRENCY

Line 259: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),

255: p_task_id,
256: p_agreement_id,
257: p_retention_rule_id,
258: p_invproc_currency,
259: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
260: p_projfunc_currency,
261: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
262: p_project_currency,
263: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

Line 261: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),

257: p_retention_rule_id,
258: p_invproc_currency,
259: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
260: p_projfunc_currency,
261: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
262: p_project_currency,
263: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
264: p_funding_currency,
265: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),

Line 263: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

259: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
260: p_projfunc_currency,
261: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
262: p_project_currency,
263: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
264: p_funding_currency,
265: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
266: l_program_application_id,
267: l_program_update_date,

Line 265: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),

261: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
262: p_project_currency,
263: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
264: p_funding_currency,
265: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
266: l_program_application_id,
267: l_program_update_date,
268: p_request_id,
269: sysdate,

Line 284: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

280: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
281: END IF;
282:
283: UPDATE pa_project_retentions
284: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
285: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
287: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
288: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

282:
283: UPDATE pa_project_retentions
284: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
285: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
287: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
288: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
289: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
290: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 288: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

284: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
285: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
287: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
288: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
289: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
290: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
291: NVL(funding_total_retained,0) + NVL(p_funding_amount,0), funding_currency_code)
292: WHERE project_id = p_project_id

Line 290: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

286: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
287: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
288: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
289: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
290: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
291: NVL(funding_total_retained,0) + NVL(p_funding_amount,0), funding_currency_code)
292: WHERE project_id = p_project_id
293: AND agreement_id = p_agreement_id
294: AND retention_rule_id = p_retention_rule_id;

Line 355: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),

351: p_task_id,
352: p_agreement_id,
353: p_customer_id,
354: p_invproc_currency,
355: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
356: p_projfunc_currency,
357: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
358: p_project_currency,
359: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

Line 357: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),

353: p_customer_id,
354: p_invproc_currency,
355: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
356: p_projfunc_currency,
357: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
358: p_project_currency,
359: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
360: p_funding_currency,
361: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),

Line 359: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

355: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
356: p_projfunc_currency,
357: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
358: p_project_currency,
359: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
360: p_funding_currency,
361: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),
362: l_program_application_id,
363: l_program_update_date,

Line 361: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),

357: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
358: p_project_currency,
359: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
360: p_funding_currency,
361: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),
362: l_program_application_id,
363: l_program_update_date,
364: p_request_id,
365: sysdate,

Line 380: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

376: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
377: END IF;
378:
379: UPDATE pa_summary_project_retn
380: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
381: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
383: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
384: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

378:
379: UPDATE pa_summary_project_retn
380: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
381: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
383: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
384: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
385: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
386: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 384: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

380: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
381: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
383: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
384: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
385: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
386: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
387: NVL(funding_total_retained,0) + NVL(p_funding_amount,0),funding_currency_code)
388: WHERE project_id = p_project_id

Line 386: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

382: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
383: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
384: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
385: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
386: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
387: NVL(funding_total_retained,0) + NVL(p_funding_amount,0),funding_currency_code)
388: WHERE project_id = p_project_id
389: AND NVL(task_id,-99) = NVL(p_task_id,-99)
390: AND agreement_id = p_agreement_id;

Line 407: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),

403:
404:
405: UPDATE pa_proj_retn_rules
406: SET total_retained = NVL(total_retained,0) +
407: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
408: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
409: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
410: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
411: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)

Line 408: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

404:
405: UPDATE pa_proj_retn_rules
406: SET total_retained = NVL(total_retained,0) +
407: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
408: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
409: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
410: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
411: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)
412: WHERE retention_rule_id = p_retention_rule_id;

Line 410: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

406: SET total_retained = NVL(total_retained,0) +
407: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
408: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
409: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
410: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
411: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)
412: WHERE retention_rule_id = p_retention_rule_id;
413:
414: END IF; -- Handle the old Credit memos

Line 433: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),

429: END IF;
430:
431: UPDATE pa_summary_project_retn
432: SET total_billed = NVL(total_billed,0) +
433: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
434: project_total_billed = NVL(project_total_billed,0) +
435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
436: projfunc_total_billed = NVL(projfunc_total_billed,0) +
437: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),

Line 435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),

431: UPDATE pa_summary_project_retn
432: SET total_billed = NVL(total_billed,0) +
433: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
434: project_total_billed = NVL(project_total_billed,0) +
435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
436: projfunc_total_billed = NVL(projfunc_total_billed,0) +
437: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
438: funding_total_billed = NVL(funding_total_billed,0) +
439: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)

Line 437: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),

433: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
434: project_total_billed = NVL(project_total_billed,0) +
435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
436: projfunc_total_billed = NVL(projfunc_total_billed,0) +
437: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
438: funding_total_billed = NVL(funding_total_billed,0) +
439: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)
440: WHERE project_id = p_project_id
441: AND NVL(task_id,-99) = NVL(p_task_id,-99)

Line 439: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)

435: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
436: projfunc_total_billed = NVL(projfunc_total_billed,0) +
437: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
438: funding_total_billed = NVL(funding_total_billed,0) +
439: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)
440: WHERE project_id = p_project_id
441: AND NVL(task_id,-99) = NVL(p_task_id,-99)
442: AND agreement_id = p_agreement_id;
443:

Line 519: inv_amount =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(bill_trans_bill_amount, trim(p_bill_trans_currency)),

515:
516: BEGIN
517: UPDATE pa_draft_invoice_items
518: SET bill_trans_currency_code = p_bill_trans_currency,
519: inv_amount =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(bill_trans_bill_amount, trim(p_bill_trans_currency)),
520: request_id = p_request_id
521: WHERE DRAFT_invoice_num = p_draft_invoice_num
522: AND invoice_line_type = 'RETENTION'
523: AND project_id = p_project_id;

Line 1067: CurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1063: END IF;
1064: END IF;
1065:
1066:
1067: CurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1068: NVL(CurRetainAmount,0),InvProcCurrency);
1069:
1070: /* Changed for bug 3132449 .This is done to handle invoices with 0 amount */
1071:

Line 1074: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1070: /* Changed for bug 3132449 .This is done to handle invoices with 0 amount */
1071:
1072: IF NVL(CurRetainAmount,0) <>0 THEN
1073:
1074: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1075: (NVL(CurRetainAmount,0)/
1076: NVL(InvoiceAmount,0)) * NVL(PFCInvoiceAmount,0),ProjfuncCurrency);
1077:
1078: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1078: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1074: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1075: (NVL(CurRetainAmount,0)/
1076: NVL(InvoiceAmount,0)) * NVL(PFCInvoiceAmount,0),ProjfuncCurrency);
1077:
1078: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1079: ( NVL(CurRetainAmount,0)/
1080: NVL(InvoiceAmount,0)) * NVL(PCInvoiceAmount,0),ProjectCurrency);
1081:
1082: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1082: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1078: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1079: ( NVL(CurRetainAmount,0)/
1080: NVL(InvoiceAmount,0)) * NVL(PCInvoiceAmount,0),ProjectCurrency);
1081:
1082: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1083: ( NVL(CurRetainAmount,0)/
1084: NVL(InvoiceAmount,0)) * NVL(FCInvoiceAmount,0), FundingCurrency);
1085:
1086: BTCCurRetainAmount :=( NVL(CurRetainAmount,0)/

Line 1392: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1388: )
1389: VALUES (p_project_id,
1390: p_draft_invoice_num,
1391: LastLineNum,
1392: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1393: (-1) * CurRetainAmount, InvProcCurrency),
1394: SUBSTR(RetnLineText,1,240),
1395: 'RETENTION',
1396: retn_rule_rec.task_id,

Line 1398: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1394: SUBSTR(RetnLineText,1,240),
1395: 'RETENTION',
1396: retn_rule_rec.task_id,
1397: ProjFuncCUrrency,
1398: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1399: (-1) * PFCCurRetainAmount,ProjfuncCurrency),
1400: ProjectCurrency,
1401: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1402: (-1) * PCCurRetainAmount,ProjectCurrency),

Line 1401: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1397: ProjFuncCUrrency,
1398: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1399: (-1) * PFCCurRetainAmount,ProjfuncCurrency),
1400: ProjectCurrency,
1401: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1402: (-1) * PCCurRetainAmount,ProjectCurrency),
1403: FundingCurrency,
1404: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1405: (-1) * FCCurRetainAmount,FundingCurrency),

Line 1404: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1400: ProjectCurrency,
1401: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1402: (-1) * PCCurRetainAmount,ProjectCurrency),
1403: FundingCurrency,
1404: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1405: (-1) * FCCurRetainAmount,FundingCurrency),
1406: (-1) * BTCCurRetainAmount,
1407: InvProcCurrency,
1408: RetentionRuleId,

Line 1456: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1452: UPDATE pa_cust_rev_dist_lines_all
1453: SET retn_draft_invoice_num = p_draft_invoice_num,
1454: retn_draft_invoice_line_num = LastLineNum,
1455: retained_amount =
1456: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1457: ((NVL(bill_amount,0)/NVL(InvoiceAmount,0))
1458: * NVL(CurRetainAmount,0)),invproc_currency_code)
1459: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1460: AND draft_invoice_num = p_draft_invoice_num

Line 1477: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1473: UPDATE pa_cust_event_rdl_all
1474: SET retn_draft_invoice_num = p_draft_invoice_num,
1475: retn_draft_invoice_line_num = LastLineNum,
1476: retained_amount =
1477: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1478: ((NVL(amount,0)/NVL(InvoiceAmount,0))
1479: * NVL(CurRetainAmount,0)),invproc_currency_code)
1480: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1481: AND draft_invoice_num = p_draft_invoice_num

Line 1499: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1495: UPDATE pa_draft_invoice_items
1496: SET retn_draft_invoice_num = p_draft_invoice_num,
1497: retn_draft_invoice_line_num = LastLineNum,
1498: retained_amount =
1499: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1500: ((NVL(amount,0)/NVL(InvoiceAmount,0))
1501: * NVL(CurRetainAmount,0)), invproc_currency_code)
1502: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1503: AND draft_invoice_num = p_draft_invoice_num

Line 3054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( (-1) * InvoiceLines.projfunc_bill_amount,

3050: InvoiceLines.taxable_flag, l_last_update_login,
3051: null, InvoiceLines.output_tax_code, InvoiceLines.output_tax_exempt_flag,
3052: InvoiceLines.output_tax_exempt_reason_code, InvoiceLines.output_tax_exempt_number,
3053: InvoiceLines.translated_text, InvoiceLines.projfunc_currency_code,
3054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( (-1) * InvoiceLines.projfunc_bill_amount,
3055: invoicelines.projfunc_currency_code),
3056: invoicelines.project_currency_code,
3057: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3058: invoicelines.project_currency_code),

Line 3057: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,

3053: InvoiceLines.translated_text, InvoiceLines.projfunc_currency_code,
3054: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( (-1) * InvoiceLines.projfunc_bill_amount,
3055: invoicelines.projfunc_currency_code),
3056: invoicelines.project_currency_code,
3057: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3058: invoicelines.project_currency_code),
3059: InvoiceLines.funding_currency_code,
3060: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.funding_bill_amount,
3061: InvoiceLines.funding_currency_code),

Line 3060: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.funding_bill_amount,

3056: invoicelines.project_currency_code,
3057: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3058: invoicelines.project_currency_code),
3059: InvoiceLines.funding_currency_code,
3060: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.funding_bill_amount,
3061: InvoiceLines.funding_currency_code),
3062: InvoiceLines.funding_rate_date, InvoiceLines.funding_exchange_rate,
3063: InvoiceLines.funding_rate_type ,InvoiceLines.invproc_currency_code,
3064: InvoiceLines.bill_trans_currency_code,

Line 3066: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.bill_trans_bill_amount,

3062: InvoiceLines.funding_rate_date, InvoiceLines.funding_exchange_rate,
3063: InvoiceLines.funding_rate_type ,InvoiceLines.invproc_currency_code,
3064: InvoiceLines.bill_trans_currency_code,
3065: DECODE(NVL(InvoiceLines.bill_trans_bill_amount,0),0,0,
3066: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.bill_trans_bill_amount,
3067: InvoiceLines.bill_trans_currency_code)),
3068: InvoiceLines.retention_rule_id,
3069: InvoiceLines.line_num_credited);
3070: