APPS.OTA_HR_DELETE dependencies on OTA_DELEGATE_BOOKINGS

Line 29: from ota_delegate_bookings

25: where developer_organization_id = p_organization_id;
26: --
27: cursor c_delegate_bookings1 is
28: select null
29: from ota_delegate_bookings
30: where delegate_person_id = p_person_id;
31: --
32: cursor c_delegate_bookings2 is
33: select null

Line 34: from ota_delegate_bookings

30: where delegate_person_id = p_person_id;
31: --
32: cursor c_delegate_bookings2 is
33: select null
34: from ota_delegate_bookings
35: where sponsor_person_id = p_person_id;
36: --
37: cursor c_delegate_bookings3 is
38: select null

Line 39: from ota_delegate_bookings

35: where sponsor_person_id = p_person_id;
36: --
37: cursor c_delegate_bookings3 is
38: select null
39: from ota_delegate_bookings
40: where organization_id = p_organization_id;
41: --
42: cursor c_delegate_bookings4 is
43: select null

Line 44: from ota_delegate_bookings

40: where organization_id = p_organization_id;
41: --
42: cursor c_delegate_bookings4 is
43: select null
44: from ota_delegate_bookings
45: where person_address_id = p_address_id;
46: --
47: cursor c_events is
48: select null

Line 100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

96: fetch c_delegate_bookings1 into l_exists;
97: if c_delegate_bookings1%found then
98: close c_delegate_bookings1;
99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');
102: fnd_message.raise_error;
103: end if;
104: close c_delegate_bookings1;

Line 112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

108: fetch c_delegate_bookings2 into l_exists;
109: if c_delegate_bookings2%found then
110: close c_delegate_bookings2;
111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');
114: fnd_message.raise_error;
115: end if;
116: close c_delegate_bookings2;

Line 162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

158: fetch c_delegate_bookings3 into l_exists;
159: if c_delegate_bookings3%found then
160: close c_delegate_bookings3;
161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
164: fnd_message.raise_error;
165: end if;
166: close c_delegate_bookings3;

Line 216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

212: fetch c_delegate_bookings4 into l_exists;
213: if c_delegate_bookings4%found then
214: close c_delegate_bookings4;
215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');
216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');
218: fnd_message.raise_error;
219: end if;
220: close c_delegate_bookings4;