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_BUS

Line 1: Package Body ota_tdb_bus as

1: Package Body ota_tdb_bus as
2: /* $Header: ottdb01t.pkb 120.30 2011/02/07 11:01:05 shwnayak ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_tdb_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tdb_bus.'; -- Global package name
9: --
10: --***************************** STARTS HERE **********************************
11: --
12: g_event_rec ota_evt_shd.g_rec_type;

Line 268: if ( nvl(ota_tdb_bus.g_booking_id, hr_api.g_number)

264: ,p_argument => 'booking_id'
265: ,p_argument_value => p_booking_id
266: );
267: --
268: if ( nvl(ota_tdb_bus.g_booking_id, hr_api.g_number)
269: = p_booking_id) then
270: --
271: -- The legislation code has already been found with a previous
272: -- call to this function. Just return the value in the global

Line 275: l_legislation_code := ota_tdb_bus.g_legislation_code;

271: -- The legislation code has already been found with a previous
272: -- call to this function. Just return the value in the global
273: -- variable.
274: --
275: l_legislation_code := ota_tdb_bus.g_legislation_code;
276: hr_utility.set_location(l_proc, 20);
277: else
278: --
279: -- The ID is different to the last call to this function

Line 299: ota_tdb_bus.g_booking_id := p_booking_id;

295: -- Set the global variables so the values are
296: -- available for the next call to this function.
297: --
298: close csr_leg_code;
299: ota_tdb_bus.g_booking_id := p_booking_id;
300: ota_tdb_bus.g_legislation_code := l_legislation_code;
301: end if;
302: hr_utility.set_location(' Leaving:'|| l_proc, 40);
303: return l_legislation_code;

Line 300: ota_tdb_bus.g_legislation_code := l_legislation_code;

296: -- available for the next call to this function.
297: --
298: close csr_leg_code;
299: ota_tdb_bus.g_booking_id := p_booking_id;
300: ota_tdb_bus.g_legislation_code := l_legislation_code;
301: end if;
302: hr_utility.set_location(' Leaving:'|| l_proc, 40);
303: return l_legislation_code;
304: end return_legislation_code;

Line 2034: ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1)

2030: where bst.booking_status_type_id = nvl(p_booking_status_type_id,
2031: bst.booking_status_type_id)
2032: and bst.type = nvl(p_status_type, bst.type)
2033: and (p_usage_type is null or
2034: ota_tdb_bus.event_place_needed(bst.booking_status_type_id) = 1)
2035: and bst.booking_status_type_id = db.booking_status_type_id
2036: and (p_booking_id is null or
2037: p_booking_id is not null and db.booking_id <> p_booking_id)
2038: and db.internal_booking_flag = decode(p_all_or_internal,

Line 2308: and ota_tdb_bus.event_place_needed(p_booking_status_type_id) = 1 then

2304: --
2305: -- check that the booking being made is of confirmed status
2306: --
2307: if p_event_id is not null
2308: and ota_tdb_bus.event_place_needed(p_booking_status_type_id) = 1 then
2309: --
2310: -- retrieve the places confirmed and places allowed for the event
2311: --
2312: l_places_used := places_for_status

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 3909: ota_tdb_bus.chk_df(p_rec);

3905: END IF;
3906: /*Enhancement 1823602*/
3907:
3908: --Bug 3619960
3909: ota_tdb_bus.chk_df(p_rec);
3910: hr_utility.set_location(' Leaving:'||l_proc, 10);
3911: End insert_validate;
3912: --
3913: -- ----------------------------------------------------------------------------

Line 4059: ota_tdb_bus2.check_person_visible (p_rec.delegate_person_id,

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

Line 4092: ota_tdb_bus2.check_enrollment_type(p_rec.event_id,

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

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

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

Line 4119: ota_tdb_bus2.check_org_business_group (p_rec.event_id,

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

Line 4134: ota_tdb_bus2.check_spon_del_validity ( p_rec.event_id,

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

Line 4183: ota_tdb_bus2.check_person_address(p_rec.delegate_person_id,

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

Line 4191: ota_tdb_bus2.check_person_address(p_rec.sponsor_person_id,

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

Line 4206: ota_tdb_bus2.check_customer_details(p_rec.customer_id,

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

Line 4216: ota_tdb_bus2.check_organization_details (p_rec.organization_id,

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

Line 4403: ota_tdb_bus2.chk_old_event_changed

4399: ,p_rec.line_id
4400: ,p_rec.org_id);
4401:
4402: if l_old_event_id_changed then
4403: ota_tdb_bus2.chk_old_event_changed
4404: (p_rec.booking_id
4405: ,p_rec.old_event_id);
4406: end if;
4407: /* Enhancement 1823602*/

Line 4409: ota_tdb_bus2.check_commitment_date(p_rec.line_id,

4405: ,p_rec.old_event_id);
4406: end if;
4407: /* Enhancement 1823602*/
4408: IF p_rec.line_id IS NOT NULL THEN
4409: ota_tdb_bus2.check_commitment_date(p_rec.line_id,
4410: p_rec.event_id);
4411: END IF;
4412: /*Enhancement 1823602*/
4413: /* Bug 4401588 */

Line 4449: ota_tdb_bus.check_secure_event(p_rec.event_id, p_rec.delegate_person_id);

4445:
4446: -- Added for bug#4606760
4447: IF ((l_delegate_person_id_changed OR l_event_id_changed)
4448: AND p_rec.delegate_person_id IS NOT NULL) THEN
4449: ota_tdb_bus.check_secure_event(p_rec.event_id, p_rec.delegate_person_id);
4450:
4451: END IF;
4452:
4453: -- Bug#5614187 - Enrollments can not be moved from cancelled status after enrollment

Line 4462: l_status_type := ota_tdb_bus.check_enrollment_dates(p_rec.event_id, sysdate);

4458: IF l_status_type = 'C' THEN
4459: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,
4460: p_type => l_status_type) ;
4461: IF l_status_type <> 'C' THEN
4462: l_status_type := ota_tdb_bus.check_enrollment_dates(p_rec.event_id, sysdate);
4463: END IF;
4464: END IF;
4465: END IF;
4466:

Line 4469: ota_tdb_bus.chk_df(p_rec);

4465: END IF;
4466:
4467: /* bug no 4509873 */
4468: --Bug 3619960
4469: ota_tdb_bus.chk_df(p_rec);
4470: hr_utility.set_location(' Leaving:'||l_proc, 10);
4471: --
4472: End update_validate;
4473: --

Line 4514: end ota_tdb_bus;

4510: --
4511: hr_utility.set_location(' Leaving:'||l_proc, 10);
4512: End delete_validate;
4513: --
4514: end ota_tdb_bus;