DBA Data[Home] [Help]

PACKAGE: APPS.PSP_AUTO_DYN

Source


1 PACKAGE psp_auto_dyn AUTHID CURRENT_USER AS
2 --$Header: PSPAUDYS.pls 120.0 2005/06/02 15:43:24 appldev noship $
3 
4 --------------------------------------------------------------------
5 --	PROCEDURE CREATE_DYN_DATA		-------------------
6 --------------------------------------------------------------------
7 
8 PROCEDURE create_dyn_data(p_parameter_class	IN 	VARCHAR2,
9 			  p_parameter		IN	VARCHAR2,
10 			  p_appl_column_name	IN	VARCHAR2,
11 			  p_dff_col_name	IN	VARCHAR2,
12 			  p_dff_context_code    IN      VARCHAR2, -- Introduced for bug 4303976
13 			  p_flex_val_set_id	IN	NUMBER,
14 			  p_dyn_sql_stmt	OUT NOCOPY	VARCHAR2,
15 			  p_bind_var		OUT NOCOPY	VARCHAR2,
16 			  p_validation_type 	OUT NOCOPY	VARCHAR2,
17 			  p_param_value_set	OUT NOCOPY	VARCHAR2);
18 
19 PROCEDURE type_table_flex_code(	p_parameter_class 	IN  VARCHAR2,
20 				p_type			OUT NOCOPY VARCHAR2,
21 				p_table_name		OUT NOCOPY VARCHAR2,
22 				p_flex_code		OUT NOCOPY VARCHAR2);
23 
24 PROCEDURE get_flexfield_parameters( p_type 		IN VARCHAR2,
25 				    p_table_name 	IN VARCHAR2,
26 				    p_flex_code 	IN VARCHAR,
27 				    p_parameter 	IN VARCHAR2,
28 				    p_datatype 		IN VARCHAR2,
29 				    p_business_group_id IN NUMBER,
30 				    p_appl_column_name 	OUT NOCOPY VARCHAR2,
31 				    p_dff_col_name 	OUT NOCOPY VARCHAR2,
32 				    p_flex_val_set_id 	OUT NOCOPY NUMBER);
33 
34 END psp_auto_dyn; -- End package