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.PJI_REP_UTIL dependencies on PA_PROJ_FP_OPTIONS

Line 853: FROM pa_proj_fp_options

849: AND projects.project_id = p_project_id;
850:
851: SELECT all_time_phased_code, cost_time_phased_code, revenue_time_phased_code
852: INTO l_all_cal_type, l_cost_cal_type, l_revenue_cal_type
853: FROM pa_proj_fp_options
854: WHERE project_id = p_project_id
855: AND fin_plan_version_id = l_working_version_id
856: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
857:

Line 861: FROM pa_proj_fp_options

857:
858: IF l_preference_code = 'SEP' THEN
859: SELECT revenue_time_phased_code
860: INTO l_revenue_cal_type
861: FROM pa_proj_fp_options
862: WHERE project_id = p_project_id
863: AND fin_plan_version_id = p_rev_version_id
864: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
865: END IF ;

Line 956: FROM pa_proj_fp_options

952: END IF;
953:
954: SELECT fin_plan_preference_code
955: INTO l_version_type
956: FROM pa_proj_fp_options
957: WHERE project_id = p_project_id
958: AND fin_plan_type_id = p_fin_plan_type_id
959: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
960:

Line 1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1002: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1003: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1004: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1005: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1006: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1007: l_temp_holder1 NUMBER;
1008: l_temp_holder2 NUMBER;
1009: BEGIN
1010:

Line 1365: FROM pa_proj_fp_options

1361: ** plan_type.
1362: */
1363: SELECT factor_by_code
1364: INTO l_factor_by_code
1365: FROM pa_proj_fp_options
1366: WHERE 1=1
1367: AND fin_plan_option_level_code = 'PLAN_VERSION'
1368: AND project_id = p_project_id
1369: AND fin_plan_version_id = p_fin_plan_version_id;

Line 1529: pa_proj_fp_options

1525:
1526: SELECT rbs_version_id
1527: INTO x_rbs_version_id
1528: FROM
1529: pa_proj_fp_options
1530: WHERE fin_plan_version_id = p_plan_version_id;
1531:
1532: IF x_rbs_version_id IS NULL THEN
1533: RAISE NO_DATA_FOUND;

Line 1983: , pa_proj_fp_options op

1979: , x_plan_report_mask
1980: , x_cost_app_flag
1981: , x_rev_app_flag
1982: FROM pa_fin_plan_types_vl pt
1983: , pa_proj_fp_options op
1984: WHERE 1=1
1985: AND pt.fin_plan_type_id = p_fin_plan_type_id
1986: AND op.fin_plan_type_id = pt.fin_plan_type_id
1987: AND op.fin_plan_option_level_code = 'PLAN_TYPE'

Line 2034: FROM pa_proj_fp_options op

2030: END IF;
2031:
2032: SELECT op.MARGIN_DERIVED_FROM_CODE
2033: INTO x_plan_margin_mask
2034: FROM pa_proj_fp_options op
2035: WHERE op.fin_plan_version_id = p_plan_version_id
2036: AND op.fin_plan_option_level_code = 'PLAN_VERSION'
2037: AND op.project_id = p_project_id;
2038:

Line 3464: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE

3460: */
3461: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
3462: ( p_project_id IN pa_projects_all.project_id%TYPE
3463: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3464: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3465: ,p_published_flag IN VARCHAR2
3466: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3467: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3468: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

Line 3468: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

3464: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3465: ,p_published_flag IN VARCHAR2
3466: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3467: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3468: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
3469: ,x_pc_flag OUT NOCOPY VARCHAR2
3470: ,x_pfc_flag OUT NOCOPY VARCHAR2
3471: ,x_margin_flag OUT NOCOPY VARCHAR2
3472: ,x_workpub_flag OUT NOCOPY VARCHAR2

Line 3737: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE

3733: */
3734: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
3735: ( p_project_id IN pa_projects_all.project_id%TYPE
3736: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3737: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3738: ,x_margin_flag OUT NOCOPY VARCHAR2
3739: ,x_return_status OUT NOCOPY VARCHAR2
3740: ,x_msg_count OUT NOCOPY NUMBER
3741: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3746: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)

3742: AS
3743:
3744: CURSOR check_margin_mask(c_project_id pa_projects_all.project_id%TYPE,
3745: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
3746: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
3747: IS
3748: SELECT 1
3749: FROM pji_xbs_denorm denorm,
3750: pji_pjp_wbs_header header,

Line 3751: pa_proj_fp_options opt

3747: IS
3748: SELECT 1
3749: FROM pji_xbs_denorm denorm,
3750: pji_pjp_wbs_header header,
3751: pa_proj_fp_options opt
3752: WHERE denorm.sup_project_id = c_project_id
3753: AND denorm.sup_id = c_wbs_version_id
3754: AND denorm.struct_type = 'PRG'
3755: AND denorm.struct_version_id IS NULL

Line 4034: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

4030: */
4031: PROCEDURE CHECK_WP_RBS_CONSISTENCY
4032: ( p_project_id IN pa_projects_all.project_id%TYPE
4033: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4034: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
4035: ,x_rbs_flag OUT NOCOPY VARCHAR2
4036: ,x_return_status OUT NOCOPY VARCHAR2
4037: ,x_msg_count OUT NOCOPY NUMBER
4038: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 4043: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)

4039: AS
4040:
4041: CURSOR check_rbs_flag(c_project_id pa_projects_all.project_id%TYPE,
4042: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4043: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4044: IS
4045: SELECT 1
4046: FROM pji_xbs_denorm denorm,
4047: pji_pjp_wbs_header header,

Line 4048: pa_proj_fp_options opt

4044: IS
4045: SELECT 1
4046: FROM pji_xbs_denorm denorm,
4047: pji_pjp_wbs_header header,
4048: pa_proj_fp_options opt
4049: WHERE denorm.sup_project_id = c_project_id
4050: AND denorm.sup_id = c_wbs_version_id
4051: AND denorm.struct_type = 'PRG'
4052: AND denorm.struct_version_id IS NULL

Line 4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

4331: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4332: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4333: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4334: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4335: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4336: l_temp_holder1 NUMBER;
4337: l_temp_holder2 NUMBER;
4338: l_temp_cstforecast_version_id NUMBER;
4339: l_tmp_orig_cstforecast_ver_id NUMBER;

Line 5266: FROM pa_proj_fp_options

5262: IF ( l_fin_plan_version_ids.COUNT > 0 ) THEN
5263: BEGIN
5264: SELECT DECODE(COUNT(DISTINCT rbs_version_id),l_count,'Y','N')
5265: INTO l_R_PlanVers_HavSame_RBS_Flag
5266: FROM pa_proj_fp_options
5267: WHERE 1=1
5268: AND fin_plan_option_level_code='PLAN_VERSION'
5269: AND fin_plan_version_id IN (l_fin_plan_version_ids(1),l_fin_plan_version_ids(2),l_fin_plan_version_ids(3),l_fin_plan_version_ids(4),
5270: l_fin_plan_version_ids(5),l_fin_plan_version_ids(6),l_fin_plan_version_ids(7),l_fin_plan_version_ids(8));

Line 5273: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);

5269: AND fin_plan_version_id IN (l_fin_plan_version_ids(1),l_fin_plan_version_ids(2),l_fin_plan_version_ids(3),l_fin_plan_version_ids(4),
5270: l_fin_plan_version_ids(5),l_fin_plan_version_ids(6),l_fin_plan_version_ids(7),l_fin_plan_version_ids(8));
5271:
5272: IF g_debug_mode = 'Y' THEN
5273: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);
5274: END IF;
5275:
5276: IF ( l_R_PlanVers_HavSame_RBS_Flag = 'Y') THEN
5277: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;

Line 5643: FROM pa_proj_fp_options

5639: END IF;
5640:
5641: SELECT COUNT(*)
5642: INTO l_plan_type_count
5643: FROM pa_proj_fp_options
5644: WHERE project_id = p_project_id
5645: AND fin_plan_type_id = p_plan_type_id
5646: AND fin_plan_option_level_code = 'PLAN_TYPE'
5647: AND ROWNUM =1;