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 1591: from per_competence_elements

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

Line 1603: from per_competence_elements

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

Line 1617: from per_competence_elements

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

Line 2396: from per_competence_elements e

2392: , e.attribute17
2393: , e.attribute18
2394: , e.attribute19
2395: , e.attribute20
2396: from per_competence_elements e
2397: where e.object_id = p_activity_version_from
2398: and e.type='TRAINER';
2399: --
2400: cursor c_get_competencies_other is

Line 2428: from per_competence_elements e

2424: , e.attribute17
2425: , e.attribute18
2426: , e.attribute19
2427: , e.attribute20
2428: from per_competence_elements e
2429: where e.activity_version_id = p_activity_version_from
2430: and e.type = nvl(p_competence_type,'DELIVERY'); -- For Bug 1868713
2431: --
2432: begin

Line 2629: from per_competence_elements e

2625: ,e.effective_date_from
2626: ,e.effective_date_to
2627: ,c.date_from
2628: ,c.date_to
2629: from per_competence_elements e
2630: , per_competences c
2631: where e.activity_version_id = p_activity_version_id
2632: and e.type = 'DELIVERY'
2633: and e.competence_id = c.competence_id