1 package PAY_DYT_COST_ALLOCATIONS_PKG
2 AS
3
4 --
5 /*
6 ==================================================
7 This is a dynamically generated database package
8 containing code to support the use of dynamic
9 triggers.
10 Preference of package Vs dbms triggers supporting
11 dyn' triggers is made via the dated table form.
12 .
13 This code will be called implicitly by table rhi
14 and explictly from non-API packages that maintain
15 data on the relevant table.
16 ==================================================
17 ** DO NOT CHANGE MANUALLY **
18 --------------------------------------------------
19 Package Name: PAY_DYT_COST_ALLOCATIONS_PKG
20 Base Table: PAY_COST_ALLOCATIONS_F
21 Date: 27/11/2012 04:01
22 ==================================================
23 */
24
25 --
26 /*
27 ================================================
28 This is a dynamically generated package procedure
29 with code representing a dynamic trigger
30 ================================================
31 ** DO NOT CHANGE MANUALLY **
32 ------------------------------------------------
33 Name: PAY_COST_ALLOCATIONS_F_ARD_ARD
34 Table: PAY_COST_ALLOCATIONS_F
35 Action: Delete
36 Generated Date: 27/11/2012 04:01
37 Description: Continuous Calculation trigger on deletion of PAY_COST_ALLOCATIONS_F
38 Full trigger name: PAY_COST_ALLOCATIONS_F_ARD
39 ================================================
40 */
41 --
42 PROCEDURE PAY_COST_ALLOCATIONS_F_ARD_ARD
43 (
44 p_new_COST_ALLOCATION_ID in NUMBER
45 ,p_new_DATETRACK_MODE in VARCHAR2
46 ,p_new_EFFECTIVE_DATE in DATE
47 ,p_new_EFFECTIVE_END_DATE in DATE
48 ,p_new_EFFECTIVE_START_DATE in DATE
49 ,p_new_VALIDATION_END_DATE in DATE
50 ,p_new_VALIDATION_START_DATE in DATE
51 ,p_old_ASSIGNMENT_ID in NUMBER
52 ,p_old_BUSINESS_GROUP_ID in NUMBER
53 ,p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER
54 ,p_old_EFFECTIVE_END_DATE in DATE
55 ,p_old_EFFECTIVE_START_DATE in DATE
56 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
57 ,p_old_PROGRAM_APPLICATION_ID in NUMBER
58 ,p_old_PROGRAM_ID in NUMBER
59 ,p_old_PROGRAM_UPDATE_DATE in DATE
60 ,p_old_PROPORTION in NUMBER
61 ,p_old_REQUEST_ID in NUMBER
62 ); -- End of procedure definition for PAY_COST_ALLOCATIONS_F_ARD_ARD
63
64 --
65 /*
66 ================================================
67 This is a dynamically generated package procedure
68 with code representing a dynamic trigger
69 ================================================
70 ** DO NOT CHANGE MANUALLY **
71 ------------------------------------------------
72 Name: PAY_COST_ALLOCATIONS_F_ARI_ARI
73 Table: PAY_COST_ALLOCATIONS_F
74 Action: Insert
75 Generated Date: 27/11/2012 04:01
76 Description: Continuous Calculation trigger on insert of PAY_COST_ALLOCATIONS_F
77 Full trigger name: PAY_COST_ALLOCATIONS_F_ARI
78 ================================================
79 */
80 --
81 PROCEDURE PAY_COST_ALLOCATIONS_F_ARI_ARI
82 (
83 p_new_ASSIGNMENT_ID in NUMBER
84 ,p_new_BUSINESS_GROUP_ID in NUMBER
85 ,p_new_COST_ALLOCATION_ID in NUMBER
86 ,p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER
87 ,p_new_EFFECTIVE_DATE in DATE
88 ,p_new_EFFECTIVE_END_DATE in DATE
89 ,p_new_EFFECTIVE_START_DATE in DATE
90 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
91 ,p_new_PROGRAM_APPLICATION_ID in NUMBER
92 ,p_new_PROGRAM_ID in NUMBER
93 ,p_new_PROGRAM_UPDATE_DATE in DATE
94 ,p_new_PROPORTION in NUMBER
95 ,p_new_REQUEST_ID in NUMBER
96 ,p_new_VALIDATION_END_DATE in DATE
97 ,p_new_VALIDATION_START_DATE in DATE
98 ); -- End of procedure definition for PAY_COST_ALLOCATIONS_F_ARI_ARI
99
100 --
101 /*
102 ================================================
103 This is a dynamically generated package procedure
104 with code representing a dynamic trigger
105 ================================================
106 ** DO NOT CHANGE MANUALLY **
107 ------------------------------------------------
108 Name: PAY_COST_ALLOCATIONS_F_ARU_ARU
109 Table: PAY_COST_ALLOCATIONS_F
110 Action: Update
111 Generated Date: 27/11/2012 04:01
112 Description: Continuous Calcuation trigger on update of PAY_COST_ALLOCATIONS_F
113 Full trigger name: PAY_COST_ALLOCATIONS_F_ARU
114 ================================================
115 */
116 --
117 PROCEDURE PAY_COST_ALLOCATIONS_F_ARU_ARU
118 (
119 p_new_ASSIGNMENT_ID in NUMBER
120 ,p_new_BUSINESS_GROUP_ID in NUMBER
121 ,p_new_COST_ALLOCATION_ID in NUMBER
122 ,p_new_COST_ALLOCATION_KEYFLEX_ in NUMBER
123 ,p_new_DATETRACK_MODE in VARCHAR2
124 ,p_new_EFFECTIVE_DATE in DATE
125 ,p_new_EFFECTIVE_END_DATE in DATE
126 ,p_new_EFFECTIVE_START_DATE in DATE
127 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
128 ,p_new_PROGRAM_APPLICATION_ID in NUMBER
129 ,p_new_PROGRAM_ID in NUMBER
130 ,p_new_PROGRAM_UPDATE_DATE in DATE
131 ,p_new_PROPORTION in NUMBER
132 ,p_new_REQUEST_ID in NUMBER
133 ,p_new_VALIDATION_END_DATE in DATE
134 ,p_new_VALIDATION_START_DATE in DATE
135 ,p_old_ASSIGNMENT_ID in NUMBER
136 ,p_old_BUSINESS_GROUP_ID in NUMBER
137 ,p_old_COST_ALLOCATION_KEYFLEX_ in NUMBER
138 ,p_old_EFFECTIVE_END_DATE in DATE
139 ,p_old_EFFECTIVE_START_DATE in DATE
140 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
141 ,p_old_PROGRAM_APPLICATION_ID in NUMBER
142 ,p_old_PROGRAM_ID in NUMBER
143 ,p_old_PROGRAM_UPDATE_DATE in DATE
144 ,p_old_PROPORTION in NUMBER
145 ,p_old_REQUEST_ID in NUMBER
146 ); -- End of procedure definition for PAY_COST_ALLOCATIONS_F_ARU_ARU
147
148 --
149 /*
150 ================================================
151 This is a dynamically generated procedure.
152 Will be called by API.
153 ================================================
154 ** DO NOT CHANGE MANUALLY **
155 ------------------------------------------------
156 Name: AFTER_INSERT
157 Table: PAY_COST_ALLOCATIONS_F
158 Action: INSERT
159 Generated Date: 27/11/2012 04:01
160 Description: Called as part of INSERT process
161 ================================================
162 */
163
164 --
165 PROCEDURE AFTER_INSERT
166 (
167 P_EFFECTIVE_DATE in DATE
168 ,P_VALIDATION_START_DATE in DATE
169 ,P_VALIDATION_END_DATE in DATE
170 ,P_COST_ALLOCATION_ID in NUMBER
171 ,P_EFFECTIVE_START_DATE in DATE
172 ,P_EFFECTIVE_END_DATE in DATE
173 ,P_BUSINESS_GROUP_ID in NUMBER
174 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
175 ,P_ASSIGNMENT_ID in NUMBER
176 ,P_PROPORTION in NUMBER
177 ,P_REQUEST_ID in NUMBER
178 ,P_PROGRAM_APPLICATION_ID in NUMBER
179 ,P_PROGRAM_ID in NUMBER
180 ,P_PROGRAM_UPDATE_DATE in DATE
181 ,P_OBJECT_VERSION_NUMBER in NUMBER
182 ); -- End of procedure definition for AFTER_INSERT
183
184 --
185 /*
186 ================================================
187 This is a dynamically generated procedure.
188 Will be called by API.
189 ================================================
190 ** DO NOT CHANGE MANUALLY **
191 ------------------------------------------------
192 Name: AFTER_UPDATE
193 Table: PAY_COST_ALLOCATIONS_F
194 Action: UPDATE
195 Generated Date: 27/11/2012 04:01
196 Description: Called as part of UPDATE process
197 ================================================
198 */
199
200 --
201 PROCEDURE AFTER_UPDATE
202 (
203 P_EFFECTIVE_DATE in DATE
204 ,P_DATETRACK_MODE in VARCHAR2
205 ,P_VALIDATION_START_DATE in DATE
206 ,P_VALIDATION_END_DATE in DATE
207 ,P_COST_ALLOCATION_ID in NUMBER
208 ,P_EFFECTIVE_START_DATE in DATE
209 ,P_EFFECTIVE_END_DATE in DATE
210 ,P_BUSINESS_GROUP_ID in NUMBER
211 ,P_COST_ALLOCATION_KEYFLEX_ID in NUMBER
212 ,P_ASSIGNMENT_ID in NUMBER
213 ,P_PROPORTION in NUMBER
214 ,P_REQUEST_ID in NUMBER
215 ,P_PROGRAM_APPLICATION_ID in NUMBER
216 ,P_PROGRAM_ID in NUMBER
217 ,P_PROGRAM_UPDATE_DATE in DATE
218 ,P_OBJECT_VERSION_NUMBER in NUMBER
219 ,P_EFFECTIVE_START_DATE_O in DATE
220 ,P_EFFECTIVE_END_DATE_O in DATE
221 ,P_BUSINESS_GROUP_ID_O in NUMBER
222 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
223 ,P_ASSIGNMENT_ID_O in NUMBER
224 ,P_PROPORTION_O in NUMBER
225 ,P_REQUEST_ID_O in NUMBER
226 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
227 ,P_PROGRAM_ID_O in NUMBER
228 ,P_PROGRAM_UPDATE_DATE_O in DATE
229 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
230 ); -- End of procedure definition for AFTER_UPDATE
231
232 --
233 /*
234 ================================================
235 This is a dynamically generated procedure.
236 Will be called by API.
237 ================================================
238 ** DO NOT CHANGE MANUALLY **
239 ------------------------------------------------
240 Name: AFTER_DELETE
241 Table: PAY_COST_ALLOCATIONS_F
242 Action: DELETE
243 Generated Date: 27/11/2012 04:01
244 Description: Called as part of DELETE process
245 ================================================
246 */
247
248 --
249 PROCEDURE AFTER_DELETE
250 (
251 P_EFFECTIVE_DATE in DATE
252 ,P_DATETRACK_MODE in VARCHAR2
253 ,P_VALIDATION_START_DATE in DATE
254 ,P_VALIDATION_END_DATE in DATE
255 ,P_COST_ALLOCATION_ID in NUMBER
256 ,P_EFFECTIVE_START_DATE in DATE
257 ,P_EFFECTIVE_END_DATE in DATE
258 ,P_EFFECTIVE_START_DATE_O in DATE
259 ,P_EFFECTIVE_END_DATE_O in DATE
260 ,P_BUSINESS_GROUP_ID_O in NUMBER
261 ,P_COST_ALLOCATION_KEYFLEX_ID_O in NUMBER
262 ,P_ASSIGNMENT_ID_O in NUMBER
263 ,P_PROPORTION_O in NUMBER
264 ,P_REQUEST_ID_O in NUMBER
265 ,P_PROGRAM_APPLICATION_ID_O in NUMBER
266 ,P_PROGRAM_ID_O in NUMBER
267 ,P_PROGRAM_UPDATE_DATE_O in DATE
268 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
269 ); -- End of procedure definition for AFTER_DELETE
270
271 --
272 END PAY_DYT_COST_ALLOCATIONS_PKG;