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 757: ota_offerings o,

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

Line 1862: ota_offerings o,

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

Line 2217: SELECT 1 from ota_offerings

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

Line 2271: p_offering_id IN OTA_OFFERINGS.offering_id%type

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

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

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

Line 2278: SELECT offering_id from ota_offerings

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

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

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

Line 2284: SELECT offering_id,end_date from ota_offerings

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

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

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