eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRAINING_SS dependencies on OTA_ENROLL_IN_TRAINING_SS

Line 1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;

1338: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
1339: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
1340: l_eventid ota_events.event_id%TYPE;
1341: l_object_version_number number;
1342: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
1343: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
1344: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
1345: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
1346: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 1600: l_person_details := ota_enroll_in_training_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);

1596: ,p_name => 'P_TDB_INFORMATION20');
1597:
1598:
1599:
1600: l_person_details := ota_enroll_in_training_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1601:
1602: IF l_person_details.full_name is not null then
1603: WF_ENGINE.setitemattrtext(l_item_type,
1604: l_item_key,

Line 1609: l_restricted_assignment_id := ota_enroll_in_training_ss.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id

1605: 'CURRENT_PERSON_DISPLAY_NAME',
1606: l_person_details.full_name);
1607: END IF;
1608:
1609: l_restricted_assignment_id := ota_enroll_in_training_ss.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id
1610: ,p_event_id => l_eventid);
1611:
1612: IF l_restricted_assignment_id IS NULL OR
1613: l_restricted_assignment_id = '-1' THEN

Line 1692: l_cancel_boolean := ota_enroll_in_training_ss.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid

1688: l_delegate_id);
1689:
1690:
1691:
1692: l_cancel_boolean := ota_enroll_in_training_ss.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid
1693: ,p_delegate_person_id => l_delegate_id
1694: ,p_booking_id => l_booking_id);
1695:
1696: IF (l_cancel_boolean) THEN

Line 1698: ota_enroll_in_training_ss.cancel_finance(l_booking_id);

1694: ,p_booking_id => l_booking_id);
1695:
1696: IF (l_cancel_boolean) THEN
1697: -- Call Cancel procedure to cancel the Finance if person Re-enroll
1698: ota_enroll_in_training_ss.cancel_finance(l_booking_id);
1699: END IF;
1700:
1701:
1702: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web(

Line 1702: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web(

1698: ota_enroll_in_training_ss.cancel_finance(l_booking_id);
1699: END IF;
1700:
1701:
1702: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web(
1703: p_web_booking_status_type => 'REQUESTED'
1704: -- Bug#2215026 ota_general call replaced by l_business_group_id.
1705: -- ,p_business_group_id => ota_general.get_business_group_id);
1706: ,p_business_group_id => l_business_group_id);

Line 1711: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;

1707:
1708: IF l_booking_status_row.booking_Status_type_id is null then
1709: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1710: -- Bug#2227738 hdshah change the exception
1711: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1712: RAISE status_not_seeded;
1713: ELSE
1714: WF_ENGINE.setitemattrtext(l_item_type,
1715: l_item_key,

Line 1911: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

1907: l_maximum_internal_allowed := nvl(l_maximum_internal_attendees,0) - l_existing_internal;
1908:
1909: IF l_event_status in ('F') THEN
1910:
1911: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
1912: (p_web_booking_status_type => 'WAITLISTED'
1913: ,p_business_group_id => l_business_group_id);
1914: ELSIF l_event_status in ('P') THEN
1915:

Line 1916: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

1912: (p_web_booking_status_type => 'WAITLISTED'
1913: ,p_business_group_id => l_business_group_id);
1914: ELSIF l_event_status in ('P') THEN
1915:
1916: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
1917: (p_web_booking_status_type => 'REQUESTED'
1918: ,p_business_group_id => l_business_group_id);
1919:
1920: ELSIF l_event_status = 'N' THEN

Line 1923: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

1919:
1920: ELSIF l_event_status = 'N' THEN
1921:
1922: IF l_maximum_internal_attendees is null then
1923: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
1924: (p_web_booking_status_type => 'PLACED'
1925: ,p_business_group_id => l_business_group_id);
1926:
1927: ELSE

Line 1930: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

1926:
1927: ELSE
1928:
1929: IF l_maximum_internal_allowed > 0 THEN
1930: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
1931: (p_web_booking_status_type => 'PLACED'
1932: ,p_business_group_id => l_business_group_id);
1933:
1934: ELSIF l_maximum_internal_allowed <= 0 THEN

Line 1935: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

1931: (p_web_booking_status_type => 'PLACED'
1932: ,p_business_group_id => l_business_group_id);
1933:
1934: ELSIF l_maximum_internal_allowed <= 0 THEN
1935: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
1936: (p_web_booking_status_type => 'WAITLISTED'
1937: ,p_business_group_id => l_business_group_id);
1938:
1939: END IF;

Line 1946: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;

1942:
1943: IF l_booking_status_row.booking_Status_type_id is null then
1944: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1945: -- Bug#2227738 hdshah change the exception
1946: -- RAISE OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception ;
1947: RAISE status_not_seeded;
1948: ELSE
1949: WF_ENGINE.setitemattrtext(l_item_type,
1950: l_item_key,

Line 2201: -- WHEN OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception THEN

2197:
2198:
2199: EXCEPTION
2200: -- Bug#2227738 hdshah change the exception
2201: -- WHEN OTA_ENROLL_IN_TRAINING_SS.g_mesg_on_stack_exception THEN
2202: -- NULL;
2203: WHEN status_not_seeded THEN
2204: RAISE;
2205: WHEN OTHERS THEN

Line 2327: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web

2323: CLOSE csr_chk_event;
2324:
2325: select sysdate into l_current_date from dual;
2326:
2327: l_booking_status_row := ota_enroll_in_training_ss.Get_Booking_Status_for_web
2328: (p_web_booking_status_type => 'CANCELLED'
2329: ,p_business_group_id => l_business_group_id);
2330:
2331: ota_tdb_api_upd2.update_enrollment(