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 907: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');

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

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

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

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

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

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

1944:
1945: --This is bulk enroll to class/lp/cert
1946: if(p_enr_request_id_end IS NULL and p_enr_request_id IS NOT NULL) then
1947:
1948: l_threshold := FND_PROFILE.VALUE('OTA_MAX_ENR_PRC_ONLINE');
1949:
1950: IF l_threshold IS NULL THEN l_threshold := 0; END IF;
1951: SELECT count(person_id)
1952: INTO l_learners_selected