1 PACKAGE AHL_LTP_SPACE_ASSIGN_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPSANS.pls 115.8 2003/06/04 00:25:53 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 TYPE Schedule_Visit_Rec IS RECORD (
40 VISIT_ID NUMBER ,
41 VISIT_NUMBER NUMBER ,
42 LAST_UPDATE_DATE DATE ,
43 LAST_UPDATED_BY NUMBER ,
44 CREATION_DATE DATE ,
45 CREATED_BY NUMBER ,
46 LAST_UPDATE_LOGIN NUMBER ,
47 ORG_ID NUMBER ,
48 ORG_NAME VARCHAR2(240) ,
49 DEPT_ID NUMBER ,
50 DEPT_NAME VARCHAR2(80) ,
51 START_DATE DATE ,
52 START_HOUR NUMBER ,
53 PLANNED_END_DATE DATE ,
54 PLANNED_END_HOUR NUMBER ,
55 VISIT_TYPE_CODE VARCHAR2(30) ,
56 VISIT_TYPE_MEAN VARCHAR2(80) ,
57 SPACE_CATEGORY_CODE VARCHAR2(30) ,
58 SPACE_CATEGORY_MEAN VARCHAR2(80) ,
59 SCHEDULE_DESIGNATOR VARCHAR2(10) ,
60 OBJECT_VERSION_NUMBER NUMBER ,
61 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
62 ATTRIBUTE1 VARCHAR2(150) ,
63 ATTRIBUTE2 VARCHAR2(150) ,
64 ATTRIBUTE3 VARCHAR2(150) ,
65 ATTRIBUTE4 VARCHAR2(150) ,
66 ATTRIBUTE5 VARCHAR2(150) ,
67 ATTRIBUTE6 VARCHAR2(150) ,
68 ATTRIBUTE7 VARCHAR2(150) ,
69 ATTRIBUTE8 VARCHAR2(150) ,
70 ATTRIBUTE9 VARCHAR2(150) ,
71 ATTRIBUTE10 VARCHAR2(150) ,
72 ATTRIBUTE11 VARCHAR2(150) ,
73 ATTRIBUTE12 VARCHAR2(150) ,
74 ATTRIBUTE13 VARCHAR2(150) ,
75 ATTRIBUTE14 VARCHAR2(150) ,
76 ATTRIBUTE15 VARCHAR2(150) ,
77 SCHEDULE_FLAG VARCHAR2(1)
78 );
79 ----------------------------------------------
80 -- Define Table Type for records structures --
81 ----------------------------------------------
82 TYPE Space_Assignment_Tbl IS TABLE OF Space_Assignment_Rec INDEX BY BINARY_INTEGER;
83
84 ------------------------
85 -- Declare Procedures --
86 ------------------------
87
88 -- Start of Comments --
89 -- Procedure name : Assign_Sch_Visit_Spaces
90 -- Type : Public
91 -- Function : Manages Create/Modify/Delete space assignments for a visit
92 -- Schedule a visit
93 -- Pre-reqs :
94 -- Parameters :
95 --
96 -- Standard IN Parameters :
97 -- p_api_version IN NUMBER Required
98 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101 -- Based on this flag, the API will set the default attributes.
102 -- p_module_type In VARCHAR2 Default NULL
103 -- This will be null.
104 -- Standard OUT Parameters :
105 -- x_return_status OUT VARCHAR2 Required
106 -- x_msg_count OUT NUMBER Required
107 -- x_msg_data OUT VARCHAR2 Required
108 --
109 -- Process_Space_Assignment Parameters :
110 -- p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,Required
111 -- p_x_schedule_visit_rec IN out Schedule_visits_rec
112 -- List of space assignemnts, Schedule a visit
113 --
114
115 PROCEDURE Assign_Sch_Visit_Spaces (
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
118 p_commit IN VARCHAR2 := Fnd_Api.g_false,
119 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
120 p_module_type IN VARCHAR2 := 'JSP',
121 p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
122 p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128 -- Start of Comments --
129 -- Procedure name : Schedule_Visit
130 -- Type : Public
131 -- Function : Defines organization,department,start_date and schedule designator
132 -- for a visit
133 -- Pre-reqs :
134 -- Parameters :
135 --
136 -- Standard IN Parameters :
137 -- p_api_version IN NUMBER Required
138 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
139 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
140 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141 -- Based on this flag, the API will set the default attributes.
142 -- p_module_type In VARCHAR2 Default NULL
143 -- This will be null.
144 -- Standard OUT Parameters :
145 -- x_return_status OUT VARCHAR2 Required
146 -- x_msg_count OUT NUMBER Required
147 -- x_msg_data OUT VARCHAR2 Required
148 --
149 -- Schedule_Visit Parameters :
150 -- p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,Required
151 -- Assigns visit attributes
152 --
153
154 PROCEDURE Schedule_Visit (
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
157 p_commit IN VARCHAR2 := Fnd_Api.g_false,
158 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
159 p_module_type IN VARCHAR2 := 'JSP',
160 p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2
164 );
165
166 -- Start of Comments --
167 -- Procedure name : Unschedule_Visit
168 -- Type : Public
169 -- Function : Removes organization,department,start_date and schedule designator
170 -- and any associated space assignments for a visit
171 -- Pre-reqs :
172 -- Parameters :
173 --
174 -- Standard IN Parameters :
175 -- p_api_version IN NUMBER Required
176 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
177 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
178 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
179 -- Based on this flag, the API will set the default attributes.
180 -- p_module_type In VARCHAR2 Default NULL
181 -- This will be null.
182 -- Standard OUT Parameters :
183 -- x_return_status OUT VARCHAR2 Required
184 -- x_msg_count OUT NUMBER Required
185 -- x_msg_data OUT VARCHAR2 Required
186 --
187 -- Unschedule_Visit Parameters :
188 -- p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,Required
189 -- List of visit attributes
190 --
191 PROCEDURE Unschedule_Visit (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
194 p_commit IN VARCHAR2 := Fnd_Api.g_false,
195 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
196 p_module_type IN VARCHAR2 := 'JSP',
197 p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2
201 );
202
203
204 END AHL_LTP_SPACE_ASSIGN_PUB;