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

Line 88: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

84: This will be called from the Add Plan Type page. This is due to bug
85: 2607945*/
86: FUNCTION Is_Plan_Type_Addition_Allowed
87: (p_project_id IN pa_projects_all.project_id%TYPE
88: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
89: ) RETURN VARCHAR2 IS
90:
91: l_valid_status VARCHAR2(1):='S';
92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;

Line 92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;

88: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
89: ) RETURN VARCHAR2 IS
90:
91: l_valid_status VARCHAR2(1):='S';
92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;
93: l_approved_cost_plan_type_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
94: l_approved_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
95: l_budget_version_id pa_budget_Versions.budget_version_id%TYPE;
96:

Line 93: l_approved_cost_plan_type_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;

89: ) RETURN VARCHAR2 IS
90:
91: l_valid_status VARCHAR2(1):='S';
92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;
93: l_approved_cost_plan_type_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
94: l_approved_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
95: l_budget_version_id pa_budget_Versions.budget_version_id%TYPE;
96:
97: BEGIN

Line 94: l_approved_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;

90:
91: l_valid_status VARCHAR2(1):='S';
92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;
93: l_approved_cost_plan_type_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
94: l_approved_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
95: l_budget_version_id pa_budget_Versions.budget_version_id%TYPE;
96:
97: BEGIN
98: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 114: FROM pa_fin_plan_types_b

110: ,approved_rev_plan_type_flag
111: INTO l_migrated_frm_bdgt_typ_code
112: ,l_approved_cost_plan_type_flag
113: ,l_approved_rev_plan_type_flag
114: FROM pa_fin_plan_types_b
115: WHERE fin_plan_type_id = p_fin_plan_type_id
116: AND nvl(use_for_workplan_flag,'N')='N'; -- Added for Changes for FP.M, Tracking Bug No - 3354518
117:
118:

Line 2343: l_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

2339: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
2340: return VARCHAR2
2341: is
2342:
2343: l_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
2344: l_return_value VARCHAR2(1);
2345: BEGIN
2346: l_return_value := 'N';
2347: select pt.fin_plan_type_code

Line 2350: pa_fin_plan_types_b pt

2346: l_return_value := 'N';
2347: select pt.fin_plan_type_code
2348: into l_plan_type_code
2349: from pa_budget_versions bv,
2350: pa_fin_plan_types_b pt
2351: where bv.budget_version_id = p_budget_version_id and
2352: bv.fin_plan_type_id = pt.fin_plan_type_id;
2353: if l_plan_type_code = 'ORG_FORECAST' then
2354: l_return_value := 'Y';

Line 3187: So adding a join to pa_fin_plan_types_b and checking status of use_for_workplan_flag.

3183: Adding conditon in the where clause below to
3184: check for new column use_for_workplan flag.
3185: This column indicates if a plan type is being
3186: used for workplan or not.
3187: So adding a join to pa_fin_plan_types_b and checking status of use_for_workplan_flag.
3188: Without this check the function would return success status even if WP plantype exists */
3189: (select 1 from pa_proj_fp_options pfo, pa_fin_plan_types_b pft -- Added pa_fin_plan_types_b for FP.M changes
3190: where pfo.project_id = p_project_id
3191: /*Changes for FP.M start here */

Line 3189: (select 1 from pa_proj_fp_options pfo, pa_fin_plan_types_b pft -- Added pa_fin_plan_types_b for FP.M changes

3185: This column indicates if a plan type is being
3186: used for workplan or not.
3187: So adding a join to pa_fin_plan_types_b and checking status of use_for_workplan_flag.
3188: Without this check the function would return success status even if WP plantype exists */
3189: (select 1 from pa_proj_fp_options pfo, pa_fin_plan_types_b pft -- Added pa_fin_plan_types_b for FP.M changes
3190: where pfo.project_id = p_project_id
3191: /*Changes for FP.M start here */
3192: and pfo.fin_plan_option_level_code='PLAN_TYPE' /*bug 3224177 added fin_plan_option_level_code check*/
3193: and nvl(pfo.fin_plan_type_id,-99) = pft.fin_plan_type_id

Line 3590: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,

3586: pa_budget_versions bv
3587: where bl.budget_version_id = bv.budget_version_id
3588: and bv.project_id = p_project_id)
3589: OR exists (Select 'x' -- included for bug 3224177
3590: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,
3591: pa_projects_all pa
3592: where pfo.project_id = pa.project_id and
3593: pa.project_id = p_project_id and
3594: /* Commented out the below for bug 5364011*/

Line 7397: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

7393: END Get_Project_Curr_Attributes;
7394:
7395: PROCEDURE IsRevVersionCreationAllowed
7396: ( p_project_id IN pa_projects_all.project_id%TYPE
7397: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
7398: ,x_creation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7399: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7400: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7401: ,x_msg_data OUT NOCOPY VARCHAR2) AS --File.Sql.39 bug 4440895

Line 7418: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518

7414: cursor autobaseline_appr_rev_info_cur is
7415: SELECT nvl(pr.baseline_funding_flag,'N') baseline_funding_flag, pfo.approved_rev_plan_type_flag,
7416: pft.use_for_workplan_flag -- Added for FP.M ,Tracking Bug No - 3354518
7417: FROM pa_projects_all pr, pa_proj_fp_options pfo,
7418: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518
7419: WHERE pr.project_id = pfo.project_id
7420: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7421: AND pfo.fin_plan_type_id = p_fin_plan_type_id
7422: AND pfo.project_id = p_project_id

Line 8483: l_edit_after_baseline_flag pa_fin_plan_types_b.edit_after_baseline_flag%TYPE;

8479: -- Bug 3057564, jwhite, 22-JUL-03 -----------------------------
8480: l_request_id pa_budget_versions.request_id%TYPE;
8481:
8482: -- Bug 3986129: FP.M Web ADI Dev. Added the followings
8483: l_edit_after_baseline_flag pa_fin_plan_types_b.edit_after_baseline_flag%TYPE;
8484: l_project_id pa_projects_all.project_id%TYPE;
8485: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8486: l_version_type pa_budget_versions.version_type%TYPE;
8487: is_edit_allowed VARCHAR2(1) := 'Y';

Line 8485: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

8481:
8482: -- Bug 3986129: FP.M Web ADI Dev. Added the followings
8483: l_edit_after_baseline_flag pa_fin_plan_types_b.edit_after_baseline_flag%TYPE;
8484: l_project_id pa_projects_all.project_id%TYPE;
8485: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8486: l_version_type pa_budget_versions.version_type%TYPE;
8487: is_edit_allowed VARCHAR2(1) := 'Y';
8488:
8489: l_debug_mode VARCHAR2(1);

Line 8811: FROM pa_fin_plan_types_b fpt,

8807: INTO l_edit_after_baseline_flag,
8808: l_project_id,
8809: l_fin_plan_type_id,
8810: l_version_type
8811: FROM pa_fin_plan_types_b fpt,
8812: pa_budget_versions bv
8813: WHERE bv.budget_version_id = p_budget_version_id
8814: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
8815:

Line 9010: FROM pa_fin_plan_types_b fpt

9006: -- Commenting Out code Below for FOM DEv Changes -- Bug 3640517 -- Starts
9007: /* AND (bv.budget_type_code IS NOT NULL
9008: OR
9009: bv.fin_plan_type_id IN (SELECT fpt.fin_plan_type_id
9010: FROM pa_fin_plan_types_b fpt
9011: WHERE fpt.fin_plan_type_code = 'ORG_FORECAST')));
9012: */
9013: -- Commenting Out code Above for FPM DEv Changes -- Bug 3640517 -- Ends
9014:

Line 9052: FROM pa_fin_plan_types_b fpt

9048: AND nvl(bv.wp_version_flag,'N') = 'N' -- Added for FP.M, Tracking Bug No - 3354518
9049: AND (bv.budget_type_code IS NOT NULL
9050: OR
9051: bv.fin_plan_type_id IN (SELECT fpt.fin_plan_type_id
9052: FROM pa_fin_plan_types_b fpt
9053: WHERE fpt.fin_plan_type_code = 'ORG_FORECAST')));
9054: */
9055:
9056:

Line 9852: from pa_fin_plan_types_b

9848:
9849: BEGIN
9850: select edit_after_baseline_flag
9851: into x_editable_flag
9852: from pa_fin_plan_types_b
9853: where fin_plan_type_id = p_fin_plan_type_id;
9854: EXCEPTION
9855: WHEN OTHERS THEN
9856:

Line 10946: from pa_proj_fp_options a, pa_fin_plan_types_b b

10942: select 'Y'
10943: into l_wp_resource_list_flag
10944: from dual
10945: where exists (select 'x'
10946: from pa_proj_fp_options a, pa_fin_plan_types_b b
10947: where a.project_id = p_project_id
10948: and a.fin_plan_option_level_code <> 'PROJECT'
10949: and a.fin_plan_type_id = b.fin_plan_type_id
10950: and (a.cost_resource_list_id = p_resource_list_id or

Line 10975: from pa_fin_plan_types_b b

10971: where exists (select 'x'
10972: from pa_proj_fp_options a
10973: where a.project_id = p_project_id
10974: and not exists (select 'x'
10975: from pa_fin_plan_types_b b
10976: where a.fin_plan_type_id = b.fin_plan_type_id
10977: and b.use_for_workplan_flag = 'Y')
10978: and (a.cost_resource_list_id = p_resource_list_id or
10979: a.revenue_resource_list_id = p_resource_list_id or

Line 10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types

10988: /* Returns the current working version ids for a given plan type.
10989: Returns -1 if the plan type cannot have a version of that version type
10990: Returns NULL if no working version exists for the plan type*/
10991:
10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895

Line 11481: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL

11477:
11478: PROCEDURE GET_SUMMARY_AMOUNTS(p_context IN VARCHAR2
11479: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
11480: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
11481: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL
11482: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11483: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

Line 12418: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE

12414: ==============================================================================*/
12415:
12416: FUNCTION check_if_amounts_exist_for_fp(
12417: p_project_id IN pa_projects_all.project_id%TYPE
12418: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE
12419: ) RETURN VARCHAR2
12420: IS
12421: l_amounts_exist_flag VARCHAR2(1) := 'N';
12422: BEGIN

Line 12891: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

12887: --Bug: 3619687 Added a function to check that the preference code the plan type is not used as a generation source for any other plan type
12888:
12889: FUNCTION Is_source_for_gen_options
12890: (p_project_id IN pa_projects_all.project_id%TYPE
12891: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12892: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
12893: ) RETURN VARCHAR2 IS
12894:
12895: l_valid_status VARCHAR2(1) := 'S';

Line 13195: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

13191: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
13192: ,p_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
13193:
13194: /*Parameters due fin plan model */
13195: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13196: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;

13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13239: l_version_type pa_budget_versions.version_type%TYPE;
13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13243:
13244: BEGIN
13245:
13246: pa_debug.set_err_stack('PA_FIN_PLAN_UTILS.create_draft_budget_wrp');