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_OFFERINGS

Line 84: OTA_OFFERINGS off,

80: evt.owner_id,
81: off.activity_version_id,
82: evt.offering_id
83: FROM OTA_EVENTS_VL evt,
84: OTA_OFFERINGS off,
85: HR_ALL_ORGANIZATION_UNITS hao
86: WHERE evt.event_id = pp_event_id
87: AND off.offering_id = evt.parent_offering_id
88: AND evt.organization_id = hao.organization_id (+);

Line 758: ota_offerings o,

754: SELECT e.course_start_date,
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

Line 1863: ota_offerings o,

1859: e.course_start_time,
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

Line 2218: SELECT 1 from ota_offerings

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;
2221:
2222:

Line 2272: p_offering_id IN OTA_OFFERINGS.offering_id%type

2268: --|--< CHK_VALID_OFFERING >-------------------------------------------|
2269: --|--------------------------------------------------------------------------|
2270:
2271: FUNCTION CHK_VALID_OFFERING(
2272: p_offering_id IN OTA_OFFERINGS.offering_id%type
2273: )
2274: RETURN VARCHAR2
2275: IS
2276: -- check for presence of offering

Line 2277: CURSOR C_GET_OFR(l_offering_id OTA_OFFERINGS.offering_id%type)

2273: )
2274: RETURN VARCHAR2
2275: IS
2276: -- check for presence of offering
2277: CURSOR C_GET_OFR(l_offering_id OTA_OFFERINGS.offering_id%type)
2278: is
2279: SELECT offering_id from ota_offerings
2280: where offering_id = l_offering_id;
2281:

Line 2279: SELECT offering_id from ota_offerings

2275: IS
2276: -- check for presence of offering
2277: CURSOR C_GET_OFR(l_offering_id OTA_OFFERINGS.offering_id%type)
2278: is
2279: SELECT offering_id from ota_offerings
2280: where offering_id = l_offering_id;
2281:
2282: -- checking for expired AND BG validation
2283: CURSOR C_GET_OFR_DET(l_offering_id OTA_OFFERINGS.offering_id%type)

Line 2283: CURSOR C_GET_OFR_DET(l_offering_id OTA_OFFERINGS.offering_id%type)

2279: SELECT offering_id from ota_offerings
2280: where offering_id = l_offering_id;
2281:
2282: -- checking for expired AND BG validation
2283: CURSOR C_GET_OFR_DET(l_offering_id OTA_OFFERINGS.offering_id%type)
2284: is
2285: SELECT offering_id,end_date from ota_offerings
2286: where offering_id = l_offering_id
2287: and business_group_id = ota_general.get_business_group_id;

Line 2285: SELECT offering_id,end_date from ota_offerings

2281:
2282: -- checking for expired AND BG validation
2283: CURSOR C_GET_OFR_DET(l_offering_id OTA_OFFERINGS.offering_id%type)
2284: is
2285: SELECT offering_id,end_date from ota_offerings
2286: where offering_id = l_offering_id
2287: and business_group_id = ota_general.get_business_group_id;
2288:
2289:

Line 2290: CURSOR C_GET_EVT_ATTACHED(l_offering_id OTA_OFFERINGS.offering_id%type)

2286: where offering_id = l_offering_id
2287: and business_group_id = ota_general.get_business_group_id;
2288:
2289:
2290: CURSOR C_GET_EVT_ATTACHED(l_offering_id OTA_OFFERINGS.offering_id%type)
2291: is
2292: SELECT 1 from ota_events
2293: where parent_offering_id = l_offering_id
2294: and business_group_id = ota_general.get_business_group_id;