1 PACKAGE pa_fp_view_plans_util as
2 /* $Header: PAFPVPUS.pls 120.1 2005/08/19 16:31:44 mwasowic noship $
3 Start of Comments
4 Package name : pa_fin_plan_maint_ver_global
5 Purpose : API's for Financial Planning: View Plans Page
6 History :
7 NOTE :
8 End of Comments
9 */
10
11 function calculate_gl_total
12 (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13 p_project_id IN pa_resource_assignments.project_id%TYPE,
14 p_task_id IN pa_resource_assignments.task_id%TYPE,
15 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16 return NUMBER;
17
18 function calculate_pa_total
19 (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
20 p_project_id IN pa_resource_assignments.project_id%TYPE,
21 p_task_id IN pa_resource_assignments.task_id%TYPE,
22 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
23 return NUMBER;
24
25 function check_compatible_pd_profiles
26 (p_period_profile_id1 IN pa_proj_period_profiles.period_profile_id%TYPE,
27 p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)
28 return VARCHAR2;
29
30 function assign_row_level
31 (p_project_id IN pa_resource_assignments.project_id%TYPE,
32 p_task_id IN pa_resource_assignments.task_id%TYPE,
33 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
34 return NUMBER;
35
36 function assign_parent_element
37 (p_project_id IN pa_resource_assignments.project_id%TYPE,
38 p_task_id IN pa_resource_assignments.task_id%TYPE,
39 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
40 return VARCHAR2;
41
42 function assign_element_name
43 (p_project_id IN pa_resource_assignments.project_id%TYPE,
44 p_task_id IN pa_resource_assignments.task_id%TYPE,
45 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
46 return VARCHAR2;
47
48 function assign_element_level
49 (p_project_id IN pa_resource_assignments.project_id%TYPE,
50 p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
51 p_task_id IN pa_resource_assignments.task_id%TYPE,
52 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
53 return VARCHAR2;
54
55 FUNCTION assign_flat_element_names
56 (p_project_id IN pa_resource_assignments.project_id%TYPE,
57 p_task_id IN pa_resource_assignments.task_id%TYPE,
58 p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
59 p_element_type IN VARCHAR2)
60 return VARCHAR2;
61
62 procedure assign_default_amount
63 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
64 x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
65 x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
66 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
67 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
68 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
69
70 function get_period_n_value
71 (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
72 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
73 p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
74 p_project_currency_type IN VARCHAR2,
75 p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
76 p_period_number IN NUMBER) return NUMBER;
77
78 function calc_margin_percent
79 (p_cost_value IN NUMBER,
80 p_rev_value IN NUMBER) return NUMBER;
81
82
83 procedure refresh_period_profile
84 (p_project_id IN pa_projects_all.project_id%TYPE,
85 p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
86 p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
87 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
90
91 function has_period_profile_id
92 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
93 return VARCHAR2;
94
95 procedure roll_up_budget_lines
96 (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,
97 p_cost_or_rev in VARCHAR2);
98
99 -- FP L: used in View/Edit Plan page whenever navigation option to View/Edit
100 -- Plan Line page is chosen. If the resource assignment has been deleted by
101 -- WBS, an error needs to be displayed
102 procedure check_res_assignment_exists
103 (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
104 x_res_assignment_exists OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
105 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
107 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
108
109 -- FP L: used in View/Edit Plan page to determine if a plan version is planned
110 -- at a resource or resource group level (bug 2813661)
111 -- NOTE: THIS PROCEDURE IS USED ONLY FOR COLUMN DISPLAY PURPOSES: IT CONTAINS LOGIC
112 -- THAT IS USED TO HIDE/SHOW THE RESOURCE AND/OR RESOURCE GROUP COLUMNS. IT
113 -- CONTAINS DISPLAY LOGIC THAT MAY NOT BE DIRECTLY RELEVANT TO THE ACTUAL
114 -- PLANNING LEVEL OF THE VERSION.
115 -- ** p_entered_amts_only_flag = 'Y' if this is used by the View Plan page
116 -- (query only rows with entered amts), and 'N' if used by Edit Plan page
117 procedure get_plan_version_res_level
118 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
119 p_entered_amts_only_flag IN VARCHAR2,
120 x_resource_level OUT NOCOPY VARCHAR2, -- 'R' = resource, 'G' = resource group, --File.Sql.39 bug 4440895
121 -- 'M' = mixed, 'N' = not applicable (ungrouped resource list)
122 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
123 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
124 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
125
126 /* THE FOLLOWING ARE USED ONLY FOR TESTING PURPOSES */
127 TYPE number_data_type_table IS TABLE OF NUMBER
128 INDEX BY BINARY_INTEGER;
129
130 TYPE char240_data_type_table IS TABLE OF VARCHAR2(240)
131 INDEX BY BINARY_INTEGER;
132
133 FUNCTION get_amttype_id
134 ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER;
135
136 end pa_fp_view_plans_util;