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.FPA_VALIDATION_PROCESS_PVT dependencies on FND_PROFILE

Line 71: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST'),

67:
68: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
69:
70: select
71: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST'),
72: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
73: into l_cost_plan_type, l_benefit_plan_type from dual;
74: if(l_cost_plan_type is null or l_benefit_plan_type is null) then
75: return;

Line 72: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')

68: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
69:
70: select
71: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_COST'),
72: fnd_profile.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
73: into l_cost_plan_type, l_benefit_plan_type from dual;
74: if(l_cost_plan_type is null or l_benefit_plan_type is null) then
75: return;
76: end if;

Line 489: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_COST') = C.FIN_PLAN_TYPE_ID (+)

485: PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B,
486: FPA_AW_PROJ_INFO_V S
487: WHERE
488: 'B' = C.BUDGET_STATUS_CODE (+) AND 'Y' = C.CURRENT_FLAG (+)
489: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_COST') = C.FIN_PLAN_TYPE_ID (+)
490: AND S.PROJECT = C.PROJECT_ID (+)
491: AND 'B' = B.BUDGET_STATUS_CODE (+) AND 'Y' = B.CURRENT_FLAG (+)
492: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = B.FIN_PLAN_TYPE_ID (+)
493: AND S.PROJECT = B.PROJECT_ID (+)

Line 492: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = B.FIN_PLAN_TYPE_ID (+)

488: 'B' = C.BUDGET_STATUS_CODE (+) AND 'Y' = C.CURRENT_FLAG (+)
489: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_COST') = C.FIN_PLAN_TYPE_ID (+)
490: AND S.PROJECT = C.PROJECT_ID (+)
491: AND 'B' = B.BUDGET_STATUS_CODE (+) AND 'Y' = B.CURRENT_FLAG (+)
492: AND FND_PROFILE.value('PJP_FINANCIAL_PLAN_TYPE_BENEFIT') = B.FIN_PLAN_TYPE_ID (+)
493: AND S.PROJECT = B.PROJECT_ID (+)
494: AND S.SCENARIO = P_SCENARIO_ID;
495:
496: L_PC_ID NUMBER := NULL;

Line 736: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_COST'') = C.FIN_PLAN_TYPE_ID (+) '

732: || 'DECODE(C.BUDGET_VERSION_ID,NULL,-1,C.BUDGET_VERSION_ID) COST_BUDGET_VERSN_ID, '
733: || 'DECODE(B.BUDGET_VERSION_ID,NULL,-1,B.BUDGET_VERSION_ID) BENF_BUDGET_VERSN_ID '
734: || 'FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B '
735: || 'WHERE ''B'' = C.BUDGET_STATUS_CODE (+) AND ''Y'' = C.CURRENT_FLAG (+) '
736: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_COST'') = C.FIN_PLAN_TYPE_ID (+) '
737: || 'AND ''B'' = B.BUDGET_STATUS_CODE (+) AND ''Y'' = B.CURRENT_FLAG (+) '
738: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_BENEFIT'') = B.FIN_PLAN_TYPE_ID (+) '
739: || 'AND P.PROJECT_ID = C.PROJECT_ID (+) AND P.PROJECT_ID = B.PROJECT_ID (+) '
740: || 'AND P.PROJECT_ID = :1';

Line 738: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_BENEFIT'') = B.FIN_PLAN_TYPE_ID (+) '

734: || 'FROM PA_PROJECTS_ALL P, PA_BUDGET_VERSIONS C, PA_BUDGET_VERSIONS B '
735: || 'WHERE ''B'' = C.BUDGET_STATUS_CODE (+) AND ''Y'' = C.CURRENT_FLAG (+) '
736: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_COST'') = C.FIN_PLAN_TYPE_ID (+) '
737: || 'AND ''B'' = B.BUDGET_STATUS_CODE (+) AND ''Y'' = B.CURRENT_FLAG (+) '
738: || 'AND fnd_profile.value(''PJP_FINANCIAL_PLAN_TYPE_BENEFIT'') = B.FIN_PLAN_TYPE_ID (+) '
739: || 'AND P.PROJECT_ID = C.PROJECT_ID (+) AND P.PROJECT_ID = B.PROJECT_ID (+) '
740: || 'AND P.PROJECT_ID = :1';
741:
742: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1038: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST'),

1034:
1035: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1036:
1037: SELECT
1038: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST'),
1039: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
1040: INTO L_COST_PLAN_TYPE, L_BENEFIT_PLAN_TYPE FROM DUAL;
1041:
1042: if(l_cost_plan_type is null or l_benefit_plan_type is null) then

Line 1039: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')

1035: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1036:
1037: SELECT
1038: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_COST'),
1039: FND_PROFILE.VALUE('PJP_FINANCIAL_PLAN_TYPE_BENEFIT')
1040: INTO L_COST_PLAN_TYPE, L_BENEFIT_PLAN_TYPE FROM DUAL;
1041:
1042: if(l_cost_plan_type is null or l_benefit_plan_type is null) then
1043: return;