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_EVT_BUS dependencies on OTA_GENERAL

Line 2346: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis

2342: l_proc varchar2(72) := 'price_basis_change';
2343: l_exists varchar2(1);
2344: --
2345: l_price_basis_changed boolean :=
2346: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis
2347: ,p_price_basis);
2348: --
2349: cursor get_enrollments is
2350: select null

Line 2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,

2448: --
2449: W_PROC varchar2 (72)
2450: := G_PACKAGE || 'VALIDITY_CHECKS';
2451: l_course_start_date_changed boolean
2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2453: p_rec.course_start_date);
2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);

Line 2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,

2451: l_course_start_date_changed boolean
2452: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2453: p_rec.course_start_date);
2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);
2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);

Line 2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,

2454: l_course_end_date_changed boolean
2455: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2456: p_rec.course_end_date);
2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);
2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);

Line 2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,

2457: l_enrolment_start_date_changed boolean
2458: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2459: p_rec.enrolment_start_date);
2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);
2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);

Line 2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,

2460: l_enrolment_end_date_changed boolean
2461: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2462: p_rec.enrolment_end_date);
2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);
2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);

Line 2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,

2463: l_public_event_flag_changed boolean
2464: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2465: p_rec.public_event_flag);
2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);
2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);

Line 2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,

2466: l_title_changed boolean
2467: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2468: p_rec.title);
2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);
2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);

Line 2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,

2469: l_maximum_attendees_changed boolean
2470: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2471: p_rec.maximum_attendees);
2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);
2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);

Line 2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,

2472: l_maximum_int_att_changed boolean
2473: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2474: p_rec.maximum_internal_attendees);
2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);
2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);

Line 2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,

2475: l_owner_id_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2477: p_rec.owner_id);
2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);
2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);

Line 2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,

2478: l_line_id_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2480: p_rec.line_id);
2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);
2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);

Line 2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,

2481: l_training_center_id_changed boolean
2482: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2483: p_rec.training_center_id);
2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);
2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);

Line 2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,

2484: l_location_id_changed boolean
2485: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2486: p_rec.location_id);
2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);
2490: l_timezone_changed boolean
2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);

Line 2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,

2487: l_offering_id_changed boolean
2488: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2489: p_rec.offering_id);
2490: l_timezone_changed boolean
2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);
2493: --bug#4895398
2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

Line 2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

2491: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2492: p_rec.timezone);
2493: --bug#4895398
2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2496:
2497: l_course_end_time_changed boolean
2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2499: --bug#4895398

Line 2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);

2494: l_course_start_time_changed boolean
2495: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2496:
2497: l_course_end_time_changed boolean
2498: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2499: --bug#4895398
2500:
2501: --Enhancement 1823602.
2502: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;

Line 2515: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2511: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2512: --
2513: -- Check only non-static domains (constraints trap the static ones)
2514: --
2515: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2516: P_DOMAIN_TYPE => 'DEV_EVENT_TYPE',
2517: P_DOMAIN_VALUE => P_REC.DEVELOPMENT_EVENT_TYPE);
2518: --
2519: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2519: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2515: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2516: P_DOMAIN_TYPE => 'DEV_EVENT_TYPE',
2517: P_DOMAIN_VALUE => P_REC.DEVELOPMENT_EVENT_TYPE);
2518: --
2519: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2520: P_DOMAIN_TYPE => 'TRAINING_CENTRE',
2521: P_DOMAIN_VALUE => P_REC.CENTRE);
2522: --
2523: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2523: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2519: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2520: P_DOMAIN_TYPE => 'TRAINING_CENTRE',
2521: P_DOMAIN_VALUE => P_REC.CENTRE);
2522: --
2523: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2524: P_DOMAIN_TYPE => 'OTA_DURATION_UNITS',
2525: P_DOMAIN_VALUE => P_REC.DURATION_UNITS);
2526: --
2527: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2527: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2523: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2524: P_DOMAIN_TYPE => 'OTA_DURATION_UNITS',
2525: P_DOMAIN_VALUE => P_REC.DURATION_UNITS);
2526: --
2527: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2528: P_DOMAIN_TYPE => 'EVENT_USER_STATUS',
2529: P_DOMAIN_VALUE => P_REC.USER_STATUS);
2530: --
2531: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2531: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2527: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2528: P_DOMAIN_TYPE => 'EVENT_USER_STATUS',
2529: P_DOMAIN_VALUE => P_REC.USER_STATUS);
2530: --
2531: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2532: P_DOMAIN_TYPE => 'SCHEDULED_EVENT_STATUS',
2533: P_DOMAIN_VALUE => P_REC.EVENT_STATUS);
2534: --
2535: OTA_GENERAL.CHECK_VENDOR_IS_VALID (

Line 2535: OTA_GENERAL.CHECK_VENDOR_IS_VALID (

2531: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2532: P_DOMAIN_TYPE => 'SCHEDULED_EVENT_STATUS',
2533: P_DOMAIN_VALUE => P_REC.EVENT_STATUS);
2534: --
2535: OTA_GENERAL.CHECK_VENDOR_IS_VALID (
2536: P_REC.VENDOR_ID,P_REC.COURSE_START_DATE);
2537: --
2538: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2539: P_REC.CURRENCY_CODE);

Line 2538: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (

2534: --
2535: OTA_GENERAL.CHECK_VENDOR_IS_VALID (
2536: P_REC.VENDOR_ID,P_REC.COURSE_START_DATE);
2537: --
2538: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2539: P_REC.CURRENCY_CODE);
2540: --
2541: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (
2542: P_REC.LANGUAGE_ID);

Line 2541: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (

2537: --
2538: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2539: P_REC.CURRENCY_CODE);
2540: --
2541: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (
2542: P_REC.LANGUAGE_ID);
2543: --
2544: if p_rec.event_id is null or l_title_changed then
2545: check_title_is_unique(

Line 3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,

3261:
3262: l_proc varchar2(72) := g_package||'chk_status_changed';
3263:
3264: l_event_status_changed boolean :=
3265: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3266: p_event_status);
3267: l_status_type ota_booking_status_types.type%type;
3268: l_old_status_type ota_booking_status_types.type%type;
3269: l_invoice_rule varchar2(80);

Line 3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);

3726: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3727: --
3728: l_proc varchar2(72) := g_package||'update_validate';
3729: l_secure_event_flag_changed boolean
3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3731: l_organization_id_changed boolean
3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3733: --
3734: Begin

Line 3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);

3728: l_proc varchar2(72) := g_package||'update_validate';
3729: l_secure_event_flag_changed boolean
3730: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3731: l_organization_id_changed boolean
3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3733: --
3734: Begin
3735: --
3736: hr_utility.set_location('Entering:'||l_proc, 5);