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

Line 1132: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

1128:
1129: l_bv_rec l_bv_csr%ROWTYPE;
1130:
1131: -- Bug 3927244
1132: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1133: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1134:
1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
1136: SELECT pfb.plan_class_code,pbv.project_id

Line 1133: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

1129: l_bv_rec l_bv_csr%ROWTYPE;
1130:
1131: -- Bug 3927244
1132: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1133: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1134:
1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
1136: SELECT pfb.plan_class_code,pbv.project_id
1137: FROM pa_fin_plan_types_b pfb,

Line 1137: FROM pa_fin_plan_types_b pfb,

1133: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
1134:
1135: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
1136: SELECT pfb.plan_class_code,pbv.project_id
1137: FROM pa_fin_plan_types_b pfb,
1138: pa_budget_versions pbv
1139: WHERE pbv.budget_version_id = c_budget_version_id
1140: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
1141: -- Bug 3927244

Line 4087: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

4083: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4084: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4085: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4086: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4087: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
4088: p_derv_rates_missing_amts_flag IN VARCHAR2,
4089: p_adj_percentage IN NUMBER,
4090: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4091: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4724: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4720:
4721: l_adj_percentage NUMBER ;
4722: l_period_profiles_same_flag VARCHAR2(1);
4723:
4724: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4725: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4726: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4727:
4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

Line 4725: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4721: l_adj_percentage NUMBER ;
4722: l_period_profiles_same_flag VARCHAR2(1);
4723:
4724: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4725: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4726: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4727:
4728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4729: l_temp NUMBER;

Line 4739: FROM pa_fin_plan_types_b pfb,

4735:
4736: -- Bug 4493425: Added pbv.project_id in the select.
4737: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
4738: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date,pbv.version_type,pbv.project_id
4739: FROM pa_fin_plan_types_b pfb,
4740: pa_budget_versions pbv
4741: WHERE pbv.budget_version_id = c_budget_version_id
4742: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
4743: -- Bug 3927244

Line 6881: ,pa_fin_plan_types_b fin

6877: SELECT pfo.proj_fp_options_id
6878: ,pfo.fin_plan_type_id
6879: ,pfo.fin_plan_preference_code
6880: FROM pa_proj_fp_options pfo
6881: ,pa_fin_plan_types_b fin
6882: WHERE project_id = p_source_project_id
6883: AND fin_plan_option_level_code = c_level_code
6884: AND pfo.fin_plan_type_id = fin.fin_plan_type_id(+)
6885: AND nvl(fin.use_for_workplan_flag,'N')<>'Y';

Line 8748: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

8744: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8745: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8746: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8747: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8748: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8749: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8750: l_pji_rollup_required VARCHAR(1);
8751:
8752: -- pjdvdsn1 compile issues, 03-FEB-2004, jwhite -------------------------

Line 8900: FROM pa_fin_plan_types_b

8896:
8897: BEGIN
8898: SELECT fin_plan_type_id
8899: INTO l_wp_plan_type_id
8900: FROM pa_fin_plan_types_b
8901: WHERE use_for_workplan_flag='Y';
8902: EXCEPTION
8903: WHEN NO_DATA_FOUND THEN
8904: IF l_debug_mode = 'Y' THEN

Line 9478: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

9474: --Bug 4290043.
9475: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9476: l_source_version_type pa_budget_versions.version_type%TYPE;
9477: l_target_version_type pa_budget_versions.version_type%TYPE;
9478: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
9479:
9480: BEGIN
9481:
9482: x_msg_count := 0;

Line 9564: pa_fin_plan_types_b fin

9560: fin.plan_class_code
9561: INTO l_source_version_type,
9562: l_src_plan_class_code
9563: FROM pa_budget_versions pbv,
9564: pa_fin_plan_types_b fin
9565: WHERE pbv.fin_plan_type_id=fin.fin_plan_type_id
9566: AND pbv.budget_version_id = p_source_plan_version_id;
9567:
9568: DELETE FROM PA_FP_BL_MAP_TMP;

Line 10128: ,pa_fin_plan_types_b fpt

10124: ,pfo.cost_non_labor_res_rate_sch_id
10125: ,pfo.cost_res_class_rate_sch_id
10126: ,pfo.cost_burden_rate_sch_id
10127: FROM pa_proj_fp_options pfo
10128: ,pa_fin_plan_types_b fpt
10129: WHERE pfo.project_id = p_project_id
10130: AND pfo.fin_plan_type_id = fpt.fin_plan_type_id
10131: AND fpt.use_for_workplan_flag = 'Y'
10132: AND pfo.fin_plan_option_level_code = 'PLAN_TYPE';