[Home] [Help]
PACKAGE: APPS.BSC_CUSTOM_VIEW_PVT
Source
1 PACKAGE BSC_CUSTOM_VIEW_PVT as
2 /* $Header: BSCCVDVS.pls 120.0 2005/06/01 15:43:02 appldev noship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCCVDBS.pls |
10 | |
11 | Creation Date: |
12 | October 22, 200 |
13 | |
14 | Creator: |
15 | ashankar |
16 | |
17 | Description: |
18 | Public specs for package. |
19 | |
20 +======================================================================================+
21 */
22
23 FUNCTION Is_More
24 ( p_cust_Views IN OUT NOCOPY VARCHAR2
25 , p_cust_View OUT NOCOPY VARCHAR2
26 ) RETURN BOOLEAN;
27
28
29 FUNCTION get_enabled_flag_for_View
30 (
31 p_tab_id IN NUMBER
32 ,p_tab_view_id IN NUMBER
33 ) RETURN NUMBER;
34
35 FUNCTION get_Tab_Default_View
36 (
37 p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
38 )RETURN NUMBER;
39
40 FUNCTION Validate_Tab_View
41 (
42 p_tab_id IN NUMBER
43 ,p_tab_view_id IN NUMBER
44 ) RETURN NUMBER;
45
46 /*********************************************************************************
47 Retrieve tab information
48 *********************************************************************************/
49
50 PROCEDURE Retrieve_Tab
51 (
52 p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
53 ,x_Tab_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ) ;
58
59 /*********************************************************************************
60 Retrieve tab view information
61 *********************************************************************************/
62
63 PROCEDURE Retrieve_Tab_View
64 (
65 p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
66 ,x_Tab_View_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_msg_count OUT NOCOPY NUMBER
69 ,x_msg_data OUT NOCOPY VARCHAR2
70 );
71
72 /*********************************************************************************
73 Update Tab View
74 *********************************************************************************/
75
76
77 PROCEDURE Update_Tab_View
78 (
79 p_commit IN VARCHAR2 := FND_API.G_FALSE
80 ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84
85 );
86
87 /*********************************************************************************
88 Update Tab default View
89 *********************************************************************************/
90
91
92 PROCEDURE Update_Tab_default_View
93 (
94 p_commit IN VARCHAR2 := FND_API.G_FALSE
95 ,p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_msg_count OUT NOCOPY NUMBER
98 ,x_msg_data OUT NOCOPY VARCHAR2
99
100 );
101
102
103 /*********************************************************************************
104 DELETE CUSTOM VIEW
105 *********************************************************************************/
106 PROCEDURE delete_Custom_View
107 (
108 p_commit IN VARCHAR2 := FND_API.G_FALSE
109 ,p_CustView_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 ) ;
114 /*********************************************************************************
115 ASSIGN_UNASSIGN CUSTOM VIEW
116 *********************************************************************************/
117
118 PROCEDURE Assign_Unassign_Views
119 (
120 p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_tab_id IN NUMBER
122 ,p_default_value IN NUMBER
123 ,p_assign_views IN VARCHAR2
124 ,p_unassign_views IN VARCHAR2
125 ,x_return_status OUT NOCOPY VARCHAR2
126 ,x_msg_count OUT NOCOPY NUMBER
127 ,x_msg_data OUT NOCOPY VARCHAR2
128
129 );
130
131 /*********************************************************************************
132 UNASSIGN CUSTOM VIEW
133 *********************************************************************************/
134
135 PROCEDURE Unassign_Cust_Views
136 (
137 p_commit IN VARCHAR2 := FND_API.G_FALSE
138 ,p_tab_id IN NUMBER
139 ,p_unassign_views IN VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143
144 );
145
146 /*********************************************************************************
147 ASSIGN CUSTOM VIEW
148 *********************************************************************************/
149 PROCEDURE Assign_Cust_Views
150 (
151 p_commit IN VARCHAR2 := FND_API.G_FALSE
152 ,p_tab_id IN NUMBER
153 ,p_assign_views IN VARCHAR2
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_msg_count OUT NOCOPY NUMBER
156 ,x_msg_data OUT NOCOPY VARCHAR2
157
158 );
159
160 /*********************************************************************************
161 CREATE TAB VIEW
162 *********************************************************************************/
163 PROCEDURE Create_Tab_View
164 (
165 p_commit IN VARCHAR2 := FND_API.G_FALSE
166 ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
167 ,x_return_status OUT NOCOPY VARCHAR2
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172
173 /********************************************************************************
174 DELETE CUSTOM VIEW LINKS
175 /*******************************************************************************/
176
177 PROCEDURE Delete_Custom_View_Links
178 (
179 p_commit IN VARCHAR2 := FND_API.G_FALSE
180 , p_tab_id IN NUMBER
181 , p_obj_id IN NUMBER
182 , x_return_status OUT NOCOPY VARCHAR2
183 , x_msg_count OUT NOCOPY NUMBER
184 , x_msg_data OUT NOCOPY VARCHAR2
185 );
186
187
188 END BSC_CUSTOM_VIEW_PVT;