eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPETENCE_ELEMENT_API dependencies on PER_COMPETENCE_ELEMENTS

Line 104: l_competence_element_id per_competence_elements.competence_id%TYPE;

100: -- Declare cursors and local variables
101: --
102: --
103: l_proc varchar2(72) := g_package||'create_competence_elements';
104: l_competence_element_id per_competence_elements.competence_id%TYPE;
105: l_object_version_number per_competence_elements.object_version_number%TYPE;
106: begin
107: hr_utility.set_location('Entering:'|| l_proc, 5);
108: --

Line 105: l_object_version_number per_competence_elements.object_version_number%TYPE;

101: --
102: --
103: l_proc varchar2(72) := g_package||'create_competence_elements';
104: l_competence_element_id per_competence_elements.competence_id%TYPE;
105: l_object_version_number per_competence_elements.object_version_number%TYPE;
106: begin
107: hr_utility.set_location('Entering:'|| l_proc, 5);
108: --
109: -- Issue a savepoint.

Line 531: l_object_version_number per_competence_elements.object_version_number%TYPE;

527: -- Declare cursors and local variables
528: --
529: --
530: l_proc varchar2(72) := g_package||'update_competence_element';
531: l_object_version_number per_competence_elements.object_version_number%TYPE;
532: --
533: lv_object_version_number per_competence_elements.object_version_number%TYPE := p_object_version_number ;
534: --
535: begin

Line 533: lv_object_version_number per_competence_elements.object_version_number%TYPE := p_object_version_number ;

529: --
530: l_proc varchar2(72) := g_package||'update_competence_element';
531: l_object_version_number per_competence_elements.object_version_number%TYPE;
532: --
533: lv_object_version_number per_competence_elements.object_version_number%TYPE := p_object_version_number ;
534: --
535: begin
536: hr_utility.set_location('Entering:'|| l_proc, 5);
537: --

Line 891: l_party_id per_competence_elements.party_id%type;

887: -- Declare cursors and local variables
888: --
889: --
890: l_proc varchar2(72) := g_package||'update_competence_element';
891: l_party_id per_competence_elements.party_id%type;
892: --
893: cursor csr_get_party_id is
894: select party_id
895: from per_competence_elements

Line 895: from per_competence_elements

891: l_party_id per_competence_elements.party_id%type;
892: --
893: cursor csr_get_party_id is
894: select party_id
895: from per_competence_elements
896: where competence_element_id = p_competence_element_id;
897: --
898:
899: begin

Line 902: -- get party_id from per_competence_elements using competence_element_id

898:
899: begin
900: hr_utility.set_location('Entering:'|| l_proc, 10);
901: --
902: -- get party_id from per_competence_elements using competence_element_id
903: --
904: open csr_get_party_id;
905: fetch csr_get_party_id into l_party_id;
906: close csr_get_party_id;

Line 1011: l_object_version_number per_competence_elements.object_version_number%TYPE;

1007: -- Declare cursors and local variables
1008: --
1009: --
1010: l_proc varchar2(72) := g_package||'update_Personal_comp_element';
1011: l_object_version_number per_competence_elements.object_version_number%TYPE;
1012: l_ins_ovn per_competence_elements.object_version_number%TYPE;
1013: l_ins_comp_id number(9);
1014: l_competence_id number(9);
1015: l_business_group_id number(9);

Line 1012: l_ins_ovn per_competence_elements.object_version_number%TYPE;

1008: --
1009: --
1010: l_proc varchar2(72) := g_package||'update_Personal_comp_element';
1011: l_object_version_number per_competence_elements.object_version_number%TYPE;
1012: l_ins_ovn per_competence_elements.object_version_number%TYPE;
1013: l_ins_comp_id number(9);
1014: l_competence_id number(9);
1015: l_business_group_id number(9);
1016: l_person_id per_competence_elements.person_id%TYPE;

Line 1016: l_person_id per_competence_elements.person_id%TYPE;

1012: l_ins_ovn per_competence_elements.object_version_number%TYPE;
1013: l_ins_comp_id number(9);
1014: l_competence_id number(9);
1015: l_business_group_id number(9);
1016: l_person_id per_competence_elements.person_id%TYPE;
1017: l_party_id per_competence_elements.party_id%TYPE;-- HR/TCA merg
1018: l_type per_competence_elements.type%TYPE;
1019: l_effective_date_from date;
1020: l_effective_date_to date;

Line 1017: l_party_id per_competence_elements.party_id%TYPE;-- HR/TCA merg

1013: l_ins_comp_id number(9);
1014: l_competence_id number(9);
1015: l_business_group_id number(9);
1016: l_person_id per_competence_elements.person_id%TYPE;
1017: l_party_id per_competence_elements.party_id%TYPE;-- HR/TCA merg
1018: l_type per_competence_elements.type%TYPE;
1019: l_effective_date_from date;
1020: l_effective_date_to date;
1021: l_upd_date_from date := p_effective_date_from;

Line 1018: l_type per_competence_elements.type%TYPE;

1014: l_competence_id number(9);
1015: l_business_group_id number(9);
1016: l_person_id per_competence_elements.person_id%TYPE;
1017: l_party_id per_competence_elements.party_id%TYPE;-- HR/TCA merg
1018: l_type per_competence_elements.type%TYPE;
1019: l_effective_date_from date;
1020: l_effective_date_to date;
1021: l_upd_date_from date := p_effective_date_from;
1022: l_upd_date_to date := p_effective_date_to;

Line 1092: from per_competence_elements

1088: attribute17,
1089: attribute18,
1090: attribute19,
1091: attribute20
1092: from per_competence_elements
1093: where competence_element_id = p_competence_element_id
1094: and object_version_number = p_object_version_number;
1095: --
1096: begin

Line 1590: from per_competence_elements

1586: , object_version_number
1587: , proficiency_level_id
1588: , effective_date_from
1589: , effective_date_to -- added for bug#1623036
1590: from per_competence_elements
1591: where person_id = p_person_id
1592: and type = 'PERSONAL'
1593: and competence_id = p_competence_id
1594: order by effective_date_from desc;

Line 1602: from per_competence_elements

1598: , object_version_number
1599: , proficiency_level_id
1600: , effective_date_from
1601: , effective_date_to
1602: from per_competence_elements
1603: where person_id = p_person_id
1604: and type = 'PERSONAL'
1605: and competence_id = p_competence_id
1606: and

Line 1616: from per_competence_elements

1612: , object_version_number
1613: , proficiency_level_id
1614: , effective_date_from
1615: , effective_date_to -- added for bug#1623036
1616: from per_competence_elements
1617: where person_id = p_person_id
1618: and type = 'PERSONAL'
1619: and competence_id = p_competence_id
1620: and

Line 2389: from per_competence_elements e

2385: , e.attribute17
2386: , e.attribute18
2387: , e.attribute19
2388: , e.attribute20
2389: from per_competence_elements e
2390: where e.object_id = p_activity_version_from
2391: and e.type='TRAINER';
2392: --
2393: cursor c_get_competencies_other is

Line 2421: from per_competence_elements e

2417: , e.attribute17
2418: , e.attribute18
2419: , e.attribute19
2420: , e.attribute20
2421: from per_competence_elements e
2422: where e.activity_version_id = p_activity_version_from
2423: and e.type = nvl(p_competence_type,'DELIVERY'); -- For Bug 1868713
2424: --
2425: begin

Line 2622: from per_competence_elements e

2618: ,e.effective_date_from
2619: ,e.effective_date_to
2620: ,c.date_from
2621: ,c.date_to
2622: from per_competence_elements e
2623: , per_competences c
2624: where e.activity_version_id = p_activity_version_id
2625: and e.type = 'DELIVERY'
2626: and e.competence_id = c.competence_id