APPS.OTA_EL_ENROLL_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 122: FROM OTA_ACTIVITY_VERSIONS_TL

118:
119: CURSOR csr_activity(p_activity_version_id number )
120: IS
121: SELECT version_name
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;

Line 177: l_activity_version_id ota_activity_versions.activity_version_id%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.
181: -- l_return boolean;

Line 178: l_version_name ota_activity_versions.version_name%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.
181: -- l_return boolean;
182: l_offering_id ota_events.offering_id%type;

Line 1927: l_version_name ota_activity_versions.version_name%type;

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;
1930: BEGIN
1931:

Line 2122: p_activity_id IN OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type

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
2126: -- checking for expired AND INVALID activity

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

2123: )
2124: RETURN VARCHAR2
2125: IS
2126: -- checking for expired AND INVALID activity
2127: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2128: is
2129: /* Modified for Bug#3585535
2130: SELECT activity_version_id,end_date from ota_activity_versions
2131: where Activity_version_id = l_activity_id

Line 2130: SELECT activity_version_id,end_date from ota_activity_versions

2126: -- checking for expired AND INVALID activity
2127: CURSOR C_GET_ACT_DET(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)
2128: is
2129: /* Modified for Bug#3585535
2130: SELECT activity_version_id,end_date from ota_activity_versions
2131: where Activity_version_id = l_activity_id
2132: and developer_organization_id=ota_general.get_business_group_id;
2133: */
2134: SELECT activity_version_id, end_date

Line 2135: FROM ota_activity_versions tav, ota_activity_definitions tad

2131: where Activity_version_id = l_activity_id
2132: and developer_organization_id=ota_general.get_business_group_id;
2133: */
2134: SELECT activity_version_id, end_date
2135: FROM ota_activity_versions tav, ota_activity_definitions tad
2136: WHERE tav.activity_id = tad.activity_id
2137: AND tad.business_group_id = ota_general.get_business_group_id
2138: AND tav.activity_version_id = l_activity_id;
2139:

Line 2141: CURSOR C_GET_EVT_ATTACHED(l_activity_id OTA_ACTIVITY_VERSIONS.Activity_Version_Id%type)

2137: AND tad.business_group_id = ota_general.get_business_group_id
2138: AND tav.activity_version_id = l_activity_id;
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;