APPS.OTA_RUD_SHD dependencies on OTA_RESOURCE_USAGES

Line 25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then

21: hr_utility.set_location('Entering:'||l_proc, 5);
22: --
23: -- Key constraints
24: --
25: If (p_constraint_name = 'OTA_RESOURCE_USAGES_FK1') Then
26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;

Line 30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then

26: fnd_message.set_name ('OTA', 'OTA_13202_GEN_INVALID_KEY');
27: fnd_message.set_token ('COLUMN_NAME','SUPPLIED_RESOURCE_ID');
28: fnd_message.set_token ('TABLE_NAME', 'OTA_SUPPLIABLE_RESOURCES');
29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');

Line 33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then

29: fnd_message.raise_error;
30: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_FK2') Then
31: fnd_message.set_name ('OTA', 'OTA_13235_RUD_NO_ACTIVITY');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'OTA_RESOURCE_USAGES_PK') Then
34: fnd_message.set_name ('OTA', 'OTA_13216_RUD_RESOURCE_UNIQUE');
35: fnd_message.raise_error;
36: --
37: -- Check constraints

Line 71: HR_UTILITY.SET_MESSAGE_TOKEN ('TABLE_NAME', 'OTA_RESOURCE_USAGES');

67: fnd_message.raise_error;
68: elsif (p_constraint_name = 'OTA_RUD_REQUIRED') then
69: HR_UTILITY.SET_MESSAGE (801,'HR_7166_OBJECT_CHK_CONSTRAINT');
70: HR_UTILITY.SET_MESSAGE_TOKEN ('CONSTRAINT_NAME', 'OTA_RUD_REQUIRED');
71: HR_UTILITY.SET_MESSAGE_TOKEN ('TABLE_NAME', 'OTA_RESOURCE_USAGES');
72: HR_UTILITY.raise_error;
73: --
74: --
75: Else

Line 134: from ota_resource_usages

130: ,rud_information18
131: ,rud_information19
132: ,rud_information20
133: ,offering_id
134: from ota_resource_usages
135: where resource_usage_id = p_resource_usage_id;
136: --
137: l_fct_ret boolean;
138: --

Line 232: from ota_resource_usages

228: rud_information18,
229: rud_information19,
230: rud_information20,
231: offering_id
232: from ota_resource_usages
233: where resource_usage_id = p_resource_usage_id
234: for update nowait;
235: --
236: l_proc varchar2(72) := g_package||'lck';

Line 275: hr_utility.set_message_token('TABLE_NAME', 'ota_resource_usages');

271: -- The object is locked therefore we need to supply a meaningful
272: -- error message.
273: --
274: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
275: hr_utility.set_message_token('TABLE_NAME', 'ota_resource_usages');
276: hr_utility.raise_error;
277: End lck;
278: --
279: -- ----------------------------------------------------------------------------