1 package PAY_DYT_ELEMENT_ENTRY_VAL_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_ELEMENT_ENTRY_VAL_PKG
20 Base Table: PAY_ELEMENT_ENTRY_VALUES_F
21 Date: 30/03/2009 04: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: PAY_ELEMENT_ENTRY_VALUES_F_ARU
34 Table: PAY_ELEMENT_ENTRY_VALUES_F
35 Action: Update
36 Generated Date: 30/03/2009 04:53
37 Description: Continuous Calculation trigger on update of element entry value
38 Full trigger name: PAY_ELEMENT_ENTRY_VALUES_F_ARU
39 ================================================
40 */
41 --
42 PROCEDURE PAY_ELEMENT_ENTRY_VALUES_F_ARU
43 (
44 p_new_EFFECTIVE_END_DATE in DATE
45 ,p_new_EFFECTIVE_START_DATE in DATE
46 ,p_new_ELEMENT_ENTRY_ID in NUMBER
47 ,p_new_ELEMENT_ENTRY_VALUE_ID in NUMBER
48 ,p_new_INPUT_VALUE_ID in NUMBER
49 ,p_new_SCREEN_ENTRY_VALUE in VARCHAR2
50 ,p_old_EFFECTIVE_END_DATE in DATE
51 ,p_old_EFFECTIVE_START_DATE in DATE
52 ,p_old_ELEMENT_ENTRY_ID in NUMBER
53 ,p_old_ELEMENT_ENTRY_VALUE_ID in NUMBER
54 ,p_old_INPUT_VALUE_ID in NUMBER
55 ,p_old_SCREEN_ENTRY_VALUE in VARCHAR2
56 ); -- End of procedure definition for PAY_ELEMENT_ENTRY_VALUES_F_ARU
57
58 --
59 /*
60 ================================================
61 This is a dynamically generated package procedure
62 with code representing a dynamic trigger
63 ================================================
64 ** DO NOT CHANGE MANUALLY **
65 ------------------------------------------------
66 Name: ES_SS_REP_ELEMENT_I_I
67 Table: PAY_ELEMENT_ENTRY_VALUES_F
68 Action: Insert
69 Generated Date: 30/03/2009 04:53
70 Description: Spanish Trigger for Social Security Reporting
71 Full trigger name: ES_SS_REP_ELEMENT_I
72 ================================================
73 */
74 --
75 PROCEDURE ES_SS_REP_ELEMENT_I_I
76 (
77 p_new_EFFECTIVE_END_DATE in DATE
78 ,p_new_EFFECTIVE_START_DATE in DATE
79 ,p_new_ELEMENT_ENTRY_ID in NUMBER
80 ,p_new_ELEMENT_ENTRY_VALUE_ID in NUMBER
81 ,p_new_INPUT_VALUE_ID in NUMBER
82 ,p_new_SCREEN_ENTRY_VALUE in VARCHAR2
83 ,p_old_EFFECTIVE_END_DATE in DATE
84 ,p_old_EFFECTIVE_START_DATE in DATE
85 ,p_old_ELEMENT_ENTRY_ID in NUMBER
86 ,p_old_ELEMENT_ENTRY_VALUE_ID in NUMBER
87 ,p_old_INPUT_VALUE_ID in NUMBER
88 ,p_old_SCREEN_ENTRY_VALUE in VARCHAR2
89 ); -- End of procedure definition for ES_SS_REP_ELEMENT_I_I
90
91 --
92 /*
93 ================================================
94 This is a dynamically generated package procedure
95 with code representing a dynamic trigger
96 ================================================
97 ** DO NOT CHANGE MANUALLY **
98 ------------------------------------------------
99 Name: ES_SS_REP_ELEMENT_U_U
100 Table: PAY_ELEMENT_ENTRY_VALUES_F
101 Action: Update
102 Generated Date: 30/03/2009 04:53
103 Description: Spanish Trigger for Social Security Reporting
104 Full trigger name: ES_SS_REP_ELEMENT_U
105 ================================================
106 */
107 --
108 PROCEDURE ES_SS_REP_ELEMENT_U_U
109 (
110 p_new_EFFECTIVE_END_DATE in DATE
111 ,p_new_EFFECTIVE_START_DATE in DATE
112 ,p_new_ELEMENT_ENTRY_ID in NUMBER
113 ,p_new_ELEMENT_ENTRY_VALUE_ID in NUMBER
114 ,p_new_INPUT_VALUE_ID in NUMBER
115 ,p_new_SCREEN_ENTRY_VALUE in VARCHAR2
116 ,p_old_EFFECTIVE_END_DATE in DATE
117 ,p_old_EFFECTIVE_START_DATE in DATE
118 ,p_old_ELEMENT_ENTRY_ID in NUMBER
119 ,p_old_ELEMENT_ENTRY_VALUE_ID in NUMBER
120 ,p_old_INPUT_VALUE_ID in NUMBER
121 ,p_old_SCREEN_ENTRY_VALUE in VARCHAR2
122 ); -- End of procedure definition for ES_SS_REP_ELEMENT_U_U
123
124 --
125 /*
126 ================================================
127 This is a dynamically generated procedure.
128 Will be called by API.
129 ================================================
130 ** DO NOT CHANGE MANUALLY **
131 ------------------------------------------------
132 Name: AFTER_INSERT
133 Table: PAY_ELEMENT_ENTRY_VALUES_F
134 Action: INSERT
135 Generated Date: 30/03/2009 04:53
136 Description: Called as part of INSERT process
137 ================================================
138 */
139
140 --
141 PROCEDURE AFTER_INSERT
142 (
143 P_EFFECTIVE_END_DATE in DATE
144 ,P_EFFECTIVE_START_DATE in DATE
145 ,P_ELEMENT_ENTRY_ID in NUMBER
146 ,P_ELEMENT_ENTRY_VALUE_ID in NUMBER
147 ,P_INPUT_VALUE_ID in NUMBER
148 ,P_SCREEN_ENTRY_VALUE in VARCHAR2
149 ,P_EFFECTIVE_END_DATE_O in DATE
150 ,P_EFFECTIVE_START_DATE_O in DATE
151 ,P_ELEMENT_ENTRY_ID_O in NUMBER
152 ,P_ELEMENT_ENTRY_VALUE_ID_O in NUMBER
153 ,P_INPUT_VALUE_ID_O in NUMBER
154 ,P_SCREEN_ENTRY_VALUE_O in VARCHAR2
155 ); -- End of procedure definition for AFTER_INSERT
156
157 --
158 /*
159 ================================================
160 This is a dynamically generated procedure.
161 Will be called by API.
162 ================================================
163 ** DO NOT CHANGE MANUALLY **
164 ------------------------------------------------
165 Name: AFTER_UPDATE
166 Table: PAY_ELEMENT_ENTRY_VALUES_F
167 Action: UPDATE
168 Generated Date: 30/03/2009 04:53
169 Description: Called as part of UPDATE process
170 ================================================
171 */
172
173 --
174 PROCEDURE AFTER_UPDATE
175 (
176 P_EFFECTIVE_END_DATE in DATE
177 ,P_EFFECTIVE_START_DATE in DATE
178 ,P_ELEMENT_ENTRY_ID in NUMBER
179 ,P_ELEMENT_ENTRY_VALUE_ID in NUMBER
180 ,P_INPUT_VALUE_ID in NUMBER
181 ,P_SCREEN_ENTRY_VALUE in VARCHAR2
182 ,P_EFFECTIVE_END_DATE_O in DATE
183 ,P_EFFECTIVE_START_DATE_O in DATE
184 ,P_ELEMENT_ENTRY_ID_O in NUMBER
185 ,P_ELEMENT_ENTRY_VALUE_ID_O in NUMBER
186 ,P_INPUT_VALUE_ID_O in NUMBER
187 ,P_SCREEN_ENTRY_VALUE_O in VARCHAR2
188 ,P_DATETRACK_MODE in VARCHAR2
189 ); -- End of procedure definition for AFTER_UPDATE
190
191 --
192 /*
193 ================================================
194 This is a dynamically generated procedure.
195 Will be called by API.
196 ================================================
197 ** DO NOT CHANGE MANUALLY **
198 ------------------------------------------------
199 Name: AFTER_DELETE
200 Table: PAY_ELEMENT_ENTRY_VALUES_F
201 Action: DELETE
202 Generated Date: 30/03/2009 04:53
203 Description: Called as part of DELETE process
204 ================================================
205 */
206
207 --
208 PROCEDURE AFTER_DELETE
209 (
210 P_EFFECTIVE_END_DATE in DATE
211 ,P_EFFECTIVE_START_DATE in DATE
212 ,P_ELEMENT_ENTRY_ID in NUMBER
213 ,P_ELEMENT_ENTRY_VALUE_ID in NUMBER
214 ,P_INPUT_VALUE_ID in NUMBER
215 ,P_SCREEN_ENTRY_VALUE in VARCHAR2
216 ,P_VALIDATION_END_DATE in DATE
217 ,P_VALIDATION_START_DATE in DATE
218 ,P_ELEMENT_ENTRY_ID_O in NUMBER
219 ,P_ELEMENT_ENTRY_VALUE_ID_O in NUMBER
220 ,P_INPUT_VALUE_ID_O in NUMBER
221 ,P_SCREEN_ENTRY_VALUE_O in VARCHAR2
222 ,P_DATETRACK_MODE in VARCHAR2
223 ); -- End of procedure definition for AFTER_DELETE
224
225 --
226 END PAY_DYT_ELEMENT_ENTRY_VAL_PKG;