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 463: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

459: /* This is commented for MCB2 */
460: -- l_currency_code := pa_multi_currency_txn.get_proj_curr_code_sql(X_project_id);
461:
462: /* MCB related changes */
463: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
464: p_project_id => X_project_id,
465: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
466: x_baseline_funding_flag => l_baseline_funding_flag,
467: x_revproc_currency_code => l_revproc_currency_code,

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

1058: CURSOR spf_tl_bill_amt is
1059: /* This new currency procs. is being used which covers the MCB2 as well as old functionality */
1060:
1061: SELECT pf.agreement_id, pf.project_id, pf.task_id
1062: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1063: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1064: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1065: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1066: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -

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

1060:
1061: SELECT pf.agreement_id, pf.project_id, pf.task_id
1062: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1063: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1064: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1065: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1066: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1067: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1068: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -

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

1062: ,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.amount * (1 -
1063: ( nvl(di.retention_percentage,0)/100 )) ), dii.invproc_currency_code) dii_amount,dii.invproc_currency_code,
1064: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1065: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1066: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1067: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1068: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1069: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1070: FROM pa_draft_invoice_items dii,

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

1064: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.projfunc_bill_amount * (1 -
1065: ( nvl(di.retention_percentage,0)/100 )) ),dii.projfunc_currency_code) dii_projfunc_amount,dii.projfunc_currency_code,
1066: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.project_bill_amount * (1 -
1067: ( nvl(di.retention_percentage,0)/100 )) ),dii.project_currency_code) dii_project_amount,dii.project_currency_code,
1068: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(sum(dii.funding_bill_amount * (1 -
1069: ( nvl(di.retention_percentage,0)/100 )) ),dii.funding_currency_code) dii_funding_amount,dii.funding_currency_code
1070: FROM pa_draft_invoice_items dii,
1071: pa_draft_invoices di,
1072: pa_summary_project_fundings pf

Line 1167: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1163: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_acc_amt : ');
1164: END IF;
1165: UPDATE pa_summary_project_fundings pf
1166: SET pf.total_accrued_amount =
1167: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1168: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1169: pf.revproc_accrued_amount =
1170: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1171: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),

Line 1170: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1166: SET pf.total_accrued_amount =
1167: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1168: (acc_amt_rec.dri_funding_amount,acc_amt_rec.funding_currency_code),
1169: pf.revproc_accrued_amount =
1170: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1171: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),
1172: pf.projfunc_accrued_amount =
1173: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1174: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),

Line 1173: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1169: pf.revproc_accrued_amount =
1170: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1171: (acc_amt_rec.dri_amount,acc_amt_rec.revproc_currency_code),
1172: pf.projfunc_accrued_amount =
1173: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1174: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),
1175: pf.project_accrued_amount =
1176: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1177: (acc_amt_rec.dri_project_amount,acc_amt_rec.project_currency_code)

Line 1176: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1172: pf.projfunc_accrued_amount =
1173: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1174: (acc_amt_rec.dri_projfunc_amount,acc_amt_rec.projfunc_currency_code),
1175: pf.project_accrued_amount =
1176: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1177: (acc_amt_rec.dri_project_amount,acc_amt_rec.project_currency_code)
1178: WHERE pf.agreement_id = acc_amt_rec.agreement_id
1179: AND pf.project_id = acc_amt_rec.project_id
1180: 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 1224: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1220: PA_MCB_INVOICE_PKG.log_message('Inside pa_billing.CHECK_SPF_AMOUNTS cursor spf_pl_bill_amt : ');
1221: END IF;
1222: UPDATE pa_summary_project_fundings pf
1223: SET pf.total_billed_amount =
1224: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1225: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1226: pf.invproc_billed_amount =
1227: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1228: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),

Line 1227: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1223: SET pf.total_billed_amount =
1224: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1225: (pl_bill_amt_rec.dii_funding_amount,pl_bill_amt_rec.funding_currency_code),
1226: pf.invproc_billed_amount =
1227: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1228: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),
1229: pf.projfunc_billed_amount =
1230: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1231: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),

Line 1230: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1226: pf.invproc_billed_amount =
1227: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1228: (pl_bill_amt_rec.dii_amount,pl_bill_amt_rec.invproc_currency_code),
1229: pf.projfunc_billed_amount =
1230: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1231: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),
1232: pf.project_billed_amount =
1233: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1234: (pl_bill_amt_rec.dii_project_amount,pl_bill_amt_rec.project_currency_code)

Line 1233: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1229: pf.projfunc_billed_amount =
1230: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1231: (pl_bill_amt_rec.dii_projfunc_amount,pl_bill_amt_rec.projfunc_currency_code),
1232: pf.project_billed_amount =
1233: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1234: (pl_bill_amt_rec.dii_project_amount,pl_bill_amt_rec.project_currency_code)
1235: WHERE pf.agreement_id = pl_bill_amt_rec.agreement_id
1236: AND pf.project_id = pl_bill_amt_rec.project_id /* MCB related changes */
1237: AND nvl(pf.task_id,0) = 0; /* 2094391 */

Line 1256: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1252: END IF;
1253:
1254: UPDATE pa_summary_project_fundings pf
1255: SET pf.total_billed_amount =
1256: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1257: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1258: pf.invproc_billed_amount =
1259: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1260: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),

Line 1259: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1255: SET pf.total_billed_amount =
1256: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1257: (tl_bill_amt_rec.dii_funding_amount,tl_bill_amt_rec.funding_currency_code),
1258: pf.invproc_billed_amount =
1259: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1260: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),
1261: pf.projfunc_billed_amount =
1262: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1263: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),

Line 1262: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1258: pf.invproc_billed_amount =
1259: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1260: (tl_bill_amt_rec.dii_amount,tl_bill_amt_rec.invproc_currency_code),
1261: pf.projfunc_billed_amount =
1262: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1263: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),
1264: pf.project_billed_amount =
1265: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1266: (tl_bill_amt_rec.dii_project_amount,tl_bill_amt_rec.project_currency_code)

Line 1265: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT

1261: pf.projfunc_billed_amount =
1262: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1263: (tl_bill_amt_rec.dii_projfunc_amount,tl_bill_amt_rec.projfunc_currency_code),
1264: pf.project_billed_amount =
1265: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT
1266: (tl_bill_amt_rec.dii_project_amount,tl_bill_amt_rec.project_currency_code)
1267: WHERE pf.agreement_id = tl_bill_amt_rec.agreement_id
1268: AND pf.project_id = tl_bill_amt_rec.project_id
1269: AND pf.task_id = tl_bill_amt_rec.task_id; /* MCB related changes */