16: where customer_id = p_customer_id;
17: --
18: cursor c_delegate_bookings1 is
19: select null
20: from ota_delegate_bookings
21: where customer_id = p_customer_id;
22: --
23: cursor c_delegate_bookings2 is
24: select null
21: where customer_id = p_customer_id;
22: --
23: cursor c_delegate_bookings2 is
24: select null
25: from ota_delegate_bookings
26: where third_party_customer_id = p_customer_id;
27: --
28: cursor c_delegate_bookings3 is
29: select null
26: where third_party_customer_id = p_customer_id;
27: --
28: cursor c_delegate_bookings3 is
29: select null
30: from ota_delegate_bookings
31: where contact_id = p_contact_id;
32: --
33: cursor c_delegate_bookings4 is
34: select null
31: where contact_id = p_contact_id;
32: --
33: cursor c_delegate_bookings4 is
34: select null
35: from ota_delegate_bookings
36: where third_party_contact_id = p_contact_id;
37: --
38: cursor c_delegate_bookings5 is
39: select null
36: where third_party_contact_id = p_contact_id;
37: --
38: cursor c_delegate_bookings5 is
39: select null
40: from ota_delegate_bookings
41: where delegate_contact_id = p_contact_id;
42: --
43: cursor c_delegate_bookings6 is
44: select null
41: where delegate_contact_id = p_contact_id;
42: --
43: cursor c_delegate_bookings6 is
44: select null
45: from ota_delegate_bookings
46: where contact_address_id = p_address_id;
47: --
48: cursor c_delegate_bookings7 is
49: select null
46: where contact_address_id = p_address_id;
47: --
48: cursor c_delegate_bookings7 is
49: select null
50: from ota_delegate_bookings
51: where third_party_address_id = p_address_id;
52: --
53: cursor c_event_associations is
54: select null
106: fetch c_delegate_bookings2 into l_exists;
107: if c_delegate_bookings2%found then
108: close c_delegate_bookings2;
109: fnd_message.set_name('OTA','OTA_13540_CUSTOMER_DELETE');
110: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
111: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
112: fnd_message.raise_error;
113: end if;
114: close c_delegate_bookings2;
144: fetch c_delegate_bookings3 into l_exists;
145: if c_delegate_bookings3%found then
146: close c_delegate_bookings3;
147: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
148: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
149: fnd_message.set_token('COLUMN','CONTACT_ID');
150: fnd_message.raise_error;
151: end if;
152: close c_delegate_bookings3;
156: fetch c_delegate_bookings4 into l_exists;
157: if c_delegate_bookings4%found then
158: close c_delegate_bookings4;
159: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
160: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
161: fnd_message.set_token('COLUMN','THIRD_PARTY_CONTACT_ID');
162: fnd_message.raise_error;
163: end if;
164: close c_delegate_bookings4;
168: fetch c_delegate_bookings5 into l_exists;
169: if c_delegate_bookings5%found then
170: close c_delegate_bookings5;
171: fnd_message.set_name('OTA','OTA_13541_CONTACT_DELETE');
172: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
173: fnd_message.set_token('COLUMN','DELEGATE_CONTACT_ID');
174: fnd_message.raise_error;
175: end if;
176: close c_delegate_bookings5;
194: fetch c_delegate_bookings6 into l_exists;
195: if c_delegate_bookings6%found then
196: close c_delegate_bookings6;
197: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
198: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
199: fnd_message.set_token('COLUMN','CONTACT_ADDRESS_ID');
200: fnd_message.raise_error;
201: end if;
202: close c_delegate_bookings6;
206: fetch c_delegate_bookings7 into l_exists;
207: if c_delegate_bookings7%found then
208: close c_delegate_bookings7;
209: fnd_message.set_name('OTA','OTA_13542_ADDRESS_DELETE');
210: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
211: fnd_message.set_token('COLUMN','THIRD_PARTY_ADDRESS_ID');
212: fnd_message.raise_error;
213: end if;
214: close c_delegate_bookings7;