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_GRADE_API dependencies on PER_GRADES

Line 111: l_grade_id per_grades.grade_id%TYPE;

107: ) is
108: --
109: -- Declare cursors and local variables
110: --
111: l_grade_id per_grades.grade_id%TYPE;
112: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
113: l_business_group_id per_grades.business_group_id%TYPE;
114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';

Line 112: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;

108: --
109: -- Declare cursors and local variables
110: --
111: l_grade_id per_grades.grade_id%TYPE;
112: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
113: l_business_group_id per_grades.business_group_id%TYPE;
114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 113: l_business_group_id per_grades.business_group_id%TYPE;

109: -- Declare cursors and local variables
110: --
111: l_grade_id per_grades.grade_id%TYPE;
112: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
113: l_business_group_id per_grades.business_group_id%TYPE;
114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;

Line 114: l_name per_grades.name%TYPE := p_name;

110: --
111: l_grade_id per_grades.grade_id%TYPE;
112: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
113: l_business_group_id per_grades.business_group_id%TYPE;
114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;
118: l_sequence per_grades.sequence%TYPE;

Line 117: l_object_version_number per_grades.object_version_number%TYPE;

113: l_business_group_id per_grades.business_group_id%TYPE;
114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;
118: l_sequence per_grades.sequence%TYPE;
119: l_date_from per_grades.date_from%TYPE;
120: l_date_to per_grades.date_to%TYPE;
121: l_effective_date date := p_effective_date;

Line 118: l_sequence per_grades.sequence%TYPE;

114: l_name per_grades.name%TYPE := p_name;
115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;
118: l_sequence per_grades.sequence%TYPE;
119: l_date_from per_grades.date_from%TYPE;
120: l_date_to per_grades.date_to%TYPE;
121: l_effective_date date := p_effective_date;
122: l_segment1 varchar2(60) := p_segment1;

Line 119: l_date_from per_grades.date_from%TYPE;

115: l_proc varchar2(72) := g_package||'create_grade';
116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;
118: l_sequence per_grades.sequence%TYPE;
119: l_date_from per_grades.date_from%TYPE;
120: l_date_to per_grades.date_to%TYPE;
121: l_effective_date date := p_effective_date;
122: l_segment1 varchar2(60) := p_segment1;
123: l_segment2 varchar2(60) := p_segment2;

Line 120: l_date_to per_grades.date_to%TYPE;

116: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
117: l_object_version_number per_grades.object_version_number%TYPE;
118: l_sequence per_grades.sequence%TYPE;
119: l_date_from per_grades.date_from%TYPE;
120: l_date_to per_grades.date_to%TYPE;
121: l_effective_date date := p_effective_date;
122: l_segment1 varchar2(60) := p_segment1;
123: l_segment2 varchar2(60) := p_segment2;
124: l_segment3 varchar2(60) := p_segment3;

Line 153: l_short_name per_grades.short_name%TYPE;

149: l_segment28 varchar2(60) := p_segment28;
150: l_segment29 varchar2(60) := p_segment29;
151: l_segment30 varchar2(60) := p_segment30;
152: l_language_code varchar2(30) := p_language_code;
153: l_short_name per_grades.short_name%TYPE;
154: --
155: -- variable to indicate whether key flex id parameter
156: -- enters the program with a value.
157: --

Line 795: l_date_to per_grades.date_to%type;

791: l_name varchar2(240);
792: l_proc varchar2(72) := g_package||'update_grade';
793: l_api_updating boolean;
794: l_effective_date date;
795: l_date_to per_grades.date_to%type;
796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;

Line 796: l_sequence per_grades.sequence%type;

792: l_proc varchar2(72) := g_package||'update_grade';
793: l_api_updating boolean;
794: l_effective_date date;
795: l_date_to per_grades.date_to%type;
796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;

Line 797: l_grade_id per_grades.grade_id%type;

793: l_api_updating boolean;
794: l_effective_date date;
795: l_date_to per_grades.date_to%type;
796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type

Line 798: l_date_from per_grades.date_from%type;

794: l_effective_date date;
795: l_date_to per_grades.date_to%type;
796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type
802: := p_grade_definition_id;

Line 799: l_short_name per_grades.short_name%type;

795: l_date_to per_grades.date_to%type;
796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type
802: := p_grade_definition_id;
803: l_flex_num fnd_id_flex_segments.id_flex_num%type;

Line 800: l_business_group_id per_grades.business_group_id%type;

796: l_sequence per_grades.sequence%type;
797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type
802: := p_grade_definition_id;
803: l_flex_num fnd_id_flex_segments.id_flex_num%type;
804: l_object_version_number per_grades.object_version_number%type;

Line 801: l_grade_definition_id per_grades.grade_definition_id%type

797: l_grade_id per_grades.grade_id%type;
798: l_date_from per_grades.date_from%type;
799: l_short_name per_grades.short_name%type;
800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type
802: := p_grade_definition_id;
803: l_flex_num fnd_id_flex_segments.id_flex_num%type;
804: l_object_version_number per_grades.object_version_number%type;
805: l_segment1 varchar2(60) := p_segment1;

Line 804: l_object_version_number per_grades.object_version_number%type;

800: l_business_group_id per_grades.business_group_id%type;
801: l_grade_definition_id per_grades.grade_definition_id%type
802: := p_grade_definition_id;
803: l_flex_num fnd_id_flex_segments.id_flex_num%type;
804: l_object_version_number per_grades.object_version_number%type;
805: l_segment1 varchar2(60) := p_segment1;
806: l_segment2 varchar2(60) := p_segment2;
807: l_segment3 varchar2(60) := p_segment3;
808: l_segment4 varchar2(60) := p_segment4;

Line 849: from per_grades

845:
846: --start changes for bug 6522394
847: cursor csr_old_seq is
848: select sequence
849: from per_grades
850: where grade_id = p_grade_id;
851: --end changes for bug 6522394
852:
853: cursor c_segments is

Line 1231: from per_grades

1227: l_eot date:=to_date('31-12-4712','dd-mm-yyyy');
1228:
1229: cursor csr_get_bgrp is
1230: select business_group_id,date_from,date_to
1231: from per_grades
1232: where grade_id = p_grade_id;
1233:
1234: begin
1235:

Line 1243: per_grades_pkg.postup1(p_sequence,

1239: if csr_get_bgrp%found then
1240: close csr_get_bgrp;
1241: end if;
1242:
1243: per_grades_pkg.postup1(p_sequence,
1244: l_old_seq,
1245: p_last_updated_by,
1246: p_last_update_login,
1247: p_grade_id,

Line 1263: per_grades_pkg.postup2(p_grade_id,

1259: if p_date_to <> hr_api.g_date then
1260: l_date_to := p_date_to;
1261: end if;
1262:
1263: per_grades_pkg.postup2(p_grade_id,
1264: l_tmp_business_group_id,
1265: l_date_from,
1266: l_date_to,
1267: l_eot,