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_LO_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

Line 153: p_booking_id ota_delegate_bookings.booking_id%type,

149: end get_contact_id_for_party;
150:
151:
152: procedure update_enrollment(
153: p_booking_id ota_delegate_bookings.booking_id%type,
154: p_event_id ota_events.event_id%type,
155: p_business_group_id ota_delegate_bookings.business_group_id%type,
156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
157: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 155: p_business_group_id ota_delegate_bookings.business_group_id%type,

151:
152: procedure update_enrollment(
153: p_booking_id ota_delegate_bookings.booking_id%type,
154: p_event_id ota_events.event_id%type,
155: p_business_group_id ota_delegate_bookings.business_group_id%type,
156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
157: p_object_version_number ota_delegate_bookings.object_version_number%type,
158: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
159: p_new_status varchar2) is

Line 156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

152: procedure update_enrollment(
153: p_booking_id ota_delegate_bookings.booking_id%type,
154: p_event_id ota_events.event_id%type,
155: p_business_group_id ota_delegate_bookings.business_group_id%type,
156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
157: p_object_version_number ota_delegate_bookings.object_version_number%type,
158: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
159: p_new_status varchar2) is
160:

Line 157: p_object_version_number ota_delegate_bookings.object_version_number%type,

153: p_booking_id ota_delegate_bookings.booking_id%type,
154: p_event_id ota_events.event_id%type,
155: p_business_group_id ota_delegate_bookings.business_group_id%type,
156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
157: p_object_version_number ota_delegate_bookings.object_version_number%type,
158: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
159: p_new_status varchar2) is
160:
161:

Line 158: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

154: p_event_id ota_events.event_id%type,
155: p_business_group_id ota_delegate_bookings.business_group_id%type,
156: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
157: p_object_version_number ota_delegate_bookings.object_version_number%type,
158: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
159: p_new_status varchar2) is
160:
161:
162: begin

Line 168: p_booking_id ota_delegate_bookings.booking_id%type,

164:
165: end update_enrollment;
166:
167: procedure update_enrollment(
168: p_booking_id ota_delegate_bookings.booking_id%type,
169: p_event_id ota_events.event_id%type,
170: p_business_group_id ota_delegate_bookings.business_group_id%type,
171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
172: p_object_version_number ota_delegate_bookings.object_version_number%type,

Line 170: p_business_group_id ota_delegate_bookings.business_group_id%type,

166:
167: procedure update_enrollment(
168: p_booking_id ota_delegate_bookings.booking_id%type,
169: p_event_id ota_events.event_id%type,
170: p_business_group_id ota_delegate_bookings.business_group_id%type,
171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
172: p_object_version_number ota_delegate_bookings.object_version_number%type,
173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
174: p_new_status varchar2,

Line 171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,

167: procedure update_enrollment(
168: p_booking_id ota_delegate_bookings.booking_id%type,
169: p_event_id ota_events.event_id%type,
170: p_business_group_id ota_delegate_bookings.business_group_id%type,
171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
172: p_object_version_number ota_delegate_bookings.object_version_number%type,
173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
174: p_new_status varchar2,
175: p_failed varchar2) is

Line 172: p_object_version_number ota_delegate_bookings.object_version_number%type,

168: p_booking_id ota_delegate_bookings.booking_id%type,
169: p_event_id ota_events.event_id%type,
170: p_business_group_id ota_delegate_bookings.business_group_id%type,
171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
172: p_object_version_number ota_delegate_bookings.object_version_number%type,
173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
174: p_new_status varchar2,
175: p_failed varchar2) is
176:

Line 173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,

169: p_event_id ota_events.event_id%type,
170: p_business_group_id ota_delegate_bookings.business_group_id%type,
171: p_date_booking_placed ota_delegate_bookings.date_booking_placed%type,
172: p_object_version_number ota_delegate_bookings.object_version_number%type,
173: p_date_status_changed ota_delegate_bookings.date_status_changed%type,
174: p_new_status varchar2,
175: p_failed varchar2) is
176:
177: v_result_object_version_number ota_finance_lines.object_version_number%type;

Line 180: v_object_version_number ota_delegate_bookings.object_version_number%type;

176:
177: v_result_object_version_number ota_finance_lines.object_version_number%type;
178: v_finance_line_id ota_finance_lines.finance_line_id%type;
179: v_booking_status_row ota_booking_status_types%rowtype;
180: v_object_version_number ota_delegate_bookings.object_version_number%type;
181: l_successful_attendance_flag varchar2(1):='N';
182: l_failure_reason varchar2(20);
183: begin
184: v_finance_line_id := null;

Line 227: p_person_id ota_delegate_bookings.delegate_person_id%type) is

223:
224:
225: cursor person_bookings(
226: p_event_id ota_events.event_id%type,
227: p_person_id ota_delegate_bookings.delegate_person_id%type) is
228: select book.booking_id,
229: ev.event_id,
230: book.business_group_id,
231: book.date_booking_placed,

Line 234: ota_delegate_bookings book,

230: book.business_group_id,
231: book.date_booking_placed,
232: book.object_version_number
233: from ota_events ev,
234: ota_delegate_bookings book,
235: ota_booking_status_types stype
236: where nvl(ev.course_start_date, sysdate) <= sysdate and
237: book.event_id = ev.event_id and
238: book.delegate_person_id = p_person_id and

Line 246: p_party_id ota_delegate_bookings.delegate_contact_id%type) is

242:
243: --Added for 6826434.
244: cursor party_bookings(
245: p_event_id ota_events.event_id%type,
246: p_party_id ota_delegate_bookings.delegate_contact_id%type) is
247: select book.booking_id,
248: ev.event_id,
249: book.business_group_id,
250: book.date_booking_placed,

Line 253: ota_delegate_bookings book,

249: book.business_group_id,
250: book.date_booking_placed,
251: book.object_version_number
252: from ota_events ev,
253: ota_delegate_bookings book,
254: ota_booking_status_types stype,
255: hz_cust_account_roles acct_role,
256: hz_relationships rel,
257: hz_cust_accounts role_acct

Line 364: p_person_id ota_delegate_bookings.delegate_person_id%type) is

360: -- use source_learning_object_id here in case reuse by reference is ever
361: -- implemented.
362: cursor person_bookings(
363: p_lo_id ota_learning_objects.learning_object_id%type,
364: p_person_id ota_delegate_bookings.delegate_person_id%type) is
365: select book.booking_id,
366: ev.event_id,
367: book.business_group_id,
368: book.date_booking_placed,

Line 374: ota_delegate_bookings book,

370: stype.type --Added for 7110517.
371: from ota_events ev,
372: ota_offerings offr,
373: ota_learning_objects lo,
374: ota_delegate_bookings book,
375: ota_booking_status_types stype
376: where lo.source_learning_object_id = p_lo_id and
377: lo.learning_object_id = offr.learning_object_id and
378: offr.offering_id = ev.parent_offering_id and

Line 394: p_party_id ota_delegate_bookings.delegate_contact_id%type) is

390: -- which the party is enrolled. Note that we use source_learning_object_id
391: -- here in case reuse by reference is ever implemented.
392: cursor party_bookings(
393: p_lo_id ota_learning_objects.learning_object_id%type,
394: p_party_id ota_delegate_bookings.delegate_contact_id%type) is
395: select book.booking_id,
396: ev.event_id,
397: book.business_group_id,
398: book.date_booking_placed,

Line 404: ota_delegate_bookings book,

400: stype.type --Added fro 7110517.
401: from ota_events ev,
402: ota_offerings offr,
403: ota_learning_objects lo,
404: ota_delegate_bookings book,
405: ota_booking_status_types stype,
406: hz_cust_account_roles acct_role,
407: hz_relationships rel,
408: hz_cust_accounts role_acct

Line 1353: from ota_delegate_bookings book,

1349: cursor person_bookings(
1350: p_event_id ota_events.event_id%type,
1351: p_person_id per_all_people.person_id%type) is
1352: select 1
1353: from ota_delegate_bookings book,
1354: ota_booking_status_types stype
1355: where book.delegate_person_id = p_person_id and
1356: book.event_id = p_event_id and
1357: book.booking_status_type_id = stype.booking_status_type_id and

Line 1364: from ota_delegate_bookings book,

1360: cursor contact_bookings(
1361: p_event_id ota_events.event_id%type,
1362: p_contact_id per_all_people.person_id%type) is
1363: select 1
1364: from ota_delegate_bookings book,
1365: ota_booking_status_types stype
1366: where book.delegate_contact_id = p_contact_id and
1367: book.event_id = p_event_id and
1368: book.booking_status_type_id = stype.booking_status_type_id and

Line 2342: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,

2338:
2339: function get_play_eval_button(
2340: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2341: p_user_id fnd_user.user_id%type,
2342: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2343: p_object_id OTA_EVALUATIONS.OBJECT_ID%TYPE,
2344: p_object_type OTA_EVALUATIONS.OBJECT_TYPE%TYPE,
2345: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2346: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is

Line 2448: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,

2444:
2445: function get_admin_eval_status(
2446: p_event_id OTA_EVENTS.EVENT_ID%TYPE,
2447: p_user_id fnd_user.user_id%type,
2448: p_booking_status_type_id OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID%TYPE,
2449: p_mand_flag OTA_EVALUATIONS.EVAL_MANDATORY_FLAG%TYPE,
2450: p_test_id OTA_TESTS.TEST_ID%TYPE) return varchar2 is
2451:
2452: l_is_mandatory boolean:= true;

Line 2701: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

2697: --
2698: FUNCTION get_player_status(p_user_id IN NUMBER,
2699: p_user_type IN ota_attempts.user_type%type,
2700: p_event_id IN ota_events.event_id%TYPE,
2701: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
2702: RETURN VARCHAR2 IS
2703:
2704: CURSOR c_learning_object IS
2705: SELECT ofr.learning_object_id

Line 2720: FROM ota_delegate_bookings

2716: AND cert_prd_enrollment_id is null;
2717:
2718: CURSOR c_odb_lo_status IS
2719: SELECT content_player_status
2720: FROM ota_delegate_bookings
2721: WHERE booking_id = p_booking_id;
2722:
2723: CURSOR c_imported_offering IS
2724: SELECT offering_id

Line 2750: -- OTA_DELEGATE_BOOKINGS

2746: close c_imported_offering;
2747:
2748: If (l_imported_offering is not null) Then
2749: -- Imported Offering, Status code should be taken from
2750: -- OTA_DELEGATE_BOOKINGS
2751: open c_odb_lo_status;
2752: fetch c_odb_lo_status into l_status;
2753: close c_odb_lo_status;
2754: Else

Line 2801: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

2797: --
2798: FUNCTION get_enroll_lo_time(p_user_id IN NUMBER,
2799: p_user_type IN ota_attempts.user_type%type,
2800: p_event_id IN ota_events.event_id%TYPE,
2801: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
2802: RETURN VARCHAR2 IS
2803:
2804: CURSOR c_learning_object IS
2805: SELECT ofr.learning_object_id

Line 2820: FROM ota_delegate_bookings

2816: AND cert_prd_enrollment_id is null;
2817:
2818: CURSOR c_odb_lo_time IS
2819: SELECT total_training_time
2820: FROM ota_delegate_bookings
2821: WHERE booking_id = p_booking_id;
2822:
2823: CURSOR c_imported_offering IS
2824: SELECT offering_id

Line 2850: -- OTA_DELEGATE_BOOKINGS

2846: close c_imported_offering;
2847:
2848: If (l_imported_offering is not null) Then
2849: -- Imported Offering, Score should be taken from
2850: -- OTA_DELEGATE_BOOKINGS
2851: open c_odb_lo_time;
2852: fetch c_odb_lo_time into l_time;
2853: close c_odb_lo_time;
2854: Else

Line 2901: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)

2897: --
2898: FUNCTION get_enroll_lo_score(p_user_id IN NUMBER,
2899: p_user_type IN ota_attempts.user_type%type,
2900: p_event_id IN ota_events.event_id%TYPE,
2901: p_booking_id IN ota_delegate_bookings.booking_id%TYPE)
2902: RETURN VARCHAR2 IS
2903:
2904: CURSOR c_learning_object IS
2905: SELECT ofr.learning_object_id

Line 2920: FROM ota_delegate_bookings

2916: AND cert_prd_enrollment_id is null;
2917:
2918: CURSOR c_odb_lo_score IS
2919: SELECT score
2920: FROM ota_delegate_bookings
2921: WHERE booking_id = p_booking_id;
2922:
2923: CURSOR c_imported_offering IS
2924: SELECT offering_id

Line 2950: -- OTA_DELEGATE_BOOKINGS

2946: close c_imported_offering;
2947:
2948: If (l_imported_offering is not null) Then
2949: -- Imported Offering, Score should be taken from
2950: -- OTA_DELEGATE_BOOKINGS
2951: open c_odb_lo_score;
2952: fetch c_odb_lo_score into l_score;
2953: close c_odb_lo_score;
2954: Else

Line 3008: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

3004: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
3005: p_user_type IN ota_attempts.user_type%type,
3006: p_event_id IN ota_events.event_id%TYPE,
3007: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3008: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3009: p_mode IN number default null,
3010: p_chk_active_cert_flag varchar2 default 'N')
3011: RETURN VARCHAR2 IS
3012:

Line 3041: FROM ota_delegate_bookings

3037:
3038: CURSOR c_odb_lo_status IS
3039: SELECT CONTENT_PLAYER_STATUS,
3040: hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS',CONTENT_PLAYER_STATUS)lesson_status_name
3041: FROM ota_delegate_bookings
3042: WHERE booking_id = p_booking_id;
3043:
3044: CURSOR c_imported_offering IS
3045: SELECT offering_id

Line 3068: from ota_delegate_bookings

3064: order by decode_lesson_status;
3065:
3066: cursor csr_contact_id is
3067: select delegate_contact_id
3068: from ota_delegate_bookings
3069: where booking_id = p_booking_id;
3070:
3071:
3072: l_proc VARCHAR2(72) := g_package|| 'get_enroll_lo_status';

Line 3117: -- OTA_DELEGATE_BOOKINGS

3113: close c_imported_offering;
3114:
3115: If (l_imported_offering is not null) Then
3116: -- Imported Offering, Status should be taken from
3117: -- OTA_DELEGATE_BOOKINGS
3118: open c_odb_lo_status;
3119: fetch c_odb_lo_status into l_status, l_status_name;
3120: close c_odb_lo_status;
3121: Else

Line 3232: p_booking_id ota_delegate_bookings.booking_id%TYPE)

3228:
3229: FUNCTION get_history_button(p_user_id fnd_user.user_id%TYPE,
3230: p_lo_id ota_learning_objects.learning_object_id%TYPE,
3231: p_event_id ota_events.event_id%TYPE,
3232: p_booking_id ota_delegate_bookings.booking_id%TYPE)
3233: RETURN VARCHAR2 IS
3234:
3235: l_return VARCHAR2(100);
3236: l_enable_move_to_history boolean;

Line 3257: FROM ota_delegate_bookings odb,

3253: AND lesson_status IN ('P', 'C');
3254:
3255: CURSOR c_booking_status_type IS
3256: SELECT type
3257: FROM ota_delegate_bookings odb,
3258: ota_booking_status_types bst
3259: WHERE booking_id = p_booking_id
3260: and odb.booking_status_type_id = bst.booking_status_type_id;
3261:

Line 3264: FROM ota_delegate_bookings

3260: and odb.booking_status_type_id = bst.booking_status_type_id;
3261:
3262: CURSOR c_history_enabled_odb IS
3263: SELECT content_player_status
3264: FROM ota_delegate_bookings
3265: WHERE booking_id = p_booking_id
3266: AND content_player_status in ('P', 'C');
3267:
3268: BEGIN

Line 3292: -- OTA_DELEGATE_BOOKINGS - Bug 3725560

3288: CLOSE c_imported_offering;
3289:
3290: IF (l_imported_offering is not null) Then
3291: -- Imported Offering, Status should be taken from
3292: -- OTA_DELEGATE_BOOKINGS - Bug 3725560
3293: OPEN c_history_enabled_odb;
3294: FETCH c_history_enabled_odb INTO l_type;
3295: CLOSE c_history_enabled_odb;
3296: ELSE

Line 3554: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,

3550: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
3551: p_user_type IN ota_attempts.user_type%type,
3552: p_event_id IN ota_events.event_id%TYPE,
3553: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
3554: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
3555: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
3556: p_mode IN number default null)
3557: RETURN VARCHAR2 IS
3558:

Line 3850: ota_delegate_bookings tdb,

3846: ocu.synchronous_flag,
3847: ocu.online_flag,
3848: bst.type
3849: FROM ota_events evt,
3850: ota_delegate_bookings tdb,
3851: ota_booking_status_types bst,
3852: ota_offerings ofr,
3853: ota_category_usages ocu
3854: WHERE evt.event_id = tdb.event_id

Line 4266: ota_delegate_bookings tdb,

4262: ocu.synchronous_flag,
4263: ocu.online_flag,
4264: bst.type
4265: FROM ota_events evt,
4266: ota_delegate_bookings tdb,
4267: ota_booking_status_types bst,
4268: ota_offerings ofr,
4269: ota_category_usages ocu
4270: WHERE evt.event_id = tdb.event_id

Line 4462: ota_delegate_bookings tdb,

4458: ocu.synchronous_flag,
4459: ocu.online_flag,
4460: bst.type
4461: FROM ota_events evt,
4462: ota_delegate_bookings tdb,
4463: ota_booking_status_types bst,
4464: ota_offerings ofr,
4465: ota_category_usages ocu
4466: WHERE evt.event_id = tdb.event_id

Line 4782: ota_delegate_bookings tdb,

4778: ocu.synchronous_flag,
4779: ocu.online_flag,
4780: bst.type
4781: FROM ota_events evt,
4782: ota_delegate_bookings tdb,
4783: ota_booking_status_types bst,
4784: ota_offerings ofr,
4785: ota_category_usages ocu
4786: WHERE evt.event_id = tdb.event_id