1 PACKAGE AHL_LTP_SPACE_ASSIGN_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSANS.pls 120.0.12020000.2 2012/12/07 14:36:20 sareepar ship $ */
3 --
4 ---------------------------------------------------------------------
5 -- Define Record Types for record structures needed by the APIs --
6 ---------------------------------------------------------------------
7
8 TYPE Space_Assignment_Rec IS RECORD (
9 SPACE_ASSIGNMENT_ID NUMBER ,
10 LAST_UPDATE_DATE DATE ,
11 LAST_UPDATED_BY NUMBER ,
12 CREATION_DATE DATE ,
13 CREATED_BY NUMBER ,
14 LAST_UPDATE_LOGIN NUMBER ,
15 VISIT_ID NUMBER ,
16 VISIT_NUMBER NUMBER ,
17 SPACE_NAME VARCHAR2(30) ,
18 SPACE_ID NUMBER ,
19 OBJECT_VERSION_NUMBER NUMBER ,
20 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
21 ATTRIBUTE1 VARCHAR2(150) ,
22 ATTRIBUTE2 VARCHAR2(150) ,
23 ATTRIBUTE3 VARCHAR2(150) ,
24 ATTRIBUTE4 VARCHAR2(150) ,
25 ATTRIBUTE5 VARCHAR2(150) ,
26 ATTRIBUTE6 VARCHAR2(150) ,
27 ATTRIBUTE7 VARCHAR2(150) ,
28 ATTRIBUTE8 VARCHAR2(150) ,
29 ATTRIBUTE9 VARCHAR2(150) ,
30 ATTRIBUTE10 VARCHAR2(150) ,
31 ATTRIBUTE11 VARCHAR2(150) ,
32 ATTRIBUTE12 VARCHAR2(150) ,
33 ATTRIBUTE13 VARCHAR2(150) ,
34 ATTRIBUTE14 VARCHAR2(150) ,
35 ATTRIBUTE15 VARCHAR2(150) ,
36 OPERATION_FLAG VARCHAR2(1) ,
37 START_FROM DATE , -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
38 END_TO DATE -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011
39 );
40
41 ------------------------
42 -- Declare Procedures --
43 ------------------------
44
45 -- Start of Comments --
46 -- Procedure name : Create_Space_Assignment
47 -- Type : Private
48 -- Function : Creates space assignments for a visit
49 -- Pre-reqs :
50 -- Parameters :
51 --
52 -- Standard IN Parameters :
53 -- p_api_version IN NUMBER Required
54 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
55 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
56 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57 -- Based on this flag, the API will set the default attributes.
58 -- p_module_type In VARCHAR2 Default NULL
59 -- This will be null.
60 -- Standard OUT Parameters :
61 -- x_return_status OUT VARCHAR2 Required
62 -- x_msg_count OUT NUMBER Required
63 -- x_msg_data OUT VARCHAR2 Required
64 --
65 -- Create_Space_Assignment Parameters :
66 -- p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
67 -- List of space assignemnts for a visit
68 --
69
70 PROCEDURE Create_Space_Assignment (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
73 p_commit IN VARCHAR2 := FND_API.g_false,
74 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
75 p_module_type IN VARCHAR2 := 'JSP',
76 p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
77 p_reschedule_flag IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 -- Start of Comments --
84 -- Procedure name : Update_Space_Assignment
85 -- Type : Private
86 -- Function : Update space assignments for a visit
87 -- Pre-reqs :
88 -- Parameters :
89 --
90 -- Standard IN Parameters :
91 -- p_api_version IN NUMBER Required
92 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
93 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
94 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
95 -- Based on this flag, the API will set the default attributes.
96 -- p_module_type In VARCHAR2 Default NULL
97 -- This will be null.
98 -- Standard OUT Parameters :
99 -- x_return_status OUT VARCHAR2 Required
100 -- x_msg_count OUT NUMBER Required
101 -- x_msg_data OUT VARCHAR2 Required
102 --
103 -- Update_Space_Assignment Parameters :
104 -- p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
105 -- List of space assignemnts for a visit
106 --
107 PROCEDURE Update_Space_Assignment (
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
110 p_commit IN VARCHAR2 := FND_API.g_false,
111 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112 p_module_type IN VARCHAR2 := 'JSP',
113 p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2
117 );
118
119 -- Start of Comments --
120 -- Procedure name : Delete_Space_Assignment
121 -- Type : Private
122 -- Function : Delete space assignments for a visit
123 -- Pre-reqs :
124 -- Parameters :
125 --
126 -- Standard IN Parameters :
127 -- p_api_version IN NUMBER Required
128 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
129 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
130 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
131 -- Based on this flag, the API will set the default attributes.
132 -- p_module_type In VARCHAR2 Default NULL
133 -- This will be null.
134 -- Standard OUT Parameters :
135 -- x_return_status OUT VARCHAR2 Required
136 -- x_msg_count OUT NUMBER Required
137 -- x_msg_data OUT VARCHAR2 Required
138 --
139 -- Delete_Space_Assignment Parameters :
140 -- p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
141 -- List of space assignemnts for a visit
142 --
143 PROCEDURE Delete_Space_assignment (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
146 p_commit IN VARCHAR2 := FND_API.g_false,
147 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
148 p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2
152
153 );
154
155 -- Start of Comments --
156 -- Procedure name : Schedule_Visit
157 -- Type : Private
158 -- Function : Schedule visit defines Organization , Department , Start_date
159 -- and Schedule designator
160 -- Pre-reqs :
161 -- Parameters :
162 --
163 -- Standard IN Parameters :
164 -- p_api_version IN NUMBER Required
165 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168 -- Based on this flag, the API will set the default attributes.
169 -- p_module_type In VARCHAR2 Default NULL
170 -- This will be null.
171 -- Standard OUT Parameters :
172 -- x_return_status OUT VARCHAR2 Required
173 -- x_msg_count OUT NUMBER Required
174 -- x_msg_data OUT VARCHAR2 Required
175 --
176 -- Schedule_Visit Parameters :
177 -- p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec, Required,
178 -- List of space assignemnts for a visit
179 --
180 PROCEDURE Schedule_Visit (
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183 p_commit IN VARCHAR2 := FND_API.g_false,
184 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185 p_module_type IN VARCHAR2 := 'JSP',
186 p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2
190 );
191
192 -- Start of Comments --
193 -- Procedure name : UnSchedule_Visit
194 -- Type : Private
195 -- Function : UnSchedule visit removes Organization , Department , Start_date
196 -- and Schedule designator. If there are any space assignments should be removed
197 -- as well
198 -- Pre-reqs :
199 -- Parameters :
200 --
201 -- Standard IN Parameters :
202 -- p_api_version IN NUMBER Required
203 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
204 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
205 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
206 -- Based on this flag, the API will set the default attributes.
207 -- p_module_type In VARCHAR2 Default NULL
208 -- This will be null.
209 -- Standard OUT Parameters :
210 -- x_return_status OUT VARCHAR2 Required
211 -- x_msg_count OUT NUMBER Required
212 -- x_msg_data OUT VARCHAR2 Required
213 --
214 -- Schedule_Visit Parameters :
215 -- p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec, Required,
216 -- List of space assignemnts for a visit
217 --
218 PROCEDURE Unschedule_Visit (
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
221 p_commit IN VARCHAR2 := FND_API.g_false,
222 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
223 p_module_type IN VARCHAR2 := 'JSP',
224 p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2
228 );
229
230 -- Start of Comments --
231 -- Procedure name : VALIDATE_SPACES_WITH_VISIT
232 -- Type : Public
233 -- Function : Validates all spaces dates associated to the visit
234 -- Pre-reqs :
235 -- Parameters :
236 --
237 -- Standard IN Parameters :
238 -- p_api_version IN NUMBER Required
239 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242 -- p_module_type In VARCHAR2 Default NULL
243 -- Standard OUT Parameters :
244 -- x_return_status OUT VARCHAR2 Required
245 -- x_msg_count OUT NUMBER Required
246 -- x_msg_data OUT VARCHAR2 Required
247 --
248 -- Schedule_Visit Parameters :
249 -- p_visit_id IN Number Required - visit id on which validation needs to be done
250 --
251 --
252 PROCEDURE VALIDATE_SPACES_WITH_VISIT (
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
255 p_commit IN VARCHAR2 := Fnd_Api.g_false,
256 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
257 p_module_type IN VARCHAR2 := NULL,
258 p_visit_id IN NUMBER,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2
262 );
263
264
265 END AHL_LTP_SPACE_ASSIGN_PVT;