PACKAGE: APPS.BSC_PORTLET_GRAPH

Source

1 PACKAGE bsc_portlet_graph AUTHID CURRENT_USER AS
2 /* $Header: BSCPGHS.pls 115.8 2003/02/12 14:26:35 adrao ship $ */
3 
4 
5 PROCEDURE plug(
6     p_session_id   IN pls_integer,
7     p_plug_id      IN pls_integer,
8     p_display_name IN VARCHAR2 default null,
9     p_delete       IN VARCHAR2 default 'N');
10 
11 
12 PROCEDURE show_err(
13 	p_ctm_url IN VARCHAR2,
14  	l_ask IN VARCHAR2,
15 	p_display_name IN VARCHAR2 DEFAULT NULL);
16 
17 FUNCTION has_access(p_plug_id IN NUMBER) RETURN BOOLEAN;
18 
19 FUNCTION re_align_html_pieces(src IN utl_http.html_pieces) RETURN
20   utl_http.html_pieces;
21 
22 PROCEDURE draw_kpi_graph(
23     p_ctm_url      IN VARCHAR2,
24     p_target_url   IN VARCHAR2,
25     p_session_id   IN pls_integer,
26     p_plug_id      IN pls_integer,
27     p_display_name IN VARCHAR2 DEFAULT NULL);
28 
29 
30 
31 
32 
33 PROCEDURE launch_bsckpi_jsp(
34     p_session_id IN pls_integer,
35     p_plug_id    IN pls_integer);
36 
37 
38 
39 FUNCTION get_tab_url(
40     p_cookie_value IN VARCHAR2,
41     p_encrypted_plug_id IN VARCHAR2
42 ) RETURN VARCHAR2;
43 
44 
45 FUNCTION get_kpi_url(
46     p_cookie_value IN VARCHAR2,
47     p_encrypted_plug_id IN VARCHAR2
48 ) RETURN VARCHAR2;
49 
50 
51 
52 FUNCTION get_tab_url(
53     p_session_id IN NUMBER,
54     p_plug_id    IN NUMBER
55 ) RETURN VARCHAR2;
56 
57 
58 FUNCTION get_kpi_url(
59     p_session_id IN NUMBER,
60     p_plug_id    IN NUMBER) RETURN VARCHAR2;
61 
62 
63 FUNCTION get_pluginfo_params(
64     p_resp_id IN NUMBER,
65     p_session_id IN NUMBER,
66     p_plug_id    IN NUMBER
67 ) RETURN VARCHAR2;
68 
69 
70 
71 FUNCTION get_portlet_kpigraph_url(
72     p_session_id IN pls_integer,
73     p_plug_id IN pls_integer,
74     p_tab_id IN NUMBER,
75     p_kpi_id IN NUMBER,
76     p_resp_id IN NUMBER) RETURN VARCHAR2;
77 
78 
79 
80 
81 FUNCTION get_customized_kpigraph_url(
82     p_session_id IN pls_integer,
83     p_plug_id IN pls_integer,
84     p_tab_id IN NUMBER,
85     p_kpi_id IN NUMBER,
86     p_is_never_customized IN BOOLEAN,
87     p_resp_id IN NUMBER,
88     p_display_name IN VARCHAR2) RETURN VARCHAR2;
89 
90 
91 
92 
93 
94 PROCEDURE get_customized_data_private(
95     p_session_id IN pls_integer,
96     p_plug_id    IN pls_integer,
97     p_o_resp_id   OUT NOCOPY NUMBER,
98     p_o_tab_id   OUT NOCOPY NUMBER,
99     p_o_kpi_id   OUT NOCOPY NUMBER);
100 
101 
102 
103 
104 
105 FUNCTION set_customized_data_private(
106     p_user_id IN NUMBER,
107     p_plug_id IN NUMBER,
108     p_resp_id IN NUMBER,
109     p_kpi_id IN NUMBER,
110     p_createy_by IN NUMBER,
111     p_last_updated_by IN NUMBER,
112     p_porlet_name IN VARCHAR2,
113     p_o_ret_status OUT NOCOPY NUMBER) RETURN VARCHAR2;
114 
115 
116 
117 FUNCTION get_customization(
118     p_cookie_value IN VARCHAR2,
119     p_encrypted_plug_id IN VARCHAR2,
120     p_resp_id OUT NOCOPY NUMBER,
121     p_tab_id OUT NOCOPY NUMBER,
122     p_kpi_id OUT NOCOPY NUMBER,
123     p_display_name OUT NOCOPY VARCHAR2,
124     p_has_access OUT NOCOPY NUMBER) RETURN NUMBER;
125 
126 
127 
128 
129 FUNCTION set_customization(
130     p_cookie_value IN VARCHAR2,
131     p_encrypted_plug_id IN VARCHAR2,
132     p_resp_id IN NUMBER,
133     p_kpi_id IN NUMBER,
134     p_portlet_name IN VARCHAR2,
135     p_o_ret_status OUT NOCOPY NUMBER) RETURN VARCHAR2;
136 
137 
138 
139 
140 FUNCTION get_graph_image(
141     p_resp_id IN NUMBER,
142     p_kpi_id IN NUMBER,
143     p_graph_key IN VARCHAR2,
144     p_fbody OUT NOCOPY BLOB,
145     p_o_ret_status OUT NOCOPY NUMBER) RETURN VARCHAR2;
146 
147 
148 
149 FUNCTION save_graphkey(
150     p_user_id IN NUMBER,
151     p_resp_id IN NUMBER,
152     p_kpi_id IN NUMBER,
153     p_graph_key IN VARCHAR2,
154     p_img_id OUT NOCOPY NUMBER,
155     p_o_ret_status OUT NOCOPY NUMBER) RETURN VARCHAR2;
156 --    p_fbody OUT NOCOPY BLOB,
157 
158 END bsc_portlet_graph;