APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_RESOURCE_USAGES

Line 1625: From Ota_Resource_Usages

1621: Else
1622: l_event_exists := 'N' ;
1623:
1624: Select count(Resource_Usage_id) into l_res_usg_cnt
1625: From Ota_Resource_Usages
1626: Where Activity_Version_id = l_act_ver_id ;
1627: If Nvl(l_res_usg_cnt,0) = 0 then
1628: Select count(Competence_element_id) into l_cmp_cnt
1629: From Per_Competence_Elements

Line 1745: Insert into ota_resource_usages

1741: Where M.activity_version_id = l_act_ver_id;
1742:
1743:
1744: begin
1745: Insert into ota_resource_usages
1746: (resource_usage_id
1747: ,supplied_resource_id
1748: ,activity_version_id
1749: ,object_version_number

Line 1780: Select ota_resource_usages_s.nextval

1776: ,rud_information18
1777: ,rud_information19
1778: ,rud_information20
1779: ,offering_id )
1780: Select ota_resource_usages_s.nextval
1781: ,res.supplied_resource_id
1782: ,l_act_ver_id
1783: ,1
1784: ,res.required_flag

Line 1814: From ota_resource_usages res

1810: ,res.rud_information18
1811: ,res.rud_information19
1812: ,res.rud_information20
1813: ,l_offering_id
1814: From ota_resource_usages res
1815: where res.activity_version_id = l_act_ver_id
1816: and Offering_id is NULL ;
1817: Exception
1818:

Line 1942: delete from ota_resource_usages

1938: -- Only delete records if migration for activity version is successful.
1939: -- i.e. No errors encountered during migrating any of the entities.
1940: if b_act_ver_migrated then
1941: -- 1) Resource Booking
1942: delete from ota_resource_usages
1943: where activity_version_id = l_act_ver_id
1944: and offering_id is null;
1945:
1946: --2) Delivery Modes