DBA Data[Home] [Help]

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.26 2008/04/22 12:43:15 smahanka noship $ */
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 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 */

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

4436:
4437: -- Added for bug#4606760
4438: IF ((l_delegate_person_id_changed OR l_event_id_changed)
4439: AND p_rec.delegate_person_id IS NOT NULL) THEN
4440: ota_tdb_bus.check_secure_event(p_rec.event_id, p_rec.delegate_person_id);
4441:
4442: END IF;
4443:
4444: -- Bug#5614187 - Enrollments can not be moved from cancelled status after enrollment

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

4449: IF l_status_type = 'C' THEN
4450: ota_utility.get_booking_status_type( p_status_type_id => p_rec.booking_status_type_id,
4451: p_type => l_status_type) ;
4452: IF l_status_type <> 'C' THEN
4453: l_status_type := ota_tdb_bus.check_enrollment_dates(p_rec.event_id, sysdate);
4454: END IF;
4455: END IF;
4456: END IF;
4457:

Line 4460: ota_tdb_bus.chk_df(p_rec);

4456: END IF;
4457:
4458: /* bug no 4509873 */
4459: --Bug 3619960
4460: ota_tdb_bus.chk_df(p_rec);
4461: hr_utility.set_location(' Leaving:'||l_proc, 10);
4462: --
4463: End update_validate;
4464: --

Line 4505: end ota_tdb_bus;

4501: --
4502: hr_utility.set_location(' Leaving:'||l_proc, 10);
4503: End delete_validate;
4504: --
4505: end ota_tdb_bus;