eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OTA_FINANCE_HEADER_BK2

Source


1 package body OTA_FINANCE_HEADER_BK2 as
2     /* $Header: ottfhapi.pkb 120.0 2005/05/29 07:40:55 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:29:52 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_FINANCE_HEADER_A
6 (P_FINANCE_HEADER_ID in NUMBER
7 ,P_OBJECT_VERSION_NUMBER in NUMBER
8 ,P_SUPERCEDING_HEADER_ID in NUMBER
9 ,P_AUTHORIZER_PERSON_ID in NUMBER
10 ,P_ORGANIZATION_ID in NUMBER
11 ,P_ADMINISTRATOR in NUMBER
12 ,P_CANCELLED_FLAG in VARCHAR2
13 ,P_CURRENCY_CODE in VARCHAR2
14 ,P_DATE_RAISED in DATE
15 ,P_PAYMENT_STATUS_FLAG in VARCHAR2
16 ,P_TRANSFER_STATUS in VARCHAR2
17 ,P_TYPE in VARCHAR2
18 ,P_RECEIVABLE_TYPE in VARCHAR2
19 ,P_COMMENTS in VARCHAR2
20 ,P_EXTERNAL_REFERENCE in VARCHAR2
21 ,P_INVOICE_ADDRESS in VARCHAR2
22 ,P_INVOICE_CONTACT in VARCHAR2
23 ,P_PAYMENT_METHOD in VARCHAR2
24 ,P_PYM_INFORMATION_CATEGORY in VARCHAR2
25 ,P_PYM_ATTRIBUTE1 in VARCHAR2
26 ,P_PYM_ATTRIBUTE2 in VARCHAR2
27 ,P_PYM_ATTRIBUTE3 in VARCHAR2
28 ,P_PYM_ATTRIBUTE4 in VARCHAR2
29 ,P_PYM_ATTRIBUTE5 in VARCHAR2
30 ,P_PYM_ATTRIBUTE6 in VARCHAR2
31 ,P_PYM_ATTRIBUTE7 in VARCHAR2
32 ,P_PYM_ATTRIBUTE8 in VARCHAR2
33 ,P_PYM_ATTRIBUTE9 in VARCHAR2
34 ,P_PYM_ATTRIBUTE10 in VARCHAR2
35 ,P_PYM_ATTRIBUTE11 in VARCHAR2
36 ,P_PYM_ATTRIBUTE12 in VARCHAR2
37 ,P_PYM_ATTRIBUTE13 in VARCHAR2
38 ,P_PYM_ATTRIBUTE14 in VARCHAR2
39 ,P_PYM_ATTRIBUTE15 in VARCHAR2
40 ,P_PYM_ATTRIBUTE16 in VARCHAR2
41 ,P_PYM_ATTRIBUTE17 in VARCHAR2
42 ,P_PYM_ATTRIBUTE18 in VARCHAR2
43 ,P_PYM_ATTRIBUTE19 in VARCHAR2
44 ,P_PYM_ATTRIBUTE20 in VARCHAR2
45 ,P_TRANSFER_DATE in DATE
46 ,P_TRANSFER_MESSAGE in VARCHAR2
47 ,P_VENDOR_ID in NUMBER
48 ,P_CONTACT_ID in NUMBER
49 ,P_ADDRESS_ID in NUMBER
50 ,P_CUSTOMER_ID in NUMBER
51 ,P_TFH_INFORMATION_CATEGORY in VARCHAR2
52 ,P_TFH_INFORMATION1 in VARCHAR2
53 ,P_TFH_INFORMATION2 in VARCHAR2
54 ,P_TFH_INFORMATION3 in VARCHAR2
55 ,P_TFH_INFORMATION4 in VARCHAR2
56 ,P_TFH_INFORMATION5 in VARCHAR2
57 ,P_TFH_INFORMATION6 in VARCHAR2
58 ,P_TFH_INFORMATION7 in VARCHAR2
59 ,P_TFH_INFORMATION8 in VARCHAR2
60 ,P_TFH_INFORMATION9 in VARCHAR2
61 ,P_TFH_INFORMATION10 in VARCHAR2
62 ,P_TFH_INFORMATION11 in VARCHAR2
63 ,P_TFH_INFORMATION12 in VARCHAR2
64 ,P_TFH_INFORMATION13 in VARCHAR2
65 ,P_TFH_INFORMATION14 in VARCHAR2
66 ,P_TFH_INFORMATION15 in VARCHAR2
67 ,P_TFH_INFORMATION16 in VARCHAR2
68 ,P_TFH_INFORMATION17 in VARCHAR2
69 ,P_TFH_INFORMATION18 in VARCHAR2
70 ,P_TFH_INFORMATION19 in VARCHAR2
71 ,P_TFH_INFORMATION20 in VARCHAR2
72 ,P_PAYING_COST_CENTER in VARCHAR2
73 ,P_RECEIVING_COST_CENTER in VARCHAR2
74 ,P_TRANSFER_FROM_SET_OF_BOOK_ID in NUMBER
75 ,P_TRANSFER_TO_SET_OF_BOOK_ID in NUMBER
76 ,P_FROM_SEGMENT1 in VARCHAR2
77 ,P_FROM_SEGMENT2 in VARCHAR2
78 ,P_FROM_SEGMENT3 in VARCHAR2
79 ,P_FROM_SEGMENT4 in VARCHAR2
80 ,P_FROM_SEGMENT5 in VARCHAR2
81 ,P_FROM_SEGMENT6 in VARCHAR2
82 ,P_FROM_SEGMENT7 in VARCHAR2
83 ,P_FROM_SEGMENT8 in VARCHAR2
84 ,P_FROM_SEGMENT9 in VARCHAR2
85 ,P_FROM_SEGMENT10 in VARCHAR2
86 ,P_FROM_SEGMENT11 in VARCHAR2
87 ,P_FROM_SEGMENT12 in VARCHAR2
88 ,P_FROM_SEGMENT13 in VARCHAR2
89 ,P_FROM_SEGMENT14 in VARCHAR2
90 ,P_FROM_SEGMENT15 in VARCHAR2
91 ,P_FROM_SEGMENT16 in VARCHAR2
92 ,P_FROM_SEGMENT17 in VARCHAR2
93 ,P_FROM_SEGMENT18 in VARCHAR2
94 ,P_FROM_SEGMENT19 in VARCHAR2
95 ,P_FROM_SEGMENT20 in VARCHAR2
96 ,P_FROM_SEGMENT21 in VARCHAR2
97 ,P_FROM_SEGMENT22 in VARCHAR2
98 ,P_FROM_SEGMENT23 in VARCHAR2
99 ,P_FROM_SEGMENT24 in VARCHAR2
100 ,P_FROM_SEGMENT25 in VARCHAR2
101 ,P_FROM_SEGMENT26 in VARCHAR2
102 ,P_FROM_SEGMENT27 in VARCHAR2
103 ,P_FROM_SEGMENT28 in VARCHAR2
104 ,P_FROM_SEGMENT29 in VARCHAR2
105 ,P_FROM_SEGMENT30 in VARCHAR2
106 ,P_TO_SEGMENT1 in VARCHAR2
107 ,P_TO_SEGMENT2 in VARCHAR2
108 ,P_TO_SEGMENT3 in VARCHAR2
109 ,P_TO_SEGMENT4 in VARCHAR2
110 ,P_TO_SEGMENT5 in VARCHAR2
111 ,P_TO_SEGMENT6 in VARCHAR2
112 ,P_TO_SEGMENT7 in VARCHAR2
113 ,P_TO_SEGMENT8 in VARCHAR2
114 ,P_TO_SEGMENT9 in VARCHAR2
115 ,P_TO_SEGMENT10 in VARCHAR2
116 ,P_TO_SEGMENT11 in VARCHAR2
117 ,P_TO_SEGMENT12 in VARCHAR2
118 ,P_TO_SEGMENT13 in VARCHAR2
119 ,P_TO_SEGMENT14 in VARCHAR2
120 ,P_TO_SEGMENT15 in VARCHAR2
121 ,P_TO_SEGMENT16 in VARCHAR2
122 ,P_TO_SEGMENT17 in VARCHAR2
123 ,P_TO_SEGMENT18 in VARCHAR2
124 ,P_TO_SEGMENT19 in VARCHAR2
125 ,P_TO_SEGMENT20 in VARCHAR2
126 ,P_TO_SEGMENT21 in VARCHAR2
127 ,P_TO_SEGMENT22 in VARCHAR2
128 ,P_TO_SEGMENT23 in VARCHAR2
129 ,P_TO_SEGMENT24 in VARCHAR2
130 ,P_TO_SEGMENT25 in VARCHAR2
131 ,P_TO_SEGMENT26 in VARCHAR2
132 ,P_TO_SEGMENT27 in VARCHAR2
133 ,P_TO_SEGMENT28 in VARCHAR2
134 ,P_TO_SEGMENT29 in VARCHAR2
135 ,P_TO_SEGMENT30 in VARCHAR2
136 ,P_TRANSFER_FROM_CC_ID in NUMBER
137 ,P_TRANSFER_TO_CC_ID in NUMBER
138 ,P_EFFECTIVE_DATE in DATE
139 )is
140 begin
141 hr_utility.set_location('Entering: OTA_FINANCE_HEADER_BK2.UPDATE_FINANCE_HEADER_A', 10);
142 hr_utility.set_location(' Leaving: OTA_FINANCE_HEADER_BK2.UPDATE_FINANCE_HEADER_A', 20);
143 end UPDATE_FINANCE_HEADER_A;
144 procedure UPDATE_FINANCE_HEADER_B
145 (P_FINANCE_HEADER_ID in NUMBER
146 ,P_OBJECT_VERSION_NUMBER in NUMBER
147 ,P_SUPERCEDING_HEADER_ID in NUMBER
148 ,P_AUTHORIZER_PERSON_ID in NUMBER
149 ,P_ORGANIZATION_ID in NUMBER
150 ,P_ADMINISTRATOR in NUMBER
151 ,P_CANCELLED_FLAG in VARCHAR2
152 ,P_CURRENCY_CODE in VARCHAR2
153 ,P_DATE_RAISED in DATE
154 ,P_PAYMENT_STATUS_FLAG in VARCHAR2
155 ,P_TRANSFER_STATUS in VARCHAR2
156 ,P_TYPE in VARCHAR2
157 ,P_RECEIVABLE_TYPE in VARCHAR2
158 ,P_COMMENTS in VARCHAR2
159 ,P_EXTERNAL_REFERENCE in VARCHAR2
160 ,P_INVOICE_ADDRESS in VARCHAR2
161 ,P_INVOICE_CONTACT in VARCHAR2
162 ,P_PAYMENT_METHOD in VARCHAR2
163 ,P_PYM_INFORMATION_CATEGORY in VARCHAR2
164 ,P_PYM_ATTRIBUTE1 in VARCHAR2
165 ,P_PYM_ATTRIBUTE2 in VARCHAR2
166 ,P_PYM_ATTRIBUTE3 in VARCHAR2
167 ,P_PYM_ATTRIBUTE4 in VARCHAR2
168 ,P_PYM_ATTRIBUTE5 in VARCHAR2
169 ,P_PYM_ATTRIBUTE6 in VARCHAR2
170 ,P_PYM_ATTRIBUTE7 in VARCHAR2
171 ,P_PYM_ATTRIBUTE8 in VARCHAR2
172 ,P_PYM_ATTRIBUTE9 in VARCHAR2
173 ,P_PYM_ATTRIBUTE10 in VARCHAR2
174 ,P_PYM_ATTRIBUTE11 in VARCHAR2
175 ,P_PYM_ATTRIBUTE12 in VARCHAR2
176 ,P_PYM_ATTRIBUTE13 in VARCHAR2
177 ,P_PYM_ATTRIBUTE14 in VARCHAR2
178 ,P_PYM_ATTRIBUTE15 in VARCHAR2
179 ,P_PYM_ATTRIBUTE16 in VARCHAR2
180 ,P_PYM_ATTRIBUTE17 in VARCHAR2
181 ,P_PYM_ATTRIBUTE18 in VARCHAR2
182 ,P_PYM_ATTRIBUTE19 in VARCHAR2
183 ,P_PYM_ATTRIBUTE20 in VARCHAR2
184 ,P_TRANSFER_DATE in DATE
185 ,P_TRANSFER_MESSAGE in VARCHAR2
186 ,P_VENDOR_ID in NUMBER
187 ,P_CONTACT_ID in NUMBER
188 ,P_ADDRESS_ID in NUMBER
189 ,P_CUSTOMER_ID in NUMBER
190 ,P_TFH_INFORMATION_CATEGORY in VARCHAR2
191 ,P_TFH_INFORMATION1 in VARCHAR2
192 ,P_TFH_INFORMATION2 in VARCHAR2
193 ,P_TFH_INFORMATION3 in VARCHAR2
194 ,P_TFH_INFORMATION4 in VARCHAR2
195 ,P_TFH_INFORMATION5 in VARCHAR2
196 ,P_TFH_INFORMATION6 in VARCHAR2
197 ,P_TFH_INFORMATION7 in VARCHAR2
198 ,P_TFH_INFORMATION8 in VARCHAR2
199 ,P_TFH_INFORMATION9 in VARCHAR2
200 ,P_TFH_INFORMATION10 in VARCHAR2
201 ,P_TFH_INFORMATION11 in VARCHAR2
202 ,P_TFH_INFORMATION12 in VARCHAR2
203 ,P_TFH_INFORMATION13 in VARCHAR2
204 ,P_TFH_INFORMATION14 in VARCHAR2
205 ,P_TFH_INFORMATION15 in VARCHAR2
206 ,P_TFH_INFORMATION16 in VARCHAR2
207 ,P_TFH_INFORMATION17 in VARCHAR2
208 ,P_TFH_INFORMATION18 in VARCHAR2
209 ,P_TFH_INFORMATION19 in VARCHAR2
210 ,P_TFH_INFORMATION20 in VARCHAR2
211 ,P_PAYING_COST_CENTER in VARCHAR2
212 ,P_RECEIVING_COST_CENTER in VARCHAR2
213 ,P_TRANSFER_FROM_SET_OF_BOOK_ID in NUMBER
214 ,P_TRANSFER_TO_SET_OF_BOOK_ID in NUMBER
215 ,P_FROM_SEGMENT1 in VARCHAR2
216 ,P_FROM_SEGMENT2 in VARCHAR2
217 ,P_FROM_SEGMENT3 in VARCHAR2
218 ,P_FROM_SEGMENT4 in VARCHAR2
219 ,P_FROM_SEGMENT5 in VARCHAR2
220 ,P_FROM_SEGMENT6 in VARCHAR2
221 ,P_FROM_SEGMENT7 in VARCHAR2
222 ,P_FROM_SEGMENT8 in VARCHAR2
223 ,P_FROM_SEGMENT9 in VARCHAR2
224 ,P_FROM_SEGMENT10 in VARCHAR2
225 ,P_FROM_SEGMENT11 in VARCHAR2
226 ,P_FROM_SEGMENT12 in VARCHAR2
227 ,P_FROM_SEGMENT13 in VARCHAR2
228 ,P_FROM_SEGMENT14 in VARCHAR2
229 ,P_FROM_SEGMENT15 in VARCHAR2
230 ,P_FROM_SEGMENT16 in VARCHAR2
231 ,P_FROM_SEGMENT17 in VARCHAR2
232 ,P_FROM_SEGMENT18 in VARCHAR2
233 ,P_FROM_SEGMENT19 in VARCHAR2
234 ,P_FROM_SEGMENT20 in VARCHAR2
235 ,P_FROM_SEGMENT21 in VARCHAR2
236 ,P_FROM_SEGMENT22 in VARCHAR2
237 ,P_FROM_SEGMENT23 in VARCHAR2
238 ,P_FROM_SEGMENT24 in VARCHAR2
239 ,P_FROM_SEGMENT25 in VARCHAR2
240 ,P_FROM_SEGMENT26 in VARCHAR2
241 ,P_FROM_SEGMENT27 in VARCHAR2
242 ,P_FROM_SEGMENT28 in VARCHAR2
243 ,P_FROM_SEGMENT29 in VARCHAR2
244 ,P_FROM_SEGMENT30 in VARCHAR2
245 ,P_TO_SEGMENT1 in VARCHAR2
246 ,P_TO_SEGMENT2 in VARCHAR2
247 ,P_TO_SEGMENT3 in VARCHAR2
248 ,P_TO_SEGMENT4 in VARCHAR2
249 ,P_TO_SEGMENT5 in VARCHAR2
250 ,P_TO_SEGMENT6 in VARCHAR2
251 ,P_TO_SEGMENT7 in VARCHAR2
252 ,P_TO_SEGMENT8 in VARCHAR2
253 ,P_TO_SEGMENT9 in VARCHAR2
254 ,P_TO_SEGMENT10 in VARCHAR2
255 ,P_TO_SEGMENT11 in VARCHAR2
256 ,P_TO_SEGMENT12 in VARCHAR2
257 ,P_TO_SEGMENT13 in VARCHAR2
258 ,P_TO_SEGMENT14 in VARCHAR2
259 ,P_TO_SEGMENT15 in VARCHAR2
260 ,P_TO_SEGMENT16 in VARCHAR2
261 ,P_TO_SEGMENT17 in VARCHAR2
262 ,P_TO_SEGMENT18 in VARCHAR2
263 ,P_TO_SEGMENT19 in VARCHAR2
264 ,P_TO_SEGMENT20 in VARCHAR2
265 ,P_TO_SEGMENT21 in VARCHAR2
266 ,P_TO_SEGMENT22 in VARCHAR2
267 ,P_TO_SEGMENT23 in VARCHAR2
268 ,P_TO_SEGMENT24 in VARCHAR2
269 ,P_TO_SEGMENT25 in VARCHAR2
270 ,P_TO_SEGMENT26 in VARCHAR2
271 ,P_TO_SEGMENT27 in VARCHAR2
272 ,P_TO_SEGMENT28 in VARCHAR2
273 ,P_TO_SEGMENT29 in VARCHAR2
274 ,P_TO_SEGMENT30 in VARCHAR2
275 ,P_TRANSFER_FROM_CC_ID in NUMBER
276 ,P_TRANSFER_TO_CC_ID in NUMBER
277 ,P_EFFECTIVE_DATE in DATE
278 )is
279 begin
280 hr_utility.set_location('Entering: OTA_FINANCE_HEADER_BK2.UPDATE_FINANCE_HEADER_B', 10);
281 hr_utility.set_location(' Leaving: OTA_FINANCE_HEADER_BK2.UPDATE_FINANCE_HEADER_B', 20);
282 end UPDATE_FINANCE_HEADER_B;
283 end OTA_FINANCE_HEADER_BK2;