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 2797: FROM pa_fin_plan_types_b

2793: ,nvl(approved_rev_plan_type_flag,'N') approved_rev_plan_type_flag
2794: ,nvl(primary_cost_forecast_flag,'N') primary_cost_forecast_flag
2795: ,nvl(primary_rev_forecast_flag,'N') primary_rev_forecast_flag
2796: ,nvl(use_for_workplan_flag,'N') use_for_workplan_flag
2797: FROM pa_fin_plan_types_b
2798: WHERE fin_plan_type_id = c_plan_type_id;
2799:
2800: plan_type_info_rec plan_type_info_cur%ROWTYPE;
2801:

Line 2922: ,pa_fin_plan_types_b ptb

2918: ,NVL(approved_rev_plan_type_flag,'N')
2919: INTO l_autobaseline_flag
2920: ,l_app_rev_plan_type_flag
2921: FROM pa_projects_all ppa
2922: ,pa_fin_plan_types_b ptb
2923: WHERE ppa.project_id = p_target_project_id
2924: AND ptb.fin_plan_type_id = p_plan_type_id;
2925:
2926: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3234: ,pa_fin_plan_types_b pt

3230: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3231: INTO l_fp_cols_rec.gen_src_cost_plan_type_id
3232: ,l_fp_cols_rec.gen_src_cost_plan_ver_code -- Bug 3572548
3233: FROM pa_proj_fp_options o
3234: ,pa_fin_plan_types_b pt
3235: WHERE o.project_id = p_target_project_id
3236: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3237: AND o.fin_plan_type_id = pt.fin_plan_type_id
3238: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3373: ,pa_fin_plan_types_b pt

3369: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3370: INTO l_fp_cols_rec.gen_src_rev_plan_type_id
3371: ,l_fp_cols_rec.gen_src_rev_plan_ver_code -- Bug 3572548
3372: FROM pa_proj_fp_options o
3373: ,pa_fin_plan_types_b pt
3374: WHERE o.project_id = p_target_project_id
3375: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3376: AND o.fin_plan_type_id = pt.fin_plan_type_id
3377: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3468: ,pa_fin_plan_types_b pt

3464: 'FORECAST','CURRENT_APPROVED') -- Bug 3572548
3465: INTO l_fp_cols_rec.gen_src_all_plan_type_id
3466: ,l_fp_cols_rec.gen_src_all_plan_ver_code -- Bug 3572548
3467: FROM pa_proj_fp_options o
3468: ,pa_fin_plan_types_b pt
3469: WHERE o.project_id = p_target_project_id
3470: AND o.fin_plan_option_level_code = 'PLAN_TYPE'
3471: AND o.fin_plan_type_id = pt.fin_plan_type_id
3472: AND nvl(pt.use_for_workplan_flag,'N') = 'N' -- bug 3429026

Line 3658: FROM pa_fin_plan_types_b

3654: ,project_rev_rate_type
3655: ,project_rev_rate_date_type
3656: ,project_rev_rate_date
3657: INTO l_fp_mc_cols_rec
3658: FROM pa_fin_plan_types_b
3659: WHERE fin_plan_type_id = p_fin_plan_type_id;
3660: RETURN l_fp_mc_cols_rec;
3661: EXCEPTION
3662: WHEN OTHERS THEN

Line 4384: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4380: ===================================================================================*/
4381:
4382: PROCEDURE Create_amt_types (
4383: p_project_id IN pa_projects_all.project_id%TYPE
4384: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4385: ,p_plan_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
4386: ,p_cost_layout_code IN pa_proj_fp_options.cost_layout_code%TYPE
4387: ,p_revenue_layout_code IN pa_proj_fp_options.revenue_layout_code%TYPE
4388: ,p_all_layout_code IN pa_proj_fp_options.all_layout_code%TYPE

Line 4394: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4390: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4391: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4392: ) IS
4393:
4394: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4395: l_cost_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4396: l_rev_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4397: l_all_amount_types_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
4398: l_cost_layout_type_code VARCHAR2(30);

Line 4461: FROM pa_fin_plan_types_b

4457: --getting the plan class code
4458:
4459: SELECT plan_class_code
4460: INTO l_plan_class_code
4461: FROM pa_fin_plan_types_b
4462: WHERE fin_plan_type_id = p_fin_plan_type_id;
4463:
4464: IF l_debug_mode = 'Y' THEN
4465: 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 4847: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4843: ===================================================================================*/
4844:
4845: PROCEDURE copy_amt_types (
4846: p_source_project_id IN pa_projects_all.project_id%TYPE
4847: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4848: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4849: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4849: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4845: PROCEDURE copy_amt_types (
4846: p_source_project_id IN pa_projects_all.project_id%TYPE
4847: ,p_source_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4848: ,p_target_project_id IN pa_projects_all.project_id%TYPE
4849: ,p_target_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4850: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4851: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4852: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4853: ) IS

Line 4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

4971:
4972: -- This procedure is used to update the amount types for the periodic budget or forcasts of an existing plan type
4973: PROCEDURE update_amt_types (
4974: p_project_id IN pa_projects_all.project_id%TYPE
4975: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
4976: ,p_add_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4977: ,p_del_cost_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4978: ,p_add_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type
4979: ,p_del_rev_amt_types_tbl IN SYSTEM.pa_varchar2_30_tbl_type