APPS.OTA_HR_DELETE dependencies on OTA_ACTIVITY_VERSIONS

Line 19: from ota_activity_versions

15: l_exists varchar2(1);
16: --
17: cursor c_activity_versions1 is
18: select null
19: from ota_activity_versions
20: where controlling_person_id = p_person_id;
21: --
22: cursor c_activity_versions2 is
23: select null

Line 24: from ota_activity_versions

20: where controlling_person_id = p_person_id;
21: --
22: cursor c_activity_versions2 is
23: select null
24: from ota_activity_versions
25: where developer_organization_id = p_organization_id;
26: --
27: cursor c_delegate_bookings1 is
28: select null

Line 88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');

84: fetch c_activity_versions1 into l_exists;
85: if c_activity_versions1%found then
86: close c_activity_versions1;
87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');
90: fnd_message.raise_error;
91: end if;
92: close c_activity_versions1;

Line 138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');

134: fetch c_activity_versions2 into l_exists;
135: if c_activity_versions2%found then
136: close c_activity_versions2;
137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');
140: fnd_message.raise_error;
141: end if;
142: close c_activity_versions2;