APPS.PER_ABS_SHADOW_BOOKING_PKG dependencies on PER_ABS_SHADOW_BOOKING_PKG

Line 1: PACKAGE BODY per_abs_shadow_booking_pkg AS

1: PACKAGE BODY per_abs_shadow_booking_pkg AS
2: -- $Header: peabsbkg.pkb 120.0 2005/05/31 04:44:57 appldev noship $
3:
4: -----------------------------------------------------------------------------
5: --

Line 24: l_proc := 'per_abs_shadow_booking_pkg.validate_params';

20: e_invalid_params EXCEPTION;
21:
22: BEGIN
23:
24: l_proc := 'per_abs_shadow_booking_pkg.validate_params';
25: hr_utility.set_location('Entering: '|| l_proc, 10);
26:
27: IF p_mode IN ('CRE','UPD','DEL','GET') THEN
28: -- Check that either person id or assignment id is supplied

Line 97: l_proc := 'per_abs_shadow_booking_pkg.get_primary_asg';

93: AND effective_end_date >= NVL(cp_start_date, SYSDATE);
94:
95: BEGIN
96:
97: l_proc := 'per_abs_shadow_booking_pkg.get_primary_asg';
98: hr_utility.set_location('Entering: '|| l_proc, 10);
99:
100: OPEN c_prim_asg ( p_person_id
101: , p_start_date

Line 140: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_type_id';

136: WHERE name = cp_bkg_type;
137:
138: BEGIN
139:
140: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_type_id';
141: hr_utility.set_location('Entering: '|| l_proc, 10);
142:
143: OPEN c_bkg_type_id ( p_bkg_type
144: );

Line 186: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_id';

182: AND source_object_id = cp_abs_id;
183:
184: BEGIN
185:
186: l_proc := 'per_abs_shadow_booking_pkg.get_bkg_id';
187: hr_utility.set_location('Entering: '|| l_proc, 10);
188:
189: OPEN c_bkg_id ( p_abs_id );
190: FETCH c_bkg_id INTO l_bkg_id

Line 235: l_proc := 'per_abs_shadow_booking_pkg.create_shadow_booking';

231: e_invalid_params EXCEPTION;
232:
233: BEGIN
234:
235: l_proc := 'per_abs_shadow_booking_pkg.create_shadow_booking';
236: hr_utility.set_location('Entering: '|| l_proc, 10);
237: x_booking_id := NULL;
238: x_return_status := '0';
239: x_return_message := '';

Line 347: l_proc := 'per_abs_shadow_booking_pkg.update_shadow_booking';

343: e_invalid_params EXCEPTION;
344:
345: BEGIN
346:
347: l_proc := 'per_abs_shadow_booking_pkg.update_shadow_booking';
348: hr_utility.set_location('Entering: '|| l_proc, 10);
349: x_return_status := '0';
350: x_return_message := '';
351:

Line 463: l_proc := 'per_abs_shadow_booking_pkg.delete_shadow_booking';

459: e_invalid_params EXCEPTION;
460:
461: BEGIN
462:
463: l_proc := 'per_abs_shadow_booking_pkg.delete_shadow_booking';
464: hr_utility.set_location('Entering: '|| l_proc, 10);
465: x_return_status := '0';
466: x_return_message := '';
467:

Line 563: l_proc := 'per_abs_shadow_booking_pkg.get_shadow_booking';

559: c_bkgs cur_type;
560:
561: BEGIN
562:
563: l_proc := 'per_abs_shadow_booking_pkg.get_shadow_booking';
564: hr_utility.set_location('Entering: '|| l_proc, 10);
565: l_booking_obj := per_abs_booking_obj(NULL,NULL,NULL,NULL,NULL,
566: NULL,NULL,NULL,NULL,NULL);
567: x_bookings := per_abs_booking_varray();

Line 640: END per_abs_shadow_booking_pkg;

636: x_return_message := SQLERRM;
637:
638: END get_shadow_booking;
639:
640: END per_abs_shadow_booking_pkg;