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