1 PACKAGE PA_PROCESS_ACCUM_CMT_RES AUTHID CURRENT_USER AS
2 /* $Header: PACMTRES.pls 120.1 2005/08/19 16:19:57 mwasowic noship $ */
3
4 TYPE task_id_tabtype IS TABLE OF PA_TASKS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
5
6 -- Process_it_yt_pt_cmt_res - Processes ITD,YTD and PTD amounts in the
7 -- PA_PROJECT_ACCUM_COMMITMENTS 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_cmt_res - Processes ITD,YTD and PP amounts in the
14 -- PA_PROJECT_ACCUM_COMMITMENTS 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_cmt_res - Processes ITD and PP amounts in the
21 -- PA_PROJECT_ACCUM_COMMITMENTS 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_cmt_res - Processes ITD and YTD amounts in the
28 -- PA_PROJECT_ACCUM_COMMITMENTS 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_cmt_res - Processes ITD amounts in the
35 -- PA_PROJECT_ACCUM_COMMITMENTS 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 -- Get_all_higher_tasks_cmt_res - For the given Task Id returns all the
42 -- higher level tasks in the WBS (including the given
43 -- task) which are not in PA_PROJECT_ACCUM_HEADERS
44 -- (Tasks with the given Resource )
45
46
47 Procedure Process_it_yt_pt_cmt_res
48 (x_project_id In Number,
49 x_task_id In Number,
50 x_resource_list_id in Number,
51 x_resource_list_Member_id in Number,
52 x_resource_id in Number,
53 x_resource_list_assignment_id in Number,
54 x_track_as_labor_flag In Varchar2,
55 x_rollup_qty_flag In Varchar2,
56 x_unit_of_measure In Varchar2,
57 x_current_period In Varchar2,
58 X_Raw_Cost In Number,
59 X_Burdened_Cost In Number,
60 X_Quantity In Number,
61 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
62 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
63 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
64 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
65
66 Procedure Process_it_yt_pp_cmt_res
67 (x_project_id In Number,
68 x_task_id In Number,
69 x_resource_list_id in Number,
70 x_resource_list_Member_id in Number,
71 x_resource_id in Number,
72 x_resource_list_assignment_id in Number,
73 x_track_as_labor_flag In Varchar2,
74 x_rollup_qty_flag In Varchar2,
75 x_unit_of_measure In Varchar2,
76 x_current_period In Varchar2,
77 X_Raw_Cost In Number,
78 X_Burdened_Cost In Number,
79 X_Quantity In Number,
80 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
81 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
82 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
83 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
84
85 Procedure Process_it_pp_cmt_res
86 (x_project_id In Number,
87 x_task_id In Number,
88 x_resource_list_id in Number,
89 x_resource_list_Member_id in Number,
90 x_resource_id in Number,
91 x_resource_list_assignment_id in Number,
92 x_track_as_labor_flag In Varchar2,
93 x_rollup_qty_flag In Varchar2,
94 x_unit_of_measure In Varchar2,
95 x_current_period In Varchar2,
96 X_Raw_Cost In Number,
97 X_Burdened_Cost In Number,
98 X_Quantity In Number,
99 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
100 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
101 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
102 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
103
104 Procedure Process_it_yt_cmt_res
105 (x_project_id In Number,
106 x_task_id In Number,
107 x_resource_list_id in Number,
108 x_resource_list_Member_id in Number,
109 x_resource_id in Number,
110 x_resource_list_assignment_id in Number,
111 x_track_as_labor_flag In Varchar2,
112 x_rollup_qty_flag In Varchar2,
113 x_unit_of_measure In Varchar2,
114 x_current_period In Varchar2,
115 X_Raw_Cost In Number,
116 X_Burdened_Cost In Number,
117 X_Quantity In Number,
118 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
119 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
120 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
121 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
122
123 Procedure Process_it_cmt_res
124 (x_project_id In Number,
125 x_task_id In Number,
126 x_resource_list_id in Number,
127 x_resource_list_Member_id in Number,
128 x_resource_id in Number,
129 x_resource_list_assignment_id in Number,
130 x_track_as_labor_flag In Varchar2,
131 x_rollup_qty_flag In Varchar2,
132 x_unit_of_measure In Varchar2,
133 x_current_period In Varchar2,
134 X_Raw_Cost In Number,
135 X_Burdened_Cost In Number,
136 X_Quantity In Number,
137 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
138 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
139 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
140 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
141
142
143 Procedure Get_all_higher_tasks_cmt_res
144 (x_project_id in Number,
145 X_task_id in Number,
146 x_resource_list_member_id in Number,
147 x_task_array Out NOCOPY task_id_tabtype, --File.Sql.39 bug 4440895
148 x_noof_tasks Out NOCOPY number, --File.Sql.39 bug 4440895
149 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
150 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
151 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
152
153
154 END PA_PROCESS_ACCUM_CMT_RES;