1 Package PA_PURGE_PJR_TXNS AS
2 /* $Header: PAXPJRPS.pls 120.1 2005/08/19 17:16:59 mwasowic noship $ */
3 -- Start of comments
4 -- API name : PA_REQUIREMENTS_PURGE
5 -- Type : Public
6 -- Pre-reqs : None
7 -- Function : Main purge procedure for Purging records related to Requirements for project
8 -- Parameters :
9 -- l p_purge_batch_id -> Purge batch Id
10 -- p_project_id -> Project Id
11 -- p_purge_release -> The release during which it is
12 -- purged
13 -- p_archive_flag -> This flag will indicate if the
14 -- records need to be archived
15 -- before they are purged.
16 -- p_txn_to_date -> Date through which the transactions
17 -- need to be purged. This value will
18 -- be NULL if the purge batch is for
19 -- active projects.
20 -- p_commit_size -> The maximum number of records that
21 -- can be allowed to remain uncommited.
22 -- If the number of records processed
23 -- goes byond this number then the
24 -- process is commited.
25 -- End of comments
26
27 Procedure PA_REQUIREMENTS_PURGE ( p_purge_batch_id in NUMBER,
28 p_project_id in NUMBER,
29 p_purge_release in VARCHAR2,
30 p_txn_to_date in DATE,
31 p_archive_flag in VARCHAR2,
32 p_commit_size in NUMBER,
33 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
36
37
38
39
40 -- Start of comments
41 -- API name : PA_ASSIGNMENTS_PURGE
42 -- Type : Public
43 -- Pre-reqs : None
44 -- Function : Main purge procedure for Purging records related to Assignments for project
45 -- Parameters :
46 -- l p_purge_batch_id -> Purge batch Id
47 -- p_project_id -> Project Id
48 -- p_purge_release -> The release during which it is
49 -- purged
50 -- p_archive_flag -> This flag will indicate if the
51 -- records need to be archived
52 -- before they are purged.
53 -- p_txn_to_date -> Date through which the transactions
54 -- need to be purged. This value will
55 -- be NULL if the purge batch is for
56 -- active projects.
57 -- p_commit_size -> The maximum number of records that
58 -- can be allowed to remain uncommited.
59 -- If the number of records processed
60 -- goes byond this number then the
61 -- process is commited.
62 -- End of comments
63
64
65 Procedure PA_ASSIGNMENTS_PURGE ( p_purge_batch_id in NUMBER,
66 p_project_id in NUMBER,
67 p_purge_release in VARCHAR2,
68 p_txn_to_date in DATE,
69 p_archive_flag in VARCHAR2,
70 p_commit_size in NUMBER,
71 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
72 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
74
75
76 -- Start of comments
77 -- API name : PA_FORECAST_ITEMS_PURGE
78 -- Type : Public
79 -- Pre-reqs : None
80 -- Function : Purge procedure for Purging records from tables PA_FORECAST_ITEMS and PA_FORECAST_ITEM_DETAILS
81 -- Parameters :
82 -- l p_purge_batch_id -> Purge batch Id
83 -- p_project_id -> Project Id
84 -- p_purge_release -> The release during which it is
85 -- purged
86 -- p_archive_flag -> This flag will indicate if the
87 -- records need to be archived
88 -- before they are purged.
89 -- p_assignment_id_tab -> Assignments for which Forecast items
90 -- need to be deleted
91 -- End of comments
92
93
94 Procedure PA_FORECAST_ITEMS_PURGE ( p_purge_batch_id in NUMBER,
95 p_project_id in NUMBER,
96 p_purge_release in VARCHAR2,
97 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
98 p_archive_flag in VARCHAR2,
99 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
100 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
101 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
102
103
104 -- Start of comments
105 -- API name : PA_SCHEDULES_PURGE
106 -- Type : Public
107 -- Pre-reqs : None
108 -- Function : Purge procedure for Purging records from tables PA_Schedules, pa_schedules_history and
109 -- pa_schedule_except_history tables.
110 -- Parameters :
111 -- l p_purge_batch_id -> Purge batch Id
112 -- p_project_id -> Project Id
113 -- p_purge_release -> The release during which it is
114 -- purged
115 -- p_archive_flag -> This flag will indicate if the
116 -- records need to be archived
117 -- before they are purged.
118 -- p_assignment_id_tab -> Assignments for which Forecast items
119 -- need to be deleted
120 -- End of comments
121
122
123 Procedure PA_SCHEDULES_PURGE ( p_purge_batch_id in NUMBER,
124 p_project_id in NUMBER,
125 p_purge_release in VARCHAR2,
126 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
127 p_archive_flag in VARCHAR2,
128 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
129 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
130 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
131
132
133 -- Start of comments
134 -- API name : PA_CANDIDATES_PURGE
135 -- Type : Public
136 -- Pre-reqs : None
137 -- Function : Main purge procedure for Purging records from PA_CANDIDATES and PA_CANDIDATE_REVIEWS table
138
139
140 Procedure PA_CANDIDATES_PURGE ( p_purge_batch_id in NUMBER,
141 p_project_id in NUMBER,
142 p_purge_release in VARCHAR2,
143 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
144 p_archive_flag in VARCHAR2,
145 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
146 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
147 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
148
149 -- Start of comments
150 -- API name : PA_ASSIGNMENT_CONFLICTS_PURGE
151 -- Type : Public
152 -- Pre-reqs : None
153 -- Function : Main purge procedure for Purging records from PA_ASSIGNMENT_CONFLICT_HIST table
154
155
156 Procedure PA_ASSIGNMENT_CONFLICTS_PURGE ( p_purge_batch_id in NUMBER,
157 p_project_id in NUMBER,
158 p_purge_release in VARCHAR2,
159 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
160 p_archive_flag in VARCHAR2,
161 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
162 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
163 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
164
165
166
167 -- Start of comments
168 -- API name : PA_PROJECT_ASSIGNMENT_PURGE
169 -- Type : Public
170 -- Pre-reqs : None
171 -- Function : Main purge procedure for Purging records from PA_PROJECT_ASSIGNMENTS table
172
173
174 Procedure PA_PROJECT_ASSIGNMENT_PURGE ( p_purge_batch_id in NUMBER,
175 p_project_id in NUMBER,
176 p_purge_release in VARCHAR2,
177 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
178 p_archive_flag in VARCHAR2,
179 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
180 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
181 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
182
183
184 -- Start of comments
185 -- API name : PA_PROJECT_PARTIES_PURGE
186 -- Type : Public
187 -- Pre-reqs : None
188 -- Function : Main purge procedure for Purging records from PA_PROJECT_PARTIES table
189
190
191 Procedure PA_PROJECT_PARTIES_PURGE ( p_purge_batch_id in NUMBER,
192 p_project_id in NUMBER,
193 p_purge_release in VARCHAR2,
194 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
195 p_archive_flag in VARCHAR2,
196 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
197 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
199
200 -- Start of comments
201 -- API name : PA_ADVERTISEMENTS_PURGE
202 -- Type : Public
203 -- Pre-reqs : None
204 -- Function : Main purge procedure for Purging records from Advertisements related tables:
205 -- PA_ACTION_SETS,
206 -- PA_ACTION_SET_LINES,
207 -- PA_ACTION_SET_LINE_COND
208 -- PA_ACTION_SET_LINE_AUD
209
210
211 Procedure PA_ADVERTISEMENTS_PURGE ( p_purge_batch_id in NUMBER,
212 p_project_id in NUMBER,
213 p_purge_release in VARCHAR2,
214 p_assignment_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
215 p_archive_flag in VARCHAR2,
216 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
217 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
218 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
219
220
221 -- Start of comments
222 -- API name : PA_WF_PURGE
223 -- Type : Public
224 -- Pre-reqs : None
225 -- Function : Main purge procedure for Purging records from Workflow related tables:
226 -- Note : Argument p_entity_key_tab can have the following values-
227 -- pa_wf_processes.entity_key2
228 -- pa_wf_process_details.object_id1.
229 -- pa_wf_ntf_performers.object_id1.
230
231 PROCEDURE PA_WF_PURGE ( p_purge_batch_id IN NUMBER,
232 p_project_id IN NUMBER,
233 p_purge_release IN VARCHAR2,
234 p_entity_key_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
235 p_wf_type_code in VARCHAR2,
236 p_item_type IN VARCHAR2,
237 p_archive_flag IN VARCHAR2,
238 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
239 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
240 x_err_code IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
241
242 -- Start of comments
243 -- API name : PA_WF_MASS_PURGE
244 -- Type : Public
245 -- Pre-reqs : None
246 -- Function : Procedure for Purging records from Workflow related tables for item_type 'PARMATRX':
247
248 PROCEDURE PA_WF_MASS_PURGE ( p_purge_batch_id IN NUMBER,
249 p_project_id IN NUMBER,
250 p_purge_release IN VARCHAR2,
251 p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
252 p_item_type IN VARCHAR2,
253 p_archive_flag IN VARCHAR2,
254 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
255 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
256 x_err_code IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
257
258 -- Start of comments
259 -- API name : PA_WF_MASS_ASGN_PURGE
260 -- Type : Public
261 -- Pre-reqs : None
262 -- Function : Procedure for Purging records from Workflow related tables for item_type 'PARMAAP':
263
264 PROCEDURE PA_WF_MASS_ASGN_PURGE ( p_purge_batch_id IN NUMBER,
265 p_project_id IN NUMBER,
266 p_purge_release IN VARCHAR2,
267 p_object_id_tab IN Pa_Plsql_Datatypes.IdTabTyp,
268 p_wf_type_code IN VARCHAR2,
269 p_archive_flag IN VARCHAR2,
270 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
271 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
272 x_err_code IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
273
274 -- Start of comments
275 -- API name : PA_WF_KEY_PURGE
276 -- Type : Public
277 -- Pre-reqs : None
278 -- Function : Procedure for Purging records from Workflow related tables where
279 -- pa_wf_processes.entity_key2 does not store assignment_id
280
281 PROCEDURE PA_WF_KEY_PURGE ( p_purge_batch_id IN NUMBER,
282 p_project_id IN NUMBER,
283 p_purge_release IN VARCHAR2,
284 p_entity_key2 IN VARCHAR2,
285 p_wf_type_code IN VARCHAR2,
286 p_item_type IN VARCHAR2,
287 p_archive_flag IN VARCHAR2,
288 x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
289 x_err_stage IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
290 x_err_code IN OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
291
292 END PA_PURGE_PJR_TXNS;