APPS.OTA_HR_DELETE dependencies on OTA_EVENT_ASSOCIATIONS

Line 54: from ota_event_associations

50: where organization_id = p_organization_id;
51: --
52: cursor c_event_associations1 is
53: select null
54: from ota_event_associations
55: where organization_id = p_organization_id;
56: --
57: cursor c_event_associations2 is
58: select null

Line 59: from ota_event_associations

55: where organization_id = p_organization_id;
56: --
57: cursor c_event_associations2 is
58: select null
59: from ota_event_associations
60: where job_id = p_job_id;
61: --
62: cursor c_event_associations3 is
63: select null

Line 64: from ota_event_associations

60: where job_id = p_job_id;
61: --
62: cursor c_event_associations3 is
63: select null
64: from ota_event_associations
65: where position_id = p_position_id;
66: --
67: cursor c_finance_headers1 is
68: select null

Line 174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

170: fetch c_event_associations1 into l_exists;
171: if c_event_associations1%found then
172: close c_event_associations1;
173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
176: fnd_message.raise_error;
177: end if;
178: close c_event_associations1;

Line 188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

184: fetch c_event_associations2 into l_exists;
185: if c_event_associations2%found then
186: close c_event_associations2;
187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');
188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
189: fnd_message.set_token('COLUMN','JOB_ID');
190: fnd_message.raise_error;
191: end if;
192: close c_event_associations2;

Line 202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

198: fetch c_event_associations3 into l_exists;
199: if c_event_associations3%found then
200: close c_event_associations3;
201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');
202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
203: fnd_message.set_token('COLUMN','POSITION_ID');
204: fnd_message.raise_error;
205: end if;
206: close c_event_associations3;