[Home] [Help]
PACKAGE: APPS.BSC_LAUNCH_PAD_PUB
Source
1 PACKAGE BSC_LAUNCH_PAD_PUB AUTHID CURRENT_USER as
2 /* $Header: BSCCVDEFS.pls 115.4 2004/01/09 14:48:03 ashankar ship $ */
3 /*
4 +======================================================================================+
5 | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +======================================================================================+
8 | FILENAME |
9 | BSCCVDEFS.pls |
10 | |
11 | Creation Date: |
12 | October 22, 2003 |
13 | |
14 | Creator: |
15 | ashankar |
16 | |
17 | Description: |
18 | Public specs for package. |
19 | |
20 +======================================================================================+
21 */
22
23 TYPE Bsc_LauchPad_Rec_Type is RECORD(
24
25 Bsc_menu_id FND_MENUS_VL.menu_id%TYPE
26 ,Bsc_menu_name FND_MENUS_VL.menu_name%TYPE
27 ,Bsc_type FND_MENUS_VL.type%TYPE
28 ,Bsc_last_update_date FND_MENUS_VL.last_update_date%TYPE
29 ,Bsc_last_updated_by FND_MENUS_VL.last_updated_by%TYPE
30 ,Bsc_last_update_login FND_MENUS_VL.last_update_login%TYPE
31 ,Bsc_user_menu_name FND_MENUS_VL.user_menu_name%TYPE
32 ,Bsc_description FND_MENUS_VL.description%TYPE
33 );
34
35 TYPE Bsc_LauchPad_Tbl_Type IS TABLE OF Bsc_LauchPad_Rec_Type
36 INDEX BY BINARY_INTEGER;
37
38 FUNCTION Is_More
39 ( p_fucntion_ids IN OUT NOCOPY VARCHAR2
40 , p_fucntion_id OUT NOCOPY VARCHAR2
41 ) RETURN BOOLEAN;
42
43
44 FUNCTION validate_Menu_UserMenu_Names(
45 p_menu_id IN NUMBER
46 ,p_menu_name IN VARCHAR2
47 ,p_user_menu_name IN VARCHAR2
48 )RETURN VARCHAR2;
49
50
51 FUNCTION validate_Function_Names(
52 p_function_id IN NUMBER
53 ,p_fucntion_name IN VARCHAR2
54 ,p_user_function_name IN VARCHAR2
55 )RETURN VARCHAR2;
56
57
58
59 FUNCTION get_Menu_Id_From_Menu_Name(
60 p_Menu_Name IN FND_MENUS.MENU_NAME%TYPE
61 )RETURN NUMBER;
62
63
64 FUNCTION get_Menu_Name_From_Menu_Id(
65 p_Menu_Id IN FND_MENUS.MENU_ID%TYPE
66 )RETURN VARCHAR2;
67
68
69 SEQ_MULTIPLIER CONSTANT NUMBER :=10;
70
71 /******************************************************************
72 CREATE LAUNCHPAD
73 /******************************************************************/
74 PROCEDURE Create_Launch_Pad
75 (
76 p_commit IN VARCHAR2 := FND_API.G_FALSE
77 ,p_menu_name IN VARCHAR2 := NULL
78 ,p_user_menu_name IN VARCHAR2
79 ,p_menu_type IN VARCHAR2 :='UNKNOWN'
80 ,p_description IN VARCHAR2
81 ,p_fucntion_ids IN VARCHAR2
82 ,p_fucntions_order IN VARCHAR2 := NULL
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ) ;
87
88 /*****************************************************************
89 RETRIEVE LAUNCHPAD
90 /*****************************************************************/
91
92 PROCEDURE Retrieve_Launch_Pad
93 (
94 p_menu_id IN NUMBER
95 ,x_launch_pad_Rec IN OUT NOCOPY BSC_LAUNCH_PAD_PUB.Bsc_LauchPad_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 UPDATE LAUNCHPAD
103 /****************************************************************/
104 PROCEDURE Update_Launch_Pad
105 (
106 p_launch_pad_rec IN BSC_LAUNCH_PAD_PUB.Bsc_LauchPad_Rec_Type
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111
112 /***************************************************************
113 UPDATE LAUNCHPAD CALLED FROM UI
114 /***************************************************************/
115 PROCEDURE Update_Launch_Pad
116 (
117 p_commit IN VARCHAR2 := FND_API.G_FALSE
118 ,p_menu_id IN NUMBER
119 ,p_menu_name IN VARCHAR2 := NULL
120 ,p_user_menu_name IN VARCHAR2
121 ,p_menu_type IN VARCHAR2
122 ,p_description IN VARCHAR2
123 ,p_fucntion_ids IN VARCHAR2
124 ,p_fucntions_order IN VARCHAR2 := NULL
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 DELETE LAUNCHPAD
133 /****************************************************************/
134
135 PROCEDURE Delete_Launch_Pad
136 (
137 p_menu_id IN NUMBER
138 ,x_return_status OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_msg_data OUT NOCOPY VARCHAR2
141 );
142
143
144 /*****************************************************************
145 DELETE LAUNCHPAD LINK ASSOCIATION
146 /****************************************************************/
147 PROCEDURE Delete_MenuFunction_Link
148 (
149 p_menu_id IN NUMBER
150 ,x_return_status OUT NOCOPY VARCHAR2
151 ,x_msg_count OUT NOCOPY NUMBER
152 ,x_msg_data OUT NOCOPY VARCHAR2
153 );
154
155 /*****************************************************************
156 CREATE MENU FUCNTION LINK
157 /*****************************************************************/
158 PROCEDURE Create_MenuFunction_Link
159 (
160
161 p_menu_id IN NUMBER
162 , p_entry_sequence IN NUMBER
163 , p_function_id IN NUMBER
164 , p_description IN VARCHAR2
165 , x_return_status OUT NOCOPY VARCHAR2
166 , x_msg_count OUT NOCOPY NUMBER
167 , x_msg_data OUT NOCOPY VARCHAR2
168
169 );
170
171 /*****************************************************************
172 CREATE LAUNCHPAD
173 /*****************************************************************/
174
175 PROCEDURE Create_Launch_Pad_Link
176 (
177 p_commit IN VARCHAR2 := FND_API.G_FALSE
178 , p_user_function_name IN VARCHAR2
179 , p_url IN VARCHAR2
180 , p_type IN VARCHAR2 :='WWW'
181 , x_function_id OUT NOCOPY FND_FORM_FUNCTIONS.function_id% TYPE
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 DELETE LAUCHPAD LINK
189 /*****************************************************************/
190
191 PROCEDURE Delete_Launch_Pad_Link
192 (
193 p_fucntion_id IN FND_FORM_FUNCTIONS.function_id%TYPE
194 , x_return_status OUT NOCOPY VARCHAR2
195 , x_msg_count OUT NOCOPY NUMBER
196 , x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199 PROCEDURE Update_Launch_Pad_Link
200 (
201 p_commit IN VARCHAR2 := FND_API.G_FALSE
202 , p_user_function_name IN VARCHAR2
203 , p_url IN VARCHAR2
204 , p_type IN VARCHAR2 :='WWW'
205 , p_function_id IN FND_FORM_FUNCTIONS.function_id% TYPE
206 , x_return_status OUT NOCOPY VARCHAR2
207 , x_msg_count OUT NOCOPY NUMBER
208 , x_msg_data OUT NOCOPY VARCHAR2
209 );
210
211 END BSC_LAUNCH_PAD_PUB;