1 package PAY_DYT_DURATION_SUMMARY_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_DURATION_SUMMARY_PKG
20 Base Table: PQP_GAP_DURATION_SUMMARY
21 Date: 03/01/2007 23:17
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: PQP_GAP_DURATION_SUMMARY_A_ARD
34 Table: PQP_GAP_DURATION_SUMMARY
35 Action: Delete
36 Generated Date: 03/01/2007 23:17
37 Description: Incident Register trigger on delete of PQP_GAP_DURATION_SUMMARY
38 Full trigger name: PQP_GAP_DURATION_SUMMARY_ARD
39 ================================================
40 */
41 --
42 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARD
43 (
44 p_old_ASSIGNMENT_ID in NUMBER
45 ,p_old_DATE_START in DATE
46 ,p_old_GAP_DURATION_SUMMARY_ID in NUMBER
47 ); -- End of procedure definition for PQP_GAP_DURATION_SUMMARY_A_ARD
48
49 --
50 /*
51 ================================================
52 This is a dynamically generated package procedure
53 with code representing a dynamic trigger
54 ================================================
55 ** DO NOT CHANGE MANUALLY **
56 ------------------------------------------------
57 Name: PQP_GAP_DURATION_SUMMARY_A_ARI
58 Table: PQP_GAP_DURATION_SUMMARY
59 Action: Insert
60 Generated Date: 03/01/2007 23:17
61 Description: Incident Register trigger on insert of PQP_GAP_DURATION_SUMMARY
62 Full trigger name: PQP_GAP_DURATION_SUMMARY_ARI
63 ================================================
64 */
65 --
66 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARI
67 (
68 p_new_ASSIGNMENT_ID in NUMBER
69 ,p_new_DATE_END in DATE
70 ,p_new_DATE_START in DATE
71 ,p_new_DURATION_IN_DAYS in NUMBER
72 ,p_new_DURATION_IN_HOURS in NUMBER
73 ,p_new_GAP_DURATION_SUMMARY_ID in NUMBER
74 ,p_new_GAP_LEVEL in VARCHAR2
75 ,p_new_SUMMARY_TYPE in VARCHAR2
76 ); -- End of procedure definition for PQP_GAP_DURATION_SUMMARY_A_ARI
77
78 --
79 /*
80 ================================================
81 This is a dynamically generated package procedure
82 with code representing a dynamic trigger
83 ================================================
84 ** DO NOT CHANGE MANUALLY **
85 ------------------------------------------------
86 Name: PQP_GAP_DURATION_SUMMARY_A_ARU
87 Table: PQP_GAP_DURATION_SUMMARY
88 Action: Update
89 Generated Date: 03/01/2007 23:17
90 Description: Incident Register trigger on update of PQP_GAP_DURATION_SUMMARY
91 Full trigger name: PQP_GAP_DURATION_SUMMARY_ARU
92 ================================================
93 */
94 --
95 PROCEDURE PQP_GAP_DURATION_SUMMARY_A_ARU
96 (
97 p_new_ASSIGNMENT_ID in NUMBER
98 ,p_new_DATE_END in DATE
99 ,p_new_DATE_START in DATE
100 ,p_new_DURATION_IN_DAYS in NUMBER
101 ,p_new_DURATION_IN_HOURS in NUMBER
102 ,p_new_GAP_DURATION_SUMMARY_ID in NUMBER
103 ,p_new_GAP_LEVEL in VARCHAR2
104 ,p_new_SUMMARY_TYPE in VARCHAR2
105 ,p_old_ASSIGNMENT_ID in NUMBER
106 ,p_old_DATE_END in DATE
107 ,p_old_DATE_START in DATE
108 ,p_old_DURATION_IN_DAYS in NUMBER
109 ,p_old_DURATION_IN_HOURS in NUMBER
110 ,p_old_GAP_LEVEL in VARCHAR2
111 ,p_old_SUMMARY_TYPE in VARCHAR2
112 ); -- End of procedure definition for PQP_GAP_DURATION_SUMMARY_A_ARU
113
114 --
115 /*
116 ================================================
117 This is a dynamically generated procedure.
118 Will be called by API.
119 ================================================
120 ** DO NOT CHANGE MANUALLY **
121 ------------------------------------------------
122 Name: AFTER_INSERT
123 Table: PQP_GAP_DURATION_SUMMARY
124 Action: INSERT
125 Generated Date: 03/01/2007 23:17
126 Description: Called as part of INSERT process
127 ================================================
128 */
129
130 --
131 PROCEDURE AFTER_INSERT
132 (
133 P_GAP_DURATION_SUMMARY_ID in NUMBER
134 ,P_ASSIGNMENT_ID in NUMBER
135 ,P_GAP_ABSENCE_PLAN_ID in NUMBER
136 ,P_SUMMARY_TYPE in VARCHAR2
137 ,P_GAP_LEVEL in VARCHAR2
138 ,P_DURATION_IN_DAYS in NUMBER
139 ,P_DURATION_IN_HOURS in NUMBER
140 ,P_DATE_START in DATE
141 ,P_DATE_END in DATE
142 ,P_OBJECT_VERSION_NUMBER in NUMBER
143 ); -- End of procedure definition for AFTER_INSERT
144
145 --
146 /*
147 ================================================
148 This is a dynamically generated procedure.
149 Will be called by API.
150 ================================================
151 ** DO NOT CHANGE MANUALLY **
152 ------------------------------------------------
153 Name: AFTER_UPDATE
154 Table: PQP_GAP_DURATION_SUMMARY
155 Action: UPDATE
156 Generated Date: 03/01/2007 23:17
157 Description: Called as part of UPDATE process
158 ================================================
159 */
160
161 --
162 PROCEDURE AFTER_UPDATE
163 (
164 P_GAP_DURATION_SUMMARY_ID in NUMBER
165 ,P_ASSIGNMENT_ID in NUMBER
166 ,P_GAP_ABSENCE_PLAN_ID in NUMBER
167 ,P_SUMMARY_TYPE in VARCHAR2
168 ,P_GAP_LEVEL in VARCHAR2
169 ,P_DURATION_IN_DAYS in NUMBER
170 ,P_DURATION_IN_HOURS in NUMBER
171 ,P_DATE_START in DATE
172 ,P_DATE_END in DATE
173 ,P_OBJECT_VERSION_NUMBER in NUMBER
174 ,P_ASSIGNMENT_ID_O in NUMBER
175 ,P_GAP_ABSENCE_PLAN_ID_O in NUMBER
176 ,P_SUMMARY_TYPE_O in VARCHAR2
177 ,P_GAP_LEVEL_O in VARCHAR2
178 ,P_DURATION_IN_DAYS_O in NUMBER
179 ,P_DURATION_IN_HOURS_O in NUMBER
180 ,P_DATE_START_O in DATE
181 ,P_DATE_END_O in DATE
182 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
183 ); -- End of procedure definition for AFTER_UPDATE
184
185 --
186 /*
187 ================================================
188 This is a dynamically generated procedure.
189 Will be called by API.
190 ================================================
194 Table: PQP_GAP_DURATION_SUMMARY
191 ** DO NOT CHANGE MANUALLY **
192 ------------------------------------------------
193 Name: AFTER_DELETE
195 Action: DELETE
196 Generated Date: 03/01/2007 23:17
197 Description: Called as part of DELETE process
198 ================================================
199 */
200
201 --
202 PROCEDURE AFTER_DELETE
203 (
204 P_GAP_DURATION_SUMMARY_ID in NUMBER
205 ,P_ASSIGNMENT_ID_O in NUMBER
206 ,P_GAP_ABSENCE_PLAN_ID_O in NUMBER
207 ,P_SUMMARY_TYPE_O in VARCHAR2
208 ,P_GAP_LEVEL_O in VARCHAR2
209 ,P_DURATION_IN_DAYS_O in NUMBER
210 ,P_DURATION_IN_HOURS_O in NUMBER
211 ,P_DATE_START_O in DATE
212 ,P_DATE_END_O in DATE
213 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
214 ); -- End of procedure definition for AFTER_DELETE
215
216 --
217 END PAY_DYT_DURATION_SUMMARY_PKG;