1 package PAY_DYT_GLOBALS_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_GLOBALS_PKG
20 Base Table: FF_GLOBALS_F
21 Date: 06/11/2008 01:53
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: FF_GLOBALS_F_ARD_ARD
34 Table: FF_GLOBALS_F
35 Action: Delete
36 Generated Date: 06/11/2008 01:53
37 Description: Continuous Calcuation trigger on Delete of FF_GLOBALS_F
38 Full trigger name: FF_GLOBALS_F_ARD
39 ================================================
40 */
41 --
42 PROCEDURE FF_GLOBALS_F_ARD_ARD
43 (
44 p_new_DATETRACK_MODE in VARCHAR2
45 ,p_new_EFFECTIVE_DATE in DATE
46 ,p_new_EFFECTIVE_END_DATE in DATE
47 ,p_new_EFFECTIVE_START_DATE in DATE
48 ,p_new_GLOBAL_ID in NUMBER
49 ,p_new_VALIDATION_END_DATE in DATE
50 ,p_new_VALIDATION_START_DATE in DATE
51 ,p_old_BUSINESS_GROUP_ID in NUMBER
52 ,p_old_DATA_TYPE in VARCHAR2
53 ,p_old_EFFECTIVE_END_DATE in DATE
54 ,p_old_EFFECTIVE_START_DATE in DATE
55 ,p_old_GLOBAL_DESCRIPTION in VARCHAR2
56 ,p_old_GLOBAL_NAME in VARCHAR2
57 ,p_old_GLOBAL_VALUE in VARCHAR2
58 ,p_old_LEGISLATION_CODE in VARCHAR2
59 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
60 ); -- End of procedure definition for FF_GLOBALS_F_ARD_ARD
61
62 --
63 /*
64 ================================================
65 This is a dynamically generated package procedure
66 with code representing a dynamic trigger
67 ================================================
68 ** DO NOT CHANGE MANUALLY **
69 ------------------------------------------------
70 Name: FF_GLOBALS_F_ARI_ARI
71 Table: FF_GLOBALS_F
72 Action: Insert
73 Generated Date: 06/11/2008 01:53
74 Description: Continuous Calcuation trigger on Insert of FF_GLOBALS_F
75 Full trigger name: FF_GLOBALS_F_ARI
76 ================================================
77 */
78 --
79 PROCEDURE FF_GLOBALS_F_ARI_ARI
80 (
81 p_new_BUSINESS_GROUP_ID in NUMBER
82 ,p_new_DATA_TYPE in VARCHAR2
83 ,p_new_EFFECTIVE_DATE in DATE
84 ,p_new_EFFECTIVE_END_DATE in DATE
85 ,p_new_EFFECTIVE_START_DATE in DATE
86 ,p_new_GLOBAL_DESCRIPTION in VARCHAR2
87 ,p_new_GLOBAL_ID in NUMBER
88 ,p_new_GLOBAL_NAME in VARCHAR2
89 ,p_new_GLOBAL_VALUE in VARCHAR2
90 ,p_new_LEGISLATION_CODE in VARCHAR2
91 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
92 ,p_new_VALIDATION_END_DATE in DATE
93 ,p_new_VALIDATION_START_DATE in DATE
94 ); -- End of procedure definition for FF_GLOBALS_F_ARI_ARI
95
96 --
97 /*
98 ================================================
99 This is a dynamically generated package procedure
100 with code representing a dynamic trigger
101 ================================================
102 ** DO NOT CHANGE MANUALLY **
103 ------------------------------------------------
104 Name: FF_GLOBALS_F_ARU_ARU
105 Table: FF_GLOBALS_F
106 Action: Update
107 Generated Date: 06/11/2008 01:53
108 Description: Continuous Calcuation trigger on update of FF_GLOBALS_F
109 Full trigger name: FF_GLOBALS_F_ARU
110 ================================================
111 */
112 --
113 PROCEDURE FF_GLOBALS_F_ARU_ARU
114 (
115 p_new_BUSINESS_GROUP_ID in NUMBER
116 ,p_new_DATA_TYPE in VARCHAR2
117 ,p_new_DATETRACK_MODE in VARCHAR2
118 ,p_new_EFFECTIVE_DATE in DATE
119 ,p_new_EFFECTIVE_END_DATE in DATE
120 ,p_new_EFFECTIVE_START_DATE in DATE
121 ,p_new_GLOBAL_DESCRIPTION in VARCHAR2
122 ,p_new_GLOBAL_ID in NUMBER
123 ,p_new_GLOBAL_NAME in VARCHAR2
124 ,p_new_GLOBAL_VALUE in VARCHAR2
125 ,p_new_LEGISLATION_CODE in VARCHAR2
126 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
127 ,p_new_VALIDATION_END_DATE in DATE
128 ,p_new_VALIDATION_START_DATE in DATE
129 ,p_old_BUSINESS_GROUP_ID in NUMBER
130 ,p_old_DATA_TYPE in VARCHAR2
131 ,p_old_EFFECTIVE_END_DATE in DATE
132 ,p_old_EFFECTIVE_START_DATE in DATE
133 ,p_old_GLOBAL_DESCRIPTION in VARCHAR2
134 ,p_old_GLOBAL_NAME in VARCHAR2
135 ,p_old_GLOBAL_VALUE in VARCHAR2
136 ,p_old_LEGISLATION_CODE in VARCHAR2
137 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
138 ); -- End of procedure definition for FF_GLOBALS_F_ARU_ARU
139
140 --
141 /*
142 ================================================
143 This is a dynamically generated procedure.
144 Will be called by API.
145 ================================================
146 ** DO NOT CHANGE MANUALLY **
147 ------------------------------------------------
148 Name: AFTER_INSERT
149 Table: FF_GLOBALS_F
150 Action: INSERT
151 Generated Date: 06/11/2008 01:53
152 Description: Called as part of INSERT process
153 ================================================
154 */
155
156 --
157 PROCEDURE AFTER_INSERT
158 (
159 P_EFFECTIVE_DATE in DATE
160 ,P_VALIDATION_START_DATE in DATE
161 ,P_VALIDATION_END_DATE in DATE
162 ,P_GLOBAL_ID in NUMBER
163 ,P_EFFECTIVE_START_DATE in DATE
164 ,P_EFFECTIVE_END_DATE in DATE
165 ,P_BUSINESS_GROUP_ID in NUMBER
166 ,P_LEGISLATION_CODE in VARCHAR2
167 ,P_DATA_TYPE in VARCHAR2
168 ,P_GLOBAL_NAME in VARCHAR2
169 ,P_GLOBAL_DESCRIPTION in VARCHAR2
170 ,P_GLOBAL_VALUE in VARCHAR2
171 ,P_OBJECT_VERSION_NUMBER in NUMBER
172 ); -- End of procedure definition for AFTER_INSERT
173
174 --
175 /*
176 ================================================
177 This is a dynamically generated procedure.
178 Will be called by API.
179 ================================================
180 ** DO NOT CHANGE MANUALLY **
181 ------------------------------------------------
182 Name: AFTER_UPDATE
183 Table: FF_GLOBALS_F
184 Action: UPDATE
185 Generated Date: 06/11/2008 01:53
186 Description: Called as part of UPDATE process
187 ================================================
188 */
189
190 --
191 PROCEDURE AFTER_UPDATE
192 (
193 P_EFFECTIVE_DATE in DATE
194 ,P_DATETRACK_MODE in VARCHAR2
195 ,P_VALIDATION_START_DATE in DATE
196 ,P_VALIDATION_END_DATE in DATE
197 ,P_GLOBAL_ID in NUMBER
198 ,P_EFFECTIVE_START_DATE in DATE
199 ,P_EFFECTIVE_END_DATE in DATE
200 ,P_BUSINESS_GROUP_ID in NUMBER
201 ,P_LEGISLATION_CODE in VARCHAR2
202 ,P_DATA_TYPE in VARCHAR2
203 ,P_GLOBAL_NAME in VARCHAR2
204 ,P_GLOBAL_DESCRIPTION in VARCHAR2
205 ,P_GLOBAL_VALUE in VARCHAR2
206 ,P_OBJECT_VERSION_NUMBER in NUMBER
207 ,P_EFFECTIVE_START_DATE_O in DATE
208 ,P_EFFECTIVE_END_DATE_O in DATE
209 ,P_BUSINESS_GROUP_ID_O in NUMBER
210 ,P_LEGISLATION_CODE_O in VARCHAR2
211 ,P_DATA_TYPE_O in VARCHAR2
212 ,P_GLOBAL_NAME_O in VARCHAR2
213 ,P_GLOBAL_DESCRIPTION_O in VARCHAR2
214 ,P_GLOBAL_VALUE_O in VARCHAR2
215 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
216 ); -- End of procedure definition for AFTER_UPDATE
217
218 --
219 /*
220 ================================================
221 This is a dynamically generated procedure.
222 Will be called by API.
223 ================================================
224 ** DO NOT CHANGE MANUALLY **
225 ------------------------------------------------
226 Name: AFTER_DELETE
227 Table: FF_GLOBALS_F
228 Action: DELETE
229 Generated Date: 06/11/2008 01:53
230 Description: Called as part of DELETE process
231 ================================================
232 */
233
234 --
235 PROCEDURE AFTER_DELETE
236 (
237 P_EFFECTIVE_DATE in DATE
238 ,P_DATETRACK_MODE in VARCHAR2
239 ,P_VALIDATION_START_DATE in DATE
240 ,P_VALIDATION_END_DATE in DATE
241 ,P_GLOBAL_ID in NUMBER
242 ,P_EFFECTIVE_START_DATE in DATE
243 ,P_EFFECTIVE_END_DATE in DATE
244 ,P_EFFECTIVE_START_DATE_O in DATE
245 ,P_EFFECTIVE_END_DATE_O in DATE
249 ,P_GLOBAL_NAME_O in VARCHAR2
246 ,P_BUSINESS_GROUP_ID_O in NUMBER
247 ,P_LEGISLATION_CODE_O in VARCHAR2
248 ,P_DATA_TYPE_O in VARCHAR2
250 ,P_GLOBAL_DESCRIPTION_O in VARCHAR2
251 ,P_GLOBAL_VALUE_O in VARCHAR2
252 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
253 ); -- End of procedure definition for AFTER_DELETE
254
255 --
256 END PAY_DYT_GLOBALS_PKG;