1 PACKAGE OE_PRINT_FLEX AUTHID CURRENT_USER AS
2 /* $Header: OEXUPRFS.pls 115.1 2003/10/20 07:16:46 appldev ship $ */
3
4 -- Purpose: This package is used by the OE_BLKTPRT_FLEX_HDR_V and
5 -- OE_BLKTPRT_FLEX_LINES_V views to print the DFF data from the blanket header
6 -- and blanket lines.The context is set initially and the structure is validated
7 -- Once the context is set and the structure validated, the api returns a value
8 -- or description based on the p_value parameter, that indicates a 'D' or 'V'
9 -- The structure validation information is cached in g_valid_structure for
10 -- performance considerations.
11 --
12
13 FUNCTION get_flexdesc(
14 p_appl_short_name IN varchar2 ,
15 p_desc_flex_name IN varchar2,
16 p_values_or_ids IN varchar2 ,
17 p_validation_date IN date,
18 p_context IN varchar2 ,
19 p_attribute1 IN varchar2 ,
20 p_attribute2 IN varchar2 ,
21 p_attribute3 IN varchar2 ,
22 p_attribute4 IN varchar2 ,
23 p_attribute5 IN varchar2 ,
24 p_attribute6 IN varchar2 ,
25 p_attribute7 IN varchar2 ,
26 p_attribute8 IN varchar2 ,
27 p_attribute9 IN varchar2 ,
28 p_attribute10 IN varchar2 ,
29 p_attribute11 IN varchar2 ,
30 p_attribute12 IN varchar2 ,
31 p_attribute13 IN varchar2 ,
32 p_attribute14 IN varchar2 ,
33 p_attribute15 IN varchar2 ,
34 p_attribute16 IN varchar2 ,
35 p_attribute17 IN varchar2 ,
36 p_attribute18 IN varchar2 ,
37 p_attribute19 IN varchar2 ,
38 p_attribute20 IN varchar2 ,
39 p_value IN varchar2 , -- Either 'V' for value or 'D' for description is passed
40 p_segment_number IN NUMBER , -- Will have a value of 1 to 21
41 p_context_reset_flag IN varchar2)
42 RETURN VARCHAR2;
43
44 END OE_PRINT_FLEX;