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_ENROLL_REVIEW_SS dependencies on OTA_TRNG_ENROLL_SS

Line 892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;

888: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
889: l_delegate_id PER_PEOPLE_F.person_id%TYPE;
890: l_eventid ota_events.event_id%TYPE;
891: l_object_version_number number;
892: l_person_details OTA_trng_enroll_SS.csr_person_to_enroll_details%ROWTYPE;
893: l_specialInstruction ota_delegate_bookings.SPECIAL_BOOKING_INSTRUCTIONS%TYPE;
894: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;
895: l_item_type HR_API_TRANSACTION_STEPS.ITEM_TYPE%TYPE;
896: l_item_key HR_API_TRANSACTION_STEPS.ITEM_KEY%TYPE;

Line 1152: l_person_details := ota_trng_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);

1148: ,p_name => 'P_TDB_INFORMATION20');
1149:
1150:
1151:
1152: l_person_details := ota_trng_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => l_delegate_id);
1153:
1154: IF l_person_details.full_name is not null then
1155: WF_ENGINE.setitemattrtext(l_item_type,
1156: l_item_key,

Line 1161: l_restricted_assignment_id := ota_trng_enroll_ss.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id

1157: 'CURRENT_PERSON_DISPLAY_NAME',
1158: l_person_details.full_name);
1159: END IF;
1160:
1161: l_restricted_assignment_id := ota_trng_enroll_ss.CHK_DELEGATE_OK_FOR_EVENT(p_delegate_id => l_delegate_id
1162: ,p_event_id => l_eventid);
1163:
1164: IF l_restricted_assignment_id IS NULL OR
1165: l_restricted_assignment_id = '-1' THEN

Line 1244: l_cancel_boolean := ota_trng_enroll_ss.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid

1240: l_delegate_id);
1241:
1242:
1243:
1244: l_cancel_boolean := ota_trng_enroll_ss.Chk_Event_Cancelled_for_Person(p_event_id => l_eventid
1245: ,p_delegate_person_id => l_delegate_id
1246: ,p_booking_id => l_booking_id);
1247:
1248: IF (l_cancel_boolean) THEN

Line 1250: ota_trng_enroll_ss.cancel_finance(l_booking_id);

1246: ,p_booking_id => l_booking_id);
1247:
1248: IF (l_cancel_boolean) THEN
1249: -- Call Cancel procedure to cancel the Finance if person Re-enroll
1250: ota_trng_enroll_ss.cancel_finance(l_booking_id);
1251: END IF;
1252:
1253:
1254: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web(

Line 1254: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web(

1250: ota_trng_enroll_ss.cancel_finance(l_booking_id);
1251: END IF;
1252:
1253:
1254: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web(
1255: p_web_booking_status_type => 'REQUESTED'
1256: -- Bug#2215026 ota_general call replaced by l_business_group_id.
1257: -- ,p_business_group_id => ota_general.get_business_group_id);
1258: ,p_business_group_id => l_business_group_id);

Line 1263: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;

1259:
1260: IF l_booking_status_row.booking_Status_type_id is null then
1261: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1262: -- Bug#2227738 hdshah change the exception
1263: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
1264: RAISE status_not_seeded;
1265: ELSE
1266: WF_ENGINE.setitemattrtext(l_item_type,
1267: l_item_key,

Line 1462: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1458: l_maximum_internal_allowed := nvl(l_maximum_internal_attendees,0) - l_existing_internal;
1459:
1460: IF l_event_status in ('F') THEN
1461:
1462: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1463: (p_web_booking_status_type => 'WAITLISTED'
1464: ,p_business_group_id => l_business_group_id);
1465: ELSIF l_event_status in ('P') THEN
1466:

Line 1467: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1463: (p_web_booking_status_type => 'WAITLISTED'
1464: ,p_business_group_id => l_business_group_id);
1465: ELSIF l_event_status in ('P') THEN
1466:
1467: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1468: (p_web_booking_status_type => 'REQUESTED'
1469: ,p_business_group_id => l_business_group_id);
1470:
1471: ELSIF l_event_status = 'N' THEN

Line 1474: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1470:
1471: ELSIF l_event_status = 'N' THEN
1472:
1473: IF l_maximum_internal_attendees is null then
1474: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1475: (p_web_booking_status_type => 'PLACED'
1476: ,p_business_group_id => l_business_group_id);
1477:
1478: ELSE

Line 1481: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1477:
1478: ELSE
1479:
1480: IF l_maximum_internal_allowed > 0 THEN
1481: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1482: (p_web_booking_status_type => 'PLACED'
1483: ,p_business_group_id => l_business_group_id);
1484:
1485: ELSIF l_maximum_internal_allowed <= 0 THEN

Line 1486: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1482: (p_web_booking_status_type => 'PLACED'
1483: ,p_business_group_id => l_business_group_id);
1484:
1485: ELSIF l_maximum_internal_allowed <= 0 THEN
1486: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1487: (p_web_booking_status_type => 'WAITLISTED'
1488: ,p_business_group_id => l_business_group_id);
1489:
1490: END IF;

Line 1497: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;

1493:
1494: IF l_booking_status_row.booking_Status_type_id is null then
1495: fnd_message.set_name ('OTA','OTA_13667_WEB_STATUS_NOT_SEEDE');
1496: -- Bug#2227738 hdshah change the exception
1497: -- RAISE OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception ;
1498: RAISE status_not_seeded;
1499: ELSE
1500: WF_ENGINE.setitemattrtext(l_item_type,
1501: l_item_key,

Line 1727: -- WHEN OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception THEN

1723:
1724:
1725: EXCEPTION
1726: -- Bug#2227738 hdshah change the exception
1727: -- WHEN OTA_TRNG_ENROLL_SS.g_mesg_on_stack_exception THEN
1728: -- NULL;
1729: WHEN status_not_seeded THEN
1730: RAISE;
1731: WHEN OTHERS THEN

Line 1848: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web

1844: CLOSE csr_chk_event;
1845:
1846: select sysdate into l_current_date from dual;
1847:
1848: l_booking_status_row := ota_trng_enroll_ss.Get_Booking_Status_for_web
1849: (p_web_booking_status_type => 'CANCELLED'
1850: ,p_business_group_id => l_business_group_id);
1851:
1852: ota_tdb_api_upd2.update_enrollment(