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

Line 72: CURSOR bg_to (pp_event_id ota_events.event_id%TYPE) IS

68: ,p_tdb_information19 in varchar2
69: ,p_tdb_information20 in varchar2 )
70: IS
71:
72: CURSOR bg_to (pp_event_id ota_events.event_id%TYPE) IS
73: SELECT hao.business_group_id,
74: evt.organization_id,
75: evt.currency_code,
76: evt.course_start_date,

Line 82: FROM OTA_EVENTS_VL evt,

78: evt.Title,
79: evt.owner_id,
80: evt.activity_version_id,
81: evt.offering_id
82: FROM OTA_EVENTS_VL evt,
83: HR_ALL_ORGANIZATION_UNITS hao
84: WHERE evt.event_id = pp_event_id
85: AND evt.organization_id = hao.organization_id (+); -- Bug 2213009
86:

Line 90: from OTA_EVENTS

86:
87:
88: Cursor Get_Event_status is
89: Select event_status, maximum_internal_attendees
90: from OTA_EVENTS
91: WHERE EVENT_ID = TO_NUMBER(p_event_id);
92:
93: CURSOR get_existing_internal IS
94: SELECT count(*)

Line 105: FROM ota_events

101:
102:
103: CURSOR c_get_price_basis is
104: SELECT nvl(price_basis,NULL)
105: FROM ota_events
106: where event_id = p_event_id;
107:
108: CURSOR csr_user(p_owner_id in number) IS
109: SELECT

Line 125: l_price_basis OTA_EVENTS.price_basis%TYPE;

121: AND language=userenv('LANG');
122:
123:
124:
125: l_price_basis OTA_EVENTS.price_basis%TYPE;
126:
127: l_person_details OTA_ENROLL_IN_TRAINING_SS.csr_person_to_enroll_details%ROWTYPE;
128: --
129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

Line 171: l_event_currency_code ota_events.currency_code%type;

167: l_item_key wf_items.item_key%type;
168: l_called_from varchar2(80);
169: l_business_group_id_to hr_all_organization_units.organization_id%type;
170: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
171: l_event_currency_code ota_events.currency_code%type;
172: l_event_title ota_events.title%type;
173: l_course_start_date ota_events.course_start_date%type;
174: l_course_end_date ota_events.course_end_date%type;
175: l_owner_id ota_events.owner_id%type;

Line 172: l_event_title ota_events.title%type;

168: l_called_from varchar2(80);
169: l_business_group_id_to hr_all_organization_units.organization_id%type;
170: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
171: l_event_currency_code ota_events.currency_code%type;
172: l_event_title ota_events.title%type;
173: l_course_start_date ota_events.course_start_date%type;
174: l_course_end_date ota_events.course_end_date%type;
175: l_owner_id ota_events.owner_id%type;
176: l_activity_version_id ota_activity_versions.activity_version_id%type;

Line 173: l_course_start_date ota_events.course_start_date%type;

169: l_business_group_id_to hr_all_organization_units.organization_id%type;
170: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
171: l_event_currency_code ota_events.currency_code%type;
172: l_event_title ota_events.title%type;
173: l_course_start_date ota_events.course_start_date%type;
174: l_course_end_date ota_events.course_end_date%type;
175: l_owner_id ota_events.owner_id%type;
176: l_activity_version_id ota_activity_versions.activity_version_id%type;
177: l_version_name ota_activity_versions.version_name%type;

Line 174: l_course_end_date ota_events.course_end_date%type;

170: l_sponsor_organization_id hr_all_organization_units.organization_id%type;
171: l_event_currency_code ota_events.currency_code%type;
172: l_event_title ota_events.title%type;
173: l_course_start_date ota_events.course_start_date%type;
174: l_course_end_date ota_events.course_end_date%type;
175: l_owner_id ota_events.owner_id%type;
176: l_activity_version_id ota_activity_versions.activity_version_id%type;
177: l_version_name ota_activity_versions.version_name%type;
178: l_owner_username fnd_user.user_name%type;

Line 175: l_owner_id ota_events.owner_id%type;

171: l_event_currency_code ota_events.currency_code%type;
172: l_event_title ota_events.title%type;
173: l_course_start_date ota_events.course_start_date%type;
174: l_course_end_date ota_events.course_end_date%type;
175: l_owner_id ota_events.owner_id%type;
176: l_activity_version_id ota_activity_versions.activity_version_id%type;
177: l_version_name ota_activity_versions.version_name%type;
178: l_owner_username fnd_user.user_name%type;
179: --Bug#2197997 commenting out completeactivity call.

Line 181: l_offering_id ota_events.offering_id%type;

177: l_version_name ota_activity_versions.version_name%type;
178: l_owner_username fnd_user.user_name%type;
179: --Bug#2197997 commenting out completeactivity call.
180: -- l_return boolean;
181: l_offering_id ota_events.offering_id%type;
182: l_booking_status_used varchar2(20);
183:
184: -- l_approval_req_flag Varchar2(20);
185:

Line 1548: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

1544: --|--------------------------------------------------------------------------|
1545:
1546: FUNCTION CHK_FOR_SECURE_EVT (
1547: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1548: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
1549: RETURN VARCHAR2
1550: IS
1551:
1552: CURSOR C_GET_SECURE_FLAG is

Line 1554: from ota_events

1550: IS
1551:
1552: CURSOR C_GET_SECURE_FLAG is
1553: SELECT secure_event_flag,organization_id
1554: from ota_events
1555: where event_id = p_event_id;
1556:
1557: CURSOR C_GET_ORG_ID is
1558: SELECT organization_id

Line 1566: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;

1562: effective_end_date;
1563:
1564:
1565: l_secure_flag varchar2(1);
1566: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1567: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1568: l_return_value varchar2(2000);
1569:
1570: BEGIN

Line 1613: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

1609: --|--------------------------------------------------------------------------|
1610:
1611: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1612: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1613: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1614: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1615: )
1616: RETURN VARCHAR2
1617:

Line 1614: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

1610:
1611: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1612: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1613: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1614: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1615: )
1616: RETURN VARCHAR2
1617:
1618: IS

Line 1628: FROM ota_events

1624:
1625: CURSOR csr_event_start_date IS
1626: SELECT course_start_date
1627: -- FROM otv_scheduled_events
1628: FROM ota_events
1629: WHERE event_id = p_event_id and
1630: --Bug#2201434 SELFPACED event_type included.
1631: -- event_type='SCHEDULED' and
1632: event_type in ('SCHEDULED','SELFPACED') and

Line 1662: per_all_people_f per, ota_events evt,

1658:
1659: Cursor c_delegate_active is
1660: select '1'
1661: from per_person_types ppt ,
1662: per_all_people_f per, ota_events evt,
1663: per_person_type_usages_f ptu
1664: where per.business_group_id = ppt.business_group_id
1665: and ppt.system_person_type in ('EMP','CWK','OTHER')
1666: and per.person_id=nvl(p_delegate_id,per.person_id)

Line 1920: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS

1916: funcmode IN VARCHAR2,
1917: resultout OUT nocopy VARCHAR2 )
1918: IS
1919:
1920: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1921: SELECT usr.user_name,
1922: evt.offering_id
1923: FROM OTA_EVENTS evt,
1924: FND_USER USR

Line 1923: FROM OTA_EVENTS evt,

1919:
1920: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1921: SELECT usr.user_name,
1922: evt.offering_id
1923: FROM OTA_EVENTS evt,
1924: FND_USER USR
1925: WHERE evt.event_id = p_event_id and
1926: usr.employee_id = evt.owner_id;
1927:

Line 1942: l_offering_id ota_events.offering_id%type;

1938: l_api_from VARCHAR2(4000);
1939: l_api_to VARCHAR2(4000);
1940: l_event_id NUMBER;
1941: l_user_name FND_USER.USER_NAME%TYPE;
1942: l_offering_id ota_events.offering_id%type;
1943: l_booking_id ota_delegate_bookings.booking_id%type;
1944: l_version_name ota_activity_versions.version_name%type;
1945: l_notification_text varchar2(2000);
1946: l_status_type ota_booking_status_types.type%type;

Line 2089: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

2085: --|--< CHK_FOR_RESTRICTED_EVT >-------------------------------------------|
2086: --|--------------------------------------------------------------------------|
2087:
2088: FUNCTION CHK_FOR_RESTRICTED_EVT (
2089: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
2090: RETURN VARCHAR2
2091: IS
2092:
2093: CURSOR C_GET_EVT_DETAILS is

Line 2095: from ota_events EVT, ota_event_associations EVA

2091: IS
2092:
2093: CURSOR C_GET_EVT_DETAILS is
2094: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
2095: from ota_events EVT, ota_event_associations EVA
2096: where EVT.event_id = p_event_id and
2097: EVT.event_id = EVA.event_id and
2098: EVA.customer_id is not null;
2099:

Line 2100: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;

2096: where EVT.event_id = p_event_id and
2097: EVT.event_id = EVA.event_id and
2098: EVA.customer_id is not null;
2099:
2100: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
2101: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
2102: l_return_value varchar2(10);
2103:
2104: BEGIN

Line 2101: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;

2097: EVT.event_id = EVA.event_id and
2098: EVA.customer_id is not null;
2099:
2100: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
2101: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
2102: l_return_value varchar2(10);
2103:
2104: BEGIN
2105: