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.5 2009/05/26 04:59:39 shwnayak 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.5 2009/05/26 04:59:39 shwnayak 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 468: l_object_version_number := OTA_LEARNER_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);

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

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

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

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

2572:
2573: --
2574: --
2575: l_comments ota_booking_status_histories.comments%TYPE := null;
2576: l_proc varchar2(72) := 'ota_learner_enroll_ss.get_booking_status_comments';
2577: --
2578: begin
2579: --
2580: --

Line 2616: end ota_learner_enroll_ss;

2612: l_booking_status_type_id := l_booking_status_row.booking_status_type_id;
2613: RETURN l_booking_status_type_id;
2614: End getCancellationStatusId;
2615:
2616: end ota_learner_enroll_ss;