APPS.OTA_BULK_ENROLL_UTIL dependencies on FND_PROFILE

Line 690: l_source_of_booking := fnd_profile.value('OTA_DEFAULT_ENROLLMENT_SOURCE');

686: l_delegate_id := p_person_id;
687: l_person_address_type := 'I';
688: l_corespondent := 'S';
689: -- l_source_of_booking := 'E'; Bug 5580960: removed hardcoding. Now Source of Booking will be decided by profile value OTA_DEFAULT_ENROLLMENT_SOURCE
690: l_source_of_booking := fnd_profile.value('OTA_DEFAULT_ENROLLMENT_SOURCE');
691:
692: l_restricted_assignment_id := p_assignment_id;
693:
694: --Modified for bug#5579345

Line 906: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');

902: ,p_delegate_person_id => l_delegate_id
903: ,p_delegate_contact_id => p_delegate_contact_id
904: ,p_booking_id => l_booking_id);
905:
906: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
907: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
908: l_user := FND_PROFILE.value('USER_ID');
909:
910: IF (l_cancel_boolean) THEN

Line 907: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');

903: ,p_delegate_contact_id => p_delegate_contact_id
904: ,p_booking_id => l_booking_id);
905:
906: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
907: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
908: l_user := FND_PROFILE.value('USER_ID');
909:
910: IF (l_cancel_boolean) THEN
911: --

Line 908: l_user := FND_PROFILE.value('USER_ID');

904: ,p_booking_id => l_booking_id);
905:
906: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
907: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
908: l_user := FND_PROFILE.value('USER_ID');
909:
910: IF (l_cancel_boolean) THEN
911: --
912: -- Delegate has a Cancelled status for this event, hence

Line 1654: l_threshold := FND_PROFILE.VALUE('OTA_MAX_ENR_PRC_ONLINE');

1650: l_learners_selected NUMBER := 0;
1651: l_request_rec csr_get_request_info%ROWTYPE;
1652:
1653: BEGIN
1654: l_threshold := FND_PROFILE.VALUE('OTA_MAX_ENR_PRC_ONLINE');
1655:
1656: IF l_threshold IS NULL THEN l_threshold := 0; END IF;
1657: SELECT count(person_id)
1658: INTO l_learners_selected