eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_BOOKINGS_SWI dependencies on PER_BOOKINGS

Line 1: PACKAGE BODY PER_BOOKINGS_SWI As

1: PACKAGE BODY PER_BOOKINGS_SWI As
2: /* $Header: pebkgswi.pkb 120.3 2007/12/14 11:13:30 uuddavol noship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'per_bookings_swi.';

2: /* $Header: pebkgswi.pkb 120.3 2007/12/14 11:13:30 uuddavol noship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'per_bookings_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_per_booking >---------------------------|
10: -- ----------------------------------------------------------------------------

Line 11: PROCEDURE create_per_bookings

7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_per_booking >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_per_bookings
12: (p_Rowid IN OUT NOCOPY VARCHAR2
13: ,p_Booking_Id IN OUT NOCOPY NUMBER
14: ,p_Business_Group_Id NUMBER
15: ,p_Person_Id NUMBER

Line 52: l_proc varchar2(72) := g_package ||'create_per_bookings';

48: -- Variables for IN/OUT parameters
49: --
50: -- Other variables
51: l_interview_details_id number;
52: l_proc varchar2(72) := g_package ||'create_per_bookings';
53: Begin
54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint

Line 58: savepoint create_per_bookings_swi;

54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_per_bookings_swi;
59: --
60: -- Initialise Multiple Message Detection
61: --
62: hr_multi_message.enable_message_list;

Line 68: per_bookings_pkg.Insert_Row(X_Rowid => p_Rowid

64: -- Remember IN OUT parameter IN values
65: --
66: -- Call API
67: --
68: per_bookings_pkg.Insert_Row(X_Rowid => p_Rowid
69: ,X_Booking_Id => p_Booking_Id
70: ,X_Business_Group_Id => p_Business_Group_Id
71: ,X_Person_Id => p_Person_Id
72: ,X_Event_Id => p_Event_Id

Line 109: rollback to create_per_bookings_swi;

105: -- Catch the Multiple Message List exception which
106: -- indicates API processing has been aborted because
107: -- at least one message exists in the list.
108: --
109: rollback to create_per_bookings_swi;
110: --
111: -- Reset IN OUT parameters and set OUT parameters
112: --
113: p_return_status := hr_multi_message.get_return_status_disable;

Line 123: rollback to create_per_bookings_swi;

119: -- exceptions. Adding appropriate details to the
120: -- Multiple Message List. Otherwise re-raise the
121: -- error.
122: --
123: rollback to create_per_bookings_swi;
124: if hr_multi_message.unexpected_error_add(l_proc) then
125: hr_utility.set_location(' Leaving:' || l_proc,40);
126: raise;
127: end if;

Line 133: end create_per_bookings;

129: -- Reset IN OUT and set OUT parameters
130: --
131: p_return_status := hr_multi_message.get_return_status_disable;
132: hr_utility.set_location(' Leaving:' || l_proc,50);
133: end create_per_bookings;
134: --
135: --
136: -- ----------------------------------------------------------------------------
137: -- |-------------------------< update_per_bookings ---------------------------|

Line 137: -- |-------------------------< update_per_bookings ---------------------------|

133: end create_per_bookings;
134: --
135: --
136: -- ----------------------------------------------------------------------------
137: -- |-------------------------< update_per_bookings ---------------------------|
138: -- ----------------------------------------------------------------------------
139: PROCEDURE update_per_bookings
140: (p_Rowid IN OUT NOCOPY VARCHAR2
141: ,p_Booking_Id IN OUT NOCOPY NUMBER

Line 139: PROCEDURE update_per_bookings

135: --
136: -- ----------------------------------------------------------------------------
137: -- |-------------------------< update_per_bookings ---------------------------|
138: -- ----------------------------------------------------------------------------
139: PROCEDURE update_per_bookings
140: (p_Rowid IN OUT NOCOPY VARCHAR2
141: ,p_Booking_Id IN OUT NOCOPY NUMBER
142: ,p_Business_Group_Id NUMBER
143: ,p_Person_Id NUMBER

Line 180: l_proc varchar2(72) := g_package ||'update_per_bookings';

176: -- Variables for IN/OUT parameters
177: --
178: -- Other variables
179: l_interview_details_id number;
180: l_proc varchar2(72) := g_package ||'update_per_bookings';
181: --
182: cursor csr_rowid is
183: select rowid
184: from per_bookings

Line 184: from per_bookings

180: l_proc varchar2(72) := g_package ||'update_per_bookings';
181: --
182: cursor csr_rowid is
183: select rowid
184: from per_bookings
185: where booking_id = p_Booking_Id;
186: Begin
187: hr_utility.set_location(' Entering:' || l_proc,10);
188: --

Line 191: savepoint update_per_bookings_swi;

187: hr_utility.set_location(' Entering:' || l_proc,10);
188: --
189: -- Issue a savepoint
190: --
191: savepoint update_per_bookings_swi;
192: --
193: -- Initialise Multiple Message Detection
194: --
195: hr_multi_message.enable_message_list;

Line 210: per_bookings_pkg.Update_Row(X_Rowid => p_Rowid

206: end if;
207: --
208: -- Call API
209: --
210: per_bookings_pkg.Update_Row(X_Rowid => p_Rowid
211: ,X_Booking_Id => p_Booking_Id
212: ,X_Business_Group_Id => p_Business_Group_Id
213: ,X_Person_Id => p_Person_Id
214: ,X_Event_Id => p_Event_Id

Line 251: rollback to update_per_bookings_swi;

247: -- Catch the Multiple Message List exception which
248: -- indicates API processing has been aborted because
249: -- at least one message exists in the list.
250: --
251: rollback to update_per_bookings_swi;
252: --
253: -- Reset IN OUT parameters and set OUT parameters
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;

Line 265: rollback to update_per_bookings_swi;

261: -- exceptions. Adding appropriate details to the
262: -- Multiple Message List. Otherwise re-raise the
263: -- error.
264: --
265: rollback to update_per_bookings_swi;
266: if hr_multi_message.unexpected_error_add(l_proc) then
267: hr_utility.set_location(' Leaving:' || l_proc,40);
268: raise;
269: end if;

Line 275: end update_per_bookings;

271: -- Reset IN OUT and set OUT parameters
272: --
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275: end update_per_bookings;
276: -- ----------------------------------------------------------------------------
277: PROCEDURE delete_per_bookings
278: (p_Booking_Id IN NUMBER
279: ,p_return_status out nocopy varchar2

Line 277: PROCEDURE delete_per_bookings

273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275: end update_per_bookings;
276: -- ----------------------------------------------------------------------------
277: PROCEDURE delete_per_bookings
278: (p_Booking_Id IN NUMBER
279: ,p_return_status out nocopy varchar2
280: ) is
281: l_Rowid VARCHAR2(30);

Line 282: l_proc varchar2(72) := g_package ||'delete_per_bookings';

278: (p_Booking_Id IN NUMBER
279: ,p_return_status out nocopy varchar2
280: ) is
281: l_Rowid VARCHAR2(30);
282: l_proc varchar2(72) := g_package ||'delete_per_bookings';
283: cursor csr_rowid is
284: select rowid
285: from per_bookings
286: where booking_id = p_Booking_Id;

Line 285: from per_bookings

281: l_Rowid VARCHAR2(30);
282: l_proc varchar2(72) := g_package ||'delete_per_bookings';
283: cursor csr_rowid is
284: select rowid
285: from per_bookings
286: where booking_id = p_Booking_Id;
287: begin
288: hr_utility.set_location(' Entering:' || l_proc,10);
289: --

Line 292: savepoint delete_per_bookings_swi;

288: hr_utility.set_location(' Entering:' || l_proc,10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint delete_per_bookings_swi;
293: --
294: -- Initialise Multiple Message Detection
295: --
296: hr_multi_message.enable_message_list;

Line 311: per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);

307: end if;
308: --
309: -- Call API
310: --
311: per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);
312: --
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc, 20);
315: ---

Line 323: rollback to delete_per_bookings_swi;

319: -- Catch the Multiple Message List exception which
320: -- indicates API processing has been aborted because
321: -- at least one message exists in the list.
322: --
323: rollback to delete_per_bookings_swi;
324: --
325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_return_status := hr_multi_message.get_return_status_disable;

Line 337: rollback to delete_per_bookings_swi;

333: -- exceptions. Adding appropriate details to the
334: -- Multiple Message List. Otherwise re-raise the
335: -- error.
336: --
337: rollback to delete_per_bookings_swi;
338: if hr_multi_message.unexpected_error_add(l_proc) then
339: hr_utility.set_location(' Leaving:' || l_proc,40);
340: raise;
341: end if;

Line 347: end delete_per_bookings;

343: -- Reset IN OUT and set OUT parameters
344: --
345: p_return_status := hr_multi_message.get_return_status_disable;
346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: end delete_per_bookings;
348:
349: --
350: end PER_BOOKINGS_SWI;

Line 350: end PER_BOOKINGS_SWI;

346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: end delete_per_bookings;
348:
349: --
350: end PER_BOOKINGS_SWI;