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_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_TYPES_B

Line 105: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

101:
102: -- FP M Dev Effort new variables
103:
104: l_default_gen_options_rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
105: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
106:
107: -- 3/30/2004 FP M Phase II Dev Effort
108:
109: l_gl_start_period gl_periods.period_name%TYPE;

Line 134: FROM pa_fin_plan_types_b

130: ,nvl(approved_rev_plan_type_flag,'N') approved_rev_plan_type_flag
131: ,nvl(primary_cost_forecast_flag,'N') primary_cost_forecast_flag
132: ,nvl(primary_rev_forecast_flag,'N') primary_rev_forecast_flag
133: ,nvl(use_for_workplan_flag,'N') use_for_workplan_flag
134: FROM pa_fin_plan_types_b
135: WHERE fin_plan_type_id = c_fin_plan_type_id;
136:
137:
138: CURSOR opt_info_Cur (c_proj_fp_options_id NUMBER) IS

Line 304: pa_fin_plan_types_b pt

300: l_source_project_id,
301: l_source_plan_class_code,
302: l_source_plan_type_id -- Added this to get the source plan type id for copying the amount types
303: FROM pa_proj_fp_options pfo,
304: pa_fin_plan_types_b pt
305: WHERE pfo.proj_fp_options_id = p_source_proj_fp_option_id
306: AND pfo.fin_plan_type_id = pt.fin_plan_type_id(+);
307:
308: END IF;

Line 411: ,pa_fin_plan_types_b ptb

407: ,NVL(approved_rev_plan_type_flag,'N')
408: INTO l_baseline_funding_flag
409: ,l_approved_rev_plan_type_flag
410: FROM pa_projects_all ppa
411: ,pa_fin_plan_types_b ptb
412: WHERE ppa.project_id = p_target_project_id
413: AND ptb.fin_plan_type_id = p_target_plan_type_id;
414:
415: END IF;

Line 524: pa_fin_plan_types_b pt

520: INTO l_source_fp_preference_code,
521: l_source_option_level_code,
522: l_source_plan_class_code
523: FROM pa_proj_fp_options pfo,
524: pa_fin_plan_types_b pt
525: WHERE pfo.proj_fp_options_id = l_par_proj_fp_options_id
526: AND pfo.fin_plan_type_id = pt.fin_plan_type_id(+);
527: EXCEPTION
528: WHEN NO_DATA_FOUND THEN

Line 2752: FROM pa_fin_plan_types_b

2748: ,nvl(approved_rev_plan_type_flag,'N') approved_rev_plan_type_flag
2749: ,nvl(primary_cost_forecast_flag,'N') primary_cost_forecast_flag
2750: ,nvl(primary_rev_forecast_flag,'N') primary_rev_forecast_flag
2751: ,nvl(use_for_workplan_flag,'N') use_for_workplan_flag
2752: FROM pa_fin_plan_types_b
2753: WHERE fin_plan_type_id = c_plan_type_id;
2754:
2755: plan_type_info_rec plan_type_info_cur%ROWTYPE;
2756:

Line 2877: ,pa_fin_plan_types_b ptb

2873: ,NVL(approved_rev_plan_type_flag,'N')
2874: INTO l_autobaseline_flag
2875: ,l_app_rev_plan_type_flag
2876: FROM pa_projects_all ppa
2877: ,pa_fin_plan_types_b ptb
2878: WHERE ppa.project_id = p_target_project_id
2879: AND ptb.fin_plan_type_id = p_plan_type_id;
2880:
2881: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3189: ,pa_fin_plan_types_b pt

3185: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3186: INTO l_fp_cols_rec.gen_src_cost_plan_type_id
3187: ,l_fp_cols_rec.gen_src_cost_plan_ver_code -- Bug 3572548
3188: FROM pa_proj_fp_options o
3189: ,pa_fin_plan_types_b pt
3190: WHERE o.project_id = p_target_project_id
3191: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3192: AND o.fin_plan_type_id = pt.fin_plan_type_id
3193: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3328: ,pa_fin_plan_types_b pt

3324: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3325: INTO l_fp_cols_rec.gen_src_rev_plan_type_id
3326: ,l_fp_cols_rec.gen_src_rev_plan_ver_code -- Bug 3572548
3327: FROM pa_proj_fp_options o
3328: ,pa_fin_plan_types_b pt
3329: WHERE o.project_id = p_target_project_id
3330: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3331: AND o.fin_plan_type_id = pt.fin_plan_type_id
3332: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3423: ,pa_fin_plan_types_b pt

3419: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3420: INTO l_fp_cols_rec.gen_src_all_plan_type_id
3421: ,l_fp_cols_rec.gen_src_all_plan_ver_code -- Bug 3572548
3422: FROM pa_proj_fp_options o
3423: ,pa_fin_plan_types_b pt
3424: WHERE o.project_id = p_target_project_id
3425: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3426: AND o.fin_plan_type_id = pt.fin_plan_type_id
3427: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3613: FROM pa_fin_plan_types_b

3609: ,project_rev_rate_type
3610: ,project_rev_rate_date_type
3611: ,project_rev_rate_date
3612: INTO l_fp_mc_cols_rec
3613: FROM pa_fin_plan_types_b
3614: WHERE fin_plan_type_id = p_fin_plan_type_id;
3615: RETURN l_fp_mc_cols_rec;
3616: EXCEPTION
3617: WHEN OTHERS THEN

Line 4339: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4335: ===================================================================================*/
4336:
4337: PROCEDURE Create_amt_types (
4338: p_project_id IN pa_projects_all.project_id%TYPE
4339: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4340: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
4341: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
4342: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE
4343: ,p_all_layout_code IN pa_proj_fp_options.all_layout_code%TYPE

Line 4349: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4345: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4346: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4347: ) IS
4348:
4349: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4350: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4351: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4352: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4353: l_cost_layout_type_code VARCHAR2(30);

Line 4416: FROM pa_fin_plan_types_b

4412: --getting the plan class code
4413:
4414: SELECT plan_class_code
4415: INTO l_plan_class_code
4416: FROM pa_fin_plan_types_b
4417: WHERE fin_plan_type_id = p_fin_plan_type_id;
4418:
4419: IF l_debug_mode = 'Y' THEN
4420: pa_debug.g_err_stage:= 'p_cost_layout_code:: ' || p_cost_layout_code || '::p_revenue_layout_code::' || p_revenue_layout_code || '::p_all_layout_code::' || p_all_layout_code;

Line 4802: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4798: ===================================================================================*/
4799:
4800: PROCEDURE copy_amt_types (
4801: p_source_project_id IN pa_projects_all.project_id%TYPE
4802: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4803: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4804: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4805: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4806: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4804: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4800: PROCEDURE copy_amt_types (
4801: p_source_project_id IN pa_projects_all.project_id%TYPE
4802: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4803: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4804: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4805: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4806: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4807: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4808: ) IS

Line 4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4926:
4927: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4928: PROCEDURE update_amt_types (
4929: p_project_id IN pa_projects_all.project_id%TYPE
4930: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4931: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4932: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4933: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4934: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type