APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_LEARNER_ENROLL_SS

Line 1: PACKAGE BODY OTA_LEARNER_ENROLL_SS as

1: PACKAGE BODY OTA_LEARNER_ENROLL_SS as
2: /* $Header: otlnrenr.pkb 120.12.12010000.3 2008/08/22 06:30:21 pvelugul ship $ */
3:
4: g_package varchar2(33) := ' ota_learner_enroll_ss.'; -- Global package name
5:

Line 4: g_package varchar2(33) := ' ota_learner_enroll_ss.'; -- Global package name

1: PACKAGE BODY OTA_LEARNER_ENROLL_SS as
2: /* $Header: otlnrenr.pkb 120.12.12010000.3 2008/08/22 06:30:21 pvelugul ship $ */
3:
4: g_package varchar2(33) := ' ota_learner_enroll_ss.'; -- Global package name
5:
6: --
7: --
8: -- ----------------------------------------------------------------------------

Line 142: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

138:
139:
140: l_price_basis OTA_EVENTS.price_basis%TYPE;
141:
142: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
143: --
144: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
145: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
146: l_object_version_number BINARY_INTEGER;

Line 467: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);

463: -- we must update the existing record by changing Cancelled
464: -- to Requested status
465: --
466:
467: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);
468:
469: /* Call Cancel procedure to cancel the Finance if person Re-enroll */
470: cancel_finance(l_booking_id);
471:

Line 1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';

1845: l_sysdate DATE := SYSDATE;
1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1850: l_activity_version_name ota_activity_versions.version_name%TYPE;
1851:
1852: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)
1853: IS

Line 2568: l_proc varchar2(72) := 'ota_learner_enroll_ss.get_booking_status_comments';

2564:
2565: --
2566: --
2567: l_comments ota_booking_status_histories.comments%TYPE := null;
2568: l_proc varchar2(72) := 'ota_learner_enroll_ss.get_booking_status_comments';
2569: --
2570: begin
2571: --
2572: --

Line 2608: end ota_learner_enroll_ss;

2604: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
2605: RETURN l_booking_status_type_id;
2606: End getCancellationStatusId;
2607:
2608: end ota_learner_enroll_ss;