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_TDB_BUS dependencies on OTA_TDB_BUS2

Line 3679: ota_tdb_bus2.check_enrollment_type(p_rec.event_id,

3675:
3676: /*
3677: if p_rec.customer_id is not null then
3678:
3679: ota_tdb_bus2.check_enrollment_type(p_rec.event_id,
3680: p_rec.delegate_contact_id,
3681: p_enrollment_type,
3682: p_rec.booking_id);
3683:

Line 3689: ota_tdb_bus2.check_person_visible (p_rec.delegate_person_id,

3685: */
3686: -- check that the delegate, contact and authorizer are visible when the
3687: -- booking is made
3688: --
3689: ota_tdb_bus2.check_person_visible (p_rec.delegate_person_id,
3690: p_rec.date_booking_placed,
3691: 'Delegate',
3692: p_rec.person_address_type);
3693: --

Line 3697: ota_tdb_bus2.check_spon_del_validity (p_rec.event_id,

3693: --
3694: --
3695: -- Check that sponsor and delegate are valid for enrollment
3696: --
3697: ota_tdb_bus2.check_spon_del_validity (p_rec.event_id,
3698: p_rec.organization_id,
3699: p_rec.delegate_person_id,
3700: p_rec.sponsor_person_id,
3701: p_rec.date_booking_placed);

Line 3720: ota_tdb_bus2.check_customer_details(p_rec.customer_id,

3716: --
3717: -- Check that the delegate contact and sponsor contact exist for
3718: -- the customer for an external enrollment
3719: --
3720: ota_tdb_bus2.check_customer_details(p_rec.customer_id,
3721: p_rec.delegate_contact_id,
3722: p_rec.contact_id);
3723: --
3724: -- Checks whether contact address id is not null and that :

Line 3727: -- ota_tdb_bus2.check_contact_address (p_rec.contact_address_id,

3723: --
3724: -- Checks whether contact address id is not null and that :
3725: -- The address_id is valid for the customer
3726: --
3727: -- ota_tdb_bus2.check_contact_address (p_rec.contact_address_id,
3728: -- p_rec.customer_id);
3729: --
3730: -- Check that when an internal booking is used that certain variables
3731: -- are populated while certain other variables are null

Line 3733: ota_tdb_bus2.check_organization_details (p_rec.organization_id,

3729: --
3730: -- Check that when an internal booking is used that certain variables
3731: -- are populated while certain other variables are null
3732: --
3733: ota_tdb_bus2.check_organization_details (p_rec.organization_id,
3734: p_rec.delegate_person_id,
3735: p_rec.delegate_assignment_id,
3736: p_rec.sponsor_person_id,
3737: p_rec.sponsor_assignment_id);

Line 3800: ota_tdb_bus2.check_person_address(p_rec.delegate_person_id,

3796: if p_rec.corespondent = 'S' then
3797: --
3798: -- Check delegate has a valid address in per_addresses
3799: --
3800: ota_tdb_bus2.check_person_address(p_rec.delegate_person_id,
3801: p_rec.person_address_id,
3802: 'Delegate');
3803: --
3804: elsif p_rec.corespondent = 'C' then

Line 3808: ota_tdb_bus2.check_person_address(p_rec.sponsor_person_id,

3804: elsif p_rec.corespondent = 'C' then
3805: --
3806: -- Check contact has a valid address in per_addresses
3807: --
3808: ota_tdb_bus2.check_person_address(p_rec.sponsor_person_id,
3809: p_rec.person_address_id,
3810: 'Contact');
3811: --
3812: end if;

Line 3888: ota_tdb_bus2.check_org_business_group (p_rec.event_id,

3884: );
3885: --
3886: -- Check business group is the same for all persons and assignments
3887: --
3888: ota_tdb_bus2.check_org_business_group (p_rec.event_id,
3889: p_rec.business_group_id,
3890: p_rec.organization_id,
3891: p_rec.delegate_person_id,
3892: p_rec.sponsor_person_id,

Line 3903: ota_tdb_bus2.check_commitment_date(p_rec.line_id,

3899: ,p_rec.org_id);
3900:
3901: /*Enhancement 1823602*/
3902: IF p_rec.line_id IS NOT NULL THEN
3903: ota_tdb_bus2.check_commitment_date(p_rec.line_id,
3904: p_rec.event_id);
3905: END IF;
3906: /*Enhancement 1823602*/
3907:

Line 4057: ota_tdb_bus2.check_person_visible (p_rec.delegate_person_id,

4053: l_event_record_use := 'NEW EVENT';
4054: --
4055: end if;
4056: --
4057: ota_tdb_bus2.check_person_visible (p_rec.delegate_person_id,
4058: p_rec.date_booking_placed,
4059: 'Delegate',
4060: p_rec.person_address_type);
4061: --

Line 4090: ota_tdb_bus2.check_enrollment_type(p_rec.event_id,

4086: l_contact_id_changed or
4087: l_date_booking_placed_changed and
4088: p_rec.customer_id is not null then
4089:
4090: ota_tdb_bus2.check_enrollment_type(p_rec.event_id,
4091: p_rec.delegate_contact_id,
4092: p_enrollment_type,
4093: p_rec.booking_id);
4094:

Line 4104: -- ota_tdb_bus2.check_contact_address (p_rec.contact_address_id,

4100: -- The address_id is valid for the customer
4101: --
4102: if l_contact_address_id_changed or
4103: l_customer_id_changed then
4104: -- ota_tdb_bus2.check_contact_address (p_rec.contact_address_id,
4105: -- p_rec.customer_id);
4106: null;
4107: end if;
4108: --

Line 4117: ota_tdb_bus2.check_org_business_group (p_rec.event_id,

4113: l_sponsor_person_id_changed or
4114: l_delegate_ass_changed or
4115: l_sponsor_ass_changed then
4116: --
4117: ota_tdb_bus2.check_org_business_group (p_rec.event_id,
4118: p_rec.business_group_id,
4119: p_rec.organization_id,
4120: p_rec.delegate_person_id,
4121: p_rec.sponsor_person_id,

Line 4132: ota_tdb_bus2.check_spon_del_validity ( p_rec.event_id,

4128: if l_event_id_changed or
4129: l_delegate_person_id_changed or
4130: l_sponsor_person_id_changed or
4131: l_organization_id_changed then
4132: ota_tdb_bus2.check_spon_del_validity ( p_rec.event_id,
4133: p_rec.organization_id,
4134: p_rec.delegate_person_id,
4135: p_rec.sponsor_person_id,
4136: p_rec.date_booking_placed);

Line 4181: ota_tdb_bus2.check_person_address(p_rec.delegate_person_id,

4177: if p_rec.corespondent = 'S' then
4178: --
4179: -- Check delegate has a valid address in per_addresses
4180: --
4181: ota_tdb_bus2.check_person_address(p_rec.delegate_person_id,
4182: p_rec.person_address_id,
4183: 'Delegate');
4184: --
4185: elsif p_rec.corespondent = 'C' then

Line 4189: ota_tdb_bus2.check_person_address(p_rec.sponsor_person_id,

4185: elsif p_rec.corespondent = 'C' then
4186: --
4187: -- Check contact has a valid address in per_addresses
4188: --
4189: ota_tdb_bus2.check_person_address(p_rec.sponsor_person_id,
4190: p_rec.person_address_id,
4191: 'Contact');
4192: --
4193: end if;

Line 4204: ota_tdb_bus2.check_customer_details(p_rec.customer_id,

4200: --
4201: if l_customer_id_changed or
4202: l_delegate_contact_id_changed or
4203: l_contact_id_changed then
4204: ota_tdb_bus2.check_customer_details(p_rec.customer_id,
4205: p_rec.delegate_contact_id,
4206: p_rec.contact_id);
4207: end if;
4208: --

Line 4214: ota_tdb_bus2.check_organization_details (p_rec.organization_id,

4210: --
4211: if l_delegate_person_id_changed or
4212: l_sponsor_person_id_changed or
4213: l_organization_id_changed then
4214: ota_tdb_bus2.check_organization_details (p_rec.organization_id,
4215: p_rec.delegate_person_id,
4216: p_rec.delegate_assignment_id,
4217: p_rec.sponsor_person_id,
4218: p_rec.sponsor_assignment_id);

Line 4394: ota_tdb_bus2.chk_old_event_changed

4390: ,p_rec.line_id
4391: ,p_rec.org_id);
4392:
4393: if l_old_event_id_changed then
4394: ota_tdb_bus2.chk_old_event_changed
4395: (p_rec.booking_id
4396: ,p_rec.old_event_id);
4397: end if;
4398: /* Enhancement 1823602*/

Line 4400: ota_tdb_bus2.check_commitment_date(p_rec.line_id,

4396: ,p_rec.old_event_id);
4397: end if;
4398: /* Enhancement 1823602*/
4399: IF p_rec.line_id IS NOT NULL THEN
4400: ota_tdb_bus2.check_commitment_date(p_rec.line_id,
4401: p_rec.event_id);
4402: END IF;
4403: /*Enhancement 1823602*/
4404: /* Bug 4401588 */