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_OFF_BUS dependencies on OTA_EVENTS

Line 473: from ota_events

469: l_event_status varchar2(1);
470: --
471: cursor events is
472: select course_start_date, course_end_date ,event_status
473: from ota_events
474: where parent_offering_id = p_offering_id;
475: begin
476: --
477: hr_utility.set_location(' Entering:'||l_proc,10);

Line 1463: -- ota_events exist.

1459: -- PUBLIC
1460: -- Description:
1461: -- Delete Validation.
1462: -- This activity version may not be deleted if child rows in
1463: -- ota_events exist.
1464: --
1465: Procedure check_if_evt_exists
1466: (
1467: p_offering_id in number

Line 1475: from ota_events evt

1471: v_proc varchar2(72) := g_package||'check_if_evt_exists';
1472: --
1473: cursor sel_evt_exists is
1474: select 'Y'
1475: from ota_events evt
1476: where evt.parent_offering_id = p_offering_id;
1477: --
1478: Begin
1479: --

Line 1512: -- ota_events exist.

1508: -- PUBLIC
1509: -- Description:
1510: -- Delete Validation.
1511: -- This activity version may not be deleted if child rows in
1512: -- ota_events exist.
1513: --
1514: Procedure check_if_comp_exists
1515: (
1516: p_offering_id in number