1 Package ff_archive_api AUTHID CURRENT_USER as
2 /* $Header: ffarcapi.pkh 115.1 2002/12/23 12:55:02 arashid ship $ */
3 --
4 --
5 -- ----------------------------------------------------------------------------
6 -- | Global Table Type Specification |
7 -- ----------------------------------------------------------------------------
8 --
9 Type context_tab_type is table of varchar2(30) index by binary_integer;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |--------------------------< create_archive_item >--------------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start Of Comments}
15 --
16 -- Description: This Business Process Inserts values into
17 -- FF_ARCHIVE_ITEMS and FF_ARCHIVE_ITEM_CONTEXTS
18 -- using the appropriate row handlers, after validating
19 -- the 'in' parameters.
20 --
21 --
22 -- Prerequisites:
23 --
24 --
25 -- In Parameters:
26 -- Name Reqd Type Description
27 --
28 /*
29 P_VALIDATE IN Control Parameter.
30 P_ARCHIVE_ITEM_ID OUT Y Primary Key, Gen by sequence.
31 P_USER_ENTITY_ID IN Y FK to FF_USER_ENTITIES
32 P_ARCHIVE_VALUE IN Y The value to be stored and retrieved
33 P_ARCHIVE_TYPE IN Used for validation of Assignment/Payroll
34 Action ID. DEFAULTS TO 'ASSIGNMENT_ACTION
35 _ID'
36 P_ACTION_ID IN Y This is either the Assignment or Payroll
37 Action ID.
38 P_LEGISLATION_CODE IN Y To identify legislative Context names.
39 P_OBJECT_VERSION_NUMBER OUT Handled by Row handler logic.
40 P_CONTEXT_NAME1 IN This will be translated from the
41 Legislative Context name to a core one.
42 This may also be a core context name.
43 P_CONTEXT1 IN The Context value.
44 P_CONTEXT_NAME2 IN Legislative or Core Context Name.
45 P_CONTEXT12 IN The Context value.
46 P_CONTEXT_NAME3 IN Legislative or Core Context Name.
47 P_CONTEXT3 IN The Context value.
48 P_CONTEXT_NAME4 IN Legislative or Core Context Name.
49 P_CONTEXT4 IN The Context value.
50 P_CONTEXT_NAME5 IN Legislative or Core Context Name.
51 P_CONTEXT5 IN The Context value.
52 P_CONTEXT_NAME6 IN Legislative or Core Context Name.
53 P_CONTEXT6 IN The Context value.
54 P_CONTEXT_NAME7 IN Legislative or Core Context Name.
55 P_CONTEXT7 IN The Context value.
56 P_CONTEXT_NAME8 IN Legislative or Core Context Name.
57 P_CONTEXT8 IN The Context value.
58 P_CONTEXT_NAME9 IN Legislative or Core Context Name.
59 P_CONTEXT9 IN The Context value.
60 P_CONTEXT_NAME10 IN Legislative or Core Context Name.
61 P_CONTEXT10 IN The Context value.
62 P_CONTEXT_NAME11 IN Legislative or Core Context Name.
63 P_CONTEXT11 IN The Context value.
64 P_CONTEXT_NAME12 IN Legislative or Core Context Name.
65 P_CONTEXT12 IN The Context value.
66 P_CONTEXT_NAME13 IN Legislative or Core Context Name.
67 P_CONTEXT13 IN The Context value.
68 P_CONTEXT_NAME14 IN Legislative or Core Context Name.
69 P_CONTEXT14 IN The Context value.
70 P_CONTEXT_NAME15 IN Legislative or Core Context Name.
71 P_CONTEXT15 IN The Context value.
72 P_CONTEXT_NAME16 IN Legislative or Core Context Name.
73 P_CONTEXT16 IN The Context value.
74 P_CONTEXT_NAME17 IN Legislative or Core Context Name.
75 P_CONTEXT17 IN The Context value.
76 P_CONTEXT_NAME18 IN Legislative or Core Context Name.
77 P_CONTEXT18 IN The Context value.
78 P_CONTEXT_NAME19 IN Legislative or Core Context Name.
79 P_CONTEXT19 IN The Context value.
80 P_CONTEXT_NAME20 IN Legislative or Core Context Name.
81 P_CONTEXT20 IN The Context value.
82 P_CONTEXT_NAME21 IN Legislative or Core Context Name.
83 P_CONTEXT21 IN The Context value.
84 P_CONTEXT_NAME22 IN Legislative or Core Context Name.
85 P_CONTEXT22 IN The Context value.
86 P_CONTEXT_NAME23 IN Legislative or Core Context Name.
87 P_CONTEXT23 IN The Context value.
88 P_CONTEXT_NAME24 IN Legislative or Core Context Name.
89 P_CONTEXT24 IN The Context value.
90 P_CONTEXT_NAME25 IN Legislative or Core Context Name.
91 P_CONTEXT25 IN The Context value.
92 P_CONTEXT_NAME26 IN Legislative or Core Context Name.
93 P_CONTEXT26 IN The Context value.
94 P_CONTEXT_NAME27 IN Legislative or Core Context Name.
95 P_CONTEXT27 IN The Context value.
96 P_CONTEXT_NAME28 IN Legislative or Core Context Name.
97 P_CONTEXT28 IN The Context value.
98 P_CONTEXT_NAME29 IN Legislative or Core Context Name.
99 P_CONTEXT29 IN The Context value.
100 P_CONTEXT_NAME30 IN Legislative or Core Context Name.
101 P_CONTEXT30 IN The Context value.
102 P_CONTEXT_NAME31 IN Legislative or Core Context Name.
103 P_CONTEXT31 IN The Context value.*/
104 --
105 --
106 -- Post Success:
107 --
108 --
109 -- Name Type Description
110 --
111 -- Post Failure:
112 --
113 --
114 -- Access Status:
115 -- Internal Development.
116 --
117 -- {End Of Comments}
118 --
119 procedure create_archive_item
120 (p_validate in boolean default false
121 ,p_archive_item_id out nocopy number
122 ,p_user_entity_id in number
123 ,p_archive_value in varchar2
124 ,p_archive_type in varchar2 default 'AAP'
125 ,p_action_id in number
126 ,p_legislation_code in varchar2
127 ,p_object_version_number out nocopy number
128 ,p_context_name1 in varchar2 default null
129 ,p_context1 in varchar2 default null
130 ,p_context_name2 in varchar2 default null
131 ,p_context2 in varchar2 default null
132 ,p_context_name3 in varchar2 default null
133 ,p_context3 in varchar2 default null
134 ,p_context_name4 in varchar2 default null
135 ,p_context4 in varchar2 default null
136 ,p_context_name5 in varchar2 default null
137 ,p_context5 in varchar2 default null
138 ,p_context_name6 in varchar2 default null
139 ,p_context6 in varchar2 default null
140 ,p_context_name7 in varchar2 default null
141 ,p_context7 in varchar2 default null
142 ,p_context_name8 in varchar2 default null
143 ,p_context8 in varchar2 default null
144 ,p_context_name9 in varchar2 default null
145 ,p_context9 in varchar2 default null
146 ,p_context_name10 in varchar2 default null
147 ,p_context10 in varchar2 default null
148 ,p_context_name11 in varchar2 default null
149 ,p_context11 in varchar2 default null
150 ,p_context_name12 in varchar2 default null
151 ,p_context12 in varchar2 default null
152 ,p_context_name13 in varchar2 default null
153 ,p_context13 in varchar2 default null
154 ,p_context_name14 in varchar2 default null
155 ,p_context14 in varchar2 default null
156 ,p_context_name15 in varchar2 default null
157 ,p_context15 in varchar2 default null
158 ,p_context_name16 in varchar2 default null
159 ,p_context16 in varchar2 default null
160 ,p_context_name17 in varchar2 default null
161 ,p_context17 in varchar2 default null
162 ,p_context_name18 in varchar2 default null
163 ,p_context18 in varchar2 default null
164 ,p_context_name19 in varchar2 default null
165 ,p_context19 in varchar2 default null
166 ,p_context_name20 in varchar2 default null
167 ,p_context20 in varchar2 default null
168 ,p_context_name21 in varchar2 default null
169 ,p_context21 in varchar2 default null
170 ,p_context_name22 in varchar2 default null
171 ,p_context22 in varchar2 default null
172 ,p_context_name23 in varchar2 default null
173 ,p_context23 in varchar2 default null
174 ,p_context_name24 in varchar2 default null
175 ,p_context24 in varchar2 default null
176 ,p_context_name25 in varchar2 default null
177 ,p_context25 in varchar2 default null
178 ,p_context_name26 in varchar2 default null
179 ,p_context26 in varchar2 default null
180 ,p_context_name27 in varchar2 default null
181 ,p_context27 in varchar2 default null
182 ,p_context_name28 in varchar2 default null
183 ,p_context28 in varchar2 default null
184 ,p_context_name29 in varchar2 default null
185 ,p_context29 in varchar2 default null
186 ,p_context_name30 in varchar2 default null
187 ,p_context30 in varchar2 default null
188 ,p_context_name31 in varchar2 default null
189 ,p_context31 in varchar2 default null
190 ,p_some_warning out nocopy boolean
191 );
192 --
193 -- ----------------------------------------------------------------------------
194 -- |-------------------------< update_archive_item >--------------------------|
195 -- ----------------------------------------------------------------------------
196 -- {Start Of Comments}
197 --
198 -- Description: This procedure updates the archive item from the
199 -- FF_ARCHIVE_ITEMS table, identifying it by parametered
200 -- ROWID.
201 --
202 --
203 -- Prerequisites: There must be a row already in FF_ARCHIVE_ITEMS to be updated.
204 --
205 --
206 -- In Parameters:
207 -- Name Reqd Type Description
208 --
209 -- P_ARCHIVE_ITEM_ID Y IN PK of FF_ARCHIVE_ITEMS.
210 -- P_EFFECTIVE_DATE Y IN Required as validation is against
211 -- a datetracked table.
212 -- P_VALIDATE IN Control Parameter.
213 -- P_ARCHIVE_VALUE Y IN The value to be stored and retrieved
217 -- Post Success: Row updated by row-handler.
214 -- P_OBJECT_VERSION_NUMBER IN OUT Object Version Number for updates.
215 -- P_SOME_WARNING OUT Generic warning.
216 --
218 --
219 -- Post Failure: Error raised to form.
220 --
221 --
222 -- Access Status:
223 -- Internal Development.
224 --
225 -- {End Of Comments}
226 --
227 procedure update_archive_item
228 (p_archive_item_id in number
229 ,p_effective_date in date
230 ,p_validate in boolean default false
231 ,p_archive_value in varchar2
232 ,p_object_version_number in out nocopy number
233 ,p_some_warning out nocopy boolean
234 );
235 --
236 end ff_archive_api;