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 4099: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

4095: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4096: p_targ_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
4097: p_source_version_type IN pa_budget_versions.version_type%TYPE,
4098: p_target_version_type IN pa_budget_versions.version_type%TYPE,
4099: p_src_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
4100: p_derv_rates_missing_amts_flag IN VARCHAR2,
4101: p_adj_percentage IN NUMBER,
4102: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4103: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4736: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4732:
4733: l_adj_percentage NUMBER ;
4734: l_period_profiles_same_flag VARCHAR2(1);
4735:
4736: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4737: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4738: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4739:
4740: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

Line 4737: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

4733: l_adj_percentage NUMBER ;
4734: l_period_profiles_same_flag VARCHAR2(1);
4735:
4736: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4737: l_trg_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
4738: l_wp_version_flag pa_budget_versions.wp_version_flag%TYPE;
4739:
4740: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
4741: l_temp NUMBER;

Line 4751: FROM pa_fin_plan_types_b pfb,

4747:
4748: -- Bug 4493425: Added pbv.project_id in the select.
4749: CURSOR get_plan_class_code_csr(c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
4750: SELECT pfb.plan_class_code,nvl(pbv.wp_version_flag,'N'),etc_start_date,pbv.version_type,pbv.project_id
4751: FROM pa_fin_plan_types_b pfb,
4752: pa_budget_versions pbv
4753: WHERE pbv.budget_version_id = c_budget_version_id
4754: AND pbv.fin_plan_type_id = pfb.fin_plan_type_id;
4755: -- Bug 3927244

Line 6898: ,pa_fin_plan_types_b fin

6894: SELECT pfo.proj_fp_options_id
6895: ,pfo.fin_plan_type_id
6896: ,pfo.fin_plan_preference_code
6897: FROM pa_proj_fp_options pfo
6898: ,pa_fin_plan_types_b fin
6899: WHERE project_id = p_source_project_id
6900: AND fin_plan_option_level_code = c_level_code
6901: AND pfo.fin_plan_type_id = fin.fin_plan_type_id(+)
6902: AND nvl(fin.use_for_workplan_flag,'N')<>'Y';

Line 8775: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

8771: l_shift_days NUMBER :=0;--SHOULD BE REMOVED LATER
8772: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8773: l_src_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8774: l_targ_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
8775: l_wp_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8776: l_targ_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
8777: l_pji_rollup_required VARCHAR(1);
8778:
8779: -- pjdvdsn1 compile issues, 03-FEB-2004, jwhite -------------------------

Line 8927: FROM pa_fin_plan_types_b

8923:
8924: BEGIN
8925: SELECT fin_plan_type_id
8926: INTO l_wp_plan_type_id
8927: FROM pa_fin_plan_types_b
8928: WHERE use_for_workplan_flag='Y';
8929: EXCEPTION
8930: WHEN NO_DATA_FOUND THEN
8931: IF l_debug_mode = 'Y' THEN

Line 9505: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

9501: --Bug 4290043.
9502: l_targ_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
9503: l_source_version_type pa_budget_versions.version_type%TYPE;
9504: l_target_version_type pa_budget_versions.version_type%TYPE;
9505: l_src_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
9506:
9507: BEGIN
9508:
9509: x_msg_count := 0;

Line 9591: pa_fin_plan_types_b fin

9587: fin.plan_class_code
9588: INTO l_source_version_type,
9589: l_src_plan_class_code
9590: FROM pa_budget_versions pbv,
9591: pa_fin_plan_types_b fin
9592: WHERE pbv.fin_plan_type_id=fin.fin_plan_type_id
9593: AND pbv.budget_version_id = p_source_plan_version_id;
9594:
9595: DELETE FROM PA_FP_BL_MAP_TMP;

Line 10155: ,pa_fin_plan_types_b fpt

10151: ,pfo.cost_non_labor_res_rate_sch_id
10152: ,pfo.cost_res_class_rate_sch_id
10153: ,pfo.cost_burden_rate_sch_id
10154: FROM pa_proj_fp_options pfo
10155: ,pa_fin_plan_types_b fpt
10156: WHERE pfo.project_id = p_project_id
10157: AND pfo.fin_plan_type_id = fpt.fin_plan_type_id
10158: AND fpt.use_for_workplan_flag = 'Y'
10159: AND pfo.fin_plan_option_level_code = 'PLAN_TYPE';