1 package PAY_DYT_USER_COLUMN_INSTA_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_USER_COLUMN_INSTA_PKG
20 Base Table: PAY_USER_COLUMN_INSTANCES_F
21 Date: 03/01/2007 23:13
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_USER_COLUMN_INSTANCES__ARD
34 Table: PAY_USER_COLUMN_INSTANCES_F
35 Action: Delete
36 Generated Date: 03/01/2007 23:13
37 Description: Continuous Calcuation trigger on Delete of PAY_USER_COLUMN_INSTANCES_F
38 Full trigger name: PAY_USER_COLUMN_INSTANCES_F_ARD
39 ================================================
40 */
41 --
42 PROCEDURE PAY_USER_COLUMN_INSTANCES__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_USER_COLUMN_INSTANCE_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_EFFECTIVE_END_DATE in DATE
53 ,p_old_EFFECTIVE_START_DATE in DATE
54 ,p_old_LEGISLATION_CODE in VARCHAR2
55 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
56 ,p_old_USER_COLUMN_ID in NUMBER
57 ,p_old_USER_ROW_ID in NUMBER
58 ,p_old_VALUE in VARCHAR2
59 ); -- End of procedure definition for PAY_USER_COLUMN_INSTANCES__ARD
60
61 --
62 /*
63 ================================================
64 This is a dynamically generated package procedure
65 with code representing a dynamic trigger
66 ================================================
67 ** DO NOT CHANGE MANUALLY **
68 ------------------------------------------------
69 Name: PAY_USER_COLUMN_INSTANCES__ARI
70 Table: PAY_USER_COLUMN_INSTANCES_F
71 Action: Insert
72 Generated Date: 03/01/2007 23:13
73 Description: Continuous Calcuation trigger on Insert of PAY_USER_COLUMN_INSTANCES_F
74 Full trigger name: PAY_USER_COLUMN_INSTANCES_F_ARI
75 ================================================
76 */
77 --
78 PROCEDURE PAY_USER_COLUMN_INSTANCES__ARI
79 (
80 p_new_BUSINESS_GROUP_ID in NUMBER
81 ,p_new_EFFECTIVE_DATE in DATE
82 ,p_new_EFFECTIVE_END_DATE in DATE
83 ,p_new_EFFECTIVE_START_DATE in DATE
84 ,p_new_LEGISLATION_CODE in VARCHAR2
85 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
86 ,p_new_USER_COLUMN_ID in NUMBER
87 ,p_new_USER_COLUMN_INSTANCE_ID in NUMBER
88 ,p_new_USER_ROW_ID in NUMBER
89 ,p_new_VALIDATION_END_DATE in DATE
90 ,p_new_VALIDATION_START_DATE in DATE
91 ,p_new_VALUE in VARCHAR2
92 ); -- End of procedure definition for PAY_USER_COLUMN_INSTANCES__ARI
93
94 --
95 /*
96 ================================================
97 This is a dynamically generated package procedure
98 with code representing a dynamic trigger
99 ================================================
100 ** DO NOT CHANGE MANUALLY **
101 ------------------------------------------------
102 Name: PAY_USER_COLUMN_INSTANCES__ARU
103 Table: PAY_USER_COLUMN_INSTANCES_F
104 Action: Update
105 Generated Date: 03/01/2007 23:13
106 Description: Continuous Calcuation trigger on update of PAY_USER_COLUMN_INSTANCES_F
107 Full trigger name: PAY_USER_COLUMN_INSTANCES_F_ARU
108 ================================================
109 */
110 --
111 PROCEDURE PAY_USER_COLUMN_INSTANCES__ARU
112 (
113 p_new_DATETRACK_MODE in VARCHAR2
114 ,p_new_EFFECTIVE_DATE in DATE
115 ,p_new_EFFECTIVE_END_DATE in DATE
116 ,p_new_EFFECTIVE_START_DATE in DATE
117 ,p_new_OBJECT_VERSION_NUMBER in NUMBER
118 ,p_new_USER_COLUMN_INSTANCE_ID in NUMBER
119 ,p_new_VALIDATION_END_DATE in DATE
120 ,p_new_VALIDATION_START_DATE in DATE
121 ,p_new_VALUE in VARCHAR2
122 ,p_old_BUSINESS_GROUP_ID in NUMBER
123 ,p_old_EFFECTIVE_END_DATE in DATE
124 ,p_old_EFFECTIVE_START_DATE in DATE
125 ,p_old_LEGISLATION_CODE in VARCHAR2
126 ,p_old_OBJECT_VERSION_NUMBER in NUMBER
127 ,p_old_USER_COLUMN_ID in NUMBER
128 ,p_old_USER_ROW_ID in NUMBER
129 ,p_old_VALUE in VARCHAR2
130 ); -- End of procedure definition for PAY_USER_COLUMN_INSTANCES__ARU
131
132 --
133 /*
134 ================================================
135 This is a dynamically generated procedure.
136 Will be called by API.
137 ================================================
138 ** DO NOT CHANGE MANUALLY **
139 ------------------------------------------------
140 Name: AFTER_INSERT
141 Table: PAY_USER_COLUMN_INSTANCES_F
142 Action: INSERT
143 Generated Date: 03/01/2007 23:13
144 Description: Called as part of INSERT process
145 ================================================
146 */
147
148 --
149 PROCEDURE AFTER_INSERT
150 (
151 P_EFFECTIVE_DATE in DATE
152 ,P_VALIDATION_START_DATE in DATE
153 ,P_VALIDATION_END_DATE in DATE
154 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
155 ,P_EFFECTIVE_START_DATE in DATE
156 ,P_EFFECTIVE_END_DATE in DATE
157 ,P_USER_ROW_ID in NUMBER
158 ,P_USER_COLUMN_ID in NUMBER
159 ,P_BUSINESS_GROUP_ID in NUMBER
160 ,P_LEGISLATION_CODE in VARCHAR2
161 ,P_VALUE in VARCHAR2
162 ,P_OBJECT_VERSION_NUMBER in NUMBER
163 ); -- End of procedure definition for AFTER_INSERT
164
165 --
166 /*
167 ================================================
168 This is a dynamically generated procedure.
169 Will be called by API.
170 ================================================
171 ** DO NOT CHANGE MANUALLY **
172 ------------------------------------------------
173 Name: AFTER_UPDATE
174 Table: PAY_USER_COLUMN_INSTANCES_F
175 Action: UPDATE
176 Generated Date: 03/01/2007 23:13
177 Description: Called as part of UPDATE process
178 ================================================
179 */
180
181 --
182 PROCEDURE AFTER_UPDATE
183 (
184 P_EFFECTIVE_DATE in DATE
185 ,P_DATETRACK_MODE in VARCHAR2
186 ,P_VALIDATION_START_DATE in DATE
187 ,P_VALIDATION_END_DATE in DATE
188 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
189 ,P_EFFECTIVE_START_DATE in DATE
190 ,P_EFFECTIVE_END_DATE in DATE
191 ,P_VALUE in VARCHAR2
192 ,P_OBJECT_VERSION_NUMBER in NUMBER
193 ,P_EFFECTIVE_START_DATE_O in DATE
194 ,P_EFFECTIVE_END_DATE_O in DATE
195 ,P_USER_ROW_ID_O in NUMBER
196 ,P_USER_COLUMN_ID_O in NUMBER
197 ,P_BUSINESS_GROUP_ID_O in NUMBER
198 ,P_LEGISLATION_CODE_O in VARCHAR2
199 ,P_VALUE_O in VARCHAR2
200 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
201 ); -- End of procedure definition for AFTER_UPDATE
202
203 --
204 /*
205 ================================================
206 This is a dynamically generated procedure.
207 Will be called by API.
208 ================================================
209 ** DO NOT CHANGE MANUALLY **
210 ------------------------------------------------
211 Name: AFTER_DELETE
212 Table: PAY_USER_COLUMN_INSTANCES_F
213 Action: DELETE
214 Generated Date: 03/01/2007 23:13
215 Description: Called as part of DELETE process
216 ================================================
217 */
218
219 --
220 PROCEDURE AFTER_DELETE
221 (
222 P_EFFECTIVE_DATE in DATE
223 ,P_DATETRACK_MODE in VARCHAR2
224 ,P_VALIDATION_START_DATE in DATE
225 ,P_VALIDATION_END_DATE in DATE
226 ,P_USER_COLUMN_INSTANCE_ID in NUMBER
227 ,P_EFFECTIVE_START_DATE in DATE
228 ,P_EFFECTIVE_END_DATE in DATE
229 ,P_EFFECTIVE_START_DATE_O in DATE
230 ,P_EFFECTIVE_END_DATE_O in DATE
231 ,P_USER_ROW_ID_O in NUMBER
232 ,P_USER_COLUMN_ID_O in NUMBER
233 ,P_BUSINESS_GROUP_ID_O in NUMBER
234 ,P_LEGISLATION_CODE_O in VARCHAR2
235 ,P_VALUE_O in VARCHAR2
236 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
237 ); -- End of procedure definition for AFTER_DELETE
238
239 --
240 END PAY_DYT_USER_COLUMN_INSTA_PKG;