[Home] [Help]
PACKAGE: APPS.AHL_LTP_SPACE_CAPB_PVT
Source
1 PACKAGE AHL_LTP_SPACE_CAPB_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSPCS.pls 115.6 2002/12/04 19:11:28 ssurapan noship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AHL_LTP_SPACE_CAPB_PVT
7 --
8 -- PURPOSE
9 -- This package is a Private API for managing Space and space Capabilities information in
10 -- Advanced Services Online. It contains specification for pl/sql records and tables
11 --
12 -- AHL_SPACE_VL And AHL_SPACE_CAPABILITIES:
13 -- Create_Space (see below for specification)
14 -- Update_Space (see below for specification)
15 -- Delete_Space (see below for specification)
16 -- Create_Space_Capblts (see below for specification)
17 -- Update_Space_Capblts (see below for specification)
18 -- Delete_Space_Capblts (see below for specification)
19 --
20 --
21 -- NOTES
22 --
23 --
24 -- HISTORY
25 -- 19-Apr-2002 ssurapan Created.
26 -----------------------------------------------------------
27
28 -------------------------------------
29 ----- SPACES And SPACE CAPABILITIES -----
30 -------------------------------------
31 -- Record for AHL_SPACES_VL
32 TYPE Space_Rec IS RECORD (
33 space_id NUMBER,
34 space_name VARCHAR2(30),
35 last_update_date DATE,
36 last_updated_by NUMBER,
37 creation_date DATE,
38 created_by NUMBER,
39 last_update_login NUMBER,
40 object_version_number NUMBER,
41 organization_id NUMBER,
42 org_name VARCHAR2(240),
43 department_id NUMBER,
44 dept_description VARCHAR2(240),
45 space_category_code VARCHAR2(30),
46 space_category_mean VARCHAR2(80),
47 inactive_flag_code VARCHAR2(1),
48 inactive_flag_mean VARCHAR2(30),
49 description VARCHAR2(2000),
50 attribute_category VARCHAR2(30),
51 attribute1 VARCHAR2(150),
52 attribute2 VARCHAR2(150),
53 attribute3 VARCHAR2(150),
54 attribute4 VARCHAR2(150),
55 attribute5 VARCHAR2(150),
56 attribute6 VARCHAR2(150),
57 attribute7 VARCHAR2(150),
58 attribute8 VARCHAR2(150),
59 attribute9 VARCHAR2(150),
60 attribute10 VARCHAR2(150),
61 attribute11 VARCHAR2(150),
62 attribute12 VARCHAR2(150),
63 attribute13 VARCHAR2(150),
64 attribute14 VARCHAR2(150),
65 attribute15 VARCHAR2(150),
66 operation_flag VARCHAR2(1)
67 );
68
69 -- Record for AHL_SPACE_CAPABILITIES
70 TYPE Space_Capbl_Rec IS RECORD (
71 space_capability_id NUMBER,
72 last_update_date DATE,
73 last_updated_by NUMBER,
74 creation_date DATE,
75 created_by NUMBER,
76 last_update_login NUMBER,
77 object_version_number NUMBER,
78 visit_type_code VARCHAR2(30),
79 visit_type_mean VARCHAR2(80),
80 inventory_item_id NUMBER,
81 item_description varchar2(240),
82 organization_id NUMBER,
83 org_name VARCHAR2(240),
84 space_id NUMBER,
85 space_name VARCHAR2(30),
86 attribute_category VARCHAR2(30),
87 attribute1 VARCHAR2(150),
88 attribute2 VARCHAR2(150),
89 attribute3 VARCHAR2(150),
90 attribute4 VARCHAR2(150),
91 attribute5 VARCHAR2(150),
92 attribute6 VARCHAR2(150),
93 attribute7 VARCHAR2(150),
94 attribute8 VARCHAR2(150),
95 attribute9 VARCHAR2(150),
96 attribute10 VARCHAR2(150),
97 attribute11 VARCHAR2(150),
98 attribute12 VARCHAR2(150),
99 attribute13 VARCHAR2(150),
100 attribute14 VARCHAR2(150),
101 attribute15 VARCHAR2(150),
102 operation_flag VARCHAR2(1)
103 );
104
105 --Declare Space table type
106 TYPE space_tbl IS TABLE OF Space_Rec
107 INDEX BY BINARY_INTEGER;
108
109 --Declare Space Capabilities table type
110 TYPE space_Capbl_tbl IS TABLE OF Space_Capbl_Rec
111 INDEX BY BINARY_INTEGER;
112
113 --------------------------------------------------------------------
114 -- PROCEDURE
115 -- Create_Space
116 --
117 -- PURPOSE
118 -- Create Space Record
119 --
120 -- PARAMETERS
121 -- p_x_space_restriction_rec: the record representing AHL_SPACES_VL view..
122 --
123 -- NOTES
124 --------------------------------------------------------------------
125 PROCEDURE Create_Space (
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128 p_commit IN VARCHAR2 := FND_API.g_false,
129 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
130 p_module_type IN VARCHAR2 := 'JSP',
131 p_x_space_rec IN OUT NOCOPY ahl_ltp_space_capb_pub.Space_Rec,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2
135 );
136
137 --------------------------------------------------------------------
138 -- PROCEDURE
139 -- Update_Space
140 --
141 -- PURPOSE
142 -- Update Space Record.
143 --
144 -- PARAMETERS
145 -- p_space_restriction_rec: the record representing AHL_SPACES_VL
146 --
147 -- NOTES
148 --------------------------------------------------------------------
149 PROCEDURE Update_Space (
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152 p_commit IN VARCHAR2 := FND_API.g_false,
153 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
154 p_module_type IN VARCHAR2 := 'JSP',
155 p_space_rec IN ahl_ltp_space_capb_pub.Space_Rec,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2
159 );
160
161 --------------------------------------------------------------------
162 -- PROCEDURE
163 -- Delete_Space
164 --
165 -- PURPOSE
166 -- Delete Space Record.
167 --
168 -- PARAMETERS
169 -- p_space_restriction_rec: the record representing AHL_SPACES_VL
170 --
171 -- ISSUES
172 --
173 -- NOTES
174 -- 1. Raise exception if the object_version_number doesn't match.
175 --------------------------------------------------------------------
176 PROCEDURE Delete_Space (
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
179 p_commit IN VARCHAR2 := FND_API.g_false,
180 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
181 p_space_rec IN ahl_ltp_space_capb_pub.Space_Rec,
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 --------------------------------------------------------------------
189 -- PROCEDURE
190 -- Create_Space_Capblts
191 --
192 -- PURPOSE
193 -- Create Space Capabilities Record
194 --
195 -- PARAMETERS
196 -- p_x_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table..
197 --
198 -- NOTES
199 --------------------------------------------------------------------
200 PROCEDURE Create_Space_Capblts (
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203 p_commit IN VARCHAR2 := FND_API.g_false,
204 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
205 p_module_type IN VARCHAR2 := 'JSP',
206 p_x_space_capblts_rec IN OUT NOCOPY ahl_ltp_space_capb_pub.Space_Capbl_Rec,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2
210 );
211
212 --------------------------------------------------------------------
213 -- PROCEDURE
214 -- Update_Space_Capblts
215 --
216 -- PURPOSE
217 -- Update Space Capblities Record.
218 --
219 -- PARAMETERS
220 -- p_space_capblts_rec: the record representing AHL_SPACE_CAPBLITIES table
221 --
222 -- NOTES
223 --------------------------------------------------------------------
227 p_commit IN VARCHAR2 := FND_API.g_false,
224 PROCEDURE Update_Space_Capblts (
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
228 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
229 p_module_type IN VARCHAR2 := 'JSP',
230 p_space_capblts_rec IN ahl_ltp_space_capb_pub.Space_Capbl_Rec,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2
234 );
235
236 --------------------------------------------------------------------
237 -- PROCEDURE
238 -- Delete_Space_Capblts
239 --
240 -- PURPOSE
241 -- Delete Space Capabilities Record.
242 --
243 -- PARAMETERS
244 -- p_space_capblts_rec: the record representing AHL_SPACE_CAPABILITIES table
245 --
246 -- ISSUES
247 --
248 -- NOTES
249 -- 1. Raise exception if the object_version_number doesn't match.
250 --------------------------------------------------------------------
251 PROCEDURE Delete_Space_Capblts (
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
254 p_commit IN VARCHAR2 := FND_API.g_false,
255 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
256 p_space_capblts_rec IN ahl_ltp_space_capb_pub.Space_Capbl_Rec,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2
260
261 );
262
263 END AHL_LTP_SPACE_CAPB_PVT;