DBA Data[Home] [Help]

APPS.HR_RATING_SCALES_API dependencies on PER_RATING_SCALES

Line 56: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;

52: -- Declare cursors and local variables
53: --
54: --
55: l_proc varchar2(72) := g_package||'create_rating_scale';
56: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
57: l_object_version_number per_rating_scales.object_version_number%TYPE;
58: l_language_code per_rating_scales_tl.language%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 57: l_object_version_number per_rating_scales.object_version_number%TYPE;

53: --
54: --
55: l_proc varchar2(72) := g_package||'create_rating_scale';
56: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
57: l_object_version_number per_rating_scales.object_version_number%TYPE;
58: l_language_code per_rating_scales_tl.language%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --

Line 58: l_language_code per_rating_scales_tl.language%TYPE;

54: --
55: l_proc varchar2(72) := g_package||'create_rating_scale';
56: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
57: l_object_version_number per_rating_scales.object_version_number%TYPE;
58: l_language_code per_rating_scales_tl.language%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Issue a savepoint.

Line 302: l_object_version_number per_rating_scales.object_version_number%TYPE;

298: -- Declare cursors and local variables
299: --
300:
301: l_proc varchar2(72) := g_package||'update_rating_scale';
302: l_object_version_number per_rating_scales.object_version_number%TYPE;
303: l_language_code per_rating_scales_tl.language%TYPE;
304: l_temp_ovn number := p_object_version_number;
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 303: l_language_code per_rating_scales_tl.language%TYPE;

299: --
300:
301: l_proc varchar2(72) := g_package||'update_rating_scale';
302: l_object_version_number per_rating_scales.object_version_number%TYPE;
303: l_language_code per_rating_scales_tl.language%TYPE;
304: l_temp_ovn number := p_object_version_number;
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 5);
307: --

Line 507: cursor csr_get_rat_levels(c_rating_scale_id per_rating_scales.rating_scale_id%TYPE)

503: ) is
504: --
505: -- Declare cursors and local variables
506: --
507: cursor csr_get_rat_levels(c_rating_scale_id per_rating_scales.rating_scale_id%TYPE)
508: is
509: select rating_level_id,
510: object_version_number
511: from per_rating_levels

Line 640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;

636: --
637: -- Declare cursor and local variables
638: --
639: l_proc varchar2(72) := g_package||'create_or_update_rating_scale';
640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;

Line 641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;

637: -- Declare cursor and local variables
638: --
639: l_proc varchar2(72) := g_package||'create_or_update_rating_scale';
640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;
645: l_default_flag per_rating_scales.default_flag%TYPE;

Line 642: l_ovn per_rating_scales.object_version_number%TYPE;

638: --
639: l_proc varchar2(72) := g_package||'create_or_update_rating_scale';
640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;
645: l_default_flag per_rating_scales.default_flag%TYPE;
646: l_effective_date date;

Line 643: l_source_ovn per_rating_scales.object_version_number%TYPE;

639: l_proc varchar2(72) := g_package||'create_or_update_rating_scale';
640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;
645: l_default_flag per_rating_scales.default_flag%TYPE;
646: l_effective_date date;
647: l_language_code varchar2(20);

Line 644: l_type per_rating_scales.type%TYPE;

640: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;
645: l_default_flag per_rating_scales.default_flag%TYPE;
646: l_effective_date date;
647: l_language_code varchar2(20);
648: l_translated_language varchar2(20);

Line 645: l_default_flag per_rating_scales.default_flag%TYPE;

641: l_source_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
642: l_ovn per_rating_scales.object_version_number%TYPE;
643: l_source_ovn per_rating_scales.object_version_number%TYPE;
644: l_type per_rating_scales.type%TYPE;
645: l_default_flag per_rating_scales.default_flag%TYPE;
646: l_effective_date date;
647: l_language_code varchar2(20);
648: l_translated_language varchar2(20);
649:

Line 652: from per_rating_scales_v

648: l_translated_language varchar2(20);
649:
650: cursor csr_rs(p_rating_scale_name in varchar2) is
651: select rating_scale_id , object_version_number
652: from per_rating_scales_v
653: where business_group_id is null
654: and name = p_rating_scale_name;
655:
656: --