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_EL_ENROLL_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 evt,

78: evttl.Title,
79: evt.owner_id,
80: evt.activity_version_id,
81: evt.offering_id
82: FROM OTA_EVENTS evt,
83: OTA_EVENTS_TL evttl,
84: HR_ALL_ORGANIZATION_UNITS hao
85: WHERE evt.event_id = pp_event_id
86: AND evt.event_id = evttl.event_id

Line 83: OTA_EVENTS_TL evttl,

79: evt.owner_id,
80: evt.activity_version_id,
81: evt.offering_id
82: FROM OTA_EVENTS evt,
83: OTA_EVENTS_TL evttl,
84: HR_ALL_ORGANIZATION_UNITS hao
85: WHERE evt.event_id = pp_event_id
86: AND evt.event_id = evttl.event_id
87: AND evt.organization_id = hao.organization_id (+)

Line 93: from OTA_EVENTS

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

Line 108: FROM ota_events

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

Line 126: l_price_basis OTA_EVENTS.price_basis%TYPE;

122: FROM OTA_ACTIVITY_VERSIONS_TL
123: WHERE activity_version_id = p_activity_version_id AND language(+) = userenv('LANG');
124:
125:
126: l_price_basis OTA_EVENTS.price_basis%TYPE;
127:
128: l_person_details csr_person_to_enroll_details%ROWTYPE;
129: --
130: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

Line 172: l_event_currency_code ota_events.currency_code%type;

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

Line 173: l_event_title ota_events.title%type;

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

Line 174: l_course_start_date ota_events.course_start_date%type;

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

Line 175: l_course_end_date ota_events.course_end_date%type;

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

Line 176: l_owner_id ota_events.owner_id%type;

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

Line 182: l_offering_id ota_events.offering_id%type;

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

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

1555: --|--------------------------------------------------------------------------|
1556:
1557: FUNCTION CHK_FOR_SECURE_EVT (
1558: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1559: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
1560: RETURN VARCHAR2
1561: IS
1562:
1563: CURSOR C_GET_SECURE_FLAG is

Line 1565: from ota_events

1561: IS
1562:
1563: CURSOR C_GET_SECURE_FLAG is
1564: SELECT secure_event_flag,organization_id
1565: from ota_events
1566: where event_id = p_event_id;
1567:
1568: CURSOR C_GET_ORG_ID is
1569: SELECT organization_id

Line 1577: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;

1573: effective_end_date;
1574:
1575:
1576: l_secure_flag varchar2(1);
1577: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1578: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1579: l_return_value varchar2(2000);
1580:
1581: BEGIN

Line 1624: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

1620: --|--------------------------------------------------------------------------|
1621:
1622: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1623: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1624: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1625: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1626: )
1627: RETURN VARCHAR2
1628:

Line 1625: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE

1621:
1622: FUNCTION CHK_DELEGATE_OK_FOR_EVENT (
1623: p_delegate_id IN PER_PEOPLE_F.PERSON_ID%TYPE
1624: , p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
1625: , p_event_start_date IN OTA_EVENTS.COURSE_START_DATE%TYPE
1626: )
1627: RETURN VARCHAR2
1628:
1629: IS

Line 1639: FROM ota_events

1635:
1636: CURSOR csr_event_start_date IS
1637: SELECT course_start_date
1638: -- FROM otv_scheduled_events
1639: FROM ota_events
1640: WHERE event_id = p_event_id and
1641: --Bug#2201434 SELFPACED event_type included.
1642: -- event_type='SCHEDULED' and
1643: event_type in ('SCHEDULED','SELFPACED') and

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

1899: funcmode IN VARCHAR2,
1900: resultout OUT NOCOPY VARCHAR2 )
1901: IS
1902:
1903: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1904: SELECT usr.user_name,
1905: evt.offering_id
1906: FROM OTA_EVENTS evt,
1907: FND_USER USR

Line 1906: FROM OTA_EVENTS evt,

1902:
1903: CURSOR user_name(p_event_id OTA_EVENTS.event_id%TYPE) IS
1904: SELECT usr.user_name,
1905: evt.offering_id
1906: FROM OTA_EVENTS evt,
1907: FND_USER USR
1908: WHERE evt.event_id = p_event_id and
1909: usr.employee_id = evt.owner_id;
1910:

Line 1925: l_offering_id ota_events.offering_id%type;

1921: l_api_from VARCHAR2(4000);
1922: l_api_to VARCHAR2(4000);
1923: l_event_id NUMBER;
1924: l_user_name FND_USER.USER_NAME%TYPE;
1925: l_offering_id ota_events.offering_id%type;
1926: l_booking_id ota_delegate_bookings.booking_id%type;
1927: l_version_name ota_activity_versions.version_name%type;
1928: l_notification_text varchar2(2000);
1929: l_status_type ota_booking_status_types.type%type;

Line 2072: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)

2068: --|--< CHK_FOR_RESTRICTED_EVT >-------------------------------------------|
2069: --|--------------------------------------------------------------------------|
2070:
2071: FUNCTION CHK_FOR_RESTRICTED_EVT (
2072: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE)
2073: RETURN VARCHAR2
2074: IS
2075:
2076: CURSOR C_GET_EVT_DETAILS is

Line 2078: from ota_events EVT, ota_event_associations EVA

2074: IS
2075:
2076: CURSOR C_GET_EVT_DETAILS is
2077: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
2078: from ota_events EVT, ota_event_associations EVA
2079: where EVT.event_id = p_event_id and
2080: EVT.event_id = EVA.event_id and
2081: EVA.customer_id is not null;
2082:

Line 2083: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;

2079: where EVT.event_id = p_event_id and
2080: EVT.event_id = EVA.event_id and
2081: EVA.customer_id is not null;
2082:
2083: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
2084: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
2085: l_return_value varchar2(10);
2086:
2087: BEGIN

Line 2084: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;

2080: EVT.event_id = EVA.event_id and
2081: EVA.customer_id is not null;
2082:
2083: l_public_event_flag OTA_EVENTS.PUBLIC_EVENT_FLAG%TYPE;
2084: l_maximum_internal_attendees OTA_EVENTS.MAXIMUM_INTERNAL_ATTENDEES%TYPE;
2085: l_return_value varchar2(10);
2086:
2087: BEGIN
2088:

Line 2121: -- p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,

2117: --|--< CHK_VALID_ACTIVITY >-------------------------------------------|
2118: --|--------------------------------------------------------------------------|
2119:
2120: FUNCTION CHK_VALID_ACTIVITY(
2121: -- p_event_id IN OTA_EVENTS.EVENT_ID%TYPE,
2122: p_activity_id IN OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type
2123: )
2124: RETURN VARCHAR2
2125: IS

Line 2143: SELECT 1 from ota_events

2139:
2140:
2141: CURSOR C_GET_EVT_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2142: is
2143: SELECT 1 from ota_events
2144: where Activity_version_id=l_activity_id
2145: and business_group_id=ota_general.get_business_group_id;
2146:
2147:

Line 2193: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE

2189: --|--< CHK_VALID_EVENT >-------------------------------------------|
2190: --|--------------------------------------------------------------------------|
2191:
2192: FUNCTION CHK_VALID_EVENT(
2193: p_event_id IN OTA_EVENTS.EVENT_ID%TYPE
2194: )
2195: RETURN VARCHAR2
2196: IS
2197: -- checking for INVALID Events

Line 2198: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

2194: )
2195: RETURN VARCHAR2
2196: IS
2197: -- checking for INVALID Events
2198: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2199: is
2200: SELECT event_id from ota_events
2201: where event_id = l_event_id;
2202:

Line 2200: SELECT event_id from ota_events

2196: IS
2197: -- checking for INVALID Events
2198: CURSOR C_GET_EVT(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2199: is
2200: SELECT event_id from ota_events
2201: where event_id = l_event_id;
2202:
2203: /*checking for valid evetns
2204: -- CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

Line 2204: -- CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

2200: SELECT event_id from ota_events
2201: where event_id = l_event_id;
2202:
2203: /*checking for valid evetns
2204: -- CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2205: is
2206: SELECT event_id from ota_events
2207: where event_id = l_event_id
2208: And trunc(sysdate) between nvl(trunc(tav.start_date),trunc(sysdate)) and

Line 2206: SELECT event_id from ota_events

2202:
2203: /*checking for valid evetns
2204: -- CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2205: is
2206: SELECT event_id from ota_events
2207: where event_id = l_event_id
2208: And trunc(sysdate) between nvl(trunc(tav.start_date),trunc(sysdate)) and
2209: nvl(trunc(tav.end_date),trunc(sysdate))
2210: And evt.event_type IN ('SCHEDULED','SELFPACED')

Line 2217: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)

2213: And trunc(sysdate) between nvl(trunc(evt.enrolment_start_date),trunc(sysdate)) and
2214: nvl(trunc(evt.enrolment_end_date),trunc(sysdate)) ;
2215: */
2216:
2217: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2218: is
2219: SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date,
2220: enrolment_end_date
2221: from ota_events

Line 2221: from ota_events

2217: CURSOR C_GET_EVT_DET(l_event_id OTA_EVENTS.EVENT_ID%TYPE)
2218: is
2219: SELECT event_id,event_status,course_start_date,course_end_date,enrolment_start_date,
2220: enrolment_end_date
2221: from ota_events
2222: where event_id = l_event_id
2223: and event_type in ('SCHEDULED','SELFPACED')
2224: and business_group_id=ota_general.get_business_group_id ;
2225: