[Home] [Help]
PACKAGE: APPS.JTF_JFLEX_PUB
Source
1 PACKAGE JTF_JFLEX_PUB AS
2 /* $Header: jtfflexs.pls 120.2 2005/10/25 05:20:19 psanyal ship $ */
3 c_valueset_valtype_independent CONSTANT VARCHAR(20) := 'I';
4 c_valueset_valtype_none CONSTANT VARCHAR(20) := 'N';
5
6 procedure Get_Flexfield(p_application IN varchar2,
7 p_flexfield_name IN varchar2,
8 name OUT NOCOPY /* file.sql.39 change */ varchar2,
9 apps_name OUT NOCOPY /* file.sql.39 change */ varchar2,
10 nr_segs OUT NOCOPY /* file.sql.39 change */ number,
11 dfs_name OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
12 dfs_dbcolumn_name OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
13 dfs_default_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
14 dfs_prompt OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
15 dfs_max_size OUT NOCOPY /* file.sql.39 change */ jtf_number_table,
16 dfs_min_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
17 dfs_max_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
18 dfs_mandatory OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_100,
19 dfs_default_type OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_100,
20 dfs_valtype OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_100,
21 dfs_lov_id OUT NOCOPY /* file.sql.39 change */ jtf_number_table,
22 dfs_format_type OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_100,
23 dfs_display_size OUT NOCOPY /* file.sql.39 change */ jtf_number_table);
24
25 procedure Get_ValueSet(p_valueset_id IN number,
26 x_value OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300,
27 x_meaning OUT NOCOPY /* file.sql.39 change */ jtf_varchar2_table_300);
28
29
30
31
32 end JTF_JFLEX_PUB;