APPS.OTA_RUD_INS dependencies on OTA_RESOURCE_USAGES

Line 87: -- Insert the row into: ota_resource_usages

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ota_resource_usages
88: --
89: insert into ota_resource_usages
90: (resource_usage_id
91: ,supplied_resource_id

Line 89: insert into ota_resource_usages

85: --
86: --
87: -- Insert the row into: ota_resource_usages
88: --
89: insert into ota_resource_usages
90: (resource_usage_id
91: ,supplied_resource_id
92: ,activity_version_id
93: ,object_version_number

Line 227: Cursor C_Sel1 is select ota_resource_usages_s.nextval from sys.dual;

223: Procedure pre_insert
224: (p_rec in out nocopy ota_rud_shd.g_rec_type
225: ) is
226: --
227: Cursor C_Sel1 is select ota_resource_usages_s.nextval from sys.dual;
228: --
229: Cursor C_Sel2 is
230: Select null
231: from ota_resource_usages

Line 231: from ota_resource_usages

227: Cursor C_Sel1 is select ota_resource_usages_s.nextval from sys.dual;
228: --
229: Cursor C_Sel2 is
230: Select null
231: from ota_resource_usages
232: where resource_usage_id =
233: ota_rud_ins.g_resource_usage_id_i;
234: --
235: l_proc varchar2(72) := g_package||'pre_insert';

Line 253: fnd_message.set_token('TABLE_NAME','ota_resource_usages');

249: --
250: -- The primary key values are already in use.
251: --
252: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
253: fnd_message.set_token('TABLE_NAME','ota_resource_usages');
254: fnd_message.raise_error;
255: End If;
256: Close C_Sel2;
257: --

Line 398: (p_module_name => 'OTA_RESOURCE_USAGES'

394: --
395: when hr_api.cannot_find_prog_unit then
396: --
397: hr_api.cannot_find_prog_unit_error
398: (p_module_name => 'OTA_RESOURCE_USAGES'
399: ,p_hook_type => 'AI');
400: --
401: end;
402: --