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.

[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_PROJ_FP_OPTIONS

Line 91: pa_proj_fp_options fpo,

87: FROM
88: ( select p_project_id project_id from dual ) map,
89: -- pji_pjp_rbs_header rhd,
90: pa_budget_versions bv,
91: pa_proj_fp_options fpo,
92: -- pji_pa_proj_events_log pel,
93: pa_projects_all ppa,
94: pa_rbs_versions_b rvb --Added for bug#5728852
95: WHERE 1=1

Line 1189: FROM pa_proj_fp_options

1185: AND projects.project_id = p_project_id;
1186:
1187: SELECT all_time_phased_code, cost_time_phased_code, revenue_time_phased_code
1188: INTO l_all_cal_type, l_cost_cal_type, l_revenue_cal_type
1189: FROM pa_proj_fp_options
1190: WHERE project_id = p_project_id
1191: AND fin_plan_version_id = l_working_version_id
1192: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
1193:

Line 1197: FROM pa_proj_fp_options

1193:
1194: IF l_preference_code = 'SEP' THEN
1195: SELECT revenue_time_phased_code
1196: INTO l_revenue_cal_type
1197: FROM pa_proj_fp_options
1198: WHERE project_id = p_project_id
1199: AND fin_plan_version_id = p_rev_version_id
1200: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_VERSION;
1201: END IF ;

Line 1292: FROM pa_proj_fp_options

1288: END IF;
1289:
1290: SELECT fin_plan_preference_code
1291: INTO l_version_type
1292: FROM pa_proj_fp_options
1293: WHERE project_id = p_project_id
1294: AND fin_plan_type_id = p_fin_plan_type_id
1295: AND fin_plan_option_level_code = Pa_Fp_Constants_Pkg.G_OPTION_LEVEL_PLAN_TYPE;
1296:

Line 1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1338: l_cst_budget_version_type pa_budget_versions.version_type%TYPE;
1339: l_rev_budget_version_type pa_budget_versions.version_type%TYPE;
1340: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
1341: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
1342: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1343: l_temp_holder1 NUMBER;
1344: l_temp_holder2 NUMBER;
1345: BEGIN
1346:

Line 1725: FROM pa_proj_fp_options

1721: ** plan_type.
1722: */
1723: SELECT factor_by_code
1724: INTO l_factor_by_code
1725: FROM pa_proj_fp_options
1726: WHERE 1=1
1727: AND fin_plan_option_level_code = 'PLAN_VERSION'
1728: AND project_id = p_project_id
1729: AND fin_plan_version_id = p_fin_plan_version_id;

Line 1889: pa_proj_fp_options

1885:
1886: SELECT rbs_version_id
1887: INTO x_rbs_version_id
1888: FROM
1889: pa_proj_fp_options
1890: WHERE fin_plan_version_id = p_plan_version_id;
1891:
1892: IF x_rbs_version_id IS NULL THEN
1893: RAISE NO_DATA_FOUND;

Line 2373: , pa_proj_fp_options op

2369: , x_plan_report_mask
2370: , x_cost_app_flag
2371: , x_rev_app_flag
2372: FROM pa_fin_plan_types_vl pt
2373: , pa_proj_fp_options op
2374: WHERE 1=1
2375: AND pt.fin_plan_type_id = p_fin_plan_type_id
2376: AND op.fin_plan_type_id = pt.fin_plan_type_id
2377: AND op.fin_plan_option_level_code = 'PLAN_TYPE'

Line 2424: FROM pa_proj_fp_options op

2420: END IF;
2421:
2422: SELECT op.MARGIN_DERIVED_FROM_CODE
2423: INTO x_plan_margin_mask
2424: FROM pa_proj_fp_options op
2425: WHERE op.fin_plan_version_id = p_plan_version_id
2426: AND op.fin_plan_option_level_code = 'PLAN_VERSION'
2427: AND op.project_id = p_project_id;
2428:

Line 3908: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE

3904: */
3905: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
3906: ( p_project_id IN pa_projects_all.project_id%TYPE
3907: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3908: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3909: ,p_published_flag IN VARCHAR2
3910: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3911: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3912: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

Line 3912: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

3908: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3909: ,p_published_flag IN VARCHAR2
3910: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3911: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
3912: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
3913: ,x_pc_flag OUT NOCOPY VARCHAR2
3914: ,x_pfc_flag OUT NOCOPY VARCHAR2
3915: ,x_margin_flag OUT NOCOPY VARCHAR2
3916: ,x_workpub_flag OUT NOCOPY VARCHAR2

Line 4181: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE

4177: */
4178: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
4179: ( p_project_id IN pa_projects_all.project_id%TYPE
4180: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4181: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
4182: ,x_margin_flag OUT NOCOPY VARCHAR2
4183: ,x_return_status OUT NOCOPY VARCHAR2
4184: ,x_msg_count OUT NOCOPY NUMBER
4185: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 4190: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)

4186: AS
4187:
4188: CURSOR check_margin_mask(c_project_id pa_projects_all.project_id%TYPE,
4189: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4190: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
4191: IS
4192: SELECT 1
4193: FROM pji_xbs_denorm denorm,
4194: pji_pjp_wbs_header header,

Line 4195: pa_proj_fp_options opt

4191: IS
4192: SELECT 1
4193: FROM pji_xbs_denorm denorm,
4194: pji_pjp_wbs_header header,
4195: pa_proj_fp_options opt
4196: WHERE denorm.sup_project_id = c_project_id
4197: AND denorm.sup_id = c_wbs_version_id
4198: AND denorm.struct_type = 'PRG'
4199: AND denorm.struct_version_id IS NULL

Line 4478: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE

4474: */
4475: PROCEDURE CHECK_WP_RBS_CONSISTENCY
4476: ( p_project_id IN pa_projects_all.project_id%TYPE
4477: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4478: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
4479: ,x_rbs_flag OUT NOCOPY VARCHAR2
4480: ,x_return_status OUT NOCOPY VARCHAR2
4481: ,x_msg_count OUT NOCOPY NUMBER
4482: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 4487: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)

4483: AS
4484:
4485: CURSOR check_rbs_flag(c_project_id pa_projects_all.project_id%TYPE,
4486: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4487: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4488: IS
4489: SELECT 1
4490: FROM pji_xbs_denorm denorm,
4491: pji_pjp_wbs_header header,

Line 4492: pa_proj_fp_options opt

4488: IS
4489: SELECT 1
4490: FROM pji_xbs_denorm denorm,
4491: pji_pjp_wbs_header header,
4492: pa_proj_fp_options opt
4493: WHERE denorm.sup_project_id = c_project_id
4494: AND denorm.sup_id = c_wbs_version_id
4495: AND denorm.struct_type = 'PRG'
4496: AND denorm.struct_version_id IS NULL

Line 4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

4775: l_cst_budget2_version_type pa_budget_versions.version_type%TYPE;
4776: l_rev_budget2_version_type pa_budget_versions.version_type%TYPE;
4777: l_cst_forecast_version_type pa_budget_versions.version_type%TYPE;
4778: l_rev_forecast_version_type pa_budget_versions.version_type%TYPE;
4779: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4780: l_temp_holder1 NUMBER;
4781: l_temp_holder2 NUMBER;
4782: l_temp_cstforecast_version_id NUMBER;
4783: l_tmp_orig_cstforecast_ver_id NUMBER;

Line 5750: FROM pa_proj_fp_options

5746: IF ( l_fin_plan_version_ids.COUNT > 0 ) THEN
5747: BEGIN
5748: SELECT DECODE(COUNT(DISTINCT rbs_version_id),l_count,'Y','N')
5749: INTO l_R_PlanVers_HavSame_RBS_Flag
5750: FROM pa_proj_fp_options
5751: WHERE 1=1
5752: AND fin_plan_option_level_code='PLAN_VERSION'
5753: 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),
5754: 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 5757: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);

5753: 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),
5754: l_fin_plan_version_ids(5),l_fin_plan_version_ids(6),l_fin_plan_version_ids(7),l_fin_plan_version_ids(8));
5755:
5756: IF g_debug_mode = 'Y' THEN
5757: Pji_Utils.WRITE2LOG( 'Chk_plan_vers_have_same_RBS: Done selecting from pa_proj_fp_options table ', TRUE , g_proc);
5758: END IF;
5759:
5760: IF ( l_R_PlanVers_HavSame_RBS_Flag = 'Y') THEN
5761: x_R_PlanVers_HavSame_RBS_Flag := l_R_PlanVers_HavSame_RBS_Flag;

Line 6127: FROM pa_proj_fp_options

6123: END IF;
6124:
6125: SELECT COUNT(*)
6126: INTO l_plan_type_count
6127: FROM pa_proj_fp_options
6128: WHERE project_id = p_project_id
6129: AND fin_plan_type_id = p_plan_type_id
6130: AND fin_plan_option_level_code = 'PLAN_TYPE'
6131: AND ROWNUM =1;