[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