1 PACKAGE pa_project_dates_utils AUTHID CURRENT_USER AS
2 /* $Header: PARMPDUS.pls 120.7.12010000.3 2010/05/02 22:25:35 nisinha ship $ */
3
4 -- API name : Get_Project_Start_Date
5 -- Type : Utility
6 -- Pre-reqs : None.
7 -- Parameters :
8 -- p_project_id IN NUMBER
9
10 FUNCTION GET_PROJECT_START_DATE
11 ( p_project_id IN NUMBER
12 ) RETURN DATE;
13
14
15 -- API name : Get_Project_Finish_Date
16 -- Type : Utility
17 -- Pre-reqs : None.
18 -- Parameters :
19 -- p_project_id IN NUMBER
20
21 FUNCTION GET_PROJECT_FINISH_DATE
22 ( p_project_id IN NUMBER
23 ) RETURN DATE;
24
25
26 -- API name : Check_Financial_Task_Exists
27 -- Type : Utility
28 -- Pre-reqs : None.
29 -- Parameters :
30 -- p_proj_element_id IN NUMBER
31
32 FUNCTION CHECK_FINANCIAL_TASK_EXISTS
33 ( p_proj_element_id IN NUMBER
34 ) RETURN VARCHAR2;
35
36
37 -- API name : Get_Task_Start_Date
38 -- Type : Utility
39 -- Pre-reqs : None.
40 -- Parameters :
41 -- p_project_id IN NUMBER
42 -- p_proj_element_id IN NUMBER
43 -- p_parent_structure_version_id IN NUMBER
44 -- x_task_start_date OUT DATE
45 -- x_start_as_of_date OUT DATE
46 PROCEDURE GET_TASK_START_DATE
47 ( p_project_id IN NUMBER
48 ,p_proj_element_id IN NUMBER
49 ,p_parent_structure_version_id IN NUMBER
50 ,x_task_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
51 ,x_start_as_of_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
52 );
53
54
55 -- API name : Get_Task_Finish_Date
56 -- Type : Utility
57 -- Pre-reqs : None.
58 -- Parameters :
59 -- p_project_id IN NUMBER
60 -- p_proj_element_id IN NUMBER
61 -- p_parent_structure_version_id IN NUMBER
62 -- x_task_finish_date OUT DATE
63 -- x_finish_as_of_date OUT DATE
64 PROCEDURE GET_TASK_FINISH_DATE
65 ( p_project_id IN NUMBER
66 ,p_proj_element_id IN NUMBER
67 ,p_parent_structure_version_id IN NUMBER
68 ,x_task_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
69 ,x_finish_as_of_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
70 );
71
72
73 -- API name : Get_Task_Derived_Dates
74 -- Type : Utility
75 -- Pre-reqs : None.
76 -- Parameters :
77 -- p_project_id IN NUMBER
78 -- p_proj_element_id IN NUMBER
79 -- p_parent_structure_version_id IN NUMBER
80 -- x_task_start_date OUT DATE
81 -- x_task_finish_date OUT DATE
82 -- x_task_as_of_date OUT DATE
83 PROCEDURE GET_TASK_DERIVED_DATES
84 ( p_project_id IN NUMBER
85 ,p_proj_element_id IN NUMBER
86 ,p_parent_structure_version_id IN NUMBER
87 ,x_task_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
88 ,x_task_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
89 ,x_task_as_of_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
90 );
91
92
93 -- API name : Get_Task_Copy_Dates
94 -- Type : Utility
95 -- Pre-reqs : None.
96 -- Parameters :
97 -- p_project_id IN NUMBER
98 -- p_proj_element_id IN NUMBER
99 -- p_parent_structure_version_id IN NUMBER
100 -- x_task_start_date OUT DATE
101 -- x_task_finish_date OUT DATE
102 PROCEDURE GET_TASK_COPY_DATES
103 ( p_project_id IN NUMBER
104 ,p_proj_element_id IN NUMBER
105 ,p_parent_structure_version_id IN NUMBER
106 ,x_task_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
107 ,x_task_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
108 ,p_act_fin_date_flag IN VARCHAR2 DEFAULT 'Y' --bug 4229865
109 );
110
111
112 -- API name : Get_Default_Proj_Start_Date
113 -- Type : Utility
114 -- Pre-reqs : None.
115 -- Parameters :
116 -- p_project_id IN NUMBER
117
118 FUNCTION GET_DEFAULT_PROJ_START_DATE
119 ( p_project_id IN NUMBER
120 ) RETURN DATE;
121
122 -- Bug 6335446: Start
123 -- API name : Get_Default_Assign_Start_Date
124 -- Type : Utility
125 -- Pre-reqs : None.
126 -- Parameters :
127 -- p_project_id IN NUMBER
128
129 FUNCTION GET_DEFAULT_ASSIGN_START_DATE
130 ( p_project_id IN NUMBER
131 ) RETURN DATE;
132 -- Bug 6335446: End
133
134 -- API name : Get_Struct_Schedule_Dates
135 -- Type : Utility
136 -- Pre-reqs : None.
137 -- Parameters :
138 -- p_structure_version_id IN NUMBER
139 -- x_schedule_start_date OUT DATE
140 -- x_schedule_finish_date OUT DATE
141 -- x_schedule_as_of_date OUT DATE
142 -- x_schedule_duration OUT NUMBER
143 PROCEDURE GET_STRUCT_SCHEDULE_DATES
144 ( p_structure_version_id IN NUMBER
145 ,x_schedule_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
146 ,x_schedule_finish_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
147 ,x_schedule_as_of_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
148 ,x_schedule_duration OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
149 );
150
151 -- API name : Get_Project_Start_Date_Src
152 -- Type : Utility
153 -- Pre-reqs : None.
154 -- Parameters :
155 -- p_project_id IN NUMBER
156
157 FUNCTION GET_PROJECT_START_DATE_SRC
158 ( p_project_id IN NUMBER
159 ) RETURN VARCHAR2;
160
161 -- Bug 6335446: Start
162 -- API name : IS_VALID_ASSIGN_START_DATE
163 -- Type : Utility
164 -- Pre-reqs : None.
165 -- Parameters :
166 -- p_project_id IN NUMBER
167 -- p_assign_start_date IN DATE
168
169 FUNCTION IS_VALID_ASSIGN_START_DATE
170 ( p_project_id IN NUMBER,
171 p_assign_start_date IN DATE
172 ) RETURN VARCHAR2;
173 -- Bug 6335446: End
174
175 -- API name : Get_Project_Finish_Date_Src
176 -- Type : Utility
177 -- Pre-reqs : None.
178 -- Parameters :
179 -- p_project_id IN NUMBER
180
181 FUNCTION GET_PROJECT_FINISH_DATE_SRC
182 ( p_project_id IN NUMBER
183 ) RETURN VARCHAR2;
184
185 -- API name : chek_all_tsk_have_act_fin_dt
186 -- Type : Utility
187 -- Pre-reqs : None.
188 -- Parameters :
189 -- p_project_id IN NUMBER
190
191 FUNCTION chek_all_tsk_have_act_fin_dt
192 ( p_project_id IN NUMBER,
193 p_parent_structure_version_id IN NUMBER
194 ) RETURN VARCHAR2;
195
196 -- API name : chek_one_task_has_act_st_date
197 -- Type : Utility
198 -- Pre-reqs : None.
199 -- Parameters :
200 -- p_project_id IN NUMBER
201
202 FUNCTION chek_one_task_has_act_st_date
203 ( p_project_id IN NUMBER,
204 p_parent_structure_version_id IN NUMBER
205 ) RETURN VARCHAR2;
206
207
208 /*============Bug 6511907:PJR DATE VALIDATION ENHANCEMENT=======START=======*/
209 PROCEDURE Validate_Project_Dates
210 (p_project_id IN NUMBER,
211 p_start_date IN DATE,
212 p_end_date IN DATE,
213 x_validate OUT NOCOPY VARCHAR2,
214 x_start_date_status OUT NOCOPY VARCHAR2,
215 x_end_date_status OUT NOCOPY VARCHAR2);
216
217 PROCEDURE Validate_Resource_Dates
218 (p_project_id IN NUMBER,
219 p_start_date IN OUT NOCOPY DATE,
220 p_end_date IN OUT NOCOPY DATE,
221 x_validate OUT NOCOPY VARCHAR2,
222 x_start_date_status OUT NOCOPY VARCHAR2,
223 x_end_date_status OUT NOCOPY VARCHAR2);
224
225
226
227 /* NISINHA Updatable Scheduled people ER */
228 PROCEDURE VALIDATE_ASSIGNMENT_DATES_BULK
229 (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
230 p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
231 p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
232 x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
233 x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
234 x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
235 x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
236
237 /* NISINHA Updatable Scheduled people ER */
238
239
240 /* PRABSING Bug 7693634 Start */
241
242 PROCEDURE Validate_Resource_Dates_Bulk
243 (p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
244 p_start_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
245 p_end_date_tbl IN OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE,
246 x_validate_tbl IN OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
247 x_start_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
248 x_end_date_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE,
249 x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
250
251 /* PRABSING Bug 7693634 Start */
252
253 PROCEDURE Validate_Template_Team_Dates
254 (p_project_id IN NUMBER,
255 p_template_id IN NUMBER,
256 x_validate OUT NOCOPY VARCHAR2,
257 x_start_date_status OUT NOCOPY VARCHAR2,
258 x_end_date_status OUT NOCOPY VARCHAR2);
259 /*============Bug 6511907:PJR DATE VALIDATION ENHANCEMENT=======END=======*/
260
261 /*===============Bug 6860603======================*/
262 PROCEDURE WPP_Validate_Project_Dates
263 (p_project_id IN NUMBER,
264 p_start_date IN DATE,
265 p_end_date IN DATE,
266 p_alwd_start_date OUT NOCOPY DATE,
267 p_alwd_end_date OUT NOCOPY DATE,
268 p_res_min_date OUT NOCOPY DATE,
269 p_res_max_date OUT NOCOPY DATE,
270 x_validate OUT NOCOPY VARCHAR2,
271 x_start_date_status OUT NOCOPY VARCHAR2,
272 x_end_date_status OUT NOCOPY VARCHAR2);
273 /*===============Bug 6860603======================*/
274
275
276 END PA_PROJECT_DATES_UTILS;