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_COMPETENCES

Line 124: l_competence_id per_competences.competence_id%TYPE;

120: --
121: -- Declare cursors and local variables
122: --
123: l_proc varchar2(72) := g_package||'create_competence';
124: l_competence_id per_competences.competence_id%TYPE;
125: l_name varchar2(700) := p_concat_segments; -- bug#2925181
126: l_flex_num number;
127: l_competence_definition_id per_competences.competence_definition_id%TYPE
128: := p_competence_definition_id;

Line 127: l_competence_definition_id per_competences.competence_definition_id%TYPE

123: l_proc varchar2(72) := g_package||'create_competence';
124: l_competence_id per_competences.competence_id%TYPE;
125: l_name varchar2(700) := p_concat_segments; -- bug#2925181
126: l_flex_num number;
127: l_competence_definition_id per_competences.competence_definition_id%TYPE
128: := p_competence_definition_id;
129: l_object_version_number per_competences.object_version_number%TYPE;
130: l_segment1 varchar2(150) := p_segment1;
131: l_segment2 varchar2(150) := p_segment2;

Line 129: l_object_version_number per_competences.object_version_number%TYPE;

125: l_name varchar2(700) := p_concat_segments; -- bug#2925181
126: l_flex_num number;
127: l_competence_definition_id per_competences.competence_definition_id%TYPE
128: := p_competence_definition_id;
129: l_object_version_number per_competences.object_version_number%TYPE;
130: l_segment1 varchar2(150) := p_segment1;
131: l_segment2 varchar2(150) := p_segment2;
132: l_segment3 varchar2(150) := p_segment3;
133: l_segment4 varchar2(150) := p_segment4;

Line 212: -- and the name should be saved in per_competences but

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
212: -- and the name should be saved in per_competences but
213: -- p_concat_segments has not been entered as a parameter
214: --
215: cursor c_name is
216: select name

Line 217: from per_competences_vl

213: -- p_concat_segments has not been entered as a parameter
214: --
215: cursor c_name is
216: select name
217: from per_competences_vl
218: where competence_definition_id = l_competence_definition_id;
219: --
220: begin
221: --

Line 877: l_object_version_number per_competences.object_version_number%TYPE;

873: -- bug 2267635 initialize l_competence_definition_id and segmnt variables with
874: -- values where these are passed into program.
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;

Line 878: l_ovn per_competences.object_version_number%TYPE := p_object_version_number;

874: -- values where these are passed into program.
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

Line 961: -- and comp def id is known, name should be in per_competences and

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
962: -- p_concat_segments has not entered as a param
963: --
964: cursor c_name is
965: select name

Line 966: from per_competences_vl

962: -- p_concat_segments has not entered as a param
963: --
964: cursor c_name is
965: select name
966: from per_competences_vl
967: where competence_definition_id = l_competence_definition_id;
968: --
969: begin
970: --

Line 1530: cursor csr_get_prof_levels(c_competence_id per_competences.competence_id%TYPE)

1526: ) is
1527: --
1528: -- Declare cursors and local variables
1529: --
1530: cursor csr_get_prof_levels(c_competence_id per_competences.competence_id%TYPE)
1531: is
1532: select rating_level_id,
1533: object_version_number
1534: from per_rating_levels

Line 1674: l_competence_id per_competences.competence_id%TYPE;

1670:
1671: ) is
1672:
1673: l_proc varchar2(72) := g_package||'create_or_update_competence';
1674: l_competence_id per_competences.competence_id%TYPE;
1675: l_source_competence_id per_competences.competence_id%TYPE;
1676: l_conc_name varchar2(700);
1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;

Line 1675: l_source_competence_id per_competences.competence_id%TYPE;

1671: ) is
1672:
1673: l_proc varchar2(72) := g_package||'create_or_update_competence';
1674: l_competence_id per_competences.competence_id%TYPE;
1675: l_source_competence_id per_competences.competence_id%TYPE;
1676: l_conc_name varchar2(700);
1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;
1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;

Line 1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;

1674: l_competence_id per_competences.competence_id%TYPE;
1675: l_source_competence_id per_competences.competence_id%TYPE;
1676: l_conc_name varchar2(700);
1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;
1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;
1680: l_ovn per_competences.object_version_number%TYPE;
1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;

Line 1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;

1675: l_source_competence_id per_competences.competence_id%TYPE;
1676: l_conc_name varchar2(700);
1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;
1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;
1680: l_ovn per_competences.object_version_number%TYPE;
1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;
1683: l_date_from date;

Line 1680: l_ovn per_competences.object_version_number%TYPE;

1676: l_conc_name varchar2(700);
1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;
1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;
1680: l_ovn per_competences.object_version_number%TYPE;
1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;
1683: l_date_from date;
1684: l_evaluation_method per_competences.evaluation_method%TYPE;

Line 1681: l_source_ovn per_competences.object_version_number%TYPE;

1677: l_flex_num number;
1678: l_competence_definition_id per_competences.competence_definition_id%TYPE;
1679: l_rating_scale_id per_competences.rating_scale_id%TYPE;
1680: l_ovn per_competences.object_version_number%TYPE;
1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;
1683: l_date_from date;
1684: l_evaluation_method per_competences.evaluation_method%TYPE;
1685: l_certification_required per_competences.certification_required%TYPE;

Line 1684: l_evaluation_method per_competences.evaluation_method%TYPE;

1680: l_ovn per_competences.object_version_number%TYPE;
1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;
1683: l_date_from date;
1684: l_evaluation_method per_competences.evaluation_method%TYPE;
1685: l_certification_required per_competences.certification_required%TYPE;
1686: l_renewal_period_units per_competences.renewal_period_units%TYPE;
1687: l_language_code varchar2(20);
1688: l_translated_language varchar2(20);

Line 1685: l_certification_required per_competences.certification_required%TYPE;

1681: l_source_ovn per_competences.object_version_number%TYPE;
1682: l_effective_date date;
1683: l_date_from date;
1684: l_evaluation_method per_competences.evaluation_method%TYPE;
1685: l_certification_required per_competences.certification_required%TYPE;
1686: l_renewal_period_units per_competences.renewal_period_units%TYPE;
1687: l_language_code varchar2(20);
1688: l_translated_language varchar2(20);
1689: l_segment1 varchar2(150);

Line 1686: l_renewal_period_units per_competences.renewal_period_units%TYPE;

1682: l_effective_date date;
1683: l_date_from date;
1684: l_evaluation_method per_competences.evaluation_method%TYPE;
1685: l_certification_required per_competences.certification_required%TYPE;
1686: l_renewal_period_units per_competences.renewal_period_units%TYPE;
1687: l_language_code varchar2(20);
1688: l_translated_language varchar2(20);
1689: l_segment1 varchar2(150);
1690: l_segment2 varchar2(150);

Line 1696: from per_competences_v

1692:
1693: cursor csr_cpn(p_competence_name in varchar2)
1694: is
1695: select competence_id , object_version_number
1696: from per_competences_v
1697: where business_group_id is null
1698: and name = p_competence_name;
1699:
1700: cursor csr_rsc