1 PACKAGE PA_PROCESS_ACCUM_ACTUALS AUTHID CURRENT_USER AS
2 /* $Header: PAACTSKS.pls 120.1 2005/08/19 16:14:59 mwasowic noship $ */
3
4 TYPE task_id_tabtype IS TABLE OF PA_TASKS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
5
6 -- This package contains the following procedures
7
8 -- Process_it_yt_pt_tasks - Processes ITD,YTD and PTD amounts in the
9 -- PA_PROJECT_ACCUM_ACTUALS table. For the
10 -- given Project-Task combination,records are
11 -- created/updated and rolled up to all the
12 -- higher level tasks.
13
14 -- Process_it_yt_pp_tasks - Processes ITD,YTD and PP amounts in the
15 -- PA_PROJECT_ACCUM_ACTUALS table. For the
16 -- given Project-Task combination,records are
17 -- created/updated and rolled up to all the
18 -- higher level tasks.
19
20 -- Process_it_pp_tasks - Processes ITD and PP amounts in the
21 -- PA_PROJECT_ACCUM_ACTUALS table. For the
22 -- given Project-Task combination,records are
23 -- created/updated and rolled up to all the
24 -- higher level tasks.
25
26 -- Process_it_yt_tasks - Processes ITD and YTD amounts in the
27 -- PA_PROJECT_ACCUM_ACTUALS table. For the
28 -- given Project-Task combination,records are
29 -- created/updated and rolled up to all the
30 -- higher level tasks.
31
32 -- Process_it_tasks - Processes ITD amounts in the
33 -- PA_PROJECT_ACCUM_ACTUALS table. For the
34 -- given Project-Task combination,records are
35 -- created/updated and rolled up to all the
36 -- higher level tasks.
37
38 Procedure Process_it_yt_pt_tasks
39 (x_project_id In Number,
40 x_task_id In Number,
41 x_Proj_Accum_Id In Number,
42 x_current_period In Varchar2,
43 X_Revenue In Number,
44 X_Raw_Cost In Number,
45 X_Burdened_Cost In Number,
46 X_Labor_Hours In Number,
47 X_Billable_Raw_Cost In Number,
48 X_Billable_Burdened_Cost In Number,
49 X_Billable_Labor_Hours In Number,
50 X_Unit_Of_Measure In Varchar2,
51 x_actual_cost_flag In Varchar2,
52 x_revenue_flag In Varchar2,
53 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
54 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
55 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
56 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
57 Procedure Process_it_yt_pp_tasks
58 (x_project_id In Number,
59 x_task_id In Number,
60 x_Proj_Accum_Id In Number,
61 x_current_period In Varchar2,
62 X_Revenue In Number,
63 X_Raw_Cost In Number,
64 X_Burdened_Cost In Number,
65 X_Labor_Hours In Number,
66 X_Billable_Raw_Cost In Number,
67 X_Billable_Burdened_Cost In Number,
68 X_Billable_Labor_Hours In Number,
69 X_Unit_Of_Measure In Varchar2,
70 x_actual_cost_flag In Varchar2,
71 x_revenue_flag In Varchar2,
72 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
73 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
74 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
75 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
76 Procedure Process_it_pp_tasks
77 (x_project_id In Number,
78 x_task_id In Number,
79 x_Proj_Accum_Id In Number,
80 x_current_period In Varchar2,
81 X_Revenue In Number,
82 X_Raw_Cost In Number,
83 X_Burdened_Cost In Number,
84 X_Labor_Hours In Number,
85 X_Billable_Raw_Cost In Number,
86 X_Billable_Burdened_Cost In Number,
87 X_Billable_Labor_Hours In Number,
88 X_Unit_Of_Measure In Varchar2,
89 x_actual_cost_flag In Varchar2,
90 x_revenue_flag In Varchar2,
91 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
92 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
93 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
94 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
95 Procedure Process_it_yt_tasks
96 (x_project_id In Number,
97 x_task_id In Number,
98 x_Proj_Accum_Id In Number,
99 x_current_period In Varchar2,
100 X_Revenue In Number,
101 X_Raw_Cost In Number,
102 X_Burdened_Cost In Number,
103 X_Labor_Hours In Number,
104 X_Billable_Raw_Cost In Number,
105 X_Billable_Burdened_Cost In Number,
106 X_Billable_Labor_Hours In Number,
107 X_Unit_Of_Measure In Varchar2,
108 x_actual_cost_flag In Varchar2,
109 x_revenue_flag In Varchar2,
110 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
111 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
112 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
113 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
114
115 Procedure Process_it_tasks
116 (x_project_id In Number,
117 x_task_id In Number,
118 x_Proj_Accum_Id In Number,
119 x_current_period In Varchar2,
120 X_Revenue In Number,
121 X_Raw_Cost In Number,
122 X_Burdened_Cost In Number,
123 X_Labor_Hours In Number,
124 X_Billable_Raw_Cost In Number,
125 X_Billable_Burdened_Cost In Number,
126 X_Billable_Labor_Hours In Number,
127 X_Unit_Of_Measure In Varchar2,
128 x_actual_cost_flag In Varchar2,
129 x_revenue_flag In Varchar2,
130 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
131 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
132 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
133 X_err_Code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
134
135 END;