1 PACKAGE hr_descr_flex_info
2 /* $Header: hrdflinf.pkh 120.0 2005/05/30 23:39:10 appldev noship $ */
3 AS
4 --
5 -- Global Types
6 --
7 TYPE t_segment IS RECORD
8 (column_name fnd_columns.column_name%TYPE
9 );
10 TYPE t_segments IS TABLE OF t_segment;
11 --
12 -- -----------------------------------------------------------------------------
13 -- |-----------------------< default_context_field_name >----------------------|
14 -- -----------------------------------------------------------------------------
15 -- {Start of Comments}
16 --
17 -- Description
18 -- This function returns the default context field name for a descriptive
19 -- flexfield.
20 --
21 -- Prerequisites
22 -- None.
23 --
24 -- In Parameters
25 -- Name Reqd Type Description
26 -- p_application_id Y number Application identifier
27 -- p_descriptive_flexfield_name Y varchar2 Descriptive flexfield name
28 -- p_field_name_prefix N varchar2 Prefix to add to field name
29 --
30 -- Post Success
31 -- The default context field name for the descriptive flexfield is returned.
32 --
33 -- Post Failure
34 -- An error is raised.
35 --
36 -- Access Status
37 -- Internal Development Use Only
38 --
39 -- {End of Comments}
40 -- -----------------------------------------------------------------------------
41 FUNCTION default_context_field_name
42 (p_application_short_name IN fnd_application.application_short_name%TYPE
43 ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
44 ,p_field_name_prefix IN VARCHAR2 DEFAULT NULL
45 )
46 RETURN fnd_descriptive_flexs.default_context_field_name%TYPE;
47 --
48 -- -----------------------------------------------------------------------------
49 -- |---------------------------< context_column_name >-------------------------|
50 -- -----------------------------------------------------------------------------
51 -- {Start of Comments}
52 --
53 -- Description
54 -- This function returns the context column name for a descriptive flexfield.
55 --
56 -- Prerequisites
57 -- None.
58 --
59 -- In Parameters
60 -- Name Reqd Type Description
61 -- p_application_id Y number Application identifier
62 -- p_descriptive_flexfield_name Y varchar2 Descriptive flexfield name
63 -- p_field_name_prefix N varchar2 Prefix to add to field name
64 --
65 -- Post Success
66 -- The context column name for the descriptive flexfield is returned.
67 --
68 -- Post Failure
69 -- An error is raised.
70 --
71 -- Access Status
72 -- Internal Development Use Only
73 --
74 -- {End of Comments}
75 -- -----------------------------------------------------------------------------
76 FUNCTION context_column_name
77 (p_application_short_name IN fnd_application.application_short_name%TYPE
78 ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
79 ,p_field_name_prefix IN VARCHAR2 DEFAULT NULL
80 )
81 RETURN fnd_descriptive_flexs.context_column_name%TYPE;
82 --
83 -- -----------------------------------------------------------------------------
84 -- |--------------------------------< segments >-------------------------------|
85 -- -----------------------------------------------------------------------------
86 -- {Start of Comments}
87 --
88 -- Description
89 -- This function returns a table containing details of all the columns which
90 -- are available for use with the descriptive flexfield.
91 --
92 -- Prerequisites
93 -- None.
94 --
95 -- In Parameters
96 -- Name Reqd Type Description
97 -- p_application_id Y number Application identifier
98 -- p_descriptive_flexfield_name Y varchar2 Descriptive flexfield name
99 --
100 -- Post Success
101 -- A table containg the available columns is returned.
102 --
103 -- Post Failure
104 -- An error is raised.
105 --
106 -- Access Status
107 -- Internal Development Use Only
108 --
109 -- {End of Comments}
110 -- -----------------------------------------------------------------------------
111 FUNCTION segments
112 (p_application_id IN fnd_descriptive_flexs.application_id%TYPE
113 ,p_descriptive_flexfield_name IN fnd_descriptive_flexs.descriptive_flexfield_name%TYPE
114 )
115 RETURN t_segments;
116 --
117 END hr_descr_flex_info;