[Home] [Help]
PACKAGE: APPS.BSC_SCORECARD_PVT
Source
1 package BSC_SCORECARD_PVT as
2 /* $Header: BSCVTABS.pls 120.0 2005/06/01 15:46:21 appldev noship $ */
3
4 BSC_ADMIN_ACCESS CONSTANT VARCHAR2(30) :='BSC_SCORECARD_ADMINISTRATOR';
5 BSC_OBJECT_NAME CONSTANT VARCHAR2(10) :='BSC_TAB';
6 BSC_INSTANCE_TYPE CONSTANT VARCHAR2(10) :='INSTANCE';
7 BSC_GRANTEE_TYPE CONSTANT VARCHAR2(5) :='USER';
8 BSC_PROGRAM_NAME CONSTANT VARCHAR2(15) :='BSC_PMD_GRANTS';
9 BSC_VIEWER_ACCESS CONSTANT VARCHAR2(30) :='BSC_SCORECARD_USER';
10 procedure Create_Tab(
11 p_commit IN varchar2 := FND_API.G_FALSE
12 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
13 ,x_return_status OUT NOCOPY varchar2
14 ,x_msg_count OUT NOCOPY number
15 ,x_msg_data OUT NOCOPY varchar2
16 );
17
18 procedure Retrieve_Tab(
19 p_commit IN varchar2 := FND_API.G_FALSE
20 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
21 ,x_Bsc_Tab_Entity_Rec IN OUT NOCOPY BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
22 ,x_return_status OUT NOCOPY varchar2
23 ,x_msg_count OUT NOCOPY number
24 ,x_msg_data OUT NOCOPY varchar2
25 );
26
27 procedure Update_Tab(
28 p_commit IN varchar2 := FND_API.G_FALSE
29 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
30 ,x_return_status OUT NOCOPY varchar2
31 ,x_msg_count OUT NOCOPY number
32 ,x_msg_data OUT NOCOPY varchar2
33 );
34
35 procedure Delete_Tab(
36 p_commit IN varchar2 := FND_API.G_FALSE
37 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
38 ,x_return_status OUT NOCOPY varchar2
39 ,x_msg_count OUT NOCOPY number
40 ,x_msg_data OUT NOCOPY varchar2
41 );
42
43 procedure Create_Tab_Access(
44 p_commit IN varchar2 := FND_API.G_FALSE
45 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
46 ,x_return_status OUT NOCOPY varchar2
47 ,x_msg_count OUT NOCOPY number
48 ,x_msg_data OUT NOCOPY varchar2
49 );
50
51 procedure Move_Tab(
52 p_commit IN varchar2 := FND_API.G_FALSE
53 ,p_tab_id number
54 ,p_tab_index number
55 ,x_return_status OUT NOCOPY varchar2
56 ,x_msg_count OUT NOCOPY number
57 ,x_msg_data OUT NOCOPY varchar2
58 );
59
60 procedure Update_Tab_Time_Stamp(
61 p_commit IN varchar2 := FND_API.G_FALSE
62 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
63 ,x_return_status OUT NOCOPY varchar2
64 ,x_msg_count OUT NOCOPY number
65 ,x_msg_data OUT NOCOPY varchar2
66 );
67
68 procedure Update_System_Time_Stamp(
69 p_commit IN varchar2 := FND_API.G_FALSE
70 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
71 ,x_return_status OUT NOCOPY varchar2
72 ,x_msg_count OUT NOCOPY number
73 ,x_msg_data OUT NOCOPY varchar2
74 );
75
76 function Validate_Tab(
77 p_Tab_Name IN varchar2
78 ) return number;
79
80 function Validate_Kpi_Group(
81 p_Kpi_Group_Name IN varchar2
82 ) return number;
83
84 function Validate_Kpi(
85 p_Kpi_Name IN varchar2
86 ) return number;
87
88 /*************************************************************
89 Added for Scorecard Security Enhancement
90 /************************************************************/
91
92 PROCEDURE Remove_Scorecard_Grants
93 (
94 p_tab_id IN NUMBER
95 );
96
97 PROCEDURE Insert_Scorecard_Grants
98 (
99 p_tab_id IN NUMBER
100 , p_user_name IN VARCHAR2
101 );
102
103 procedure Create_Tab_Grants(
104 p_commit IN varchar2 := FND_API.G_FALSE
105 ,p_Bsc_Tab_Entity_Rec IN BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec
106 ,x_return_status OUT NOCOPY varchar2
107 ,x_msg_count OUT NOCOPY number
108 ,x_msg_data OUT NOCOPY varchar2
109 );
110
111 procedure REVOKE_GRANT
112 ( p_commit IN VARCHAR2
113 , p_api_version IN NUMBER
114 , p_grant_guid IN VARCHAR2
115 , x_success OUT NOCOPY VARCHAR2
116 , x_errorcode OUT NOCOPY NUMBER
117 );
118
119 FUNCTION Is_More
120 ( p_grant_uids IN OUT NOCOPY VARCHAR2
121 , p_grant_uid OUT NOCOPY VARCHAR2
122 ) RETURN BOOLEAN;
123
124 /**************************************************************/
125 end BSC_SCORECARD_PVT;