[Home] [Help]
PACKAGE: APPS.OKE_PRINT_FORM_PUB
Source
1 PACKAGE oke_print_form_pub AUTHID CURRENT_USER AS
2 /* $Header: OKEPPFMS.pls 115.5 2002/11/19 21:22:00 jxtang ship $ */
3
4 --
5 -- This record type is used to specify an instance of a print form and
6 -- provide header level data.
7 --
8 TYPE PFH_Rec_Type IS RECORD
9 ( --
10 -- Form_Header_ID can only be used in Update_Print_Form. If
11 -- populated in Create_Print_Form, the value will be ignored
12 --
13 Form_Header_ID oke_k_form_headers.form_header_id%TYPE := NULL
14 , Print_Form_Code oke_k_form_headers.print_form_code%TYPE
15 , Form_Header_Number oke_k_form_headers.form_header_number%TYPE
16 , Form_Date oke_k_form_headers.form_date%TYPE
17 --
18 -- Either the ID or Number / Type / Intent must be provided for
19 -- contract header. If both are provided, the ID value will be used.
20 --
21 , Contract_Number oke_k_headers.k_number_disp%TYPE := NULL
22 , Buy_Or_Sell okc_k_headers_b.buy_or_sell%TYPE := NULL
23 , K_Type_Code oke_k_headers.k_type_code%TYPE := NULL
24 , Contract_Header_ID okc_k_headers_b.id%TYPE := NULL
25 --
26 -- Either the ID or Number maybe provided for contract line. If
27 -- both are provided, the ID value will be used.
28 --
29 , Contract_Line_Number okc_k_lines_b.line_number%TYPE := NULL
30 , Contract_Line_ID okc_k_lines_b.ID%TYPE := NULL
31 --
32 -- Either the ID or Number maybe provided for deliverable. If
33 -- both are provided, the ID value will be used.
34 --
35 , Deliverable_Number oke_k_deliverables_b.deliverable_num%TYPE := NULL
36 , Deliverable_ID NUMBER := NULL
37 --
38 -- Additional Reference columns 1 through 5
39 --
40 , Reference1 VARCHAR2(240) := FND_API.G_MISS_CHAR
41 , Reference2 VARCHAR2(240) := FND_API.G_MISS_CHAR
42 , Reference3 VARCHAR2(240) := FND_API.G_MISS_CHAR
43 , Reference4 VARCHAR2(240) := FND_API.G_MISS_CHAR
44 , Reference5 VARCHAR2(240) := FND_API.G_MISS_CHAR
45 --
46 -- Form Statuses are defined as lookups with lookup_type
47 -- OKE_FORM_STATUS. Either the code or the meaning must be
48 -- provided. If both are provided, the CODE value will be used.
49 --
50 , Status_Name fnd_lookup_values.meaning%TYPE
51 , Status_Code oke_k_form_headers.status_code%TYPE
52 --
53 -- Header Level Data
54 --
55 , Text01 VARCHAR2(2000) := FND_API.G_MISS_CHAR
56 , Text02 VARCHAR2(2000) := FND_API.G_MISS_CHAR
57 , Text03 VARCHAR2(2000) := FND_API.G_MISS_CHAR
58 , Text04 VARCHAR2(2000) := FND_API.G_MISS_CHAR
59 , Text05 VARCHAR2(2000) := FND_API.G_MISS_CHAR
60 , Text06 VARCHAR2(2000) := FND_API.G_MISS_CHAR
61 , Text07 VARCHAR2(2000) := FND_API.G_MISS_CHAR
62 , Text08 VARCHAR2(2000) := FND_API.G_MISS_CHAR
63 , Text09 VARCHAR2(2000) := FND_API.G_MISS_CHAR
64 , Text10 VARCHAR2(2000) := FND_API.G_MISS_CHAR
65 , Text11 VARCHAR2(2000) := FND_API.G_MISS_CHAR
66 , Text12 VARCHAR2(2000) := FND_API.G_MISS_CHAR
67 , Text13 VARCHAR2(2000) := FND_API.G_MISS_CHAR
68 , Text14 VARCHAR2(2000) := FND_API.G_MISS_CHAR
69 , Text15 VARCHAR2(2000) := FND_API.G_MISS_CHAR
70 , Text16 VARCHAR2(2000) := FND_API.G_MISS_CHAR
71 , Text17 VARCHAR2(2000) := FND_API.G_MISS_CHAR
72 , Text18 VARCHAR2(2000) := FND_API.G_MISS_CHAR
73 , Text19 VARCHAR2(2000) := FND_API.G_MISS_CHAR
74 , Text20 VARCHAR2(2000) := FND_API.G_MISS_CHAR
75 , Text21 VARCHAR2(2000) := FND_API.G_MISS_CHAR
76 , Text22 VARCHAR2(2000) := FND_API.G_MISS_CHAR
77 , Text23 VARCHAR2(2000) := FND_API.G_MISS_CHAR
78 , Text24 VARCHAR2(2000) := FND_API.G_MISS_CHAR
79 , Text25 VARCHAR2(2000) := FND_API.G_MISS_CHAR
80 , Text26 VARCHAR2(2000) := FND_API.G_MISS_CHAR
81 , Text27 VARCHAR2(2000) := FND_API.G_MISS_CHAR
82 , Text28 VARCHAR2(2000) := FND_API.G_MISS_CHAR
83 , Text29 VARCHAR2(2000) := FND_API.G_MISS_CHAR
84 , Text30 VARCHAR2(2000) := FND_API.G_MISS_CHAR
85 , Text31 VARCHAR2(2000) := FND_API.G_MISS_CHAR
86 , Text32 VARCHAR2(2000) := FND_API.G_MISS_CHAR
87 , Text33 VARCHAR2(2000) := FND_API.G_MISS_CHAR
88 , Text34 VARCHAR2(2000) := FND_API.G_MISS_CHAR
89 , Text35 VARCHAR2(2000) := FND_API.G_MISS_CHAR
90 , Text36 VARCHAR2(2000) := FND_API.G_MISS_CHAR
91 , Text37 VARCHAR2(2000) := FND_API.G_MISS_CHAR
92 , Text38 VARCHAR2(2000) := FND_API.G_MISS_CHAR
93 , Text39 VARCHAR2(2000) := FND_API.G_MISS_CHAR
94 , Text40 VARCHAR2(2000) := FND_API.G_MISS_CHAR
95 , Text41 VARCHAR2(2000) := FND_API.G_MISS_CHAR
96 , Text42 VARCHAR2(2000) := FND_API.G_MISS_CHAR
97 , Text43 VARCHAR2(2000) := FND_API.G_MISS_CHAR
98 , Text44 VARCHAR2(2000) := FND_API.G_MISS_CHAR
99 , Text45 VARCHAR2(2000) := FND_API.G_MISS_CHAR
100 , Text46 VARCHAR2(2000) := FND_API.G_MISS_CHAR
101 , Text47 VARCHAR2(2000) := FND_API.G_MISS_CHAR
102 , Text48 VARCHAR2(2000) := FND_API.G_MISS_CHAR
103 , Text49 VARCHAR2(2000) := FND_API.G_MISS_CHAR
104 , Text50 VARCHAR2(2000) := FND_API.G_MISS_CHAR
105 , Number01 NUMBER := FND_API.G_MISS_NUM
106 , Number02 NUMBER := FND_API.G_MISS_NUM
107 , Number03 NUMBER := FND_API.G_MISS_NUM
108 , Number04 NUMBER := FND_API.G_MISS_NUM
109 , Number05 NUMBER := FND_API.G_MISS_NUM
110 , Number06 NUMBER := FND_API.G_MISS_NUM
111 , Number07 NUMBER := FND_API.G_MISS_NUM
112 , Number08 NUMBER := FND_API.G_MISS_NUM
113 , Number09 NUMBER := FND_API.G_MISS_NUM
114 , Number10 NUMBER := FND_API.G_MISS_NUM
115 , Number11 NUMBER := FND_API.G_MISS_NUM
116 , Number12 NUMBER := FND_API.G_MISS_NUM
117 , Number13 NUMBER := FND_API.G_MISS_NUM
118 , Number14 NUMBER := FND_API.G_MISS_NUM
119 , Number15 NUMBER := FND_API.G_MISS_NUM
120 , Number16 NUMBER := FND_API.G_MISS_NUM
121 , Number17 NUMBER := FND_API.G_MISS_NUM
122 , Number18 NUMBER := FND_API.G_MISS_NUM
123 , Number19 NUMBER := FND_API.G_MISS_NUM
124 , Number20 NUMBER := FND_API.G_MISS_NUM
125 , Number21 NUMBER := FND_API.G_MISS_NUM
126 , Number22 NUMBER := FND_API.G_MISS_NUM
127 , Number23 NUMBER := FND_API.G_MISS_NUM
128 , Number24 NUMBER := FND_API.G_MISS_NUM
129 , Number25 NUMBER := FND_API.G_MISS_NUM
130 , Number26 NUMBER := FND_API.G_MISS_NUM
131 , Number27 NUMBER := FND_API.G_MISS_NUM
132 , Number28 NUMBER := FND_API.G_MISS_NUM
133 , Number29 NUMBER := FND_API.G_MISS_NUM
134 , Number30 NUMBER := FND_API.G_MISS_NUM
135 , Number31 NUMBER := FND_API.G_MISS_NUM
136 , Number32 NUMBER := FND_API.G_MISS_NUM
137 , Number33 NUMBER := FND_API.G_MISS_NUM
138 , Number34 NUMBER := FND_API.G_MISS_NUM
139 , Number35 NUMBER := FND_API.G_MISS_NUM
140 , Number36 NUMBER := FND_API.G_MISS_NUM
141 , Number37 NUMBER := FND_API.G_MISS_NUM
142 , Number38 NUMBER := FND_API.G_MISS_NUM
143 , Number39 NUMBER := FND_API.G_MISS_NUM
144 , Number40 NUMBER := FND_API.G_MISS_NUM
145 , Number41 NUMBER := FND_API.G_MISS_NUM
146 , Number42 NUMBER := FND_API.G_MISS_NUM
147 , Number43 NUMBER := FND_API.G_MISS_NUM
148 , Number44 NUMBER := FND_API.G_MISS_NUM
149 , Number45 NUMBER := FND_API.G_MISS_NUM
150 , Number46 NUMBER := FND_API.G_MISS_NUM
151 , Number47 NUMBER := FND_API.G_MISS_NUM
152 , Number48 NUMBER := FND_API.G_MISS_NUM
153 , Number49 NUMBER := FND_API.G_MISS_NUM
154 , Number50 NUMBER := FND_API.G_MISS_NUM
155 , Date01 DATE := FND_API.G_MISS_DATE
156 , Date02 DATE := FND_API.G_MISS_DATE
157 , Date03 DATE := FND_API.G_MISS_DATE
158 , Date04 DATE := FND_API.G_MISS_DATE
159 , Date05 DATE := FND_API.G_MISS_DATE
160 , Date06 DATE := FND_API.G_MISS_DATE
161 , Date07 DATE := FND_API.G_MISS_DATE
162 , Date08 DATE := FND_API.G_MISS_DATE
163 , Date09 DATE := FND_API.G_MISS_DATE
164 , Date10 DATE := FND_API.G_MISS_DATE
165 , Date11 DATE := FND_API.G_MISS_DATE
166 , Date12 DATE := FND_API.G_MISS_DATE
167 , Date13 DATE := FND_API.G_MISS_DATE
168 , Date14 DATE := FND_API.G_MISS_DATE
169 , Date15 DATE := FND_API.G_MISS_DATE
170 , Date16 DATE := FND_API.G_MISS_DATE
171 , Date17 DATE := FND_API.G_MISS_DATE
172 , Date18 DATE := FND_API.G_MISS_DATE
173 , Date19 DATE := FND_API.G_MISS_DATE
174 , Date20 DATE := FND_API.G_MISS_DATE
175 , Date21 DATE := FND_API.G_MISS_DATE
176 , Date22 DATE := FND_API.G_MISS_DATE
177 , Date23 DATE := FND_API.G_MISS_DATE
178 , Date24 DATE := FND_API.G_MISS_DATE
179 , Date25 DATE := FND_API.G_MISS_DATE
180 , Date26 DATE := FND_API.G_MISS_DATE
181 , Date27 DATE := FND_API.G_MISS_DATE
182 , Date28 DATE := FND_API.G_MISS_DATE
183 , Date29 DATE := FND_API.G_MISS_DATE
184 , Date30 DATE := FND_API.G_MISS_DATE
185 , Date31 DATE := FND_API.G_MISS_DATE
186 , Date32 DATE := FND_API.G_MISS_DATE
187 , Date33 DATE := FND_API.G_MISS_DATE
188 , Date34 DATE := FND_API.G_MISS_DATE
189 , Date35 DATE := FND_API.G_MISS_DATE
190 , Date36 DATE := FND_API.G_MISS_DATE
191 , Date37 DATE := FND_API.G_MISS_DATE
192 , Date38 DATE := FND_API.G_MISS_DATE
193 , Date39 DATE := FND_API.G_MISS_DATE
194 , Date40 DATE := FND_API.G_MISS_DATE
195 , Date41 DATE := FND_API.G_MISS_DATE
196 , Date42 DATE := FND_API.G_MISS_DATE
197 , Date43 DATE := FND_API.G_MISS_DATE
198 , Date44 DATE := FND_API.G_MISS_DATE
199 , Date45 DATE := FND_API.G_MISS_DATE
200 , Date46 DATE := FND_API.G_MISS_DATE
201 , Date47 DATE := FND_API.G_MISS_DATE
202 , Date48 DATE := FND_API.G_MISS_DATE
203 , Date49 DATE := FND_API.G_MISS_DATE
204 , Date50 DATE := FND_API.G_MISS_DATE
205 );
206
207 --
208 -- This record type is used to specify line level data. Line level
209 -- data is optional.
210 --
211 TYPE PFL_Rec_Type IS RECORD
212 ( Form_Line_Number oke_k_form_lines.form_line_number%TYPE
213 --
214 -- Either the ID or Number / Type / Intent may be provided for
215 -- contract header. If both are provided, the ID value will be used.
216 --
217 , Contract_Number oke_k_headers.k_number_disp%TYPE := NULL
218 , Buy_Or_Sell okc_k_headers_b.buy_or_sell%TYPE := NULL
219 , K_Type_Code oke_k_headers.k_type_code%TYPE := NULL
220 , Contract_Header_ID okc_k_headers_b.id%TYPE := NULL
221 --
222 -- Either the ID or Number may be provided for contract line. If
223 -- both are provided, the ID value will be used.
224 --
225 , Contract_Line_Number okc_k_lines_b.line_number%TYPE := NULL
226 , Contract_Line_ID okc_k_lines_b.ID%TYPE := NULL
227 --
228 -- Either the ID or Number may be provided for deliverable. If
229 -- both are provided, the ID value will be used.
230 --
231 , Deliverable_Number oke_k_deliverables_b.deliverable_num%TYPE := NULL
232 , Deliverable_ID NUMBER := NULL
233 --
234 -- Additional Reference columns 1 through 5
235 --
236 , Reference1 VARCHAR2(240) := FND_API.G_MISS_CHAR
237 , Reference2 VARCHAR2(240) := FND_API.G_MISS_CHAR
238 , Reference3 VARCHAR2(240) := FND_API.G_MISS_CHAR
239 , Reference4 VARCHAR2(240) := FND_API.G_MISS_CHAR
240 , Reference5 VARCHAR2(240) := FND_API.G_MISS_CHAR
241 , Text01 VARCHAR2(2000) := FND_API.G_MISS_CHAR
242 , Text02 VARCHAR2(2000) := FND_API.G_MISS_CHAR
243 , Text03 VARCHAR2(2000) := FND_API.G_MISS_CHAR
244 , Text04 VARCHAR2(2000) := FND_API.G_MISS_CHAR
245 , Text05 VARCHAR2(2000) := FND_API.G_MISS_CHAR
246 , Text06 VARCHAR2(2000) := FND_API.G_MISS_CHAR
247 , Text07 VARCHAR2(2000) := FND_API.G_MISS_CHAR
248 , Text08 VARCHAR2(2000) := FND_API.G_MISS_CHAR
249 , Text09 VARCHAR2(2000) := FND_API.G_MISS_CHAR
250 , Text10 VARCHAR2(2000) := FND_API.G_MISS_CHAR
251 , Text11 VARCHAR2(2000) := FND_API.G_MISS_CHAR
252 , Text12 VARCHAR2(2000) := FND_API.G_MISS_CHAR
253 , Text13 VARCHAR2(2000) := FND_API.G_MISS_CHAR
254 , Text14 VARCHAR2(2000) := FND_API.G_MISS_CHAR
255 , Text15 VARCHAR2(2000) := FND_API.G_MISS_CHAR
256 , Text16 VARCHAR2(2000) := FND_API.G_MISS_CHAR
257 , Text17 VARCHAR2(2000) := FND_API.G_MISS_CHAR
258 , Text18 VARCHAR2(2000) := FND_API.G_MISS_CHAR
259 , Text19 VARCHAR2(2000) := FND_API.G_MISS_CHAR
260 , Text20 VARCHAR2(2000) := FND_API.G_MISS_CHAR
261 , Text21 VARCHAR2(2000) := FND_API.G_MISS_CHAR
262 , Text22 VARCHAR2(2000) := FND_API.G_MISS_CHAR
263 , Text23 VARCHAR2(2000) := FND_API.G_MISS_CHAR
264 , Text24 VARCHAR2(2000) := FND_API.G_MISS_CHAR
265 , Text25 VARCHAR2(2000) := FND_API.G_MISS_CHAR
266 , Text26 VARCHAR2(2000) := FND_API.G_MISS_CHAR
267 , Text27 VARCHAR2(2000) := FND_API.G_MISS_CHAR
268 , Text28 VARCHAR2(2000) := FND_API.G_MISS_CHAR
269 , Text29 VARCHAR2(2000) := FND_API.G_MISS_CHAR
270 , Text30 VARCHAR2(2000) := FND_API.G_MISS_CHAR
271 , Text31 VARCHAR2(2000) := FND_API.G_MISS_CHAR
272 , Text32 VARCHAR2(2000) := FND_API.G_MISS_CHAR
273 , Text33 VARCHAR2(2000) := FND_API.G_MISS_CHAR
274 , Text34 VARCHAR2(2000) := FND_API.G_MISS_CHAR
275 , Text35 VARCHAR2(2000) := FND_API.G_MISS_CHAR
276 , Text36 VARCHAR2(2000) := FND_API.G_MISS_CHAR
277 , Text37 VARCHAR2(2000) := FND_API.G_MISS_CHAR
278 , Text38 VARCHAR2(2000) := FND_API.G_MISS_CHAR
279 , Text39 VARCHAR2(2000) := FND_API.G_MISS_CHAR
280 , Text40 VARCHAR2(2000) := FND_API.G_MISS_CHAR
281 , Text41 VARCHAR2(2000) := FND_API.G_MISS_CHAR
282 , Text42 VARCHAR2(2000) := FND_API.G_MISS_CHAR
283 , Text43 VARCHAR2(2000) := FND_API.G_MISS_CHAR
284 , Text44 VARCHAR2(2000) := FND_API.G_MISS_CHAR
285 , Text45 VARCHAR2(2000) := FND_API.G_MISS_CHAR
286 , Text46 VARCHAR2(2000) := FND_API.G_MISS_CHAR
287 , Text47 VARCHAR2(2000) := FND_API.G_MISS_CHAR
288 , Text48 VARCHAR2(2000) := FND_API.G_MISS_CHAR
289 , Text49 VARCHAR2(2000) := FND_API.G_MISS_CHAR
290 , Text50 VARCHAR2(2000) := FND_API.G_MISS_CHAR
291 , Number01 NUMBER := FND_API.G_MISS_NUM
292 , Number02 NUMBER := FND_API.G_MISS_NUM
293 , Number03 NUMBER := FND_API.G_MISS_NUM
294 , Number04 NUMBER := FND_API.G_MISS_NUM
295 , Number05 NUMBER := FND_API.G_MISS_NUM
296 , Number06 NUMBER := FND_API.G_MISS_NUM
297 , Number07 NUMBER := FND_API.G_MISS_NUM
298 , Number08 NUMBER := FND_API.G_MISS_NUM
299 , Number09 NUMBER := FND_API.G_MISS_NUM
300 , Number10 NUMBER := FND_API.G_MISS_NUM
301 , Number11 NUMBER := FND_API.G_MISS_NUM
302 , Number12 NUMBER := FND_API.G_MISS_NUM
303 , Number13 NUMBER := FND_API.G_MISS_NUM
304 , Number14 NUMBER := FND_API.G_MISS_NUM
305 , Number15 NUMBER := FND_API.G_MISS_NUM
306 , Number16 NUMBER := FND_API.G_MISS_NUM
307 , Number17 NUMBER := FND_API.G_MISS_NUM
308 , Number18 NUMBER := FND_API.G_MISS_NUM
309 , Number19 NUMBER := FND_API.G_MISS_NUM
310 , Number20 NUMBER := FND_API.G_MISS_NUM
311 , Number21 NUMBER := FND_API.G_MISS_NUM
312 , Number22 NUMBER := FND_API.G_MISS_NUM
313 , Number23 NUMBER := FND_API.G_MISS_NUM
314 , Number24 NUMBER := FND_API.G_MISS_NUM
315 , Number25 NUMBER := FND_API.G_MISS_NUM
316 , Number26 NUMBER := FND_API.G_MISS_NUM
317 , Number27 NUMBER := FND_API.G_MISS_NUM
318 , Number28 NUMBER := FND_API.G_MISS_NUM
319 , Number29 NUMBER := FND_API.G_MISS_NUM
320 , Number30 NUMBER := FND_API.G_MISS_NUM
321 , Number31 NUMBER := FND_API.G_MISS_NUM
322 , Number32 NUMBER := FND_API.G_MISS_NUM
323 , Number33 NUMBER := FND_API.G_MISS_NUM
324 , Number34 NUMBER := FND_API.G_MISS_NUM
325 , Number35 NUMBER := FND_API.G_MISS_NUM
326 , Number36 NUMBER := FND_API.G_MISS_NUM
327 , Number37 NUMBER := FND_API.G_MISS_NUM
328 , Number38 NUMBER := FND_API.G_MISS_NUM
329 , Number39 NUMBER := FND_API.G_MISS_NUM
330 , Number40 NUMBER := FND_API.G_MISS_NUM
331 , Number41 NUMBER := FND_API.G_MISS_NUM
332 , Number42 NUMBER := FND_API.G_MISS_NUM
333 , Number43 NUMBER := FND_API.G_MISS_NUM
334 , Number44 NUMBER := FND_API.G_MISS_NUM
335 , Number45 NUMBER := FND_API.G_MISS_NUM
336 , Number46 NUMBER := FND_API.G_MISS_NUM
337 , Number47 NUMBER := FND_API.G_MISS_NUM
338 , Number48 NUMBER := FND_API.G_MISS_NUM
339 , Number49 NUMBER := FND_API.G_MISS_NUM
340 , Number50 NUMBER := FND_API.G_MISS_NUM
341 , Date01 DATE := FND_API.G_MISS_DATE
342 , Date02 DATE := FND_API.G_MISS_DATE
343 , Date03 DATE := FND_API.G_MISS_DATE
344 , Date04 DATE := FND_API.G_MISS_DATE
345 , Date05 DATE := FND_API.G_MISS_DATE
346 , Date06 DATE := FND_API.G_MISS_DATE
347 , Date07 DATE := FND_API.G_MISS_DATE
348 , Date08 DATE := FND_API.G_MISS_DATE
349 , Date09 DATE := FND_API.G_MISS_DATE
350 , Date10 DATE := FND_API.G_MISS_DATE
351 , Date11 DATE := FND_API.G_MISS_DATE
352 , Date12 DATE := FND_API.G_MISS_DATE
353 , Date13 DATE := FND_API.G_MISS_DATE
354 , Date14 DATE := FND_API.G_MISS_DATE
355 , Date15 DATE := FND_API.G_MISS_DATE
356 , Date16 DATE := FND_API.G_MISS_DATE
357 , Date17 DATE := FND_API.G_MISS_DATE
358 , Date18 DATE := FND_API.G_MISS_DATE
359 , Date19 DATE := FND_API.G_MISS_DATE
360 , Date20 DATE := FND_API.G_MISS_DATE
361 , Date21 DATE := FND_API.G_MISS_DATE
362 , Date22 DATE := FND_API.G_MISS_DATE
363 , Date23 DATE := FND_API.G_MISS_DATE
364 , Date24 DATE := FND_API.G_MISS_DATE
365 , Date25 DATE := FND_API.G_MISS_DATE
366 , Date26 DATE := FND_API.G_MISS_DATE
367 , Date27 DATE := FND_API.G_MISS_DATE
368 , Date28 DATE := FND_API.G_MISS_DATE
369 , Date29 DATE := FND_API.G_MISS_DATE
370 , Date30 DATE := FND_API.G_MISS_DATE
371 , Date31 DATE := FND_API.G_MISS_DATE
372 , Date32 DATE := FND_API.G_MISS_DATE
373 , Date33 DATE := FND_API.G_MISS_DATE
374 , Date34 DATE := FND_API.G_MISS_DATE
375 , Date35 DATE := FND_API.G_MISS_DATE
376 , Date36 DATE := FND_API.G_MISS_DATE
377 , Date37 DATE := FND_API.G_MISS_DATE
378 , Date38 DATE := FND_API.G_MISS_DATE
379 , Date39 DATE := FND_API.G_MISS_DATE
380 , Date40 DATE := FND_API.G_MISS_DATE
381 , Date41 DATE := FND_API.G_MISS_DATE
382 , Date42 DATE := FND_API.G_MISS_DATE
383 , Date43 DATE := FND_API.G_MISS_DATE
384 , Date44 DATE := FND_API.G_MISS_DATE
385 , Date45 DATE := FND_API.G_MISS_DATE
386 , Date46 DATE := FND_API.G_MISS_DATE
387 , Date47 DATE := FND_API.G_MISS_DATE
388 , Date48 DATE := FND_API.G_MISS_DATE
389 , Date49 DATE := FND_API.G_MISS_DATE
390 , Date50 DATE := FND_API.G_MISS_DATE
391 );
392
393 TYPE PFL_Tbl_Type IS TABLE OF PFL_Rec_Type
394 INDEX BY BINARY_INTEGER;
395
396
397 --
398 -- API Name : Create_Print_Form
399 -- Type : Public
400 -- Pre-reqs : None
401 -- Function : Creates a new instances of a print form
402 --
403 -- Parameters :
404 -- IN : p_api_version NUMBER
405 -- p_commit VARCHAR2
406 -- p_init_msg_list VARCHAR2
407 -- p_header_rec PFH_Rec_Type
408 -- p_line_tbl PFL_Tbl_Type
409 -- OUT : x_form_header_id NUMBER
410 -- Primary Key of print form header, if
411 -- successfully created
412 -- x_msg_count NUMBER
413 -- x_msg_data VARCHAR2
414 -- x_return_status VARCHAR2
415 --
416 -- Version : Current Version - 1.0
417 -- Initial Version - 1.0
418 --
419 PROCEDURE Create_Print_Form
420 ( p_api_version IN NUMBER
421 , p_commit IN VARCHAR2
422 , p_init_msg_list IN VARCHAR2
423 , x_msg_count OUT NOCOPY NUMBER
424 , x_msg_data OUT NOCOPY VARCHAR2
425 , x_return_status OUT NOCOPY VARCHAR2
426 , p_header_rec IN PFH_Rec_Type
427 , p_line_tbl IN PFL_Tbl_Type
428 , x_form_header_id OUT NOCOPY NUMBER
429 );
430
431
432 --
433 -- API Name : Create_Print_Form
434 -- Type : Public
435 -- Pre-reqs : None
436 -- Function : Updates an existing instance of a print form
437 --
438 -- Parameters :
439 -- IN : p_api_version NUMBER
440 -- p_commit VARCHAR2
441 -- p_init_msg_list VARCHAR2
442 -- p_header_rec PFH_Rec_Type
443 -- p_line_tbl PFL_Tbl_Type
444 -- OUT : x_msg_count NUMBER
445 -- x_msg_data VARCHAR2
446 -- x_return_status VARCHAR2
447 --
448 -- Version : Current Version - 1.0
449 -- Initial Version - 1.0
450 --
451 PROCEDURE Update_Print_Form
452 ( p_api_version IN NUMBER
453 , p_commit IN VARCHAR2
454 , p_init_msg_list IN VARCHAR2
455 , x_msg_count OUT NOCOPY NUMBER
456 , x_msg_data OUT NOCOPY VARCHAR2
457 , x_return_status OUT NOCOPY VARCHAR2
458 , p_header_rec IN PFH_Rec_Type
459 , p_line_tbl IN PFL_Tbl_Type
460 );
461
462 END oke_print_form_pub;