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_BILLING dependencies on PA_MULTI_CURRENCY_BILLING

Line 524: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

520: /* This is commented for MCB2 */
521: -- l_currency_code := pa_multi_currency_txn.get_proj_curr_code_sql(X_project_id);
522:
523: /* MCB related changes */
524: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
525: p_project_id => X_project_id,
526: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
527: x_baseline_funding_flag => l_baseline_funding_flag,
528: x_revproc_currency_code => l_revproc_currency_code,

Line 1128: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -

1124: CURSOR spf_tl_bill_amt is
1125: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1126:
1127: SELECT pf.agreement_id, pf.project_id, pf.task_id
1128: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1129: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1130: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1131: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -

Line 1130: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -

1126:
1127: SELECT pf.agreement_id, pf.project_id, pf.task_id
1128: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1129: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1130: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1131: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1133: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1134: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -

Line 1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -

1128: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1129: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1130: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1131: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1133: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1134: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1135: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1136: FROM pa_draft_invoice_items dii,

Line 1134: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -

1130: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1131: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1132: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1133: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1134: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1135: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1136: FROM pa_draft_invoice_items dii,
1137: pa_draft_invoices di,
1138: pa_summary_project_fundings pf

Line 1236: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1232: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1233: END IF;
1234: UPDATE pa_summary_project_fundings pf
1235: SET pf.total_accrued_amount =
1236: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1237: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1238: pf.revproc_accrued_amount =
1239: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1240: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),

Line 1239: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1235: SET pf.total_accrued_amount =
1236: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1237: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1238: pf.revproc_accrued_amount =
1239: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1240: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),
1241: pf.projfunc_accrued_amount =
1242: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1243: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),

Line 1242: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1238: pf.revproc_accrued_amount =
1239: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1240: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),
1241: pf.projfunc_accrued_amount =
1242: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1243: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),
1244: pf.project_accrued_amount =
1245: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1246: (acc_amt_rec.dri_project_amount,acc_amt_rec.project_currency_code)

Line 1245: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1241: pf.projfunc_accrued_amount =
1242: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1243: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),
1244: pf.project_accrued_amount =
1245: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1246: (acc_amt_rec.dri_project_amount,acc_amt_rec.project_currency_code)
1247: WHERE pf.agreement_id = acc_amt_rec.agreement_id
1248: AND pf.project_id = acc_amt_rec.project_id
1249: AND nvl(pf.task_id,0) = nvl(acc_amt_rec.task_fund,0); /* changed task_id to task_fund for bug 3647592 */ /* added semi-colon for bug 3717388*/

Line 1293: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1289: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1290: END IF;
1291: UPDATE pa_summary_project_fundings pf
1292: SET pf.total_billed_amount =
1293: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1294: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1295: pf.invproc_billed_amount =
1296: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1297: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),

Line 1296: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1292: SET pf.total_billed_amount =
1293: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1294: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1295: pf.invproc_billed_amount =
1296: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1297: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),
1298: pf.projfunc_billed_amount =
1299: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1300: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),

Line 1299: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1295: pf.invproc_billed_amount =
1296: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1297: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),
1298: pf.projfunc_billed_amount =
1299: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1300: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),
1301: pf.project_billed_amount =
1302: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1303: (pl_bill_amt_rec.dii_project_amount,pl_bill_amt_rec.project_currency_code)

Line 1302: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1298: pf.projfunc_billed_amount =
1299: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1300: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),
1301: pf.project_billed_amount =
1302: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1303: (pl_bill_amt_rec.dii_project_amount,pl_bill_amt_rec.project_currency_code)
1304: WHERE pf.agreement_id = pl_bill_amt_rec.agreement_id
1305: AND pf.project_id = pl_bill_amt_rec.project_id /* MCB related changes */
1306: AND nvl(pf.task_id,0) = 0 /* 2094391 */

Line 1326: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1322: END IF;
1323:
1324: UPDATE pa_summary_project_fundings pf
1325: SET pf.total_billed_amount =
1326: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1327: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1328: pf.invproc_billed_amount =
1329: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1330: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),

Line 1329: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1325: SET pf.total_billed_amount =
1326: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1327: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1328: pf.invproc_billed_amount =
1329: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1330: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),
1331: pf.projfunc_billed_amount =
1332: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1333: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),

Line 1332: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1328: pf.invproc_billed_amount =
1329: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1330: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),
1331: pf.projfunc_billed_amount =
1332: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1333: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),
1334: pf.project_billed_amount =
1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1336: (tl_bill_amt_rec.dii_project_amount,tl_bill_amt_rec.project_currency_code)

Line 1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1331: pf.projfunc_billed_amount =
1332: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1333: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),
1334: pf.project_billed_amount =
1335: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1336: (tl_bill_amt_rec.dii_project_amount,tl_bill_amt_rec.project_currency_code)
1337: WHERE pf.agreement_id = tl_bill_amt_rec.agreement_id
1338: AND pf.project_id = tl_bill_amt_rec.project_id
1339: AND pf.task_id = tl_bill_amt_rec.task_id /* MCB related changes */