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_LEARNER_ENROLL_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 130: FROM OTA_ACTIVITY_VERSIONS_TL

126:
127: CURSOR csr_activity(p_activity_version_id number )
128: IS
129: SELECT version_name
130: FROM OTA_ACTIVITY_VERSIONS_TL
131: WHERE activity_version_id = p_activity_version_id
132: AND language=userenv('LANG');
133:
134: CURSOR csr_get_priority IS

Line 190: l_activity_version_id ota_activity_versions.activity_version_id%type;

186: l_event_title ota_events.title%type;
187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;
193: l_offering_id ota_events.offering_id%type;
194: l_booking_status_used varchar2(20);

Line 191: l_version_name ota_activity_versions.version_name%type;

187: l_course_start_date ota_events.course_start_date%type;
188: l_course_end_date ota_events.course_end_date%type;
189: l_owner_id ota_events.owner_id%type;
190: l_activity_version_id ota_activity_versions.activity_version_id%type;
191: l_version_name ota_activity_versions.version_name%type;
192: l_owner_username fnd_user.user_name%type;
193: l_offering_id ota_events.offering_id%type;
194: l_booking_status_used varchar2(20);
195:

Line 758: ota_activity_versions_tl a

754: e.course_start_time,
755: e.course_end_date
756: FROM ota_events_vl e,
757: ota_offerings o,
758: ota_activity_versions_tl a
759: WHERE e.parent_offering_id = o.offering_id
760: AND o.activity_version_id = a.activity_version_id
761: AND e.event_id = p_event_id
762: AND language=userenv('LANG');

Line 1850: l_activity_version_name ota_activity_versions.version_name%TYPE;

1846: l_daemon_flag ota_delegate_bookings.daemon_flag%TYPE;
1847: l_daemon_type ota_delegate_bookings.daemon_type%TYPE;
1848: lb_object_version_number ota_delegate_bookings.object_version_number%TYPE;
1849: l_proc VARCHAR2(72) := 'ota_learner_enroll_ss.cancel_enrollment';
1850: l_activity_version_name ota_activity_versions.version_name%TYPE;
1851:
1852: CURSOR event_csr (p_event_id ota_events.event_id%TYPE)
1853: IS
1854: SELECT a.version_name,

Line 1863: ota_activity_versions_tl a

1859: e.course_end_date,
1860: e.owner_id
1861: FROM ota_events_vl e,
1862: ota_offerings o,
1863: ota_activity_versions_tl a
1864: WHERE e.parent_offering_id = o.offering_id
1865: AND o.activity_version_id = a.activity_version_id
1866: AND e.event_id = p_event_id
1867: AND language=userenv('LANG');

Line 2197: p_activity_id IN OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type

2193: --|--< CHK_VALID_ACTIVITY >-------------------------------------------|
2194: --|--------------------------------------------------------------------------|
2195:
2196: FUNCTION CHK_VALID_ACTIVITY(
2197: p_activity_id IN OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type
2198: )
2199: RETURN VARCHAR2
2200: IS
2201: -- check for presence of activity

Line 2202: CURSOR C_GET_ACT(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

2198: )
2199: RETURN VARCHAR2
2200: IS
2201: -- check for presence of activity
2202: CURSOR C_GET_ACT(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2203: is
2204: SELECT activity_version_id from ota_activity_versions
2205: where Activity_version_id = l_activity_id;
2206:

Line 2204: SELECT activity_version_id from ota_activity_versions

2200: IS
2201: -- check for presence of activity
2202: CURSOR C_GET_ACT(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2203: is
2204: SELECT activity_version_id from ota_activity_versions
2205: where Activity_version_id = l_activity_id;
2206:
2207: -- checking for expired AND BG validation
2208: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

Line 2208: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

2204: SELECT activity_version_id from ota_activity_versions
2205: where Activity_version_id = l_activity_id;
2206:
2207: -- checking for expired AND BG validation
2208: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2209: is
2210: SELECT activity_version_id,end_date from ota_activity_versions
2211: where Activity_version_id = l_activity_id
2212: and business_group_id = ota_general.get_business_group_id;

Line 2210: SELECT activity_version_id,end_date from ota_activity_versions

2206:
2207: -- checking for expired AND BG validation
2208: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2209: is
2210: SELECT activity_version_id,end_date from ota_activity_versions
2211: where Activity_version_id = l_activity_id
2212: and business_group_id = ota_general.get_business_group_id;
2213:
2214:

Line 2215: CURSOR C_GET_OFR_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

2211: where Activity_version_id = l_activity_id
2212: and business_group_id = ota_general.get_business_group_id;
2213:
2214:
2215: CURSOR C_GET_OFR_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2216: is
2217: SELECT 1 from ota_offerings
2218: where Activity_version_id = l_activity_id
2219: and business_group_id = ota_general.get_business_group_id;