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_FP_ADJUSTMENT_UTILS dependencies on PA_FP_ADJUSTMENT_UTILS

Line 1: PACKAGE BODY PA_FP_ADJUSTMENT_UTILS AS

1: PACKAGE BODY PA_FP_ADJUSTMENT_UTILS AS
2: -- $Header: PAFPADJB.pls 120.5 2007/11/26 07:50:38 vgovvala ship $
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: L_MODULE varchar2(100) := 'PA_FP_ADJUSTMENT_UTILS';

Line 5: L_MODULE varchar2(100) := 'PA_FP_ADJUSTMENT_UTILS';

1: PACKAGE BODY PA_FP_ADJUSTMENT_UTILS AS
2: -- $Header: PAFPADJB.pls 120.5 2007/11/26 07:50:38 vgovvala ship $
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: L_MODULE varchar2(100) := 'PA_FP_ADJUSTMENT_UTILS';
6: L_FuncProc varchar2(250) := 'DEFAULT';
7: li_message_level NUMBER := 1;
8: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:

Line 381: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :1, :2, ' ||

377: ' NVL(SUM(BL.PROJECT_RAW_COST),0) PC_RAW_COST, ' ||
378: ' NVL(SUM(BL.PROJECT_BURDENED_COST),0) PC_BURDENED_COST, ' ;
379:
380: l_sql := l_sql ||
381: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :1, :2, ' ||
382: ' BL.PROJECT_REVENUE)),0) PC_REVENUE, ' ||
383: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :3, :4, ' ||
384: ' BL.REVENUE)),0) PFC_REVENUE, ' ;
385:

Line 383: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :3, :4, ' ||

379:
380: l_sql := l_sql ||
381: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :1, :2, ' ||
382: ' BL.PROJECT_REVENUE)),0) PC_REVENUE, ' ||
383: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :3, :4, ' ||
384: ' BL.REVENUE)),0) PFC_REVENUE, ' ;
385:
386: l_sql := l_sql ||
387: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :5, null, :6, :7, ' ||

Line 387: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :5, null, :6, :7, ' ||

383: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(bl.budget_version_id, :3, :4, ' ||
384: ' BL.REVENUE)),0) PFC_REVENUE, ' ;
385:
386: l_sql := l_sql ||
387: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :5, null, :6, :7, ' ||
388: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
389: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :8, null, :9, :10, ' ||
390: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
391: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :11, :12, :13, ' ||

Line 389: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :8, null, :9, :10, ' ||

385:
386: l_sql := l_sql ||
387: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :5, null, :6, :7, ' ||
388: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
389: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :8, null, :9, :10, ' ||
390: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
391: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :11, :12, :13, ' ||
392: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
393: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :14, :15, :16, ' ||

Line 391: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :11, :12, :13, ' ||

387: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :5, null, :6, :7, ' ||
388: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
389: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :8, null, :9, :10, ' ||
390: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
391: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :11, :12, :13, ' ||
392: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
393: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :14, :15, :16, ' ||
394: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_EQUIP_HOURS ' ;
395:

Line 393: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :14, :15, :16, ' ||

389: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, :8, null, :9, :10, ' ||
390: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
391: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :11, :12, :13, ' ||
392: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
393: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(bl.budget_version_id, null, :14, :15, :16, ' ||
394: ' ra.resource_class_code, bl.quantity, ra.rate_based_flag)),0),2) TOTAL_REV_EQUIP_HOURS ' ;
395:
396: l_sql := l_sql || ' FROM PA_BUDGET_LINES BL, PA_RESOURCE_ASSIGNMENTS RA ' ||
397: ' where bl.resource_assignment_id = ra.resource_assignment_id ' ||

Line 458: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :1, :2, ' ||

454: ' NVL(SUM(TOTAL_PROJECT_RAW_COST),0) PC_RAW_COST, ' ||
455: ' NVL(SUM(TOTAL_PROJECT_BURDENED_COST),0) PC_BURDENED_COST, ' ;
456:
457: l_sql := l_sql ||
458: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :1, :2, ' ||
459: ' TOTAL_PROJECT_REVENUE)),0) PC_REVENUE, ' ||
460: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :3, :4, ' ||
461: ' TOTAL_PLAN_REVENUE)),0) PFC_REVENUE, ' ;
462:

Line 460: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :3, :4, ' ||

456:
457: l_sql := l_sql ||
458: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :1, :2, ' ||
459: ' TOTAL_PROJECT_REVENUE)),0) PC_REVENUE, ' ||
460: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :3, :4, ' ||
461: ' TOTAL_PLAN_REVENUE)),0) PFC_REVENUE, ' ;
462:
463: l_sql := l_sql ||
464: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :5, null, :6, :7, ' ||

Line 464: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :5, null, :6, :7, ' ||

460: ' NVL(SUM(PA_FP_ADJUSTMENT_UTILS.revenue(budget_version_id, :3, :4, ' ||
461: ' TOTAL_PLAN_REVENUE)),0) PFC_REVENUE, ' ;
462:
463: l_sql := l_sql ||
464: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :5, null, :6, :7, ' ||
465: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
466: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :8, null, :9, :10, ' ||
467: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
468: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :11, :12, :13, ' ||

Line 466: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :8, null, :9, :10, ' ||

462:
463: l_sql := l_sql ||
464: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :5, null, :6, :7, ' ||
465: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
466: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :8, null, :9, :10, ' ||
467: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
468: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :11, :12, :13, ' ||
469: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
470: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :14, :15, :16, ' ||

Line 468: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :11, :12, :13, ' ||

464: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :5, null, :6, :7, ' ||
465: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_LABOR_HOURS, ' ||
466: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :8, null, :9, :10, ' ||
467: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
468: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :11, :12, :13, ' ||
469: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
470: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :14, :15, :16, ' ||
471: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_REV_EQUIP_HOURS ' ;
472:

Line 470: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :14, :15, :16, ' ||

466: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, :8, null, :9, :10, ' ||
467: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_EQUIP_HOURS, ' ||
468: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :11, :12, :13, ' ||
469: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_REV_LABOR_HOURS, ' ||
470: ' ROUND(NVL(SUM(PA_FP_ADJUSTMENT_UTILS.class_hours(budget_version_id, null, :14, :15, :16, ' ||
471: ' resource_class_code, total_plan_quantity, rate_based_flag)),0),2) TOTAL_REV_EQUIP_HOURS ' ;
472:
473: l_sql := l_sql || ' FROM PA_RESOURCE_ASSIGNMENTS ' ||
474: ' where resource_assignment_id in ( ';

Line 2264: END PA_FP_ADJUSTMENT_UTILS ;

2260: END;
2261:
2262: --Messages --Use PA_NO_ACCESS_TO_UPDATE and
2263: -- PA_ALL_NO_UPDATE_RECORD
2264: END PA_FP_ADJUSTMENT_UTILS ;