[Home] [Help]
PACKAGE: APPS.BIS_TREND_PLUG
Source
1 package bis_trend_plug AUTHID CURRENT_USER as
2 /* $Header: BISTRNDS.pls 120.1 2006/02/02 02:08:02 nbarik noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.49=120.1):~PROD:~PATH:~FILE
5
6 PROCEDURE get_graph_from_url
7 (p_trend_type IN VARCHAR2
8 , p_report_Fn_URL IN VARCHAR2
9 , x_img_html OUT NOCOPY VARCHAR2
10 );
11
12 procedure Show(p_session_id pls_integer default NULL,
13 p_plug_id pls_integer default NULL,
14 p_display_name varchar2 default NULL,
15 p_delete varchar2 default 'N');
16
17 procedure setTableStyles;
18
19 procedure view_report_from_portlet(pRegionCode in varchar2,
20 pFunctionName in varchar2,
21 pScheduleId in number,
22 pPageId IN VARCHAR2 DEFAULT NULL,
23 --Bug Fix 2997706
24 pObjectType IN VARCHAR2 DEFAULT NULL,
25 pResponsibilityId IN VARCHAR2 DEFAULT NULL);
26
27 procedure showPortletStatus(p_report_available number, last_upd date);
28
29 -- mdamle 10/30/01 - Converted plsql customize page to jsp
30 -- Enh#3690747: Portlet Personalization -ansingh
31 procedure customizePortlet ( pResponsibilityId IN VARCHAR2 default NULL
32 ,pSessionId IN VARCHAR2 default NULL
33 ,Region_Code IN VARCHAR2 default NULL
34 ,Function_Name IN VARCHAR2 default NULL
35 ,pUserId IN VARCHAR2 default NULL
36 ,pPlugId IN VARCHAR2 default NULL
37 ,pScheduleId IN VARCHAR2 default NULL
38 ,pFileId IN VARCHAR2 default NULL
39 ,pScheduleOverride IN varchar2 default 'N'
40 ,pShowPortletSettings IN VARCHAR2 DEFAULT NULL
41 ,pMsrId IN VARCHAR2 DEFAULT NULL
42 ,pComponentType IN VARCHAR2 DEFAULT NULL
43 ,pIsPrintable IN VARCHAR2 DEFAULT NULL
44 ,pReturnURL IN VARCHAR2 DEFAULT NULL
45 );
46
47
48 PROCEDURE initialiseRLPortlet (
49 pUserID IN NUMBER,
50 pReferencePath IN VARCHAR2,
51 x_plug_id OUT NOCOPY NUMBER
52 ) ;
53
54 procedure invokeBISRunFunction
55 (function_id in number
56 ,pFunctionName in VARCHAR2
57 ,pWebHtmlCall IN VARCHAR2
58 ,user_id in varchar2 default null
59 ,responsibility_id in varchar2 default null
60 ,responsibility_app_id in varchar2 default null
61 ,session_id in varchar2 default null
62 ,sec_grp_id in varchar2 default null
63 -- jprabhud 03/04/2003 - Refresh Portal Page
64 ,pSourcePageId in number default -1
65 ,pParameters IN VARCHAR2 DEFAULT NULL
66
67 );
68 procedure invokeRFFunction
69 (function_id in number
70 ,user_id in varchar2 default null
71 ,responsibility_id in varchar2 default null
72 ,responsibility_App_id in varchar2 default null
73 ,session_id in varchar2 default null
74 -- mdamle 10/29/2002 Bug#2560743 - Use previous page parameters for linked page
75 ,sec_grp_id in varchar2 default null
76 -- jprabhud 03/04/2003 - Refresh Portal Page
77 ,pSourcePageId in number default -1
78 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
79 ,pDrillDefaultParameters IN VARCHAR2 DEFAULT NULL
80 );
81
82 PROCEDURE checkUsercustomizeRLPortlet (
83 pUserId In NUMBER,
84 pPlugId IN NUMBER,
85 xCustomised OUT NOCOPY NUMBER
86 );
87
88
89 -- mdamle 11/1/2002 - Bug#2649477 - Support for ICX Patch
90 procedure getRespInfo( pUserId in number
91 , pRespId in number
92 , pRespAppId out NOCOPY number
93 , pSecGrpId out NOCOPY number);
94
95 -- mdamle 11/1/2002 - Bug#2649477 - Support for ICX Patch
96 function getFunctionId (pFunctionName varchar2) return number;
97
98 PROCEDURE processLinkedPage(
99 pSourcePageId in varchar2
100 ,pDestFunctionId in number
101 ,pSessionId IN VARCHAR2
102 ,pUserId IN NUMBER
103 ,xParamRegionCode OUT NOCOPY VARCHAR2
104 ,xParamFunctionName OUT NOCOPY VARCHAR2
105 , xParamGroup OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_group_tbl_type
106 , xSourcePageId OUT NOCOPY NUMBER
107 , xDestPageId OUT NOCOPY NUMBER
108 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
109 , x_DrillDefaultParameters OUT NOCOPY VARCHAR2
110 ) ;
111 -- mdamle 10/31/2002 - Bug#2560743 - Use previous page parameters for linked page
112 --jprabhud 11/13/03 - Bug 3253597
113 procedure launchLinkedPage( pSourcePageId in varchar2 --number
114 ,pDestFunctionId in number
115 ,pRespId in varchar2 default null
116 ,pRespAppId in varchar2 default null
117 ,pSecGrpId in varchar2 default null);
118
119 -- jprabhud 03/04/2003 - Refresh Portal Page
120 function getFunctionName (pFunctionId number) return varchar2;
121
122 -- gsanap 4/14/2003 - added this to get user_function_name if prompt is null
123 function getUserFunctionName (pFunctionId number) return varchar2;
124
125 PROCEDURE processPageFromReport(
126 pFunctionName In VARCHAR2
127 ,pDestFunctionId IN NUMBER
128 ,pSessionId IN VARCHAR2
129 ,pUserId IN NUMBER
130 , xDestPageID OUT NOCOPY NUMBER
131 , xParamRegionCode OUT NOCOPY VARCHAR2
132 , xParamFunctionName OUT NOCOPY VARCHAR2
133 ,xParamGroup OUT NOCOPY BIS_PMV_PARAMETERS_PVT.parameter_group_tbl_type
134 -- nbarik - 04/20/04 - Enhancement 3378782 - Parameter Validation
135 ,x_DrillDefaultParameters OUT NOCOPY VARCHAR2
136 ,x_return_status OUT NOCOPY varchar2
137 ,x_msg_count OUT NOCOPY number
138 ,x_msg_data OUT NOCOPY varchar2
139 );
140
141 PROCEDURE launchPageFromReport(
142 pFunctionName IN VARCHAR2
143 ,pDestFunctionId in number
144 ,pRespId in varchar2 default null
145 ,pRespAppId in varchar2 default null
146 ,pSecGrpId in varchar2 default null
147 ) ;
148
149 PROCEDURE checkAndSetRL (
150 pUserId IN VARCHAR2,
151 pPlugId IN VARCHAR2,
152 pFunctionName IN VARCHAR2
153 ) ;
154
155 end bis_trend_plug;