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 2327: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis

2323: l_proc varchar2(72) := 'price_basis_change';
2324: l_exists varchar2(1);
2325: --
2326: l_price_basis_changed boolean :=
2327: ota_general.value_changed(ota_evt_shd.g_old_rec.price_basis
2328: ,p_price_basis);
2329: --
2330: cursor get_enrollments is
2331: select null

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

2429: --
2430: W_PROC varchar2 (72)
2431: := G_PACKAGE || 'VALIDITY_CHECKS';
2432: l_course_start_date_changed boolean
2433: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2434: p_rec.course_start_date);
2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);

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

2432: l_course_start_date_changed boolean
2433: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_date,
2434: p_rec.course_start_date);
2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);
2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);

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

2435: l_course_end_date_changed boolean
2436: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_date,
2437: p_rec.course_end_date);
2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);
2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);

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

2438: l_enrolment_start_date_changed boolean
2439: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_start_date,
2440: p_rec.enrolment_start_date);
2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);
2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);

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

2441: l_enrolment_end_date_changed boolean
2442: := ota_general.value_changed(ota_evt_shd.g_old_rec.enrolment_end_date,
2443: p_rec.enrolment_end_date);
2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);
2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);

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

2444: l_public_event_flag_changed boolean
2445: := ota_general.value_changed(ota_evt_shd.g_old_rec.public_event_flag,
2446: p_rec.public_event_flag);
2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);
2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);

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

2447: l_title_changed boolean
2448: := ota_general.value_changed(ota_evt_shd.g_old_rec.title,
2449: p_rec.title);
2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);
2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);

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

2450: l_maximum_attendees_changed boolean
2451: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_attendees,
2452: p_rec.maximum_attendees);
2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);
2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);

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

2453: l_maximum_int_att_changed boolean
2454: := ota_general.value_changed(ota_evt_shd.g_old_rec.maximum_internal_attendees,
2455: p_rec.maximum_internal_attendees);
2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);
2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);

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

2456: l_owner_id_changed boolean
2457: := ota_general.value_changed(ota_evt_shd.g_old_rec.owner_id,
2458: p_rec.owner_id);
2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);
2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);

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

2459: l_line_id_changed boolean
2460: := ota_general.value_changed(ota_evt_shd.g_old_rec.line_id,
2461: p_rec.line_id);
2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);
2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);

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

2462: l_training_center_id_changed boolean
2463: := ota_general.value_changed(ota_evt_shd.g_old_rec.training_center_id,
2464: p_rec.training_center_id);
2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);
2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);

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

2465: l_location_id_changed boolean
2466: := ota_general.value_changed(ota_evt_shd.g_old_rec.location_id,
2467: p_rec.location_id);
2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);
2471: l_timezone_changed boolean
2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);

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

2468: l_offering_id_changed boolean
2469: := ota_general.value_changed(ota_evt_shd.g_old_rec.offering_id,
2470: p_rec.offering_id);
2471: l_timezone_changed boolean
2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);
2474: --bug#4895398
2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);

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

2472: := ota_general.value_changed(ota_evt_shd.g_old_rec.timezone,
2473: p_rec.timezone);
2474: --bug#4895398
2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2477:
2478: l_course_end_time_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2480: --bug#4895398

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

2475: l_course_start_time_changed boolean
2476: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_start_time,p_rec.course_start_time);
2477:
2478: l_course_end_time_changed boolean
2479: := ota_general.value_changed(ota_evt_shd.g_old_rec.course_end_time,p_rec.course_end_time);
2480: --bug#4895398
2481:
2482: --Enhancement 1823602.
2483: l_commitment_id ra_customer_trx_all.customer_trx_id%TYPE;

Line 2496: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2492: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2493: --
2494: -- Check only non-static domains (constraints trap the static ones)
2495: --
2496: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2497: P_DOMAIN_TYPE => 'DEV_EVENT_TYPE',
2498: P_DOMAIN_VALUE => P_REC.DEVELOPMENT_EVENT_TYPE);
2499: --
2500: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2500: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2496: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2497: P_DOMAIN_TYPE => 'DEV_EVENT_TYPE',
2498: P_DOMAIN_VALUE => P_REC.DEVELOPMENT_EVENT_TYPE);
2499: --
2500: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2501: P_DOMAIN_TYPE => 'TRAINING_CENTRE',
2502: P_DOMAIN_VALUE => P_REC.CENTRE);
2503: --
2504: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2504: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2500: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2501: P_DOMAIN_TYPE => 'TRAINING_CENTRE',
2502: P_DOMAIN_VALUE => P_REC.CENTRE);
2503: --
2504: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2505: P_DOMAIN_TYPE => 'OTA_DURATION_UNITS',
2506: P_DOMAIN_VALUE => P_REC.DURATION_UNITS);
2507: --
2508: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2508: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2504: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2505: P_DOMAIN_TYPE => 'OTA_DURATION_UNITS',
2506: P_DOMAIN_VALUE => P_REC.DURATION_UNITS);
2507: --
2508: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2509: P_DOMAIN_TYPE => 'EVENT_USER_STATUS',
2510: P_DOMAIN_VALUE => P_REC.USER_STATUS);
2511: --
2512: OTA_GENERAL.CHECK_DOMAIN_VALUE (

Line 2512: OTA_GENERAL.CHECK_DOMAIN_VALUE (

2508: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2509: P_DOMAIN_TYPE => 'EVENT_USER_STATUS',
2510: P_DOMAIN_VALUE => P_REC.USER_STATUS);
2511: --
2512: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2513: P_DOMAIN_TYPE => 'SCHEDULED_EVENT_STATUS',
2514: P_DOMAIN_VALUE => P_REC.EVENT_STATUS);
2515: --
2516: OTA_GENERAL.CHECK_VENDOR_IS_VALID (

Line 2516: OTA_GENERAL.CHECK_VENDOR_IS_VALID (

2512: OTA_GENERAL.CHECK_DOMAIN_VALUE (
2513: P_DOMAIN_TYPE => 'SCHEDULED_EVENT_STATUS',
2514: P_DOMAIN_VALUE => P_REC.EVENT_STATUS);
2515: --
2516: OTA_GENERAL.CHECK_VENDOR_IS_VALID (
2517: P_REC.VENDOR_ID,P_REC.COURSE_START_DATE);
2518: --
2519: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2520: P_REC.CURRENCY_CODE);

Line 2519: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (

2515: --
2516: OTA_GENERAL.CHECK_VENDOR_IS_VALID (
2517: P_REC.VENDOR_ID,P_REC.COURSE_START_DATE);
2518: --
2519: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2520: P_REC.CURRENCY_CODE);
2521: --
2522: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (
2523: P_REC.LANGUAGE_ID);

Line 2522: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (

2518: --
2519: OTA_GENERAL.CHECK_CURRENCY_IS_VALID (
2520: P_REC.CURRENCY_CODE);
2521: --
2522: OTA_GENERAL.CHECK_LANGUAGE_IS_VALID (
2523: P_REC.LANGUAGE_ID);
2524: --
2525: if p_rec.event_id is null or l_title_changed then
2526: check_title_is_unique(

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

3241:
3242: l_proc varchar2(72) := g_package||'chk_status_changed';
3243:
3244: l_event_status_changed boolean :=
3245: ota_general.value_changed (ota_evt_shd.g_old_rec.event_status,
3246: p_event_status);
3247: l_status_type ota_booking_status_types.type%type;
3248: l_old_status_type ota_booking_status_types.type%type;
3249: l_invoice_rule varchar2(80);

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

3706: Procedure update_validate(p_rec in out nocopy ota_evt_shd.g_rec_type) is
3707: --
3708: l_proc varchar2(72) := g_package||'update_validate';
3709: l_secure_event_flag_changed boolean
3710: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3711: l_organization_id_changed boolean
3712: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3713: --
3714: Begin

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

3708: l_proc varchar2(72) := g_package||'update_validate';
3709: l_secure_event_flag_changed boolean
3710: := ota_general.value_changed(ota_evt_shd.g_old_rec.secure_event_flag, p_rec.secure_event_flag);
3711: l_organization_id_changed boolean
3712: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3713: --
3714: Begin
3715: --
3716: hr_utility.set_location('Entering:'||l_proc, 5);