DBA Data[Home] [Help]

APPS.OTA_OM_UPD_API dependencies on OTA_DELEGATE_BOOKINGS

Line 1049: l_booking_priority ota_delegate_bookings.booking_priority%TYPE := NULL;

1045: l_type_id number;
1046: l_finance_line_id number := NULL;
1047: l_meaning varchar2(100);
1048: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1049: l_booking_priority ota_delegate_bookings.booking_priority%TYPE := NULL;
1050: l_delegate_contact_phone varchar2(80);
1051: l_delegate_contact_fax varchar2(80);
1052: l_delegate_contact_email HZ_PARTIES.email_address%TYPE; ---changed
1053: l_contact_address_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE := NULL; --changed

Line 1067: l_single_business_group_id ota_delegate_bookings.business_group_id%type:=

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 --
1070: l_third_contact_phone varchar2(80);
1071: l_third_contact_fax varchar2(80);