1 PACKAGE PA_PROCESS_ACCUM_ACTUALS_RES AUTHID CURRENT_USER AS
2 /* $Header: PAACRESS.pls 120.1 2005/08/19 16:14:20 mwasowic noship $ */
3
4 -- This package contains the following procedures
5
6 -- Process_it_yt_pt_res - Processes ITD,YTD and PTD amounts in the
7 -- PA_PROJECT_ACCUM_ACTUALS table. For the
8 -- given Project-Task-Resource combination,records are
9 -- created/updated and rolled up to all the
10 -- higher level tasks. The Project-Resource records
11 -- are also created/updated.
12
13 -- Process_it_yt_pp_res - Processes ITD,YTD and PP amounts in the
14 -- PA_PROJECT_ACCUM_ACTUALS table. For the
15 -- given Project-Task-Resource combination,records are
16 -- created/updated and rolled up to all the
17 -- higher level tasks. The Project-Resource records
18 -- are also created/updated.
19
20 -- Process_it_pp_res - Processes ITD and PP amounts in the
21 -- PA_PROJECT_ACCUM_ACTUALS table. For the
22 -- given Project-Task-Resource combination,records are
23 -- created/updated and rolled up to all the
24 -- higher level tasks. The Project-Resource records
25 -- are also created/updated.
26
27 -- Process_it_yt_res - Processes ITD and YTD amounts in the
28 -- PA_PROJECT_ACCUM_ACTUALS table. For the
29 -- given Project-Task-Resource combination,records are
30 -- created/updated and rolled up to all the
31 -- higher level tasks. The Project-Resource records
32 -- are also created/updated.
33
34 -- Process_it_res - Processes ITD amounts in the
35 -- PA_PROJECT_ACCUM_ACTUALS table. For the
36 -- given Project-Task-Resource combination,records are
37 -- created/updated and rolled up to all the
38 -- higher level tasks. The Project-Resource records
39 -- are also created/updated.
40
41 -- Insert_Headers_res - Inserts Header records in the
42 -- PA_PROJECT_ACCUM_HEADERS table for the given
43 -- Project-Task-Resource combination
44
45 Procedure Process_it_yt_pt_res
46 (x_project_id In Number,
47 x_task_id In Number,
48 x_resource_list_id in Number,
49 x_resource_list_Member_id in Number,
50 x_resource_id in Number,
51 x_resource_list_assignment_id in Number,
52 x_track_as_labor_flag In Varchar2,
53 x_rollup_qty_flag In Varchar2,
54 x_unit_of_measure In Varchar2,
55 x_current_period In Varchar2,
56 X_Revenue In Number,
57 X_Raw_Cost In Number,
58 X_Burdened_Cost In Number,
59 X_Labor_Hours In Number,
60 X_Quantity In Number,
61 X_Billable_Quantity In Number,
62 X_Billable_Raw_Cost In Number,
63 X_Billable_Burdened_Cost In Number,
64 X_Billable_Labor_Hours In Number,
65 x_actual_cost_flag In Varchar2,
66 x_revenue_flag In Varchar2,
67 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
68 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
69 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
70 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
71 Procedure Process_it_yt_pp_res
72 (x_project_id In Number,
73 x_task_id In Number,
74 x_resource_list_id in Number,
75 x_resource_list_Member_id in Number,
76 x_resource_id in Number,
77 x_resource_list_assignment_id in Number,
78 x_track_as_labor_flag In Varchar2,
79 x_rollup_qty_flag In Varchar2,
80 x_unit_of_measure In Varchar2,
81 x_current_period In Varchar2,
82 X_Revenue In Number,
83 X_Raw_Cost In Number,
84 X_Burdened_Cost In Number,
85 X_Labor_Hours In Number,
86 X_Quantity In Number,
87 X_Billable_Quantity In Number,
88 X_Billable_Raw_Cost In Number,
89 X_Billable_Burdened_Cost In Number,
90 X_Billable_Labor_Hours In Number,
91 x_actual_cost_flag In Varchar2,
92 x_revenue_flag In Varchar2,
93 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
94 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
95 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
96 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
97 Procedure Process_it_pp_res
98 (x_project_id In Number,
99 x_task_id In Number,
100 x_resource_list_id in Number,
101 x_resource_list_Member_id in Number,
102 x_resource_id in Number,
103 x_resource_list_assignment_id in Number,
104 x_track_as_labor_flag In Varchar2,
105 x_rollup_qty_flag In Varchar2,
106 x_unit_of_measure In Varchar2,
107 x_current_period In Varchar2,
108 X_Revenue In Number,
109 X_Raw_Cost In Number,
110 X_Burdened_Cost In Number,
111 X_Labor_Hours In Number,
112 X_Quantity In Number,
113 X_Billable_Quantity In Number,
114 X_Billable_Raw_Cost In Number,
115 X_Billable_Burdened_Cost In Number,
116 X_Billable_Labor_Hours In Number,
117 x_actual_cost_flag In Varchar2,
118 x_revenue_flag In Varchar2,
119 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
120 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
121 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
122 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
123
124 Procedure Process_it_yt_res
125 (x_project_id In Number,
126 x_task_id In Number,
127 x_resource_list_id in Number,
128 x_resource_list_Member_id in Number,
129 x_resource_id in Number,
130 x_resource_list_assignment_id in Number,
131 x_track_as_labor_flag In Varchar2,
132 x_rollup_qty_flag In Varchar2,
133 x_unit_of_measure In Varchar2,
134 x_current_period In Varchar2,
135 X_Revenue In Number,
136 X_Raw_Cost In Number,
137 X_Burdened_Cost In Number,
138 X_Labor_Hours In Number,
139 X_Quantity In Number,
140 X_Billable_Quantity In Number,
141 X_Billable_Raw_Cost In Number,
142 X_Billable_Burdened_Cost In Number,
143 X_Billable_Labor_Hours In Number,
144 x_actual_cost_flag In Varchar2,
145 x_revenue_flag In Varchar2,
146 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
147 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
148 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
149 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
150
151
152 Procedure Process_it_res
153 (x_project_id In Number,
154 x_task_id In Number,
155 x_resource_list_id in Number,
156 x_resource_list_Member_id in Number,
157 x_resource_id in Number,
158 x_resource_list_assignment_id in Number,
159 x_track_as_labor_flag In Varchar2,
160 x_rollup_qty_flag In Varchar2,
161 x_unit_of_measure In Varchar2,
162 x_current_period In Varchar2,
163 X_Revenue In Number,
164 X_Raw_Cost In Number,
165 X_Burdened_Cost In Number,
166 X_Labor_Hours In Number,
167 X_Quantity In Number,
168 X_Billable_Quantity In Number,
169 X_Billable_Raw_Cost In Number,
170 X_Billable_Burdened_Cost In Number,
171 X_Billable_Labor_Hours In Number,
172 x_actual_cost_flag In Varchar2,
173 x_revenue_flag In Varchar2,
174 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
175 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
176 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
177 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
178
179 Procedure Insert_Headers_res (X_project_id In Number,
180 x_task_id In Number,
181 x_resource_list_id in Number,
182 x_resource_list_Member_id in Number,
183 x_resource_id in Number,
184 x_resource_list_assignment_id in Number,
185 x_current_period In Varchar2,
186 x_accum_id In Number,
187 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
188 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
189 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
190
191 END;