APPS.OTA_LEARNER_ENROLL_REVIEW_SS dependencies on OTA_LEARNER_ENROLL_SS

Line 970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

966: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
967: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
968: l_eventid ota_events.event_id%TYPE;
969: l_object_version_number number;
970: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;
971: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
972: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
973: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
974: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 1267: l_person_details := OTA_LEARNER_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);

1263:
1264:
1265:
1266:
1267: l_person_details := OTA_LEARNER_ENROLL_SS.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1268:
1269: IF l_person_details.full_name is not null then
1270: WF_ENGINE.setitemattrtext(l_item_type,
1271: l_item_key,

Line 1276: l_restricted_assignment_id := OTA_LEARNER_ENROLL_SS.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id

1272: 'CURRENT_PERSON_DISPLAY_NAME',
1273: l_person_details.full_name);
1274: END IF;
1275:
1276: l_restricted_assignment_id := OTA_LEARNER_ENROLL_SS.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id
1277: ,p_event_id => l_eventid);
1278:
1279: IF l_restricted_assignment_id IS NULL OR
1280: l_restricted_assignment_id = '-1' THEN

Line 1387: l_cancel_boolean := OTA_LEARNER_ENROLL_SS.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid

1383: l_delegate_id);
1384:
1385:
1386:
1387: l_cancel_boolean := OTA_LEARNER_ENROLL_SS.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid
1388: ,p_delegate_person_id => l_delegate_id
1389: ,p_delegate_contact_id => null
1390: ,p_booking_id => l_booking_id);
1391:

Line 1394: OTA_LEARNER_ENROLL_SS.cancel_finance(l_booking_id);

1390: ,p_booking_id => l_booking_id);
1391:
1392: IF (l_cancel_boolean) THEN
1393: -- Call Cancel procedure to cancel the Finance if person Re-enroll
1394: OTA_LEARNER_ENROLL_SS.cancel_finance(l_booking_id);
1395: END IF;
1396:
1397:
1398: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web(

Line 1398: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web(

1394: OTA_LEARNER_ENROLL_SS.cancel_finance(l_booking_id);
1395: END IF;
1396:
1397:
1398: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web(
1399: p_web_booking_status_type => 'REQUESTED'
1400: ,p_business_group_id => l_business_group_id);
1401:
1402: IF l_booking_status_row.booking_Status_type_id is null then

Line 1603: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1599: l_maximum_internal_allowed := nvl(l_maximum_internal_attendees,0) - l_existing_internal;
1600:
1601: IF l_event_status in ('F') THEN
1602:
1603: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1604: (p_web_booking_status_type => 'WAITLISTED'
1605: ,p_business_group_id => l_business_group_id);
1606: ELSIF l_event_status in ('P') THEN
1607:

Line 1608: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1604: (p_web_booking_status_type => 'WAITLISTED'
1605: ,p_business_group_id => l_business_group_id);
1606: ELSIF l_event_status in ('P') THEN
1607:
1608: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1609: (p_web_booking_status_type => 'REQUESTED'
1610: ,p_business_group_id => l_business_group_id);
1611:
1612: ELSIF l_event_status = 'N' THEN

Line 1615: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1611:
1612: ELSIF l_event_status = 'N' THEN
1613:
1614: IF l_maximum_internal_attendees is null then
1615: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1616: (p_web_booking_status_type => 'PLACED'
1617: ,p_business_group_id => l_business_group_id);
1618:
1619: ELSE

Line 1622: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1618:
1619: ELSE
1620:
1621: IF l_maximum_internal_allowed > 0 THEN
1622: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1623: (p_web_booking_status_type => 'PLACED'
1624: ,p_business_group_id => l_business_group_id);
1625:
1626: ELSIF l_maximum_internal_allowed <= 0 THEN

Line 1627: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1623: (p_web_booking_status_type => 'PLACED'
1624: ,p_business_group_id => l_business_group_id);
1625:
1626: ELSIF l_maximum_internal_allowed <= 0 THEN
1627: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1628: (p_web_booking_status_type => 'WAITLISTED'
1629: ,p_business_group_id => l_business_group_id);
1630:
1631: END IF;

Line 1977: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1973: CLOSE csr_chk_event;
1974:
1975: select sysdate into l_current_date from dual;
1976:
1977: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1978: (p_web_booking_status_type => 'CANCELLED'
1979: ,p_business_group_id => l_business_group_id);
1980:
1981: ota_tdb_api_upd2.update_enrollment(