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 241: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),

237: p_task_id,
238: p_agreement_id,
239: p_retention_rule_id,
240: p_invproc_currency,
241: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
242: p_projfunc_currency,
243: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
244: p_project_currency,
245: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

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

239: p_retention_rule_id,
240: p_invproc_currency,
241: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
242: p_projfunc_currency,
243: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
244: p_project_currency,
245: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
246: p_funding_currency,
247: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),

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

241: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount, p_invproc_currency),
242: p_projfunc_currency,
243: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
244: p_project_currency,
245: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
246: p_funding_currency,
247: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
248: l_program_application_id,
249: l_program_update_date,

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

243: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
244: p_project_currency,
245: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
246: p_funding_currency,
247: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount,p_funding_currency),
248: l_program_application_id,
249: l_program_update_date,
250: p_request_id,
251: sysdate,

Line 266: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

262: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
263: END IF;
264:
265: UPDATE pa_project_retentions
266: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
267: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
269: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
270: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

264:
265: UPDATE pa_project_retentions
266: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
267: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
269: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
270: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
271: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
272: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 270: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

266: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
267: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
269: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
270: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
271: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
272: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
273: NVL(funding_total_retained,0) + NVL(p_funding_amount,0), funding_currency_code)
274: WHERE project_id = p_project_id

Line 272: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

268: project_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
269: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
270: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
271: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
272: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
273: NVL(funding_total_retained,0) + NVL(p_funding_amount,0), funding_currency_code)
274: WHERE project_id = p_project_id
275: AND agreement_id = p_agreement_id
276: AND retention_rule_id = p_retention_rule_id;

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

333: p_task_id,
334: p_agreement_id,
335: p_customer_id,
336: p_invproc_currency,
337: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
338: p_projfunc_currency,
339: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
340: p_project_currency,
341: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),

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

335: p_customer_id,
336: p_invproc_currency,
337: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
338: p_projfunc_currency,
339: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
340: p_project_currency,
341: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
342: p_funding_currency,
343: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),

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

337: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_amount,p_invproc_currency),
338: p_projfunc_currency,
339: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
340: p_project_currency,
341: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
342: p_funding_currency,
343: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),
344: l_program_application_id,
345: l_program_update_date,

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

339: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_projfunc_amount,p_projfunc_currency),
340: p_project_currency,
341: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_project_amount,p_project_currency),
342: p_funding_currency,
343: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(p_funding_amount, p_funding_currency),
344: l_program_application_id,
345: l_program_update_date,
346: p_request_id,
347: sysdate,

Line 362: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

358: pa_retention_util.write_log('Update_Retention_Balances: ' || 'Funding Amount : ' || p_funding_amount);
359: END IF;
360:
361: UPDATE pa_summary_project_retn
362: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
363: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
365: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
366: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

360:
361: UPDATE pa_summary_project_retn
362: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
363: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
365: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
366: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
367: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
368: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 366: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

362: SET total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
363: NVL(total_retained,0) + NVL(p_amount,0), invproc_currency_code),
364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
365: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
366: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
367: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
368: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
369: NVL(funding_total_retained,0) + NVL(p_funding_amount,0),funding_currency_code)
370: WHERE project_id = p_project_id

Line 368: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

364: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
365: NVL(project_total_retained,0) + NVL(p_project_amount,0),project_currency_code),
366: projfunc_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
367: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0),projfunc_currency_code),
368: funding_total_retained =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
369: NVL(funding_total_retained,0) + NVL(p_funding_amount,0),funding_currency_code)
370: WHERE project_id = p_project_id
371: AND NVL(task_id,-99) = NVL(p_task_id,-99)
372: AND agreement_id = p_agreement_id;

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

385:
386:
387: UPDATE pa_proj_retn_rules
388: SET total_retained = NVL(total_retained,0) +
389: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
390: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
391: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
392: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
393: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)

Line 390: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

386:
387: UPDATE pa_proj_retn_rules
388: SET total_retained = NVL(total_retained,0) +
389: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
390: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
391: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
392: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
393: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)
394: WHERE retention_rule_id = p_retention_rule_id;

Line 392: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

388: SET total_retained = NVL(total_retained,0) +
389: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
390: projfunc_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
391: NVL(projfunc_total_retained,0) + NVL(p_projfunc_amount,0), p_projfunc_currency),
392: project_total_retained = PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
393: NVL(project_total_retained,0) + NVL(p_project_amount,0), p_project_currency)
394: WHERE retention_rule_id = p_retention_rule_id;
395:
396: END IF; -- Handle the old Credit memos

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

411: END IF;
412:
413: UPDATE pa_summary_project_retn
414: SET total_billed = NVL(total_billed,0) +
415: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
416: project_total_billed = NVL(project_total_billed,0) +
417: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
418: projfunc_total_billed = NVL(projfunc_total_billed,0) +
419: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),

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

413: UPDATE pa_summary_project_retn
414: SET total_billed = NVL(total_billed,0) +
415: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
416: project_total_billed = NVL(project_total_billed,0) +
417: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
418: projfunc_total_billed = NVL(projfunc_total_billed,0) +
419: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
420: funding_total_billed = NVL(funding_total_billed,0) +
421: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)

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

415: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_amount,0),p_invproc_currency),
416: project_total_billed = NVL(project_total_billed,0) +
417: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
418: projfunc_total_billed = NVL(projfunc_total_billed,0) +
419: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
420: funding_total_billed = NVL(funding_total_billed,0) +
421: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)
422: WHERE project_id = p_project_id
423: AND NVL(task_id,-99) = NVL(p_task_id,-99)

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

417: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( NVL(p_project_amount,0),p_project_currency),
418: projfunc_total_billed = NVL(projfunc_total_billed,0) +
419: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_projfunc_amount,0),p_projfunc_currency),
420: funding_total_billed = NVL(funding_total_billed,0) +
421: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(NVL(p_funding_amount,0), p_funding_currency)
422: WHERE project_id = p_project_id
423: AND NVL(task_id,-99) = NVL(p_task_id,-99)
424: AND agreement_id = p_agreement_id;
425:

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

497:
498: BEGIN
499: UPDATE pa_draft_invoice_items
500: SET bill_trans_currency_code = p_bill_trans_currency,
501: inv_amount =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(bill_trans_bill_amount, trim(p_bill_trans_currency)),
502: request_id = p_request_id
503: WHERE DRAFT_invoice_num = p_draft_invoice_num
504: AND invoice_line_type = 'RETENTION'
505: AND project_id = p_project_id;

Line 1049: CurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1045: END IF;
1046: END IF;
1047:
1048:
1049: CurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1050: NVL(CurRetainAmount,0),InvProcCurrency);
1051:
1052: /* Changed for bug 3132449 .This is done to handle invoices with 0 amount */
1053:

Line 1056: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1052: /* Changed for bug 3132449 .This is done to handle invoices with 0 amount */
1053:
1054: IF NVL(CurRetainAmount,0) <>0 THEN
1055:
1056: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1057: (NVL(CurRetainAmount,0)/
1058: NVL(InvoiceAmount,0)) * NVL(PFCInvoiceAmount,0),ProjfuncCurrency);
1059:
1060: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1060: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1056: PFCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1057: (NVL(CurRetainAmount,0)/
1058: NVL(InvoiceAmount,0)) * NVL(PFCInvoiceAmount,0),ProjfuncCurrency);
1059:
1060: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1061: ( NVL(CurRetainAmount,0)/
1062: NVL(InvoiceAmount,0)) * NVL(PCInvoiceAmount,0),ProjectCurrency);
1063:
1064: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1064: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1060: PCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1061: ( NVL(CurRetainAmount,0)/
1062: NVL(InvoiceAmount,0)) * NVL(PCInvoiceAmount,0),ProjectCurrency);
1063:
1064: FCCurRetainAmount := PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1065: ( NVL(CurRetainAmount,0)/
1066: NVL(InvoiceAmount,0)) * NVL(FCInvoiceAmount,0), FundingCurrency);
1067:
1068: BTCCurRetainAmount :=( NVL(CurRetainAmount,0)/

Line 1374: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1370: )
1371: VALUES (p_project_id,
1372: p_draft_invoice_num,
1373: LastLineNum,
1374: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1375: (-1) * CurRetainAmount, InvProcCurrency),
1376: SUBSTR(RetnLineText,1,240),
1377: 'RETENTION',
1378: retn_rule_rec.task_id,

Line 1380: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1376: SUBSTR(RetnLineText,1,240),
1377: 'RETENTION',
1378: retn_rule_rec.task_id,
1379: ProjFuncCUrrency,
1380: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1381: (-1) * PFCCurRetainAmount,ProjfuncCurrency),
1382: ProjectCurrency,
1383: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1384: (-1) * PCCurRetainAmount,ProjectCurrency),

Line 1383: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1379: ProjFuncCUrrency,
1380: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1381: (-1) * PFCCurRetainAmount,ProjfuncCurrency),
1382: ProjectCurrency,
1383: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1384: (-1) * PCCurRetainAmount,ProjectCurrency),
1385: FundingCurrency,
1386: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1387: (-1) * FCCurRetainAmount,FundingCurrency),

Line 1386: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1382: ProjectCurrency,
1383: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1384: (-1) * PCCurRetainAmount,ProjectCurrency),
1385: FundingCurrency,
1386: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1387: (-1) * FCCurRetainAmount,FundingCurrency),
1388: (-1) * BTCCurRetainAmount,
1389: InvProcCurrency,
1390: RetentionRuleId,

Line 1438: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1434: UPDATE pa_cust_rev_dist_lines_all
1435: SET retn_draft_invoice_num = p_draft_invoice_num,
1436: retn_draft_invoice_line_num = LastLineNum,
1437: retained_amount =
1438: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1439: ((NVL(bill_amount,0)/NVL(InvoiceAmount,0))
1440: * NVL(CurRetainAmount,0)),invproc_currency_code)
1441: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1442: AND draft_invoice_num = p_draft_invoice_num

Line 1459: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1455: UPDATE pa_cust_event_rdl_all
1456: SET retn_draft_invoice_num = p_draft_invoice_num,
1457: retn_draft_invoice_line_num = LastLineNum,
1458: retained_amount =
1459: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1460: ((NVL(amount,0)/NVL(InvoiceAmount,0))
1461: * NVL(CurRetainAmount,0)),invproc_currency_code)
1462: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1463: AND draft_invoice_num = p_draft_invoice_num

Line 1481: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

1477: UPDATE pa_draft_invoice_items
1478: SET retn_draft_invoice_num = p_draft_invoice_num,
1479: retn_draft_invoice_line_num = LastLineNum,
1480: retained_amount =
1481: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(
1482: ((NVL(amount,0)/NVL(InvoiceAmount,0))
1483: * NVL(CurRetainAmount,0)), invproc_currency_code)
1484: WHERE retention_rule_id = retn_rule_rec.retention_rule_id
1485: AND draft_invoice_num = p_draft_invoice_num

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

3013: InvoiceLines.taxable_flag, l_last_update_login,
3014: null, InvoiceLines.output_tax_code, InvoiceLines.output_tax_exempt_flag,
3015: InvoiceLines.output_tax_exempt_reason_code, InvoiceLines.output_tax_exempt_number,
3016: InvoiceLines.translated_text, InvoiceLines.projfunc_currency_code,
3017: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( (-1) * InvoiceLines.projfunc_bill_amount,
3018: invoicelines.projfunc_currency_code),
3019: invoicelines.project_currency_code,
3020: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3021: invoicelines.project_currency_code),

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

3016: InvoiceLines.translated_text, InvoiceLines.projfunc_currency_code,
3017: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT( (-1) * InvoiceLines.projfunc_bill_amount,
3018: invoicelines.projfunc_currency_code),
3019: invoicelines.project_currency_code,
3020: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3021: invoicelines.project_currency_code),
3022: InvoiceLines.funding_currency_code,
3023: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.funding_bill_amount,
3024: InvoiceLines.funding_currency_code),

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

3019: invoicelines.project_currency_code,
3020: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * invoicelines.project_bill_amount,
3021: invoicelines.project_currency_code),
3022: InvoiceLines.funding_currency_code,
3023: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.funding_bill_amount,
3024: InvoiceLines.funding_currency_code),
3025: InvoiceLines.funding_rate_date, InvoiceLines.funding_exchange_rate,
3026: InvoiceLines.funding_rate_type ,InvoiceLines.invproc_currency_code,
3027: InvoiceLines.bill_trans_currency_code,

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

3025: InvoiceLines.funding_rate_date, InvoiceLines.funding_exchange_rate,
3026: InvoiceLines.funding_rate_type ,InvoiceLines.invproc_currency_code,
3027: InvoiceLines.bill_trans_currency_code,
3028: DECODE(NVL(InvoiceLines.bill_trans_bill_amount,0),0,0,
3029: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT((-1) * InvoiceLines.bill_trans_bill_amount,
3030: InvoiceLines.bill_trans_currency_code)),
3031: InvoiceLines.retention_rule_id,
3032: InvoiceLines.line_num_credited);
3033: