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.6 2010/08/19 12:01:51 kgowripe ship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: pebkgswi.pkb 120.6 2010/08/19 12:01:51 kgowripe ship $ */
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 ROW_ID, b.*
184: from per_bookings b

Line 184: from per_bookings b

180: l_proc varchar2(72) := g_package ||'update_per_bookings';
181: --
182: cursor csr_rowid is
183: select rowid ROW_ID, b.*
184: from per_bookings b
185: where booking_id = p_Booking_Id;
186: l_oldrec csr_rowid%ROWTYPE;
187: p_rec per_bookings%ROWTYPE;
188: Begin

Line 187: p_rec per_bookings%ROWTYPE;

183: select rowid ROW_ID, b.*
184: from per_bookings b
185: where booking_id = p_Booking_Id;
186: l_oldrec csr_rowid%ROWTYPE;
187: p_rec per_bookings%ROWTYPE;
188: Begin
189: hr_utility.set_location(' Entering:' || l_proc,10);
190: --
191: -- Issue a savepoint

Line 193: savepoint update_per_bookings_swi;

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

Line 328: per_bookings_pkg.Update_Row(X_Rowid => p_Rowid

324: END IF;
325: --
326: -- Call API
327: --
328: per_bookings_pkg.Update_Row(X_Rowid => p_Rowid
329: ,X_Booking_Id => p_Booking_Id
330: ,X_Business_Group_Id => p_Business_Group_Id
331: ,X_Person_Id => p_Person_Id
332: ,X_Event_Id => p_Event_Id

Line 369: rollback to update_per_bookings_swi;

365: -- Catch the Multiple Message List exception which
366: -- indicates API processing has been aborted because
367: -- at least one message exists in the list.
368: --
369: rollback to update_per_bookings_swi;
370: --
371: -- Reset IN OUT parameters and set OUT parameters
372: --
373: p_return_status := hr_multi_message.get_return_status_disable;

Line 383: rollback to update_per_bookings_swi;

379: -- exceptions. Adding appropriate details to the
380: -- Multiple Message List. Otherwise re-raise the
381: -- error.
382: --
383: rollback to update_per_bookings_swi;
384: if hr_multi_message.unexpected_error_add(l_proc) then
385: hr_utility.set_location(' Leaving:' || l_proc,40);
386: raise;
387: end if;

Line 393: end update_per_bookings;

389: -- Reset IN OUT and set OUT parameters
390: --
391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc,50);
393: end update_per_bookings;
394: -- ----------------------------------------------------------------------------
395: PROCEDURE delete_per_bookings
396: (p_Booking_Id IN NUMBER
397: ,p_return_status out nocopy varchar2

Line 395: PROCEDURE delete_per_bookings

391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc,50);
393: end update_per_bookings;
394: -- ----------------------------------------------------------------------------
395: PROCEDURE delete_per_bookings
396: (p_Booking_Id IN NUMBER
397: ,p_return_status out nocopy varchar2
398: ) is
399: l_Rowid VARCHAR2(30);

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

396: (p_Booking_Id IN NUMBER
397: ,p_return_status out nocopy varchar2
398: ) is
399: l_Rowid VARCHAR2(30);
400: l_proc varchar2(72) := g_package ||'delete_per_bookings';
401: cursor csr_rowid is
402: select rowid
403: from per_bookings
404: where booking_id = p_Booking_Id;

Line 403: from per_bookings

399: l_Rowid VARCHAR2(30);
400: l_proc varchar2(72) := g_package ||'delete_per_bookings';
401: cursor csr_rowid is
402: select rowid
403: from per_bookings
404: where booking_id = p_Booking_Id;
405: begin
406: hr_utility.set_location(' Entering:' || l_proc,10);
407: --

Line 410: savepoint delete_per_bookings_swi;

406: hr_utility.set_location(' Entering:' || l_proc,10);
407: --
408: -- Issue a savepoint
409: --
410: savepoint delete_per_bookings_swi;
411: --
412: -- Initialise Multiple Message Detection
413: --
414: hr_multi_message.enable_message_list;

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

425: end if;
426: --
427: -- Call API
428: --
429: per_bookings_pkg.Delete_Row(X_Rowid => l_Rowid);
430: --
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc, 20);
433: ---

Line 441: rollback to delete_per_bookings_swi;

437: -- Catch the Multiple Message List exception which
438: -- indicates API processing has been aborted because
439: -- at least one message exists in the list.
440: --
441: rollback to delete_per_bookings_swi;
442: --
443: -- Reset IN OUT parameters and set OUT parameters
444: --
445: p_return_status := hr_multi_message.get_return_status_disable;

Line 455: rollback to delete_per_bookings_swi;

451: -- exceptions. Adding appropriate details to the
452: -- Multiple Message List. Otherwise re-raise the
453: -- error.
454: --
455: rollback to delete_per_bookings_swi;
456: if hr_multi_message.unexpected_error_add(l_proc) then
457: hr_utility.set_location(' Leaving:' || l_proc,40);
458: raise;
459: end if;

Line 465: end delete_per_bookings;

461: -- Reset IN OUT and set OUT parameters
462: --
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end delete_per_bookings;
466:
467: --
468: end PER_BOOKINGS_SWI;

Line 468: end PER_BOOKINGS_SWI;

464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end delete_per_bookings;
466:
467: --
468: end PER_BOOKINGS_SWI;