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 1455: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

1451: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1452: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1453: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';
1454: i NUMBER;
1455: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1456:
1457: -- IPM Arch Enhancement - Bug 4865563
1458: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
1459: l_debug_level5 NUMBER:=5;

Line 1564: FROM pa_fin_plan_types_b

1560:
1561: BEGIN
1562: SELECT fin_plan_type_id
1563: INTO l_wp_fin_plan_type_id
1564: FROM pa_fin_plan_types_b
1565: WHERE use_for_workplan_flag='Y';
1566: EXCEPTION
1567: WHEN NO_DATA_FOUND THEN
1568: IF l_debug_mode = 'Y' THEN

Line 1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

1844: PROCEDURE get_copy_paramters
1845: (
1846: p_source_project_id IN pa_projects_all.project_id%TYPE,
1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1852: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

1845: (
1846: p_source_project_id IN pa_projects_all.project_id%TYPE,
1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1852: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1853: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2031: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

2027: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2028: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2029:
2030: --Declared for Bug 4290043
2031: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2032: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2033: l_copy_actuals_flag VARCHAR2(1);
2034: l_derv_rates_missing_amts_flag VARCHAR2(1);
2035:

Line 2032: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

2028: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2029:
2030: --Declared for Bug 4290043
2031: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2032: l_target_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
2033: l_copy_actuals_flag VARCHAR2(1);
2034: l_derv_rates_missing_amts_flag VARCHAR2(1);
2035:
2036: --IPM Architechture Enhancement Bug 4865563

Line 2159: pa_fin_plan_types_b fin

2155: ,l_source_appr_rev_plan_flag
2156: ,l_source_ver_rbs_version_id -- Bug 3731925
2157: ,l_source_plan_class_code
2158: FROM pa_proj_fp_options pfo,
2159: pa_fin_plan_types_b fin
2160: WHERE pfo.fin_plan_version_id = p_source_version_id
2161: AND fin.fin_plan_type_id=pfo.fin_plan_type_id;
2162:
2163: --Fetch proj fp options id for target version if its already existing.

Line 2183: pa_fin_plan_types_b fin

2179: ,l_target_element_type
2180: ,l_target_appr_rev_plan_flag
2181: ,l_target_plan_class_code
2182: FROM pa_proj_fp_options pfo,
2183: pa_fin_plan_types_b fin
2184: WHERE pfo.fin_plan_version_id = l_budget_version_id
2185: AND pfo.fin_plan_type_id = fin.fin_plan_type_id;
2186:
2187: ELSE

Line 3216: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

3212: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3213: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3214: is
3215: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3216: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3217: l_debug_mode VARCHAR2(30);
3218: l_valid1_flag VARCHAR2(1);
3219: l_valid2_flag VARCHAR2(1);
3220: l_msg_count NUMBER := 0;

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

3341: into l_fin_plan_type_code,
3342: l_version_type,
3343: l_fin_plan_type_id
3344: from pa_budget_versions pbv,
3345: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3346: where pbv.budget_version_id = p_budget_version_id and
3347: pbv.fin_plan_type_id = pt.fin_plan_type_id ;
3348:
3349:

Line 3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

3603: l_msg_index_out NUMBER;
3604: l_return_status VARCHAR2(2000);
3605:
3606: l_version_type pa_budget_versions.version_type%TYPE;
3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3608: l_max_version pa_budget_versions.version_number%TYPE;
3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3610:
3611: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */

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

3698: IF P_PA_DEBUG_MODE = 'Y' THEN
3699: pa_debug.write_file('Create_Version_OrgFcst: ' || 'no business rules violations');
3700: END IF;
3701: SAVEPOINT PA_FP_PUB_CREATE_VER_ORGFCST;
3702: /* Get the version_type by querying pa_fin_plan_types_b using fin_plan_type_id */
3703: select
3704: fin_plan_type_code,
3705: name
3706: into

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

5307:
5308: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5309: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5310:
5311: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5312: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5313:
5314: CURSOR plan_type_info_cur (
5315: c_project_id NUMBER,

Line 5312: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;

5308: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5309: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5310:
5311: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5312: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5313:
5314: CURSOR plan_type_info_cur (
5315: c_project_id NUMBER,
5316: c_fin_plan_type_id NUMBER )IS

Line 6016: FROM pa_fin_plan_types_b

6012:
6013: -- Getting the Use for workplan flag to populate WP_VERSION_FLAG in pa_budget_versions
6014: SELECT use_for_workplan_flag
6015: INTO l_wp_version_flag
6016: FROM pa_fin_plan_types_b
6017: WHERE fin_plan_type_id = p_fin_plan_type_id;
6018:
6019: /* This fix is done during IB1 testing of FP M. There are some flows, which
6020: * are creation more than one budget version for the same workplan version. To