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.

[Home] [Help]

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 759: ota_activity_versions_tl a

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

Line 1851: l_activity_version_name ota_activity_versions.version_name%TYPE;

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

Line 1864: ota_activity_versions_tl a

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

Line 2198: p_activity_id IN OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type

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

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

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

Line 2205: SELECT activity_version_id from ota_activity_versions

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

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

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

Line 2211: SELECT activity_version_id,end_date from ota_activity_versions

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

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

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