APPS.OTA_TRNG_ENROLL_SS dependencies on OTA_TRNG_ENROLL_SS

Line 1: PACKAGE BODY OTA_TRNG_ENROLL_SS as

1: PACKAGE BODY OTA_TRNG_ENROLL_SS as
2: /* $Header: ottrnenr.pkb 120.2 2008/01/08 14:06:43 aabalakr noship $ */
3:
4: g_package varchar2(33) := ' ota_trng_enroll_ss.'; -- Global package name
5:

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

1: PACKAGE BODY OTA_TRNG_ENROLL_SS as
2: /* $Header: ottrnenr.pkb 120.2 2008/01/08 14:06:43 aabalakr noship $ */
3:
4: g_package varchar2(33) := ' ota_trng_enroll_ss.'; -- Global package name
5:
6: --
7: --
8: -- ----------------------------------------------------------------------------

Line 125: l_person_details OTA_TRNG_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

121: AND language=userenv('LANG');
122:
123: l_price_basis OTA_EVENTS.price_basis%TYPE;
124:
125: l_person_details OTA_TRNG_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
126: --
127: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
128: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
129: l_object_version_number BINARY_INTEGER;

Line 332: RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;

328: EXCEPTION
329: WHEN OTHERS THEN
330:
331: fnd_message.set_name ('OTA','OTA_13658_WF_ERR_GETTING_TYPE');
332: RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
333: p_message_name := SUBSTR(SQLERRM, 1,300);
334: END; /* End Check booking Type */
335:
336:

Line 549: l_object_version_number := OTA_TRNG_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);

545: ,itemkey => l_item_key
546: ,aname => 'BOOKING_STATUS_TYPE_ID'
547: ,avalue => l_booking_status_row.booking_status_type_id); */
548:
549: l_object_version_number := OTA_TRNG_ENROLL_SS.Get_Booking_OVN (p_booking_id => l_booking_id);
550:
551: /* Call Cancel procedure to cancel the Finance if person Re-enroll */
552: cancel_finance(l_booking_id);
553:

Line 1300: RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;

1296: --
1297: IF csr_person_to_enroll_details%NOTFOUND THEN
1298: CLOSE csr_person_to_enroll_details;
1299: fnd_message.set_name('PER','HR_51396_WEB_PERSON_NOT_FND');
1300: RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
1301: ELSE
1302: CLOSE csr_person_to_enroll_details;
1303: RETURN l_csr_person_to_enroll_details;
1304: END IF;

Line 1307: WHEN OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception THEN

1303: RETURN l_csr_person_to_enroll_details;
1304: END IF;
1305:
1306: EXCEPTION
1307: WHEN OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception THEN
1308: --
1309: -- Handle the exception in the calling code.
1310: RAISE;
1311:

Line 1355: OTA_TRNG_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

1351:
1352: IS
1353:
1354: l_person_details
1355: OTA_TRNG_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1356: l_cancel_boolean boolean;
1357: l_dummy number;
1358: Begin
1359: p_double_book := 'N';

Line 1360: l_person_details := OTA_TRNG_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => p_person_id);

1356: l_cancel_boolean boolean;
1357: l_dummy number;
1358: Begin
1359: p_double_book := 'N';
1360: l_person_details := OTA_TRNG_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => p_person_id);
1361:
1362: l_cancel_boolean :=
1363: Chk_Event_Cancelled_for_Person
1364: (p_event_id => p_event_id

Line 2160: end ota_trng_enroll_ss;

2156: RETURN l_ovn;
2157: --
2158: END Get_Booking_OVN;
2159:
2160: end ota_trng_enroll_ss;