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_COMPETENCES_API dependencies on PER_COMPETENCE_DEFINITIONS

Line 207: from per_competence_definitions

203: segment27,
204: segment28,
205: segment29,
206: segment30
207: from per_competence_definitions
208: where competence_definition_id = l_competence_definition_id;
209: --
210: -- bug 2267635 get per_competence name value for cases when the user is using
211: -- the api to insert the record directly and the comp def id is known

Line 879: l_competence_definition_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;

875: --
876: l_proc varchar2(72) := g_package||'update_competence';
877: l_object_version_number per_competences.object_version_number%TYPE;
878: l_ovn per_competences.object_version_number%TYPE := p_object_version_number;
879: l_competence_definition_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
880: l_comp_def_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
881: l_flex_num per_competence_definitions.id_flex_num%TYPE;
882: l_name varchar2(700); -- bug#2925181
883: l_api_updating boolean;

Line 880: l_comp_def_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;

876: l_proc varchar2(72) := g_package||'update_competence';
877: l_object_version_number per_competences.object_version_number%TYPE;
878: l_ovn per_competences.object_version_number%TYPE := p_object_version_number;
879: l_competence_definition_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
880: l_comp_def_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
881: l_flex_num per_competence_definitions.id_flex_num%TYPE;
882: l_name varchar2(700); -- bug#2925181
883: l_api_updating boolean;
884: l_segment1 varchar2(150) := p_segment1;

Line 881: l_flex_num per_competence_definitions.id_flex_num%TYPE;

877: l_object_version_number per_competences.object_version_number%TYPE;
878: l_ovn per_competences.object_version_number%TYPE := p_object_version_number;
879: l_competence_definition_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
880: l_comp_def_id per_competence_definitions.competence_definition_id%TYPE := p_competence_definition_id;
881: l_flex_num per_competence_definitions.id_flex_num%TYPE;
882: l_name varchar2(700); -- bug#2925181
883: l_api_updating boolean;
884: l_segment1 varchar2(150) := p_segment1;
885: l_segment2 varchar2(150) := p_segment2;

Line 919: from per_competence_definitions cmp

915: l_language_code varchar2(30);
916: --
917: cursor csr_idsel is
918: select cmp.id_flex_num
919: from per_competence_definitions cmp
920: where cmp.competence_definition_id = l_competence_definition_id;
921: --
922: --
923: -- bug 2267635 get per_competence_definition segment values where

Line 957: from per_competence_definitions

953: segment27,
954: segment28,
955: segment29,
956: segment30
957: from per_competence_definitions
958: where competence_definition_id = l_competence_definition_id;
959: --
960: -- bug 2267635 get per_competence name value for when updating by api
961: -- and comp def id is known, name should be in per_competences and

Line 1205: -- update competence definitions in per_competence_definitions if

1201: end if;
1202: close csr_idsel;
1203: --
1204: -- 2267635
1205: -- update competence definitions in per_competence_definitions if
1206: -- p_competence_definition_id had no value when passed into program
1207: -- no value when passed into program or if l_name has no value.
1208: --
1209: --