PACKAGE: APPS.QPR_DASHBOARD_UTIL

Source

1 PACKAGE QPR_DASHBOARD_UTIL AS
2 /* $Header: QPRPDSBS.pls 120.0 2007/10/11 13:11:22 agbennet noship $  */
3 TYPE  DashboardDetailsRec is RECORD
4 (  dashboard_detail_id  NUMBER
5 ,  row_number    NUMBER
6 ,  column_number    NUMBER
7 ,  content_id    NUMBER
8 ,  width         NUMBER
9 );
10 
11 
12 TYPE DashboardDetailsTab is TABLE of DashboardDetailsRec INDEX by BINARY_INTEGER;
13 
14 
15 PROCEDURE Create_Dashboard_Default
16 (  p_user_id              IN   NUMBER
17   ,p_plan_id              IN   NUMBER
18   ,x_return_status        OUT   NOCOPY  VARCHAR2
19 );
20 
21 PROCEDURE  Populate_Dashboard_Details
22 (  p_user_id              IN     NUMBER
23   ,p_plan_id              IN     NUMBER
24   ,p_dashboard_id         IN     NUMBER
25   ,n_dashboard_id         IN     NUMBER
26   ,p_dsb_table            OUT   NOCOPY  DashboardDetailsTab
27   ,x_return_status        OUT   NOCOPY   VARCHAR2
28 );
29 
30 
31 PROCEDURE Generate_Default_Rows
32 (  p_dashboard_name       IN   VARCHAR2
33   ,p_source_template_id   IN   NUMBER
34   ,p_dashboard_id         IN   NUMBER
35   ,p_source_lang          IN   VARCHAR2
36   ,p_dsb_table            IN   DashboardDetailsTab
37   ,x_return_status        OUT  NOCOPY  VARCHAR2
38 );
39 
40 
41 PROCEDURE Delete_Dashboards
42 (
43   p_price_plan_id        IN    NUMBER
44  ,x_return_status        OUT   NOCOPY VARCHAR2
45 );
46 
47 END QPR_DASHBOARD_UTIL;