[Home] [Help]
1061: l_contact_id number;
1062: l_student_id number;
1063: l_event_status ota_events.event_status%type;
1064: l_business_group_id number ;
1065: -- l_business_group_id number:=FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1066: l_ship_to_org_id number;
1067: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
1068: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
1069: --Third party info --
1064: l_business_group_id number ;
1065: -- l_business_group_id number:=FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1066: l_ship_to_org_id number;
1067: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=
1068: fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
1069: --Third party info --
1070: l_third_contact_phone varchar2(80);
1071: l_third_contact_fax varchar2(80);
1072: l_third_contact_email HZ_PARTIES.email_address%TYPE; --changed
1259: END IF;
1260: IF l_single_business_group_id is not null then
1261: l_business_group_id := l_single_business_group_id;
1262: ELSE
1263: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
1264: END IF;
1265:
1266: OPEN get_event_status;
1267: FETCH get_event_status into l_event_status;
1301:
1302:
1303: -- ***
1304: IF ota_tdb_bus.Booking_status_type(l_booking_status_type_id) = 'W' then
1305: l_booking_priority := fnd_profile.value('OTA_WAITLIST_PRIORITY');
1306: if l_booking_priority is null then
1307: FND_MESSAGE.set_name ('OTA', 'OTA_13902_TDB_OM_NO_PROFILE');
1308:
1309: fnd_message.raise_error;
1499: p_booking_priority => l_booking_priority,
1500: p_successful_attendance_flag => null,
1501: p_failure_reason => null,
1502: p_attendance_result => null,
1503: p_administrator => fnd_profile.value('USER_ID'),
1504: p_authorizer_person_id => null,
1505: p_comments => null,
1506: p_date_status_changed => NULL,
1507: p_language_id => null,