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

Line 39: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
38: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
39: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
40:
41: l_msg_count NUMBER := 0;
42: l_data VARCHAR2(2000);
43: l_msg_data VARCHAR2(2000);

Line 85: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */

81: budget_version_id = p_budget_version_id;
82: select pt.fin_plan_type_code
83: into l_fin_plan_type_code
84: from pa_proj_fp_options po,
85: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */
86: where po.project_id = p_project_id and
87: po.fin_plan_version_id = p_budget_version_id and
88: po.fin_plan_option_level_code = 'PLAN_VERSION' and
89: po.fin_plan_type_id = pt.fin_plan_type_id;

Line 934: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

930: l_max_version NUMBER;
931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
932: l_exists varchar2(1);
933: l_module_name VARCHAR2(100):='PAFPPUBB.delete_version';
934: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
936:
937: /* Bug 2688610 - Add the following two locals*/
938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

Line 1192: FROM pa_fin_plan_types_b

1188:
1189: BEGIN
1190: SELECT fin_plan_type_id
1191: INTO l_wp_fin_plan_type_id
1192: FROM pa_fin_plan_types_b
1193: WHERE use_for_workplan_flag='Y';
1194: EXCEPTION
1195: WHEN NO_DATA_FOUND THEN
1196: IF l_debug_mode = 'Y' THEN

Line 1439: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

1435: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1436: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1437: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';
1438: i NUMBER;
1439: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1440:
1441: -- IPM Arch Enhancement - Bug 4865563
1442: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
1443: l_debug_level5 NUMBER:=5;

Line 1548: FROM pa_fin_plan_types_b

1544:
1545: BEGIN
1546: SELECT fin_plan_type_id
1547: INTO l_wp_fin_plan_type_id
1548: FROM pa_fin_plan_types_b
1549: WHERE use_for_workplan_flag='Y';
1550: EXCEPTION
1551: WHEN NO_DATA_FOUND THEN
1552: IF l_debug_mode = 'Y' THEN

Line 1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

1828: PROCEDURE get_copy_paramters
1829: (
1830: p_source_project_id IN pa_projects_all.project_id%TYPE,
1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1836: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

1829: (
1830: p_source_project_id IN pa_projects_all.project_id%TYPE,
1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1836: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1837: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2015: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

2011: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2012: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2013:
2014: --Declared for Bug 4290043
2015: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2016: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2017: l_copy_actuals_flag VARCHAR2(1);
2018: l_derv_rates_missing_amts_flag VARCHAR2(1);
2019:

Line 2016: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

2012: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2013:
2014: --Declared for Bug 4290043
2015: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2016: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2017: l_copy_actuals_flag VARCHAR2(1);
2018: l_derv_rates_missing_amts_flag VARCHAR2(1);
2019:
2020: --IPM Architechture Enhancement Bug 4865563

Line 2143: pa_fin_plan_types_b fin

2139: ,l_source_appr_rev_plan_flag
2140: ,l_source_ver_rbs_version_id -- Bug 3731925
2141: ,l_source_plan_class_code
2142: FROM pa_proj_fp_options pfo,
2143: pa_fin_plan_types_b fin
2144: WHERE pfo.fin_plan_version_id = p_source_version_id
2145: AND fin.fin_plan_type_id=pfo.fin_plan_type_id;
2146:
2147: --Fetch proj fp options id for target version if its already existing.

Line 2167: pa_fin_plan_types_b fin

2163: ,l_target_element_type
2164: ,l_target_appr_rev_plan_flag
2165: ,l_target_plan_class_code
2166: FROM pa_proj_fp_options pfo,
2167: pa_fin_plan_types_b fin
2168: WHERE pfo.fin_plan_version_id = l_budget_version_id
2169: AND pfo.fin_plan_type_id = fin.fin_plan_type_id;
2170:
2171: ELSE

Line 3200: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

3196: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3197: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3198: is
3199: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3200: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3201: l_debug_mode VARCHAR2(30);
3202: l_valid1_flag VARCHAR2(1);
3203: l_valid2_flag VARCHAR2(1);
3204: l_msg_count NUMBER := 0;

Line 3329: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */

3325: into l_fin_plan_type_code,
3326: l_version_type,
3327: l_fin_plan_type_id
3328: from pa_budget_versions pbv,
3329: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3330: where pbv.budget_version_id = p_budget_version_id and
3331: pbv.fin_plan_type_id = pt.fin_plan_type_id ;
3332:
3333:

Line 3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

3587: l_msg_index_out NUMBER;
3588: l_return_status VARCHAR2(2000);
3589:
3590: l_version_type pa_budget_versions.version_type%TYPE;
3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3592: l_max_version pa_budget_versions.version_number%TYPE;
3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3594:
3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */

Line 3686: /* Get the version_type by querying pa_fin_plan_types_b using fin_plan_type_id */

3682: IF P_PA_DEBUG_MODE = 'Y' THEN
3683: pa_debug.write_file('Create_Version_OrgFcst: ' || 'no business rules violations');
3684: END IF;
3685: SAVEPOINT PA_FP_PUB_CREATE_VER_ORGFCST;
3686: /* Get the version_type by querying pa_fin_plan_types_b using fin_plan_type_id */
3687: select
3688: fin_plan_type_code,
3689: name
3690: into

Line 5295: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b

5291:
5292: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5293: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5294:
5295: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5296: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5297:
5298: CURSOR plan_type_info_cur (
5299: c_project_id NUMBER,

Line 5296: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;

5292: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5293: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5294:
5295: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5296: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5297:
5298: CURSOR plan_type_info_cur (
5299: c_project_id NUMBER,
5300: c_fin_plan_type_id NUMBER )IS

Line 5999: FROM pa_fin_plan_types_b

5995:
5996: -- Getting the Use for workplan flag to populate WP_VERSION_FLAG in pa_budget_versions
5997: SELECT use_for_workplan_flag
5998: INTO l_wp_version_flag
5999: FROM pa_fin_plan_types_b
6000: WHERE fin_plan_type_id = p_fin_plan_type_id;
6001:
6002: /* This fix is done during IB1 testing of FP M. There are some flows, which
6003: * are creation more than one budget version for the same workplan version. To