APPS.OTA_RUD_BUS dependencies on OTA_RESOURCE_USAGES

Line 31: , ota_resource_usages rud

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_resource_usages rud
32: , ota_offerings off
33: where rud.resource_usage_id = p_resource_usage_id
34: and rud.offering_id = off.offering_id
35: and pbg.business_group_id = off.business_group_id;

Line 103: , ota_resource_usages rud

99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups_perf pbg
103: , ota_resource_usages rud
104: , ota_suppliable_resources tsr
105: where rud.resource_usage_id = p_resource_usage_id
106: and rud.supplied_resource_id = tsr.supplied_Resource_id
107: and pbg.business_group_id = tsr.business_group_id;

Line 181: from ota_resource_usages rud

177: l_ok varchar2 (3);
178: --
179: cursor c1 is
180: select 'No'
181: from ota_resource_usages rud
182: where rud.supplied_resource_id = p_supplied_resource_id
183: and rud.offering_id = p_offering_id;
184: --
185: begin

Line 193: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_PK');

189: open c1;
190: fetch c1
191: into l_ok;
192: if (c1%found) then
193: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_PK');
194: end if;
195: close c1;
196: --
197: hr_utility.set_location (' leaving:' || l_proc, 10);

Line 263: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK2');

259: fetch c1
260: into l_off_start_date,
261: l_off_end_date;
262: if (c1%notfound) then
263: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK2');
264: end if;
265: close c1;
266: --
267: -- Start date in range ?

Line 320: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK1');

316: fetch c1
317: into l_tsr_start_date,
318: l_tsr_end_date;
319: if (c1%notfound) then
320: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK1');
321: end if;
322: close c1;
323: --
324: -- Start date in range ?

Line 510: (p_associated_column1 => 'OTA_RESOURCE_USAGES.QUANTITY'

506: Exception
507: --
508: when app_exception.application_exception then
509: if hr_multi_message.exception_add
510: (p_associated_column1 => 'OTA_RESOURCE_USAGES.QUANTITY'
511: )
512: Then
513: --
514: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 716: ,p_descflex_name => 'OTA_RESOURCE_USAGES'

712: -- b) During insert.
713: --
714: hr_dflex_utility.ins_or_upd_descflex_attribs
715: (p_appl_short_name => 'OTA'
716: ,p_descflex_name => 'OTA_RESOURCE_USAGES'
717: ,p_attribute_category => p_rec.rud_information_category
718: ,p_attribute1_name => 'RUD_INFORMATION1'
719: ,p_attribute1_value => p_rec.rud_information1
720: ,p_attribute2_name => 'RUD_INFORMATION2'