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_TRB_BUS dependencies on OTA_TRB_API_PROCEDURES

Line 451: ota_trb_api_procedures.check_role_to_play(p_rec.role_to_play);

447: --
448: -- Check the role_to_play field.
449: --
450: IF p_rec.role_to_play is not null THEN
451: ota_trb_api_procedures.check_role_to_play(p_rec.role_to_play);
452: END IF;
453: --
454: -- Check role_to_play is allowed to be populated.
455: --

Line 456: ota_trb_api_procedures.check_role_res_type_excl(p_rec.supplied_resource_id,

452: END IF;
453: --
454: -- Check role_to_play is allowed to be populated.
455: --
456: ota_trb_api_procedures.check_role_res_type_excl(p_rec.supplied_resource_id,
457: p_rec.role_to_play);
458: --
459: -- Check quantity_entered is allowed to be populated.
460: --

Line 462: ota_trb_api_procedures.check_quantity_entered(p_rec.supplied_resource_id,

458: --
459: -- Check quantity_entered is allowed to be populated.
460: --
461: IF p_rec.quantity is not null THEN
462: ota_trb_api_procedures.check_quantity_entered(p_rec.supplied_resource_id,
463: p_rec.quantity);
464: END IF;
465: --
466: -- Check delivery address is allowed to be populated.

Line 469: ota_trb_api_procedures.check_delivery_address(p_rec.supplied_resource_id,

465: --
466: -- Check delivery address is allowed to be populated.
467: --
468: IF p_rec.deliver_to is not null THEN
469: ota_trb_api_procedures.check_delivery_address(p_rec.supplied_resource_id,
470: p_rec.deliver_to);
471: END IF;
472: --
473: -- Check required dates validity.

Line 475: ota_trb_api_procedures.check_from_to_dates(p_rec.required_date_from,

471: END IF;
472: --
473: -- Check required dates validity.
474: --
475: ota_trb_api_procedures.check_from_to_dates(p_rec.required_date_from,
476: p_rec.required_date_to);
477: --
478: -- Check validity of required dates within suppliable resource
479: -- availability.

Line 481: ota_trb_api_procedures.check_dates_tsr(p_rec.supplied_resource_id,

477: --
478: -- Check validity of required dates within suppliable resource
479: -- availability.
480: --
481: ota_trb_api_procedures.check_dates_tsr(p_rec.supplied_resource_id,
482: p_rec.required_date_from,
483: p_rec.required_date_to,
484: p_rec.required_start_time,
485: p_rec.required_end_time,

Line 488: ota_trb_api_procedures.check_obj_booking_dates(p_rec.supplied_resource_id,

484: p_rec.required_start_time,
485: p_rec.required_end_time,
486: p_rec.timezone_code);
487: /*
488: ota_trb_api_procedures.check_obj_booking_dates(p_rec.supplied_resource_id,
489: p_rec.required_date_from,
490: p_rec.required_date_to,
491: p_rec.event_id,
492: p_rec.chat_id,

Line 502: ota_trb_api_procedures.check_evt_tsr_bus_grp(p_rec.event_id,

498: --
499: -- Check the validity of the business_group_id.
500: --
501: if p_rec.event_id is not null then
502: ota_trb_api_procedures.check_evt_tsr_bus_grp(p_rec.event_id,
503: p_rec.supplied_resource_id);
504: end if;
505: --
506: -- Check user status domain.

Line 509: ota_trb_api_procedures.check_status(p_rec.status);

505: --
506: -- Check user status domain.
507: --
508: IF p_rec.status is not null THEN
509: ota_trb_api_procedures.check_status(p_rec.status);
510: END IF;
511: --
512: -- Check that only one resource marked as a primary venue.
513: --

Line 515: ota_trb_api_procedures.check_primary_venue(p_rec.event_id,

511: --
512: -- Check that only one resource marked as a primary venue.
513: --
514: IF p_rec.primary_venue_flag is not null THEN
515: ota_trb_api_procedures.check_primary_venue(p_rec.event_id,
516: p_rec.resource_booking_id,
517: p_rec.primary_venue_flag,
518: p_rec.required_date_from,
519: p_rec.required_date_to);

Line 532: ota_trb_api_procedures.check_trainer_venue_book

528: -- no double booking check for forum and chat Trainer(Moderator).
529: if( (l_resource_type = 'T') and (p_rec.chat_id is not null or p_rec.forum_id is not null)) then
530: null;
531: else
532: ota_trb_api_procedures.check_trainer_venue_book
533: (p_rec.supplied_resource_id
534: ,p_rec.required_date_from
535: ,p_rec.required_start_time
536: ,p_rec.required_date_to

Line 547: ota_trb_api_procedures.check_event_type(p_rec.event_id);

543: --
544: -- Check the event type
545: --
546: if p_rec.event_id is not null then
547: ota_trb_api_procedures.check_event_type(p_rec.event_id);
548: end if;
549: --
550:
551: --

Line 556: ota_trb_api_procedures.check_start_end_times(p_rec.required_start_time

552: -- Check start time is after end time.
553: --
554: -- Added date check condition for bug# 3183071
555: If (trunc(p_rec.required_date_from) = trunc(p_rec.required_date_to)) then
556: ota_trb_api_procedures.check_start_end_times(p_rec.required_start_time
557: ,p_rec.required_end_time);
558: End if;
559:
560: check_timezone(p_rec.timezone_code);

Line 703: ota_trb_api_procedures.check_role_to_play(p_rec.role_to_play);

699: --
700: -- Check the role_to_play field.
701: --
702: IF l_role_to_play_changed and p_rec.role_to_play is not null THEN
703: ota_trb_api_procedures.check_role_to_play(p_rec.role_to_play);
704: END IF;
705: --
706: -- Check quantity_entered is allowed to be populated.
707: --

Line 709: ota_trb_api_procedures.check_quantity_entered(p_rec.supplied_resource_id,

705: --
706: -- Check quantity_entered is allowed to be populated.
707: --
708: IF l_quantity_changed THEN
709: ota_trb_api_procedures.check_quantity_entered(p_rec.supplied_resource_id,
710: p_rec.quantity);
711: END IF;
712: --
713: -- Check delivery address is allowed to be populated.

Line 716: ota_trb_api_procedures.check_delivery_address(p_rec.supplied_resource_id,

712: --
713: -- Check delivery address is allowed to be populated.
714: --
715: IF l_deliver_to_changed THEN
716: ota_trb_api_procedures.check_delivery_address(p_rec.supplied_resource_id,
717: p_rec.deliver_to);
718: END IF;
719: --
720: -- check required dates validity and default if necessary.

Line 726: ota_trb_api_procedures.check_from_to_dates(p_rec.required_date_from,

722: /*Adding the start_time change or end_time change or timezone change to this if,for bug6078493*/
723:
724: IF (l_required_date_from_changed OR l_required_date_to_changed
725: OR l_required_start_time_changed OR l_required_end_time_changed OR l_timezone_changed) THEN
726: ota_trb_api_procedures.check_from_to_dates(p_rec.required_date_from,
727: p_rec.required_date_to);
728: ota_trb_api_procedures.check_dates_tsr(p_rec.supplied_resource_id,
729: p_rec.required_date_from,
730: p_rec.required_date_to,

Line 728: ota_trb_api_procedures.check_dates_tsr(p_rec.supplied_resource_id,

724: IF (l_required_date_from_changed OR l_required_date_to_changed
725: OR l_required_start_time_changed OR l_required_end_time_changed OR l_timezone_changed) THEN
726: ota_trb_api_procedures.check_from_to_dates(p_rec.required_date_from,
727: p_rec.required_date_to);
728: ota_trb_api_procedures.check_dates_tsr(p_rec.supplied_resource_id,
729: p_rec.required_date_from,
730: p_rec.required_date_to,
731: p_rec.required_start_time,
732: p_rec.required_end_time,

Line 735: ota_trb_api_procedures.check_obj_booking_dates(p_rec.supplied_resource_id,

731: p_rec.required_start_time,
732: p_rec.required_end_time,
733: p_rec.timezone_code);
734: /*
735: ota_trb_api_procedures.check_obj_booking_dates(p_rec.supplied_resource_id,
736: p_rec.required_date_from,
737: p_rec.required_date_to,
738: p_rec.event_id,
739: p_rec.chat_id,

Line 751: ota_trb_api_procedures.check_status(p_rec.status);

747: --
748: -- Check status validity.
749: --
750: IF l_status_changed THEN
751: ota_trb_api_procedures.check_status(p_rec.status);
752: END IF;
753: --
754: -- Check primary venue marked only once.
755: --

Line 761: ota_trb_api_procedures.check_primary_venue(p_rec.event_id,

757: l_required_date_from_changed or
758: l_required_date_to_changed)
759: AND p_rec.primary_venue_flag = 'Y' THEN
760: --
761: ota_trb_api_procedures.check_primary_venue(p_rec.event_id,
762: p_rec.resource_booking_id,
763: p_rec.primary_venue_flag,
764: p_rec.required_date_from,
765: p_rec.required_date_to);

Line 787: ota_trb_api_procedures.check_trainer_venue_book

783: -- no double booking check for forum and chat Trainer(Moderator).
784: if( (l_resource_type = 'T') and (p_rec.chat_id is not null or p_rec.forum_id is not null)) then
785: null;
786: else
787: ota_trb_api_procedures.check_trainer_venue_book
788: (p_rec.supplied_resource_id
789: ,p_rec.required_date_from
790: ,p_rec.required_start_time
791: ,p_rec.required_date_to

Line 807: ota_trb_api_procedures.check_start_end_times(p_rec.required_start_time

803: -- added date check condition for bug# 3183071
804: if (l_required_start_time_changed or l_required_end_time_changed)
805: and (trunc(p_rec.required_date_from) = trunc(p_rec.required_date_to)) then
806: --
807: ota_trb_api_procedures.check_start_end_times(p_rec.required_start_time
808: ,p_rec.required_end_time);
809:
810: --
811: end if;