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_AMOUNT dependencies on PA_MCB_INVOICE_PKG

Line 20: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.CostAmount :');

16: l_calling_process varchar2(15);
17:
18: BEGIN
19: IF g1_debug_mode = 'Y' THEN
20: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.CostAmount :');
21: END IF;
22:
23: l_calling_process := pa_billing.GetCallProcess; /*Added for bug 7299493*/
24:

Line 166: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.CostAmount :');

162:
163: X2_cost_amount := nvl(new_cost,0);
164:
165: IF g1_debug_mode = 'Y' THEN
166: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.CostAmount :');
167: END IF;
168: END CostAmount;
169:
170:

Line 238: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.RevenueAmount :');

234:
235: l_projfunc_convers_fail EXCEPTION;
236: BEGIN
237: IF g1_debug_mode = 'Y' THEN
238: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.RevenueAmount :');
239: END IF;
240:
241: -- Cost-Cost Revenue that has been accrued.
242: SELECT sum(nvl(dri.projfunc_revenue_amount,0)) /* change this column from amount to projfunc_revenue_amount for MCB2 */

Line 264: PA_MCB_INVOICE_PKG.log_message('Number 01 RevenueAmount.accrued_ccrev :'||TO_CHAR(accrued_ccrev));

260: and be.procedure_name = 'pa_billing.ccrev')
261: OR dri.revenue_source like 'Expenditure%');
262:
263: IF g1_debug_mode = 'Y' THEN
264: PA_MCB_INVOICE_PKG.log_message('Number 01 RevenueAmount.accrued_ccrev :'||TO_CHAR(accrued_ccrev));
265: END IF;
266: -- Cost-Cost revenue that has not been created as events but not accrued yet.
267: -- This could be due to unauthorized task or an erroring request.
268: /* The following code is commented because this amount is in RPC i.e. Revenue programm is going to populate this amount

Line 338: PA_MCB_INVOICE_PKG.log_message('Number 02 RevenueAmount.pending_ccrev :'||to_char(l_projfunc_rev_amount_sum));

334: l_converted_rev_amount := 0;
335: END IF;
336: l_projfunc_rev_amount_sum := NVL(l_projfunc_rev_amount_sum,0) + NVL(l_converted_rev_amount,0);
337: IF g1_debug_mode = 'Y' THEN
338: PA_MCB_INVOICE_PKG.log_message('Number 02 RevenueAmount.pending_ccrev :'||to_char(l_projfunc_rev_amount_sum));
339: END IF;
340: End Loop;
341: Close func_revenue;
342: pending_ccrev := l_projfunc_rev_amount_sum;

Line 345: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.RevenueAmount :');

341: Close func_revenue;
342: pending_ccrev := l_projfunc_rev_amount_sum;
343: X2_revenue_amount := nvl(accrued_ccrev,0) + nvl(pending_ccrev,0);
344: IF g1_debug_mode = 'Y' THEN
345: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.RevenueAmount :');
346: END IF;
347: END RevenueAmount;
348:
349:

Line 430: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Entering pa_billing_amount.PotEvent :');

426: and be.procedure_name = 'pa_billing.ccrev');
427:
428: BEGIN
429: IF g1_debug_mode = 'Y' THEN
430: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Entering pa_billing_amount.PotEvent :');
431: END IF;
432: /* The following sql has been commented for MCB2 */
433: /* SELECT sum(decode(et.event_type_classification,
434: 'WRITE OFF', -1 * nvl(revenue_amount,0),

Line 514: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Number 01 pa_billing_amount.PotEvent.l_projfunc_amount_sum :'||to_char(l_projfunc_amount_sum));

510: END IF;
511:
512: l_projfunc_amount_sum := NVL(l_projfunc_amount_sum,0) + NVL(l_converted_amount,0);
513: IF g1_debug_mode = 'Y' THEN
514: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Number 01 pa_billing_amount.PotEvent.l_projfunc_amount_sum :'||to_char(l_projfunc_amount_sum));
515: END IF;
516: End Loop;
517: Close func_rev_inv_amt;
518:

Line 527: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Exiting pa_billing_amount.PotEvent :');

523: X2_revenue_amount := 0;
524: X2_invoice_amount := l_projfunc_amount_sum;
525: END IF;
526: IF g1_debug_mode = 'Y' THEN
527: PA_MCB_INVOICE_PKG.log_message('PotEventAmount: ' || 'Exiting pa_billing_amount.PotEvent :');
528: END IF;
529: END PotEventAmount;
530:
531:

Line 609: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.InvoiceAmount :');

605: and nvl(pdii.task_id,0) = nvl(e.task_id,0));
606:
607: BEGIN
608: IF g1_debug_mode = 'Y' THEN
609: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.InvoiceAmount :');
610: END IF;
611:
612: -- Cost/Cost Invoice Amount that has been created as an event, but not billed
613: -- yet.

Line 692: PA_MCB_INVOICE_PKG.log_message('inside pa_billing_amount.InvoiceAmount :'||l_projfunc_bill_amount_sum);

688: END IF;
689:
690: l_projfunc_bill_amount_sum := NVL(l_projfunc_bill_amount_sum,0) + NVL(l_converted_bill_amount,0);
691: IF g1_debug_mode = 'Y' THEN
692: PA_MCB_INVOICE_PKG.log_message('inside pa_billing_amount.InvoiceAmount :'||l_projfunc_bill_amount_sum);
693: END IF;
694: End Loop;
695: Close func_invoice;
696: pending_ccinv := l_projfunc_bill_amount_sum;

Line 764: PA_MCB_INVOICE_PKG.log_message('Overall invoice amount pa_billing_amount.InvoiceAmount :'||to_char(nvl(task_billed_ccinv,0) + nvl(task_billed_ev_ccinv,0) + nvl(pending_ccinv,0)));

760:
761: X2_invoice_amount := nvl(task_billed_ccinv,0) + nvl(task_billed_ev_ccinv,0) + nvl(pending_ccinv,0);
762:
763: IF g1_debug_mode = 'Y' THEN
764: PA_MCB_INVOICE_PKG.log_message('Overall invoice amount pa_billing_amount.InvoiceAmount :'||to_char(nvl(task_billed_ccinv,0) + nvl(task_billed_ev_ccinv,0) + nvl(pending_ccinv,0)));
765: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.InvoiceAmount :');
766: END IF;
767: END IF;
768:

Line 765: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.InvoiceAmount :');

761: X2_invoice_amount := nvl(task_billed_ccinv,0) + nvl(task_billed_ev_ccinv,0) + nvl(pending_ccinv,0);
762:
763: IF g1_debug_mode = 'Y' THEN
764: PA_MCB_INVOICE_PKG.log_message('Overall invoice amount pa_billing_amount.InvoiceAmount :'||to_char(nvl(task_billed_ccinv,0) + nvl(task_billed_ev_ccinv,0) + nvl(pending_ccinv,0)));
765: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.InvoiceAmount :');
766: END IF;
767: END IF;
768:
769: END InvoiceAmount;

Line 848: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.LowestAmountLeft :');

844:
845: BEGIN
846:
847: IF g1_debug_mode = 'Y' THEN
848: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.LowestAmountLeft :');
849: END IF;
850: -- This select gets automatic events that were created in this run or some
851: -- previous run, but have not been accrued/billed yet.
852: -- This must be subtracted from amount available to get the real amount

Line 932: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Inside pa_billing_amount.LowestAmount :'||l_projfunc_amount_sum);

928: END IF;
929:
930: l_projfunc_amount_sum := NVL(l_projfunc_amount_sum,0) + NVL(l_converted_amount,0);
931: IF g1_debug_mode = 'Y' THEN
932: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Inside pa_billing_amount.LowestAmount :'||l_projfunc_amount_sum);
933: END IF;
934: End Loop;
935: Close func_lwst_rev_inv_amt;
936:

Line 1008: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 1 :'||lowest_revenue_amount);

1004: END IF ;
1005: -- End of FP_M changes
1006:
1007: IF g1_debug_mode = 'Y' THEN
1008: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 1 :'||lowest_revenue_amount);
1009: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 2 :'||lowest_invoice_amount);
1010: END IF;
1011:
1012:

Line 1009: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 2 :'||lowest_invoice_amount);

1005: -- End of FP_M changes
1006:
1007: IF g1_debug_mode = 'Y' THEN
1008: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 1 :'||lowest_revenue_amount);
1009: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Entering .LowestAmount 2 :'||lowest_invoice_amount);
1010: END IF;
1011:
1012:
1013: IF (X2_calling_process = 'Revenue') THEN

Line 1022: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Exiting pa_billing_amount.LowestAmount :');

1018: - nvl(current_event_invoice,0)),0);
1019: END IF;
1020:
1021: IF g1_debug_mode = 'Y' THEN
1022: PA_MCB_INVOICE_PKG.log_message('LowestAmountLeft: ' || 'Exiting pa_billing_amount.LowestAmount :');
1023: END IF;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: /* DBMS_OUTPUT.PUT_LINE(SQLERRM); */

Line 1037: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.rdl_amount :');

1033:
1034: Ramount REAL;
1035: BEGIN
1036: IF g1_debug_mode = 'Y' THEN
1037: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.rdl_amount :');
1038: END IF;
1039: /* Changed column from bill_amount to projfunc_bill_amount and amount to projfunc_revenue_amount for MCB2 */
1040: SELECT sum(decode(X_which, 'I', nvl(rdl.projfunc_bill_amount,0),
1041: 'R', NVL(rdl.projfunc_revenue_amount,0),NVL(rdl.projfunc_revenue_amount,0)))

Line 1065: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.rdl_amount :');

1061: -- 2. Exclude items which have been reversed out, if
1062: -- only positive items requested.
1063:
1064: IF g1_debug_mode = 'Y' THEN
1065: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.rdl_amount :');
1066: END IF;
1067:
1068: RETURN Ramount;
1069: END rdl_amount;

Line 1095: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.get_baseline_budget :');

1091:
1092:
1093: BEGIN
1094: IF g1_debug_mode = 'Y' THEN
1095: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing_amount.get_baseline_budget :');
1096: END IF;
1097: c := 5;
1098:
1099: SELECT Decode(SUBSTR(distribution_rule,INSTR(distribution_rule,'/')+1),'COST','x','y') /* Added Decode for Bug 2389765 */

Line 1211: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.get_baseline_budget :');

1207: pa_currency.round_currency_amt(l_revenue_total);
1208:
1209:
1210: IF g1_debug_mode = 'Y' THEN
1211: PA_MCB_INVOICE_PKG.log_message('Exiting pa_billing_amount.get_baseline_budget :');
1212: END IF;
1213: EXCEPTION
1214: When NO_DATA_FOUND
1215: then