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_REV_CA dependencies on PA_BILLING

Line 6: -- pa_billing_extensions table

2: /*$Header: PAXICOSB.pls 120.1.12010000.2 2008/09/25 08:56:47 dlella ship $*/
3:
4: /*****************************************************************************
5: -- Global variables to store the attribute12 - 15 columns of
6: -- pa_billing_extensions table
7: ****************************************************************************/
8:
9: g_ca_event_type VARCHAR2(30);
10: g_ca_contra_event_type VARCHAR2(30);

Line 207: -- This procedure is same as the public api pa_billing_pub.get_budget_amount

203: X_cost_accrued := NULL;
204: END GetCostWIP;
205: --
206: -- Procedure that returns the cost budget and revenue budget amount
207: -- This procedure is same as the public api pa_billing_pub.get_budget_amount
208: -- the only difference in this case the raw cost is used for cost budget amount
209: --
210: PROCEDURE get_budget_amount( X2_project_id NUMBER,
211: X2_task_id NUMBER DEFAULT NULL,

Line 277: FROM pa_billing_extensions

273: INTO l_cost_budget_type_code,
274: l_rev_budget_type_code,
275: l_cost_plan_type_id,
276: l_rev_plan_type_id
277: FROM pa_billing_extensions
278: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
279:
280: END IF;
281:

Line 278: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;

274: l_rev_budget_type_code,
275: l_cost_plan_type_id,
276: l_rev_plan_type_id
277: FROM pa_billing_extensions
278: WHERE billing_extension_id=pa_billing.GetBillingExtensionId;
279:
280: END IF;
281:
282:

Line 467: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');

463: -- If any exception then raise it to the calling pl/sql block
464: --
465: EXCEPTION
466: WHEN invalid_cost_budget_code THEN
467: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');
468: l_status := 1;
469: RAISE_APPLICATION_ERROR(-20101,status);
470: WHEN invalid_rev_budget_code THEN
471: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');

Line 471: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');

467: status := pa_billing_values.get_message('INVALID_COST_BUDGET_TYPE');
468: l_status := 1;
469: RAISE_APPLICATION_ERROR(-20101,status);
470: WHEN invalid_rev_budget_code THEN
471: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');
472: l_status := 2;
473: RAISE_APPLICATION_ERROR(-20101,status);
474: WHEN rev_budget_not_baselined THEN
475: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');

Line 475: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');

471: status := pa_billing_values.get_message('INVALID_REV_BUDGET_TYPE');
472: l_status := 2;
473: RAISE_APPLICATION_ERROR(-20101,status);
474: WHEN rev_budget_not_baselined THEN
475: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');
476: l_status := 3;
477: RAISE_APPLICATION_ERROR(-20101,status);
478: WHEN cost_budget_not_baselined THEN
479: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');

Line 479: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');

475: status := pa_billing_values.get_message('REV_BUDGET_NOT_BASELINED');
476: l_status := 3;
477: RAISE_APPLICATION_ERROR(-20101,status);
478: WHEN cost_budget_not_baselined THEN
479: status := pa_billing_values.get_message('COST_BUDGET_NOT_BASELINED');
480: l_status := 4;
481: RAISE_APPLICATION_ERROR(-20101,status);
482: WHEN OTHERS THEN
483: status := substr(SQLERRM,1,240);

Line 501: pa_billing_pub.insert_message

497:
498: X_error_message := status;
499: X_status := l_status;
500:
501: pa_billing_pub.insert_message
502: (X_inserting_procedure_name =>'pa_rev_ca.get_budget_amount',
503: X_attribute1 => l_cost_budget_type_code,
504: X_attribute2 => l_rev_budget_type_code,
505: X_message => status,

Line 579: pa_billing_pub.insert_event (

575:
576: --
577: -- Use the public api to create reversing events for each row
578: --
579: pa_billing_pub.insert_event (
580: X_rev_amt => (-1) * r_rec.revenue_amount,
581: X_bill_amt => 0,
582: X_event_type =>r_rec.event_type ,
583: X_event_description => event_description,

Line 734: pa_billing_pub.insert_event (

730: --
731: l_event_set_id := 'CONTRA-' ||x_project_id||'-'||nvl(x_top_task_id,0)||'-'
732: ||nvl(x_request_id,0);
733: /** public api to insert event **/
734: pa_billing_pub.insert_event (
735: X_rev_amt => cost_accrual,
736: X_bill_amt => 0,
737: X_event_type =>g_ca_contra_event_type ,
738: X_event_description => event_description,

Line 764: pa_billing_pub.insert_event (

760: --
761: -- In order to debit the cost accrual account the event is created with
762: -- a negative of the cost accrual amount
763: --
764: pa_billing_pub.insert_event (
765: X_rev_amt => (-1) * cost_accrual,
766: X_bill_amt => 0,
767: X_event_description => event_description,
768: X_event_type => g_ca_event_type ,

Line 934: pa_billing_pub.insert_event (

930: --
931: /** public api to insert event **/
932:
933: IF cost_WIP <> 0 THEN /* Added for bug 3788835: if project doesnot have EIs then this would be 0 */
934: pa_billing_pub.insert_event (
935: X_rev_amt => cost_WIP,
936: X_bill_amt => 0,
937: X_event_type => g_ca_wip_event_type ,
938: X_event_description => event_description,

Line 964: pa_billing_pub.insert_event (

960:
961: --
962: -- Create event to close the cost accrual contra account
963: --
964: pa_billing_pub.insert_event (
965: X_rev_amt => cost_accrual_contra,
966: X_bill_amt => 0,
967: X_event_description => event_description,
968: X_event_type => g_ca_contra_event_type ,

Line 997: pa_billing_pub.insert_event (

993: to_char(cost_WIP,fnd_currency.get_format_mask(l_currency_code,30))
994: || ' + ' ||
995: to_char(cost_accrual_contra,fnd_currency.get_format_mask(l_currency_code,30));
996:
997: pa_billing_pub.insert_event (
998: X_rev_amt => cost_accrual,
999: X_bill_amt => 0,
1000: X_event_description => event_description,
1001: X_event_type => g_ca_event_type,

Line 1123: FROM pa_billing_extensions

1119: -- cost accrual , cost accrual contra and cost WIP
1120:
1121: SELECT attribute12 , attribute13 , attribute14 , attribute15
1122: INTO g_ca_event_type ,g_ca_contra_event_type,g_ca_wip_event_type,g_ca_budget_type
1123: FROM pa_billing_extensions
1124: WHERE billing_extension_id = X_billing_extension_id;
1125:
1126: IF g1_debug_mode = 'Y' THEN
1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');

Line 1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');

1123: FROM pa_billing_extensions
1124: WHERE billing_extension_id = X_billing_extension_id;
1125:
1126: IF g1_debug_mode = 'Y' THEN
1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');
1128: END IF;
1129: /* Added for bug 2649456.Not handling exception intentionaly because if it is coming,
1130: it will be data issue */
1131: BEGIN

Line 1134: FROM pa_billing_extn_params_v;

1130: it will be data issue */
1131: BEGIN
1132: SELECT default_cost_plan_type_id,default_rev_plan_type_id
1133: INTO l_cost_plan_type_id,l_rev_plan_type_id
1134: FROM pa_billing_extn_params_v;
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF g1_debug_mode = 'Y' THEN
1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);

Line 1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);

1134: FROM pa_billing_extn_params_v;
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF g1_debug_mode = 'Y' THEN
1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);
1139: END IF;
1140: RAISE;
1141: END;
1142: /* till here */

Line 1145: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_rev_ca.calc_ca_amt :'||l_cost_plan_type_id);

1141: END;
1142: /* till here */
1143:
1144: IF g1_debug_mode = 'Y' THEN
1145: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_rev_ca.calc_ca_amt :'||l_cost_plan_type_id);
1146: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_rev_ca.calc_ca_amt :'||l_rev_plan_type_id);
1147: END IF;
1148:
1149:

Line 1146: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_rev_ca.calc_ca_amt :'||l_rev_plan_type_id);

1142: /* till here */
1143:
1144: IF g1_debug_mode = 'Y' THEN
1145: PA_MCB_INVOICE_PKG.log_message('pa billing params v.cost_plan_type_id pa_rev_ca.calc_ca_amt :'||l_cost_plan_type_id);
1146: PA_MCB_INVOICE_PKG.log_message('pa billing params v.rev_plan_type_id pa_rev_ca.calc_ca_amt :'||l_rev_plan_type_id);
1147: END IF;
1148:
1149:
1150: -- gets the cost and revenue budget amounts

Line 1152: -- else use the public api in package pa_billing_pub

1148:
1149:
1150: -- gets the cost and revenue budget amounts
1151: -- if budget type = 'R' then call the procedure defined in this package
1152: -- else use the public api in package pa_billing_pub
1153: --
1154: IF g_ca_budget_type = 'R' THEN
1155: pa_rev_ca.get_budget_amount(
1156: X2_project_id => X_project_id,

Line 1167: pa_billing_pub.get_budget_amount(

1163: P_rev_plan_type_id => l_rev_plan_type_id, /* Added for fin plan impact */
1164: X_error_message => l_error_message,
1165: X_status => l_status);
1166: ELSE
1167: pa_billing_pub.get_budget_amount(
1168: X2_project_id => X_project_id,
1169: X2_task_id => X_top_task_id,
1170: X2_revenue_amount => budget_revenue,
1171: X2_cost_amount => budget_cost,

Line 1820: from pa_billing_extensions be,

1816: l_ca_event_type,
1817: l_ca_contra_event_type,
1818: l_ca_wip_event_type,
1819: l_ca_budget_type
1820: from pa_billing_extensions be,
1821: pa_billing_assignments_all bea,
1822: pa_projects_all p
1823: where p.project_id = p_project_id
1824: and bea.active_flag = 'Y'

Line 1821: pa_billing_assignments_all bea,

1817: l_ca_contra_event_type,
1818: l_ca_wip_event_type,
1819: l_ca_budget_type
1820: from pa_billing_extensions be,
1821: pa_billing_assignments_all bea,
1822: pa_projects_all p
1823: where p.project_id = p_project_id
1824: and bea.active_flag = 'Y'
1825: and bea.billing_extension_id = be.billing_extension_id

Line 1856: from pa_billing_extensions be,

1852: l_ca_event_type,
1853: l_ca_contra_event_type,
1854: l_ca_wip_event_type,
1855: l_ca_budget_type
1856: from pa_billing_extensions be,
1857: pa_billing_assignments_all bea
1858: where bea.active_flag = 'Y'
1859: and bea.billing_extension_id = be.billing_extension_id
1860: and be.attribute11 = 'COST-ACCRUAL'

Line 1857: pa_billing_assignments_all bea

1853: l_ca_contra_event_type,
1854: l_ca_wip_event_type,
1855: l_ca_budget_type
1856: from pa_billing_extensions be,
1857: pa_billing_assignments_all bea
1858: where bea.active_flag = 'Y'
1859: and bea.billing_extension_id = be.billing_extension_id
1860: and be.attribute11 = 'COST-ACCRUAL'
1861: and bea.project_type = l_Project_Type