PACKAGE: APPS.JTF_JFLEX_PUB

Source

1 PACKAGE JTF_JFLEX_PUB AUTHID CURRENT_USER 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;