DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on PA_BILLING_PUB

Line 392: -- The cost and revenue budget type codes used by the pa_billing_pub.get_budget_amount procedure

388: Amount_Left REAL := 0;
389:
390: event_description VARCHAR2(240);
391: --
392: -- The cost and revenue budget type codes used by the pa_billing_pub.get_budget_amount procedure
393: --
394: l_cost_budget_type_code VARCHAR2(30);
395: l_rev_budget_type_code VARCHAR2(30);
396: l_currency_code VARCHAR2(15);

Line 513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');

509:
510: IF g1_debug_mode = 'Y' THEN
511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(
516: X2_project_id => X_project_id,
517: X2_task_id => X_top_task_id,

Line 515: pa_billing_pub.get_budget_amount(

511: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_billing.ccrev :'||l_cost_plan_type_id);
512: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_billing.ccrev :'||l_rev_plan_type_id);
513: PA_MCB_INVOICE_PKG.log_message('Before calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev :');
514: END IF;
515: pa_billing_pub.get_budget_amount(
516: X2_project_id => X_project_id,
517: X2_task_id => X_top_task_id,
518: X2_revenue_amount => budget_revenue,
519: X2_cost_amount => budget_cost,

Line 528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));

524: X_error_message => l_error_message,
525: X_status => l_status);
526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
531: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
532: END IF;

Line 529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));

525: X_status => l_status);
526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
531: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
532: END IF;
533: -- If get budget amount return an error its fatal.

Line 530: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);

526:
527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
531: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
532: END IF;
533: -- If get budget amount return an error its fatal.
534:

Line 531: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);

527: IF g1_debug_mode = 'Y' THEN
528: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_revenue :'||to_char(budget_revenue));
529: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost :'||to_char(budget_cost));
530: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev l_cost_budget_type_code :'||l_cost_budget_type_code);
531: PA_MCB_INVOICE_PKG.log_message('After calling pa_billing_pub.get_budget_amount inside pa_billing.ccrev budget_cost l_rev_budget_type_code :'||l_rev_budget_type_code);
532: END IF;
533: -- If get budget amount return an error its fatal.
534:
535: IF l_status <> 0 THEN

Line 637: pa_billing_pub.insert_event (

633: PA_MCB_INVOICE_PKG.log_message('rev part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
634: PA_MCB_INVOICE_PKG.log_message('Rev part Before insert pa_billing.ccrev.insert_event 1 :'||to_char(Revenue));
635: END IF;
636: -- Modified to add new parameters for insert_event
637: pa_billing_pub.insert_event (
638: X_rev_amt => Revenue,
639: X_bill_amt => 0,
640: X_event_description => event_description,
641: X_audit_amount1 => amount_left,

Line 711: pa_billing_pub.insert_event (

707: IF g1_debug_mode = 'Y' THEN
708: PA_MCB_INVOICE_PKG.log_message('inv part Inside Revenue part pa_billing.ccrev Event desc :'||Event_Description);
709: PA_MCB_INVOICE_PKG.log_message('inv part before insert pa_billing.ccrev.insert_event inv 2 :'||to_char(Invoice));
710: END IF;
711: pa_billing_pub.insert_event (
712: X_rev_amt => 0,
713: X_bill_amt => Invoice,
714: X_event_description => Event_Description,
715: X_audit_amount1 => amount_left,