1 PACKAGE PA_PROCESS_ACCUM_COMMITMENTS AUTHID CURRENT_USER AS
2 /* $Header: PACMTSKS.pls 120.1 2005/08/19 16:20:05 mwasowic noship $ */
3
4 TYPE task_id_tabtype IS TABLE OF PA_TASKS.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
5 -- This package contains the following procedures
6
7 -- Process_it_yt_pt_tasks_cmt - Processes ITD,YTD and PTD amounts in the
8 -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
9 -- given Project-Task combination,records are
10 -- created/updated and rolled up to all the
11 -- higher level tasks.
12
13 -- Process_it_yt_pp_tasks_cmt - Processes ITD,YTD and PP amounts in the
14 -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
15 -- given Project-Task combination,records are
16 -- created/updated and rolled up to all the
17 -- higher level tasks.
18
19 -- Process_it_pp_tasks_cmt - Processes ITD and PP amounts in the
20 -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
21 -- given Project-Task combination,records are
22 -- created/updated and rolled up to all the
23 -- higher level tasks.
24
25 -- Process_it_yt_tasks_cmt - Processes ITD and YTD amounts in the
26 -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
27 -- given Project-Task combination,records are
28 -- created/updated and rolled up to all the
29 -- higher level tasks.
30
31 -- Process_it_tasks_cmt - Processes ITD amounts in the
32 -- PA_PROJECT_ACCUM_COMMITMENTS table. For the
33 -- given Project-Task combination,records are
34 -- created/updated and rolled up to all the
35 -- higher level tasks.
36
37 -- Get_all_higher_tasks_cmt - For the given Task Id returns all the
38 -- higher level tasks in the WBS (including the given
39 -- task) which are not in PA_PROJECT_ACCUM_HEADERS
40
41 Procedure Process_it_yt_pt_tasks_cmt
42 (x_project_id In Number,
43 x_task_id In Number,
44 x_Proj_Accum_Id In Number,
45 x_current_period In Varchar2,
46 X_Raw_Cost In Number,
47 X_Burdened_Cost In Number,
48 X_Quantity In Number,
49 X_Unit_Of_Measure In Varchar2,
50 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
51 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
52 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
53 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
54 Procedure Process_it_yt_pp_tasks_cmt
55 (x_project_id In Number,
56 x_task_id In Number,
57 x_Proj_Accum_Id In Number,
58 x_current_period In Varchar2,
59 X_Raw_Cost In Number,
60 X_Burdened_Cost In Number,
61 X_Quantity In Number,
62 X_Unit_Of_Measure In Varchar2,
63 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
64 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
65 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
66 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
67 Procedure Process_it_pp_tasks_cmt
68 (x_project_id In Number,
69 x_task_id In Number,
70 x_Proj_Accum_Id In Number,
71 x_current_period In Varchar2,
72 X_Raw_Cost In Number,
73 X_Burdened_Cost In Number,
74 X_Quantity In Number,
75 X_Unit_Of_Measure In Varchar2,
76 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
77 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
78 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
79 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
80 Procedure Process_it_yt_tasks_cmt
81 (x_project_id In Number,
82 x_task_id In Number,
83 x_Proj_Accum_Id In Number,
84 x_current_period In Varchar2,
85 X_Raw_Cost In Number,
86 X_Burdened_Cost In Number,
87 X_Quantity In Number,
88 X_Unit_Of_Measure In Varchar2,
89 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
90 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
91 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
92 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
93 Procedure Process_it_tasks_cmt
94 (x_project_id In Number,
95 x_task_id In Number,
96 x_Proj_Accum_Id In Number,
97 x_current_period In Varchar2,
98 X_Raw_Cost In Number,
99 X_Burdened_Cost In Number,
100 X_Quantity In Number,
101 X_Unit_Of_Measure In Varchar2,
102 X_Recs_processed Out NOCOPY Number, --File.Sql.39 bug 4440895
103 x_err_stack In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
104 x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
105 x_err_code In Out NOCOPY Number ); --File.Sql.39 bug 4440895
106
107 Procedure Get_all_higher_tasks_cmt (x_project_id in Number,
108 X_task_id in Number,
109 x_task_array Out NOCOPY task_id_tabtype, --File.Sql.39 bug 4440895
110 x_noof_tasks 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 END;