1 PACKAGE BEN_ICD_PKG AUTHID CURRENT_USER AS
2 /* $Header: beicd.pkh 120.0.12010000.2 2009/06/16 13:36:05 vkodedal ship $ */
3
4 procedure CREATE_TRANSACTION
5 (
6 P_ICD_TRANSACTION_ID IN NUMBER
7 ,P_ICD_CHC_RATE_ID IN NUMBER
8 ,P_BUSINESS_GROUP_ID IN NUMBER
9 ,P_PERSON_ID IN NUMBER
10 ,P_ASSIGNMENT_ID IN NUMBER
11 ,P_TRANSACTION_ID IN NUMBER
12 ,P_TRANSACTION_STEP_ID IN NUMBER
13 ,P_EFFECTIVE_START_DATE IN DATE
14 ,P_EFFECTIVE_END_DATE IN DATE
15 ,P_DML_OPERATION IN VARCHAR
16 ,P_DATETRACK_MODE IN VARCHAR
17 ,P_EFFECTIVE_DATE IN DATE
18 ,P_PL_TYP_ID IN NUMBER
19 ,P_PL_ID IN NUMBER
20 ,P_OPT_ID IN NUMBER
21 ,P_OIPL_ID IN NUMBER
22 ,P_ACTY_BASE_RT_ID IN NUMBER
23 ,P_RT_STRT_DT_CD IN VARCHAR
24 ,P_RT_STRT_DT IN DATE
25 ,P_RT_STRT_DT_RL IN NUMBER
26 ,P_RT_END_DT_CD IN VARCHAR
27 ,P_RT_END_DT IN DATE
28 ,P_RT_END_DT_RL IN NUMBER
29 ,P_NNMNTRY_UOM IN VARCHAR
30 ,P_BNF_RQD_FLAG IN VARCHAR
31 ,P_ELEMENT_TYPE_ID IN NUMBER
32 ,P_ELEMENT_LINK_ID IN NUMBER
33 ,P_ELEMENT_ENTRY_ID IN NUMBER
34 ,P_ELEMENT_TYPE_CONTEXT IN VARCHAR
35 ,P_INPUT_VALUE_ID1 IN NUMBER
36 ,P_INPUT_VALUE1 IN VARCHAR
37 ,P_INPUT_VALUE_ID2 IN NUMBER
38 ,P_INPUT_VALUE2 IN VARCHAR
39 ,P_INPUT_VALUE_ID3 IN NUMBER
40 ,P_INPUT_VALUE3 IN VARCHAR
41 ,P_INPUT_VALUE_ID4 IN NUMBER
42 ,P_INPUT_VALUE4 IN VARCHAR
43 ,P_INPUT_VALUE_ID5 IN NUMBER
44 ,P_INPUT_VALUE5 IN VARCHAR
45 ,P_INPUT_VALUE_ID6 IN NUMBER
46 ,P_INPUT_VALUE6 IN VARCHAR
47 ,P_INPUT_VALUE_ID7 IN NUMBER
48 ,P_INPUT_VALUE7 IN VARCHAR
49 ,P_INPUT_VALUE_ID8 IN NUMBER
50 ,P_INPUT_VALUE8 IN VARCHAR
51 ,P_INPUT_VALUE_ID9 IN NUMBER
52 ,P_INPUT_VALUE9 IN VARCHAR
53 ,P_INPUT_VALUE_ID10 IN NUMBER
54 ,P_INPUT_VALUE10 IN VARCHAR
55 ,P_INPUT_VALUE_ID11 IN NUMBER
56 ,P_INPUT_VALUE11 IN VARCHAR
57 ,P_INPUT_VALUE_ID12 IN NUMBER
58 ,P_INPUT_VALUE12 IN VARCHAR
59 ,P_INPUT_VALUE_ID13 IN NUMBER
60 ,P_INPUT_VALUE13 IN VARCHAR
61 ,P_INPUT_VALUE_ID14 IN NUMBER
62 ,P_INPUT_VALUE14 IN VARCHAR
63 ,P_INPUT_VALUE_ID15 IN NUMBER
64 ,P_INPUT_VALUE15 IN VARCHAR
65 ,P_ITEM_TYPE IN VARCHAR
66 ,P_ITEM_KEY IN VARCHAR
67 ,P_STATUS IN VARCHAR
68 ,P_PL_ORDR_NUM IN NUMBER
69 ,P_OIPL_ORDR_NUM IN NUMBER
70 ,P_REASON IN VARCHAR
71 ,P_FUTURE_DATA_EXISTS IN VARCHAR
72 ,P_OBJECT_VERSION_NUMBER IN NUMBER
73 ,P_E_OBJECT_VERSION_NUMBER IN NUMBER
74 ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
75 ,P_ATTRIBUTE_CATEGORY IN VARCHAR
76 ,P_ATTRIBUTE1 IN VARCHAR
77 ,P_ATTRIBUTE2 IN VARCHAR
78 ,P_ATTRIBUTE3 IN VARCHAR
79 ,P_ATTRIBUTE4 IN VARCHAR
80 ,P_ATTRIBUTE5 IN VARCHAR
81 ,P_ATTRIBUTE6 IN VARCHAR
82 ,P_ATTRIBUTE7 IN VARCHAR
83 ,P_ATTRIBUTE8 IN VARCHAR
84 ,P_ATTRIBUTE9 IN VARCHAR
85 ,P_ATTRIBUTE10 IN VARCHAR
86 ,P_ATTRIBUTE11 IN VARCHAR
87 ,P_ATTRIBUTE12 IN VARCHAR
88 ,P_ATTRIBUTE13 IN VARCHAR
89 ,P_ATTRIBUTE14 IN VARCHAR
90 ,P_ATTRIBUTE15 IN VARCHAR
91 ,P_ATTRIBUTE16 IN VARCHAR
92 ,P_ATTRIBUTE17 IN VARCHAR
93 ,P_ATTRIBUTE18 IN VARCHAR
94 ,P_ATTRIBUTE19 IN VARCHAR
95 ,P_ATTRIBUTE20 IN VARCHAR
96 ,P_ENTRY_INFORMATION_CATEGORY IN VARCHAR
97 ,P_ENTRY_INFORMATION1 IN VARCHAR
98 ,P_ENTRY_INFORMATION2 IN VARCHAR
99 ,P_ENTRY_INFORMATION3 IN VARCHAR
100 ,P_ENTRY_INFORMATION4 IN VARCHAR
101 ,P_ENTRY_INFORMATION5 IN VARCHAR
102 ,P_ENTRY_INFORMATION6 IN VARCHAR
103 ,P_ENTRY_INFORMATION7 IN VARCHAR
104 ,P_ENTRY_INFORMATION8 IN VARCHAR
105 ,P_ENTRY_INFORMATION9 IN VARCHAR
106 ,P_ENTRY_INFORMATION10 IN VARCHAR
107 ,P_ENTRY_INFORMATION11 IN VARCHAR
108 ,P_ENTRY_INFORMATION12 IN VARCHAR
109 ,P_ENTRY_INFORMATION13 IN VARCHAR
110 ,P_ENTRY_INFORMATION14 IN VARCHAR
111 ,P_ENTRY_INFORMATION15 IN VARCHAR
112 ,P_ENTRY_INFORMATION16 IN VARCHAR
113 ,P_ENTRY_INFORMATION17 IN VARCHAR
114 ,P_ENTRY_INFORMATION18 IN VARCHAR
115 ,P_ENTRY_INFORMATION19 IN VARCHAR
116 ,P_ENTRY_INFORMATION20 IN VARCHAR
117 ,P_ENTRY_INFORMATION21 IN VARCHAR
118 ,P_ENTRY_INFORMATION22 IN VARCHAR
119 ,P_ENTRY_INFORMATION23 IN VARCHAR
120 ,P_ENTRY_INFORMATION24 IN VARCHAR
121 ,P_ENTRY_INFORMATION25 IN VARCHAR
122 ,P_ENTRY_INFORMATION26 IN VARCHAR
123 ,P_ENTRY_INFORMATION27 IN VARCHAR
124 ,P_ENTRY_INFORMATION28 IN VARCHAR
125 ,P_ENTRY_INFORMATION29 IN VARCHAR
126 ,P_ENTRY_INFORMATION30 IN VARCHAR
127 );
128
129 procedure UPDATE_TRANSACTION
130 (
131 P_ICD_TRANSACTION_ID IN NUMBER
132 ,P_ICD_CHC_RATE_ID IN NUMBER
133 ,P_BUSINESS_GROUP_ID IN NUMBER
134 ,P_PERSON_ID IN NUMBER
135 ,P_ASSIGNMENT_ID IN NUMBER
136 ,P_TRANSACTION_ID IN NUMBER
137 ,P_TRANSACTION_STEP_ID IN NUMBER
138 ,P_EFFECTIVE_START_DATE IN DATE
139 ,P_EFFECTIVE_END_DATE IN DATE
140 ,P_DML_OPERATION IN VARCHAR
141 ,P_DATETRACK_MODE IN VARCHAR
142 ,P_EFFECTIVE_DATE IN DATE
143 ,P_PL_TYP_ID IN NUMBER
144 ,P_PL_ID IN NUMBER
145 ,P_OPT_ID IN NUMBER
146 ,P_OIPL_ID IN NUMBER
147 ,P_ACTY_BASE_RT_ID IN NUMBER
148 ,P_RT_STRT_DT_CD IN VARCHAR
149 ,P_RT_STRT_DT IN DATE
150 ,P_RT_STRT_DT_RL IN NUMBER
151 ,P_RT_END_DT_CD IN VARCHAR
152 ,P_RT_END_DT IN DATE
153 ,P_RT_END_DT_RL IN NUMBER
154 ,P_NNMNTRY_UOM IN VARCHAR
155 ,P_BNF_RQD_FLAG IN VARCHAR
156 ,P_ELEMENT_TYPE_ID IN NUMBER
157 ,P_ELEMENT_LINK_ID IN NUMBER
158 ,P_ELEMENT_ENTRY_ID IN NUMBER
159 ,P_ELEMENT_TYPE_CONTEXT IN VARCHAR
160 ,P_INPUT_VALUE_ID1 IN NUMBER
161 ,P_INPUT_VALUE1 IN VARCHAR
162 ,P_INPUT_VALUE_ID2 IN NUMBER
163 ,P_INPUT_VALUE2 IN VARCHAR
164 ,P_INPUT_VALUE_ID3 IN NUMBER
165 ,P_INPUT_VALUE3 IN VARCHAR
166 ,P_INPUT_VALUE_ID4 IN NUMBER
167 ,P_INPUT_VALUE4 IN VARCHAR
168 ,P_INPUT_VALUE_ID5 IN NUMBER
169 ,P_INPUT_VALUE5 IN VARCHAR
170 ,P_INPUT_VALUE_ID6 IN NUMBER
171 ,P_INPUT_VALUE6 IN VARCHAR
172 ,P_INPUT_VALUE_ID7 IN NUMBER
173 ,P_INPUT_VALUE7 IN VARCHAR
174 ,P_INPUT_VALUE_ID8 IN NUMBER
175 ,P_INPUT_VALUE8 IN VARCHAR
176 ,P_INPUT_VALUE_ID9 IN NUMBER
177 ,P_INPUT_VALUE9 IN VARCHAR
178 ,P_INPUT_VALUE_ID10 IN NUMBER
179 ,P_INPUT_VALUE10 IN VARCHAR
180 ,P_INPUT_VALUE_ID11 IN NUMBER
181 ,P_INPUT_VALUE11 IN VARCHAR
182 ,P_INPUT_VALUE_ID12 IN NUMBER
183 ,P_INPUT_VALUE12 IN VARCHAR
184 ,P_INPUT_VALUE_ID13 IN NUMBER
185 ,P_INPUT_VALUE13 IN VARCHAR
186 ,P_INPUT_VALUE_ID14 IN NUMBER
187 ,P_INPUT_VALUE14 IN VARCHAR
188 ,P_INPUT_VALUE_ID15 IN NUMBER
189 ,P_INPUT_VALUE15 IN VARCHAR
190 ,P_ITEM_TYPE IN VARCHAR
191 ,P_ITEM_KEY IN VARCHAR
192 ,P_STATUS IN VARCHAR
193 ,P_PL_ORDR_NUM IN NUMBER
194 ,P_OIPL_ORDR_NUM IN NUMBER
195 ,P_REASON IN VARCHAR
196 ,P_FUTURE_DATA_EXISTS IN VARCHAR
197 ,P_OBJECT_VERSION_NUMBER IN NUMBER
198 ,P_E_OBJECT_VERSION_NUMBER IN NUMBER
199 ,P_COST_ALLOCATION_KEYFLEX_ID IN NUMBER
200 ,P_ATTRIBUTE_CATEGORY IN VARCHAR
201 ,P_ATTRIBUTE1 IN VARCHAR
202 ,P_ATTRIBUTE2 IN VARCHAR
203 ,P_ATTRIBUTE3 IN VARCHAR
204 ,P_ATTRIBUTE4 IN VARCHAR
205 ,P_ATTRIBUTE5 IN VARCHAR
206 ,P_ATTRIBUTE6 IN VARCHAR
207 ,P_ATTRIBUTE7 IN VARCHAR
208 ,P_ATTRIBUTE8 IN VARCHAR
209 ,P_ATTRIBUTE9 IN VARCHAR
210 ,P_ATTRIBUTE10 IN VARCHAR
211 ,P_ATTRIBUTE11 IN VARCHAR
212 ,P_ATTRIBUTE12 IN VARCHAR
213 ,P_ATTRIBUTE13 IN VARCHAR
214 ,P_ATTRIBUTE14 IN VARCHAR
215 ,P_ATTRIBUTE15 IN VARCHAR
216 ,P_ATTRIBUTE16 IN VARCHAR
217 ,P_ATTRIBUTE17 IN VARCHAR
218 ,P_ATTRIBUTE18 IN VARCHAR
219 ,P_ATTRIBUTE19 IN VARCHAR
220 ,P_ATTRIBUTE20 IN VARCHAR
221 ,P_ENTRY_INFORMATION_CATEGORY IN VARCHAR
222 ,P_ENTRY_INFORMATION1 IN VARCHAR
223 ,P_ENTRY_INFORMATION2 IN VARCHAR
224 ,P_ENTRY_INFORMATION3 IN VARCHAR
225 ,P_ENTRY_INFORMATION4 IN VARCHAR
226 ,P_ENTRY_INFORMATION5 IN VARCHAR
227 ,P_ENTRY_INFORMATION6 IN VARCHAR
228 ,P_ENTRY_INFORMATION7 IN VARCHAR
229 ,P_ENTRY_INFORMATION8 IN VARCHAR
230 ,P_ENTRY_INFORMATION9 IN VARCHAR
231 ,P_ENTRY_INFORMATION10 IN VARCHAR
232 ,P_ENTRY_INFORMATION11 IN VARCHAR
233 ,P_ENTRY_INFORMATION12 IN VARCHAR
234 ,P_ENTRY_INFORMATION13 IN VARCHAR
235 ,P_ENTRY_INFORMATION14 IN VARCHAR
236 ,P_ENTRY_INFORMATION15 IN VARCHAR
237 ,P_ENTRY_INFORMATION16 IN VARCHAR
238 ,P_ENTRY_INFORMATION17 IN VARCHAR
239 ,P_ENTRY_INFORMATION18 IN VARCHAR
240 ,P_ENTRY_INFORMATION19 IN VARCHAR
241 ,P_ENTRY_INFORMATION20 IN VARCHAR
242 ,P_ENTRY_INFORMATION21 IN VARCHAR
243 ,P_ENTRY_INFORMATION22 IN VARCHAR
244 ,P_ENTRY_INFORMATION23 IN VARCHAR
245 ,P_ENTRY_INFORMATION24 IN VARCHAR
246 ,P_ENTRY_INFORMATION25 IN VARCHAR
247 ,P_ENTRY_INFORMATION26 IN VARCHAR
248 ,P_ENTRY_INFORMATION27 IN VARCHAR
249 ,P_ENTRY_INFORMATION28 IN VARCHAR
250 ,P_ENTRY_INFORMATION29 IN VARCHAR
251 ,P_ENTRY_INFORMATION30 IN VARCHAR
252 );
253 PROCEDURE VALIDATE_TRANSACTION (
254 P_ICD_TRANSACTION_ID IN NUMBER
255 ,P_ASSIGNMENT_ID IN NUMBER
256 ,P_TRANSACTION_ID IN NUMBER
257 ,P_EFFECTIVE_START_DATE IN DATE
258 ,P_EFFECTIVE_END_DATE IN DATE
259 ,P_DML_OPERATION IN VARCHAR
260 ,P_EFFECTIVE_DATE IN DATE
261 ,P_ELEMENT_TYPE_ID IN NUMBER
262 );
263 END BEN_ICD_PKG ;