APPS.OTA_CLASSIC_UPGRADE dependencies on PER_COMPETENCE_ELEMENTS

Line 1629: From Per_Competence_Elements

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
1630: Where Type = 'TRAINER'
1631: and Object_id = l_act_ver_id ;
1632: End If;
1633: If Nvl(l_res_usg_cnt,0) > 0 OR Nvl(l_cmp_cnt,0) > 0 then

Line 1836: Insert into PER_COMPETENCE_ELEMENTS

1832: end;
1833:
1834:
1835: begin
1836: Insert into PER_COMPETENCE_ELEMENTS
1837: (competence_element_id
1838: ,business_group_id
1839: ,object_version_number
1840: ,type

Line 1848: SELECT per_competence_elements_s.nextval

1844: ,effective_date_from
1845: ,effective_date_to
1846: ,object_id
1847: ,object_name)
1848: SELECT per_competence_elements_s.nextval
1849: ,nvl(Ids.business_group_id,0)
1850: ,1
1851: ,'OTA_OFFERING'
1852: ,cmp.competence_id

Line 1859: FROM PER_COMPETENCE_ELEMENTS cmp

1855: ,cmp.effective_date_from
1856: ,cmp.effective_date_to
1857: ,l_offering_id
1858: ,'OTA'
1859: FROM PER_COMPETENCE_ELEMENTS cmp
1860: WHERE cmp.type = 'TRAINER'
1861: AND cmp.object_id = l_act_ver_id
1862: AND not exists (select 1 from per_competence_elements pce
1863: where pce.object_id = l_act_ver_id and type = 'OTA_OFFERING');

Line 1862: AND not exists (select 1 from per_competence_elements pce

1858: ,'OTA'
1859: FROM PER_COMPETENCE_ELEMENTS cmp
1860: WHERE cmp.type = 'TRAINER'
1861: AND cmp.object_id = l_act_ver_id
1862: AND not exists (select 1 from per_competence_elements pce
1863: where pce.object_id = l_act_ver_id and type = 'OTA_OFFERING');
1864: Exception
1865:
1866: when others then

Line 1967: delete from per_competence_elements

1963: from ota_category_usages
1964: where type = 'DM');
1965:
1966: --3) Trainer Competences
1967: delete from per_competence_elements
1968: where object_id = l_act_ver_id
1969: and type = 'TRAINER';
1970: end if;
1971: