APPS.OTA_EL_TRAINING_SS dependencies on OTA_EL_ENROLL_SS

Line 1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

1083: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1084: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1085: l_eventid ota_events.event_id%TYPE;
1086: l_object_version_number number;
1087: l_person_details OTA_EL_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
1088: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1089: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1090: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1091: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 1345: l_person_details := OTA_EL_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);

1341: ,p_name => 'P_TDB_INFORMATION20');
1342:
1343:
1344:
1345: l_person_details := OTA_EL_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1346:
1347: IF l_person_details.full_name is not null then
1348: WF_ENGINE.setitemattrtext(l_item_type,
1349: l_item_key,

Line 1354: l_restricted_assignment_id := OTA_EL_ENROLL_SS.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id

1350: 'CURRENT_PERSON_DISPLAY_NAME',
1351: l_person_details.full_name);
1352: END IF;
1353:
1354: l_restricted_assignment_id := OTA_EL_ENROLL_SS.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id
1355: ,p_event_id => l_eventid);
1356:
1357: IF l_restricted_assignment_id IS NULL OR
1358: l_restricted_assignment_id = '-1' THEN

Line 1437: l_cancel_boolean := OTA_EL_ENROLL_SS.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid

1433: l_delegate_id);
1434:
1435:
1436:
1437: l_cancel_boolean := OTA_EL_ENROLL_SS.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid
1438: ,p_delegate_person_id => l_delegate_id
1439: ,p_booking_id => l_booking_id);
1440:
1441: IF (l_cancel_boolean) THEN

Line 1443: OTA_EL_ENROLL_SS.cancel_finance(l_booking_id);

1439: ,p_booking_id => l_booking_id);
1440:
1441: IF (l_cancel_boolean) THEN
1442: -- Call Cancel procedure to cancel the Finance if person Re-enroll
1443: OTA_EL_ENROLL_SS.cancel_finance(l_booking_id);
1444: END IF;
1445:
1446:
1447: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web(

Line 1447: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web(

1443: OTA_EL_ENROLL_SS.cancel_finance(l_booking_id);
1444: END IF;
1445:
1446:
1447: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web(
1448: p_web_booking_status_type => 'REQUESTED'
1449: -- Bug#2215026 ota_general call replaced by l_business_group_id.
1450: -- ,p_business_group_id => ota_general.get_business_group_id);
1451: ,p_business_group_id => l_business_group_id);

Line 1655: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web

1651: l_maximum_internal_allowed := nvl(l_maximum_internal_attendees,0) - l_existing_internal;
1652:
1653: IF l_event_status in ('F') THEN
1654:
1655: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web
1656: (p_web_booking_status_type => 'WAITLISTED'
1657: ,p_business_group_id => l_business_group_id);
1658: ELSIF l_event_status in ('P') THEN
1659:

Line 1660: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web

1656: (p_web_booking_status_type => 'WAITLISTED'
1657: ,p_business_group_id => l_business_group_id);
1658: ELSIF l_event_status in ('P') THEN
1659:
1660: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web
1661: (p_web_booking_status_type => 'REQUESTED'
1662: ,p_business_group_id => l_business_group_id);
1663:
1664: ELSIF l_event_status = 'N' THEN

Line 1667: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web

1663:
1664: ELSIF l_event_status = 'N' THEN
1665:
1666: IF l_maximum_internal_attendees is null then
1667: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web
1668: (p_web_booking_status_type => 'PLACED'
1669: ,p_business_group_id => l_business_group_id);
1670:
1671: ELSE

Line 1674: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web

1670:
1671: ELSE
1672:
1673: IF l_maximum_internal_allowed > 0 THEN
1674: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web
1675: (p_web_booking_status_type => 'PLACED'
1676: ,p_business_group_id => l_business_group_id);
1677:
1678: ELSIF l_maximum_internal_allowed <= 0 THEN

Line 1679: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web

1675: (p_web_booking_status_type => 'PLACED'
1676: ,p_business_group_id => l_business_group_id);
1677:
1678: ELSIF l_maximum_internal_allowed <= 0 THEN
1679: l_booking_status_row := OTA_EL_ENROLL_SS.Get_Booking_Status_for_web
1680: (p_web_booking_status_type => 'WAITLISTED'
1681: ,p_business_group_id => l_business_group_id);
1682:
1683: END IF;