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 1606: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1602:
1603: --Update enrollments to Waitlisted status for planned class
1604: IF l_event_status in ('F','P') THEN
1605:
1606: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1607: (p_web_booking_status_type => 'WAITLISTED'
1608: ,p_business_group_id => l_business_group_id);
1609: /*ELSIF l_event_status in ('P') THEN
1610:

Line 1611: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1607: (p_web_booking_status_type => 'WAITLISTED'
1608: ,p_business_group_id => l_business_group_id);
1609: /*ELSIF l_event_status in ('P') THEN
1610:
1611: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1612: (p_web_booking_status_type => 'REQUESTED'
1613: ,p_business_group_id => l_business_group_id);*/
1614:
1615: ELSIF l_event_status = 'N' THEN

Line 1618: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

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

Line 1625: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

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

Line 1630: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

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

Line 1986: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web

1982: CLOSE csr_chk_event;
1983:
1984: select sysdate into l_current_date from dual;
1985:
1986: l_booking_status_row := OTA_LEARNER_ENROLL_SS.Get_Booking_Status_for_web
1987: (p_web_booking_status_type => 'CANCELLED'
1988: ,p_business_group_id => l_business_group_id);
1989:
1990: ota_tdb_api_upd2.update_enrollment(