1 package pa_purge_costing AUTHID CURRENT_USER as
2 /* $Header: PAXCSPRS.pls 120.1 2005/08/02 10:58:57 aaggarwa noship $ */
3
4 -- Start of comments
5 -- API name : Pa_Costing_Main_Purge
6 -- Type : Public
7 -- Pre-reqs : None
8 -- Function : This procedure is the main purge procedure for costing
9 -- tables. This procedure calls a procedure that purges
10 -- each of the individual tables.
11 --
12 -- Parameters : p_batch_id IN NUMBER
13 -- The purge batch id for which rows have
14 -- to be purged/archived.
15 -- p_project_Id IN NUMBER,
16 -- The project id for which records have
17 -- to be purged/archived.
18 -- p_txn_to_date IN DATE,
19 -- If the purging is being done on projects
20 -- that are active then this parameter is
21 -- determine the date to which the transactions
22 -- need to be purged.
23 -- p_Commit_Size IN NUMBER,
24 -- The number of records that can be allowed to
25 -- remain uncommited. If the number of records
26 -- goes byond this number then the process is
27 -- commited.
28 -- p_Archive_Flag IN OUT VARCHAR2,
29 -- This flag determines if the records need to
30 -- be archived before they are purged
31 -- p_Purge_Release IN OUT VARCHAR2,
32 -- The version of the application on which the
33 -- purge process is run.
34 -- X_Err_Stack IN OUT VARCHAR2,
35 -- Error stack
36 -- X_Err_Stage IN OUT VARCHAR2,
37 -- Stage in the procedure where error occurred
38 -- X_Err_Code IN OUT NUMBER
39 -- Error code returned from the procedure
40 -- End of comments
41
42 procedure pa_costing_main_purge (
43 p_purge_batch_id in NUMBER,
44 p_project_id in NUMBER,
45 p_purge_release in VARCHAR2,
46 p_txn_to_date in DATE,
47 p_archive_flag in VARCHAR2,
48 p_commit_size in NUMBER,
49 x_err_stack in OUT NOCOPY VARCHAR2,
50 x_err_stage in OUT NOCOPY VARCHAR2,
51 x_err_code in OUT NOCOPY NUMBER ) ;
52
53 procedure PA_CostDistLines (
54 p_purge_batch_id IN NUMBER,
55 p_project_id IN NUMBER,
56 p_txn_to_date IN DATE,
57 p_purge_release IN VARCHAR2,
58 p_archive_flag IN VARCHAR2,
59 p_commit_size IN NUMBER,
60 x_err_code IN OUT NOCOPY NUMBER,
61 x_err_stack IN OUT NOCOPY VARCHAR2,
62 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
63
64 procedure PA_CcDistLines (
65 p_purge_batch_id IN NUMBER,
66 p_project_id IN NUMBER,
67 p_txn_to_date IN DATE,
68 p_purge_release IN VARCHAR2,
69 p_archive_flag IN VARCHAR2,
70 p_commit_size IN NUMBER,
71 x_err_code IN OUT NOCOPY NUMBER,
72 x_err_stack IN OUT NOCOPY VARCHAR2,
73 x_err_stage IN OUT NOCOPY VARCHAR2);
74
75 procedure PA_ExpenditureComments (
76 p_purge_batch_id IN NUMBER,
77 p_project_id IN NUMBER,
78 p_txn_to_date IN DATE,
79 p_purge_release IN VARCHAR2,
80 p_archive_flag IN VARCHAR2,
81 p_commit_size IN NUMBER,
82 x_err_code IN OUT NOCOPY NUMBER,
83 x_err_stack IN OUT NOCOPY VARCHAR2,
84 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
85
86
87 procedure PA_ExpendItemAdjActivities (
88 p_purge_batch_id IN NUMBER,
89 p_project_id IN NUMBER,
90 p_txn_to_date IN DATE,
91 p_purge_release IN VARCHAR2,
92 p_archive_flag IN VARCHAR2,
93 p_commit_size IN NUMBER,
94 x_err_code IN OUT NOCOPY NUMBER,
95 x_err_stack IN OUT NOCOPY VARCHAR2,
96 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
97
98 procedure PA_EiDenorm (
99 p_purge_batch_id IN NUMBER,
100 p_project_id IN NUMBER,
101 p_txn_to_date IN DATE,
102 p_purge_release IN VARCHAR2,
103 p_archive_flag IN VARCHAR2,
104 p_commit_size IN NUMBER,
105 x_err_code IN OUT NOCOPY NUMBER,
106 x_err_stack IN OUT NOCOPY VARCHAR2,
107 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
108
109 procedure PA_ExpenditureHistory (
110 p_purge_batch_id IN NUMBER,
111 p_project_id IN NUMBER,
112 p_txn_to_date IN DATE,
113 p_purge_release IN VARCHAR2,
114 p_archive_flag IN VARCHAR2,
115 p_commit_size IN NUMBER,
116 x_err_code IN OUT NOCOPY NUMBER,
117 x_err_stack IN OUT NOCOPY VARCHAR2,
118 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
119
120 procedure PA_ExpenditureItems (
121 p_purge_batch_id IN NUMBER,
122 p_project_id IN NUMBER,
123 p_txn_to_date IN DATE,
124 p_purge_release IN VARCHAR2,
125 p_archive_flag IN VARCHAR2,
126 p_commit_size IN NUMBER,
127 x_err_code IN OUT NOCOPY NUMBER,
128 x_err_stack IN OUT NOCOPY VARCHAR2,
129 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
130
131 procedure PA_ExpItemsSrcPurge (
132 p_purge_batch_id IN NUMBER,
133 p_project_id IN NUMBER,
134 p_txn_to_date IN DATE,
135 p_purge_release IN VARCHAR2,
136 p_archive_flag IN VARCHAR2,
137 p_commit_size IN NUMBER,
138 x_err_code IN OUT NOCOPY NUMBER,
139 x_err_stack IN OUT NOCOPY VARCHAR2,
140 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
141
142 procedure PA_ExpItemsDestPurge(
143 p_purge_batch_id IN NUMBER,
144 p_project_id IN NUMBER,
145 p_txn_to_date IN DATE,
146 p_purge_release IN VARCHAR2,
147 p_archive_flag IN VARCHAR2,
148 p_commit_size IN NUMBER,
149 x_err_code IN OUT NOCOPY NUMBER,
150 x_err_stack IN OUT NOCOPY VARCHAR2,
151 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
152
153 procedure PA_Routings1 (
154 p_purge_batch_id IN NUMBER,
155 p_project_id IN NUMBER,
156 p_purge_release IN VARCHAR2,
157 p_archive_flag IN VARCHAR2,
158 p_commit_size IN NUMBER,
159 x_err_code IN OUT NOCOPY NUMBER,
160 x_err_stack IN OUT NOCOPY VARCHAR2,
161 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
162
163 procedure PA_Expenditures1 (
164 p_purge_batch_id IN NUMBER,
165 p_project_id IN NUMBER,
166 p_purge_release IN VARCHAR2,
167 p_archive_flag IN VARCHAR2,
168 p_commit_size IN NUMBER,
169 x_err_code IN OUT NOCOPY NUMBER,
170 x_err_stack IN OUT NOCOPY VARCHAR2,
171 x_err_stage IN OUT NOCOPY VARCHAR2 ) ;
172
173 procedure PA_MRCExpenditureItems(
174 p_purge_batch_id IN NUMBER,
175 p_project_id IN NUMBER,
176 p_txn_to_date IN DATE,
177 p_purge_release IN VARCHAR2,
178 p_archive_flag IN VARCHAR2,
179 p_commit_size IN NUMBER,
180 x_err_code IN OUT NOCOPY NUMBER,
181 x_err_stack IN OUT NOCOPY VARCHAR2,
182 x_err_stage IN OUT NOCOPY VARCHAR2,
183 x_MRC_NoOfRecordsIns OUT NOCOPY NUMBER ) ;
184
185 procedure PA_MRCCostDistLines(
186 p_purge_batch_id IN NUMBER,
187 p_project_id IN NUMBER,
188 p_txn_to_date IN DATE,
189 p_purge_release IN VARCHAR2,
190 p_archive_flag IN VARCHAR2,
191 p_commit_size IN NUMBER,
192 x_err_code IN OUT NOCOPY NUMBER,
193 x_err_stack IN OUT NOCOPY VARCHAR2,
194 x_err_stage IN OUT NOCOPY VARCHAR2,
195 x_MRC_NoOfRecordsIns OUT NOCOPY NUMBER ) ;
196
197 PROCEDURE PA_MRCCcDistLines( p_purge_batch_id IN NUMBER,
198 p_project_id IN NUMBER,
199 p_txn_to_date IN DATE,
200 p_purge_release IN VARCHAR2,
201 p_archive_flag IN VARCHAR2,
202 p_commit_size IN NUMBER,
203 x_err_code IN OUT NOCOPY NUMBER,
204 x_err_stack IN OUT NOCOPY VARCHAR2,
205 x_err_stage IN OUT NOCOPY VARCHAR2,
206 x_MRC_NoOfRecordsIns OUT NOCOPY NUMBER );
207
208 END pa_purge_costing;