PACKAGE: APPS.BIS_PMV_PARAMETERS_PUB

Source

1 package BIS_PMV_PARAMETERS_PUB AUTHID CURRENT_USER as
2 /* $Header: BISPPARS.pls 120.3 2006/05/11 10:05:07 nbarik noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.6=120.3):~PROD:~PATH:~FILE
5 
6 SQL_STRING VARCHAR2(200) := 'SQL';
7 VIEW_BY_VALUE VARCHAR2(200) := 'VIEW_BY_VALUE';
8 INTEGER_BIND    NUMBER := 1;
9 VARCHAR2_BIND   NUMBER := 2;
10 DATE_BIND       NUMBER := 3;
11 NUMERIC_BIND    NUMBER := 4;
12 CHARACTER_BIND  NUMBER := 5;
13 MESSAGE_BIND    NUMBER := 6;
14 
15 BIND_TYPE            NUMBER :=1;
16 SQL_STRING_TYPE      NUMBER :=2;
17 VIEW_BY_TYPE         NUMBER :=3;
18 
19 TYPE page_session_rec_type IS RECORD
20 (user_id                VARCHAR2(32000)
21 ,page_id                VARCHAR2(32000)
22 ,session_id             VARCHAR2(32000)
23 ,responsibility_id      VARCHAR2(32000)
24 );
25 
26 TYPE parameter_rec_type IS RECORD
27 (parameter_name	        VARCHAR2(32000)
28 ,parameter_label        VARCHAR2(32000)
29 ,parameter_value        VARCHAR2(32000)
30 ,parameter_description  VARCHAR2(32000)
31 ,operator               VARCHAR2(32000)
32 ,dimension              VARCHAR2(32000)
33 ,period_date            DATE
34 ,required_flag          VARCHAR2(1)
35 ,default_flag           VARCHAR2(1)
36 ,hierarchy_flag         VARCHAR2(1)
37 );
38 TYPE parameter_tbl_type IS TABLE OF parameter_rec_type INDEX BY
39 BINARY_INTEGER;
40 
41 PROCEDURE RETRIEVE_PAGE_PARAMETER
42 (p_page_session_rec     IN  BIS_PMV_PARAMETERS_PUB.page_session_rec_type
43 ,p_parameter_rec	IN  OUT NOCOPY BIS_PMV_PARAMETERS_PUB.parameter_rec_type
44 ,x_return_status	OUT NOCOPY VARCHAR2
45 ,x_msg_count		OUT NOCOPY NUMBER
46 ,x_msg_data	        OUT NOCOPY VARCHAR2
47 );
48 
49 PROCEDURE RETRIEVE_PAGE_PARAMETERS
50 (p_page_session_rec     IN  BIS_PMV_PARAMETERS_PUB.page_session_rec_type
51 ,x_page_param_tbl	OUT NOCOPY BIS_PMV_PARAMETERS_PUB.parameter_tbl_type
52 ,x_return_status	OUT NOCOPY VARCHAR2
53 ,x_msg_count		OUT NOCOPY NUMBER
54 ,x_msg_data		OUT NOCOPY VARCHAR2
55 );
56 FUNCTION INITIALIZE_QUERY_TYPE
57 
58 RETURN BIS_QUERY_ATTRIBUTES;
59 
60 /* nbarik - 05/11/06 - Bug Fix 4881596
61 --
62 -- This is a public API which will be called by product teams to clear
63 -- user level personalization
64 --
65 */
66 PROCEDURE CLEAR_USER_PERSONALIZATION (
67 	p_function_name			IN  VARCHAR2
68 ,	p_region_code           IN  VARCHAR2
69 , 	p_region_application_id IN 	NUMBER
70 ,	x_return_status	    	OUT NOCOPY VARCHAR2
71 ,	x_msg_count		    	OUT NOCOPY NUMBER
72 ,	x_msg_data	        	OUT NOCOPY VARCHAR2
73 );
74 
75 FUNCTION INITIALIZE_BIS_BUCKET_REC RETURN BIS_BUCKET_REC;
76 END BIS_PMV_PARAMETERS_PUB;