1 PACKAGE AHL_LTP_SPACE_ASSIGN_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSANS.pls 115.8 2003/08/04 16:37:37 ssurapan noship $ */
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 );
38
39 ------------------------
40 -- Declare Procedures --
41 ------------------------
42
43 -- Start of Comments --
44 -- Procedure name : Create_Space_Assignment
45 -- Type : Private
46 -- Function : Creates space assignments for a visit
47 -- Pre-reqs :
48 -- Parameters :
49 --
50 -- Standard IN Parameters :
51 -- p_api_version IN NUMBER Required
52 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
53 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
54 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
55 -- Based on this flag, the API will set the default attributes.
56 -- p_module_type In VARCHAR2 Default NULL
57 -- This will be null.
58 -- Standard OUT Parameters :
59 -- x_return_status OUT VARCHAR2 Required
60 -- x_msg_count OUT NUMBER Required
61 -- x_msg_data OUT VARCHAR2 Required
62 --
63 -- Create_Space_Assignment Parameters :
64 -- p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
65 -- List of space assignemnts for a visit
66 --
67
68 PROCEDURE Create_Space_Assignment (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71 p_commit IN VARCHAR2 := FND_API.g_false,
72 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
73 p_module_type IN VARCHAR2 := 'JSP',
74 p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
75 p_reschedule_flag IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2
79 );
80
81 -- Start of Comments --
82 -- Procedure name : Update_Space_Assignment
83 -- Type : Private
84 -- Function : Update space assignments for a visit
85 -- Pre-reqs :
86 -- Parameters :
87 --
88 -- Standard IN Parameters :
89 -- p_api_version IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
91 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
92 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
93 -- Based on this flag, the API will set the default attributes.
94 -- p_module_type In VARCHAR2 Default NULL
95 -- This will be null.
96 -- Standard OUT Parameters :
97 -- x_return_status OUT VARCHAR2 Required
98 -- x_msg_count OUT NUMBER Required
99 -- x_msg_data OUT VARCHAR2 Required
100 --
101 -- Update_Space_Assignment Parameters :
102 -- p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
103 -- List of space assignemnts for a visit
104 --
105 PROCEDURE Update_Space_Assignment (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108 p_commit IN VARCHAR2 := FND_API.g_false,
109 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110 p_module_type IN VARCHAR2 := 'JSP',
111 p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2
115 );
116
117 -- Start of Comments --
118 -- Procedure name : Delete_Space_Assignment
119 -- Type : Private
120 -- Function : Delete space assignments for a visit
121 -- Pre-reqs :
122 -- Parameters :
123 --
124 -- Standard IN Parameters :
125 -- p_api_version IN NUMBER Required
126 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129 -- Based on this flag, the API will set the default attributes.
130 -- p_module_type In VARCHAR2 Default NULL
131 -- This will be null.
132 -- Standard OUT Parameters :
133 -- x_return_status OUT VARCHAR2 Required
134 -- x_msg_count OUT NUMBER Required
135 -- x_msg_data OUT VARCHAR2 Required
136 --
137 -- Delete_Space_Assignment Parameters :
138 -- p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec, Required
139 -- List of space assignemnts for a visit
140 --
141 PROCEDURE Delete_Space_assignment (
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144 p_commit IN VARCHAR2 := FND_API.g_false,
145 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
146 p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2
150
151 );
152
153 -- Start of Comments --
154 -- Procedure name : Schedule_Visit
155 -- Type : Private
156 -- Function : Schedule visit defines Organization , Department , Start_date
157 -- and Schedule designator
158 -- Pre-reqs :
159 -- Parameters :
160 --
161 -- Standard IN Parameters :
162 -- p_api_version IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
164 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
166 -- Based on this flag, the API will set the default attributes.
167 -- p_module_type In VARCHAR2 Default NULL
168 -- This will be null.
169 -- Standard OUT Parameters :
170 -- x_return_status OUT VARCHAR2 Required
171 -- x_msg_count OUT NUMBER Required
172 -- x_msg_data OUT VARCHAR2 Required
173 --
174 -- Schedule_Visit Parameters :
175 -- p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec, Required,
176 -- List of space assignemnts for a visit
177 --
178 PROCEDURE Schedule_Visit (
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
181 p_commit IN VARCHAR2 := FND_API.g_false,
182 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
183 p_module_type IN VARCHAR2 := 'JSP',
184 p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2
188 );
189
190 -- Start of Comments --
191 -- Procedure name : UnSchedule_Visit
192 -- Type : Private
193 -- Function : UnSchedule visit removes Organization , Department , Start_date
194 -- and Schedule designator. If there are any space assignments should be removed
195 -- as well
196 -- Pre-reqs :
197 -- Parameters :
198 --
199 -- Standard IN Parameters :
200 -- p_api_version IN NUMBER Required
201 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
202 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
203 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
204 -- Based on this flag, the API will set the default attributes.
205 -- p_module_type In VARCHAR2 Default NULL
206 -- This will be null.
207 -- Standard OUT Parameters :
208 -- x_return_status OUT VARCHAR2 Required
209 -- x_msg_count OUT NUMBER Required
210 -- x_msg_data OUT VARCHAR2 Required
211 --
212 -- Schedule_Visit Parameters :
213 -- p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec, Required,
214 -- List of space assignemnts for a visit
215 --
216 PROCEDURE Unschedule_Visit (
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219 p_commit IN VARCHAR2 := FND_API.g_false,
220 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
221 p_module_type IN VARCHAR2 := 'JSP',
222 p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2
226 );
227
228
229 END AHL_LTP_SPACE_ASSIGN_PVT;