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 234: ,P_FIN_PLAN_TYPE_ID IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

230:
231: /*This is due to bug 2607945*/
232: FUNCTION is_plan_type_addition_allowed
233: (p_project_id IN pa_projects_all.project_id%TYPE
234: ,P_FIN_PLAN_TYPE_ID IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
235: ) RETURN VARCHAR2 ;
236:
237:
238: PROCEDURE Get_Peceding_Suceeding_Pd_Info

Line 620: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

616: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
617:
618: PROCEDURE IsRevVersionCreationAllowed
619: ( p_project_id IN pa_projects_all.project_id%TYPE
620: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
621: ,x_creation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
622: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
623: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
624: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 887: 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

883: ,p_resource_list_id IN
884: pa_resource_lists_all_bg.resource_list_id%TYPE)
885: RETURN VARCHAR2;
886:
887: 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
888: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
889: ,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
890: ,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
891: ,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 907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.

903:
904: PROCEDURE GET_SUMMARY_AMOUNTS(p_context IN VARCHAR2
905: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
906: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
907: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL -- Name of default staffing owner.
908: -- ,p_version_type IN pa_budget_versions.version_type%TYPE DEFAULT NULL --Bug 3902176
909: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
910: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
911: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

Line 1039: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE

1035: ==============================================================================*/
1036:
1037: FUNCTION check_if_amounts_exist_for_fp(
1038: p_project_id IN pa_projects_all.project_id%TYPE
1039: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE
1040: ) RETURN VARCHAR2;
1041:
1042: /*===================================================================================
1043: This api is used to validate the plan processing code if it passed, or to return

Line 1068: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE

1064: );
1065:
1066: FUNCTION Is_source_for_gen_options
1067: (p_project_id IN pa_projects_all.project_id%TYPE
1068: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
1069: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
1070: ) RETURN VARCHAR2;
1071:
1072:

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

1164: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
1165: ,p_budget_lines_out OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
1166:
1167: /*Parameters due fin plan model */
1168: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1169: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1170: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1171: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1172: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR