1 PACKAGE hr_id_flex_info
2 /* $Header: hrkflinf.pkh 120.0 2005/05/31 01:06:01 appldev noship $ */
3 AUTHID CURRENT_USER 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 -- |--------------------------< defining_column_name >-------------------------|
14 -- -----------------------------------------------------------------------------
15 -- {Start of Comments}
16 --
17 -- Description
18 -- This function returns the defining column for a key flexfield.
19 --
20 -- Prerequisites
21 -- None.
22 --
23 -- In Parameters
24 -- Name Reqd Type Description
25 -- p_application_short_name Y varchar2 Application short name
26 -- p_id_flex_code Y varchar2 Key flexfield code
27 --
28 -- Post Success
29 -- The defining column name for the key flexfield is returned.
30 --
31 -- Post Failure
32 -- An error is raised.
33 --
34 -- Access Status
35 -- Internal Development Use Only
36 --
37 -- {End of Comments}
38 -- -----------------------------------------------------------------------------
39 FUNCTION defining_column_name
40 (p_application_short_name IN fnd_application.application_short_name%TYPE
41 ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
42 )
43 RETURN fnd_id_flexs.set_defining_column_name%TYPE;
44 --
45 -- -----------------------------------------------------------------------------
46 -- |--------------------------------< segments >-------------------------------|
47 -- -----------------------------------------------------------------------------
48 -- {Start of Comments}
49 --
50 -- Description
51 -- This function returns a table containing details of all the columns which
52 -- are available for use with the key flexfield.
53 --
54 -- Prerequisites
55 -- None.
56 --
57 -- In Parameters
58 -- Name Reqd Type Description
59 -- p_application_id Y number Application identifier
60 -- p_id_flex_code Y varchar2 Key flexfield code
61 --
62 -- Post Success
63 -- A table containg the available columns is returned.
64 --
65 -- Post Failure
66 -- An error is raised.
67 --
68 -- Access Status
69 -- Internal Development Use Only
70 --
71 -- {End of Comments}
72 -- -----------------------------------------------------------------------------
73 FUNCTION segments
74 (p_application_id IN fnd_id_flexs.application_id%TYPE
75 ,p_id_flex_code IN fnd_id_flexs.id_flex_code%TYPE
76 )
77 RETURN t_segments;
78 --
79 END hr_id_flex_info;