PACKAGE: APPS.BSC_PORTLET_UTIL

Source

1 PACKAGE bsc_portlet_util AS
2 /* $Header: BSCPUTLS.pls 120.0 2005/06/01 14:37:58 appldev noship $ */
3 
4 CODE_RET_SUCCESS CONSTANT NUMBER := 0;
5 CODE_RET_ERROR CONSTANT NUMBER := -1;
6 CODE_RET_SESSION_EXP CONSTANT NUMBER := -2;
7 CODE_RET_NOROW CONSTANT NUMBER := -3;
8 
9 
10 VALUE_NOT_SET CONSTANT NUMBER := -1923;
11 
12 
13 PR_KCODE      CONSTANT VARCHAR2(20) := 'sKCode';
14 PR_TABCODE    CONSTANT VARCHAR2(20) := 'sTabCode';
15 PR_PORLETNAME CONSTANT VARCHAR2(20) := 'portletName';
16 PR_RESPID CONSTANT VARCHAR2(20) := 'responsibilityId';
17 
18 -- message names ------
19 MSGNM_UPDATE_ERR CONSTANT VARCHAR2(30) := 'BSC_PKGRAPH_UPD_ERR';
20 MSGNM_SESSION_EXP CONSTANT VARCHAR2(30) := 'BSC_SESSION_EXPIRE';
21 
22 
23 -- message texts ------
24 MSGTXT_SUCCESS CONSTANT VARCHAR2(30) := 'SUCCESS';
25 MSGTXT_NOROW CONSTANT VARCHAR2(30) := 'Row not found.';
26 MSGTXT_SESSION_EXP CONSTANT VARCHAR2(30) := 'You session has expired.';
27 
28 FUNCTION get_jsp_server RETURN VARCHAR2;
29 FUNCTION get_webdb_host RETURN VARCHAR2;
30 FUNCTION get_webdb_port RETURN VARCHAR2;
31 
32 FUNCTION get_bsc_url(
33     p_session_id IN NUMBER,
34     p_plug_id IN NUMBER,
35     p_jsp_name IN VARCHAR2,
36     p_ext_params IN VARCHAR2,
37     p_is_respid_used IN BOOLEAN
38 ) RETURN VARCHAR2;
39 
40 
41 
42 FUNCTION get_bsc_jsp_path RETURN VARCHAR2;
43 
44 
45 PROCEDURE gotoMainMenu(
46     p_cookie_value IN VARCHAR2,
47     p_encrypted_plug_id IN VARCHAR2);
48 
49 
50 PROCEDURE update_portlet_name(
51     p_user_id IN NUMBER,
52     p_plug_id      IN pls_integer,
53     p_display_name IN VARCHAR2
54  );
55 
56 
57 
58 
59 PROCEDURE decrypt_plug_info(
60     p_cookie_value IN VARCHAR2,
61     p_encrypted_plug_id IN VARCHAR2,
62     p_session_id OUT NOCOPY NUMBER,
63     p_plug_id OUT NOCOPY NUMBER);
64 
65 
66 
67 
68 FUNCTION request_html_pieces(
69     p_url     IN VARCHAR2,
70     p_proxy   IN VARCHAR2 DEFAULT NULL
71 ) RETURN utl_http.html_pieces;
72 
73 
74 
75 
76 FUNCTION re_align_html_pieces(
77     src       IN utl_http.html_pieces
78 ) RETURN utl_http.html_pieces;
79 
80 
81 
82 PROCEDURE test_https(
83     url       IN VARCHAR2
84 );
85 
86 
87 
88 --==========================================================================
89 
90 FUNCTION getValue(
91   p_key        IN VARCHAR2
92  ,p_parameters IN VARCHAR2
93  ,p_delimiter  IN VARCHAR2 := '&'
94 ) RETURN VARCHAR2;
95 
96 
97 END bsc_portlet_util;