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_AME_ATTRIBUTES dependencies on OTA_EVENTS

Line 72: c_class_standard_price ota_events.standard_price%type;

68:
69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number is
72: c_class_standard_price ota_events.standard_price%type;
73: c_event_id ota_events.event_id%type;
74: c_item_type varchar2(50);
75: c_item_key varchar2(100);
76:

Line 73: c_event_id ota_events.event_id%type;

69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number is
72: c_class_standard_price ota_events.standard_price%type;
73: c_event_id ota_events.event_id%type;
74: c_item_type varchar2(50);
75: c_item_key varchar2(100);
76:
77: cursor c_get_standard_price is

Line 79: from ota_events

75: c_item_key varchar2(100);
76:
77: cursor c_get_standard_price is
78: select standard_price
79: from ota_events
80: where event_id = c_event_id;
81:
82: begin
83:

Line 124: c_event_id ota_events.event_id%type;

120: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
121: return varchar2 is
122:
123: c_lp_name ota_learning_paths_tl.name%type;
124: c_event_id ota_events.event_id%type;
125: c_item_type varchar2(50);
126: c_item_key varchar2(100);
127:
128: l_lp_name ota_learning_paths_tl.name%type;

Line 132: from ota_events oev,ota_training_plans otp, ota_training_plan_members otpm,

128: l_lp_name ota_learning_paths_tl.name%type;
129:
130: /*cursor c_get_lp_name is
131: select olpt.name
132: from ota_events oev,ota_training_plans otp, ota_training_plan_members otpm,
133: ota_learning_paths_tl olpt
134: where oev.activity_version_id = otpm.activity_version_id
135: and otpm.member_status_type_id='OTA_COMPLETED'
136: and otpm.training_plan_id=otp.training_plan_id

Line 190: c_event_id ota_events.event_id%type;

186: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
187: return varchar2 is
188:
189: c_course_category ota_category_usages_tl.category%type;
190: c_event_id ota_events.event_id%type;
191: c_item_type varchar2(50);
192: c_item_key varchar2(100);
193:
194: cursor c_get_course_category is

Line 198: ota_events oev,

194: cursor c_get_course_category is
195: Select ocu.Category
196: From ota_act_cat_inclusions oaci,
197: ota_category_usages_vl ocu,
198: ota_events oev,
199: ota_offerings ofr
200: Where oev.event_id = c_event_id
201: AND oev.parent_offering_id = ofr.offering_id
202: AND ofr.activity_version_id = oaci.activity_version_id

Line 303: c_event_id ota_events.event_id%type;

299: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
300: return varchar2 is
301:
302: c_delivery_mode ota_category_usages_tl.category%type;
303: c_event_id ota_events.event_id%type;
304: c_offering_id ota_offerings.offering_id%type;
305: c_item_type varchar2(50);
306: c_item_key varchar2(100);
307:

Line 320: From ota_events

316: AND nvl(TRUNC(ocu.end_date_active), TRUNC(sysdate)));
317:
318: cursor c_get_ofr_id is
319: Select parent_offering_id
320: From ota_events
321: Where event_id = c_event_id;
322: begin
323:
324: c_item_type := get_item_type(p_transaction_id);

Line 366: c_event_id ota_events.event_id%type;

362: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
363: return varchar2 is
364:
365: c_course_name ota_activity_versions_tl.version_name%type;
366: c_event_id ota_events.event_id%type;
367: c_item_type varchar2(50);
368: c_item_key varchar2(100);
369:
370: cursor c_get_course_name is

Line 372: From ota_events oev,

368: c_item_key varchar2(100);
369:
370: cursor c_get_course_name is
371: Select oav.version_name
372: From ota_events oev,
373: ota_activity_versions_tl oav
374: Where oev.activity_version_id = oav.activity_version_id
375: And oav.language = USERENV ('LANG')
376: And oev.event_id = c_event_id;

Line 415: c_event_id ota_events.event_id%type;

411: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
412: return varchar2 is
413:
414: c_offering_name ota_offerings_tl.name%type;
415: c_event_id ota_events.event_id%type;
416: c_item_type varchar2(50);
417: c_item_key varchar2(100);
418:
419: cursor c_get_offering_name is

Line 421: From ota_events oev,

417: c_item_key varchar2(100);
418:
419: cursor c_get_offering_name is
420: Select ofr.name
421: From ota_events oev,
422: ota_offerings_tl ofr
423: Where oev.parent_offering_id = ofr.offering_id
424: And ofr.language = USERENV ('LANG')
425: And oev.event_id = c_event_id;

Line 463: c_class_name ota_events_tl.title%type;

459: function get_class_name
460: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
461: return varchar2 is
462:
463: c_class_name ota_events_tl.title%type;
464: c_event_id ota_events.event_id%type;
465: c_item_type varchar2(50);
466: c_item_key varchar2(100);
467:

Line 464: c_event_id ota_events.event_id%type;

460: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
461: return varchar2 is
462:
463: c_class_name ota_events_tl.title%type;
464: c_event_id ota_events.event_id%type;
465: c_item_type varchar2(50);
466: c_item_key varchar2(100);
467:
468: cursor c_get_class_name is

Line 470: From ota_events_tl oev

466: c_item_key varchar2(100);
467:
468: cursor c_get_class_name is
469: Select oev.title
470: From ota_events_tl oev
471: Where oev.language = USERENV ('LANG')
472: And oev.event_id = c_event_id;
473: begin
474:

Line 511: c_event_id ota_events.event_id%type;

507: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
508: return varchar2 is
509:
510: c_class_location hr_locations_all.location_code%type;
511: c_event_id ota_events.event_id%type;
512: c_item_type varchar2(50);
513: c_item_key varchar2(100);
514:
515: cursor c_get_class_location is

Line 517: From ota_events oev

513: c_item_key varchar2(100);
514:
515: cursor c_get_class_location is
516: Select ota_general.get_location_code(ota_utility.get_event_location(oev.event_id)) Location_Name
517: From ota_events oev
518: Where oev.event_id = c_event_id;
519:
520: begin
521:

Line 558: --c_certification_id ota_events.event_id%type;

554: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
555: return varchar2 is
556:
557: c_certification_name ota_certifications_tl.name%type;
558: --c_certification_id ota_events.event_id%type;
559: c_item_type varchar2(50);
560: c_item_key varchar2(100);
561:
562: