[Home] [Help]
PACKAGE: APPS.BIS_PAGE_PUB
Source
1 PACKAGE BIS_PAGE_PUB AUTHID CURRENT_USER AS
2 /* $Header: BISPPGES.pls 120.2 2005/08/11 22:56:02 ashankar noship $ */
3 --- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4 --- All rights reserved.
5 ---
6 ---==========================================================================
7 --- FILENAME
8 ---
9 --- BISPPGES.pls
10 ---
11 --- DESCRIPTION
12 --- Package Specification File for Page transactions
13 ---
14 --- NOTES
15 ---
16 --- HISTORY
17 ---
18 --- 07-Oct-2003 mdamle Created
19 --- 06-Feb-2004 mdamle Remove AK Region Integration
20 --- 18-Jan-2005 rpenneru Enh#4059160- Opening up FA in Designers |
21 --- 13-JUL-2005 akoduri Bug #4368221 Added the function Get_Custom_View_Name|
22 -- 10-AUG-2005 ashankar Bug #4548914 Added a new Function Is_Simulatable_Cust_View |
23 ---===========================================================================
24
25 c_DUMMY_DB_OBJECT CONSTANT VARCHAR2(20) := 'BIS_REGIONS_V';
26 c_ATTRIBUTE_CATEGORY CONSTANT VARCHAR2(8) := 'BisPage';
27 c_RACK_ATTRIBUTE_CODE CONSTANT VARCHAR2(9) := 'BIS_RACK_';
28 c_PORTLET_ATTRIBUTE_CODE CONSTANT VARCHAR2(12) := 'BIS_PORTLET_';
29 c_BIS_APP_ID CONSTANT NUMBER := 191;
30 c_PAGE_LAYOUT CONSTANT VARCHAR2(11) := 'PAGE_LAYOUT';
31 c_ROW_LAYOUT CONSTANT VARCHAR2(10) := 'ROW_LAYOUT';
32 c_HEADER CONSTANT VARCHAR2(6) := 'HEADER';
33 c_MDS_PATH_PRE CONSTANT VARCHAR2(13) := '/oracle/apps/';
34 c_MDS_PATH_POST CONSTANT VARCHAR2(7) := '/pages/';
35
36 c_WEB_HTML_CALL CONSTANT VARCHAR2(64) := 'OA.jsp?akRegionCode=BIS_COMPONENT_PAGE'||'&'||'akRegionApplicationId=191';
37 c_FUNCTION_TYPE CONSTANT VARCHAR2(3) := 'JSP';
38 c_MDS CONSTANT VARCHAR2(3) := 'MDS';
39 c_FND_MENU CONSTANT VARCHAR2(8) := 'FND_MENU';
40 c_SOURCE_TYPE CONSTANT VARCHAR2(10) := 'sourceType';
41 c_PAGE_APP_ID CONSTANT VARCHAR2(9) := 'pageAppId';
42 c_PAGE_NAME CONSTANT VARCHAR2(8) := 'pageName';
43 c_MENU_NAME CONSTANT VARCHAR2(12) := 'migratedMenu';
44 c_APP_MOD CONSTANT VARCHAR2(52) := 'oracle.apps.fnd.framework.server.OAApplicationModule';
45
46 c_SIMULATABLE CONSTANT NUMBER := 1;
47 c_NON_SIMULATABLE CONSTANT NUMBER := 0;
48
49
50 procedure Create_Page_Region(
51 p_internal_name IN VARCHAR2
52 ,p_application_id IN NUMBER
53 ,p_title IN VARCHAR2
54 ,p_page_function_name IN VARCHAR2
55 ,x_page_id OUT NOCOPY NUMBER
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 procedure Update_Page_Region(
62 p_internal_name IN VARCHAR2
63 ,p_application_id IN NUMBER
64 ,p_title IN VARCHAR2
65 ,p_page_id IN NUMBER
66 ,p_new_internal_name IN VARCHAR2
67 ,p_new_application_id IN NUMBER
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 Procedure Delete_Page_Region (
74 p_internal_name IN VARCHAR2
75 ,p_application_id IN NUMBER
76 ,p_page_id IN NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 procedure Create_Rack_Region(
83 p_internal_name IN VARCHAR2
84 ,p_application_id IN NUMBER
85 ,x_return_status OUT NOCOPY VARCHAR2
86 ,x_msg_count OUT NOCOPY NUMBER
87 ,x_msg_data OUT NOCOPY VARCHAR2
88 );
89
90 Procedure Delete_Rack_Region (
91 p_internal_name IN VARCHAR2
92 ,p_application_id IN NUMBER
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 );
97
98 procedure Create_Rack_Item(
99 p_internal_name IN VARCHAR2
100 ,p_application_id IN NUMBER
101 ,p_rack_Num IN NUMBER
102 ,p_display_flag IN VARCHAR2 := 'Y'
103 ,p_rack_region IN VARCHAR2
104 ,p_rack_region_application_id IN NUMBER
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110 Procedure Delete_Rack_Item (
111 p_internal_name IN VARCHAR2
112 ,p_application_id IN NUMBER
113 ,p_rack_Num IN NUMBER
114 ,x_return_status OUT NOCOPY VARCHAR2
115 ,x_msg_count OUT NOCOPY NUMBER
116 ,x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 procedure Create_Portlet_Item(
120 p_internal_name IN VARCHAR2
121 ,p_application_id IN NUMBER
122 ,p_Portlet_Num IN NUMBER
123 ,p_display_flag IN VARCHAR2 := 'Y'
124 ,p_function_name IN VARCHAR2
125 ,p_title IN VARCHAR2
126 ,x_return_status OUT NOCOPY VARCHAR2
127 ,x_msg_count OUT NOCOPY NUMBER
128 ,x_msg_data OUT NOCOPY VARCHAR2
129 );
130
131 Procedure Delete_Rack_Item (
132 p_internal_name IN VARCHAR2
133 ,p_application_id IN NUMBER
134 ,p_portlet_Num IN NUMBER
135 ,x_return_status OUT NOCOPY VARCHAR2
136 ,x_msg_count OUT NOCOPY NUMBER
137 ,x_msg_data OUT NOCOPY VARCHAR2
138 );
139
140 Procedure Delete_Page_Racks (
141 p_internal_name IN VARCHAR2
142 ,p_application_id IN NUMBER
143 ,x_return_status OUT NOCOPY VARCHAR2
144 ,x_msg_count OUT NOCOPY NUMBER
145 ,x_msg_data OUT NOCOPY VARCHAR2
146 );
147
148 Procedure Delete_Region_Items (
149 p_internal_name IN VARCHAR2
150 ,p_application_id IN NUMBER
151 ,x_return_status OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 function getUniqueRegion(
157 p_internal_name IN VARCHAR2
158 ,p_application_id IN NUMBER) return VARCHAR2;
159
160
161 procedure Migrate_Menu_To_MDS(
162 p_internal_name IN VARCHAR2
163 ,p_application_id IN NUMBER
164 ,p_title IN VARCHAR2
165 ,p_page_function_name IN VARCHAR2
166 ,x_return_status OUT NOCOPY VARCHAR2
167 ,x_msg_count OUT NOCOPY NUMBER
168 ,x_msg_data OUT NOCOPY VARCHAR2
169 );
170
171 -- mdamle 02/06/2004 - Remove AK Region Integration
172 procedure Create_Page_Function(
173 p_page_function_name IN VARCHAR2
174 ,p_application_id IN NUMBER
175 ,p_title IN VARCHAR2
176 ,p_page_xml_name IN VARCHAR2 := null
177 ,p_description IN VARCHAR2 := NULL
178 ,x_page_id OUT NOCOPY NUMBER
179 ,x_return_status OUT NOCOPY VARCHAR2
180 ,x_msg_count OUT NOCOPY NUMBER
181 ,x_msg_data OUT NOCOPY VARCHAR2
182 );
183
184 -- mdamle 02/06/2004 - Remove AK Region Integration
185 procedure Update_Page_Function(
186 p_page_function_name IN VARCHAR2
187 ,p_application_id IN NUMBER
188 ,p_title IN VARCHAR2
189 ,p_page_xml_name IN VARCHAR2 := null
190 ,p_new_page_function_name IN VARCHAR2
191 ,p_new_application_id IN NUMBER
192 ,p_new_page_xml_name IN VARCHAR2 := null
193 ,p_description IN VARCHAR2 := NULL
194 ,x_return_status OUT NOCOPY VARCHAR2
195 ,x_msg_count OUT NOCOPY NUMBER
196 ,x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199 FUNCTION Get_Custom_View_Name(
200 p_Function_Id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE
201 )RETURN VARCHAR2;
202
203
204
205 FUNCTION Is_Simulatable_Cust_View
206 (
207 p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE
208 ) RETURN NUMBER;
209
210 end BIS_PAGE_PUB;
211