28: ,p_effective_end_date OUT NOCOPY DATE) IS
29: --
30: -- Declare cursors and local variables
31: --
32: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
33: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
34: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
35: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
36: l_effective_date DATE;
29: --
30: -- Declare cursors and local variables
31: --
32: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
33: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
34: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
35: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
36: l_effective_date DATE;
37: l_proc VARCHAR2(72) := g_package||'create_rate_value';
30: -- Declare cursors and local variables
31: --
32: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
33: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
34: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
35: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
36: l_effective_date DATE;
37: l_proc VARCHAR2(72) := g_package||'create_rate_value';
38: --
31: --
32: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
33: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
34: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
35: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
36: l_effective_date DATE;
37: l_proc VARCHAR2(72) := g_package||'create_rate_value';
38: --
39: l_rate_uom pay_rates.rate_uom%TYPE;
36: l_effective_date DATE;
37: l_proc VARCHAR2(72) := g_package||'create_rate_value';
38: --
39: l_rate_uom pay_rates.rate_uom%TYPE;
40: l_currency_code pay_grade_rules_f.currency_code%TYPE;
41: --
42: cursor csr_get_rate_uom is
43: select rate_uom
44: from pay_rates
278: --
279: -- Declare cursors and local variables
280: --
281: l_proc VARCHAR2(72) := g_package||'update_rate_value';
282: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
283: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
284: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
285: l_effective_date DATE;
286: l_temp_ovn number := p_object_version_number;
279: -- Declare cursors and local variables
280: --
281: l_proc VARCHAR2(72) := g_package||'update_rate_value';
282: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
283: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
284: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
285: l_effective_date DATE;
286: l_temp_ovn number := p_object_version_number;
287: --
280: --
281: l_proc VARCHAR2(72) := g_package||'update_rate_value';
282: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
283: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
284: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
285: l_effective_date DATE;
286: l_temp_ovn number := p_object_version_number;
287: --
288:
442: --
443: -- Declare cursors and local variables
444: --
445: l_proc VARCHAR2(72) := g_package||'delete_rate_value';
446: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
447: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
448: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
449: l_effective_date DATE;
450: l_temp_ovn number := p_object_version_number;
443: -- Declare cursors and local variables
444: --
445: l_proc VARCHAR2(72) := g_package||'delete_rate_value';
446: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
447: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
448: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
449: l_effective_date DATE;
450: l_temp_ovn number := p_object_version_number;
451: --
444: --
445: l_proc VARCHAR2(72) := g_package||'delete_rate_value';
446: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
447: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
448: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
449: l_effective_date DATE;
450: l_temp_ovn number := p_object_version_number;
451: --
452: BEGIN
590: ,p_effective_end_date OUT NOCOPY DATE) IS
591: --
592: -- Declare cursors and local variables
593: --
594: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
595: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
596: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
597: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
598: l_effective_date DATE;
591: --
592: -- Declare cursors and local variables
593: --
594: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
595: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
596: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
597: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
598: l_effective_date DATE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
592: -- Declare cursors and local variables
593: --
594: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
595: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
596: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
597: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
598: l_effective_date DATE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
600: l_proc VARCHAR2(72) := g_package||'create_assignment_rate_value';
593: --
594: l_grade_rule_id pay_grade_rules_f.grade_rule_id%TYPE;
595: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
596: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
597: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
598: l_effective_date DATE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
600: l_proc VARCHAR2(72) := g_package||'create_assignment_rate_value';
601: --
595: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
596: l_effective_end_date pay_grade_rules_f.effective_end_date%TYPE;
597: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
598: l_effective_date DATE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
600: l_proc VARCHAR2(72) := g_package||'create_assignment_rate_value';
601: --
602: l_rate_uom pay_rates.rate_uom%TYPE;
603: l_currency_code pay_grade_rules_f.currency_code%TYPE;
599: l_default_rate_type pay_grade_rules_f.rate_type%TYPE;
600: l_proc VARCHAR2(72) := g_package||'create_assignment_rate_value';
601: --
602: l_rate_uom pay_rates.rate_uom%TYPE;
603: l_currency_code pay_grade_rules_f.currency_code%TYPE;
604: --
605: cursor csr_get_rate_uom is
606: select rate_uom
607: from pay_rates
770: --
771: -- Declare cursors and local variables
772: --
773: l_proc VARCHAR2(72) := g_package||'update_assignment_rate_value';
774: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
775: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
776: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
777: l_effective_date DATE;
778: l_temp_ovn number := p_object_version_number;
771: -- Declare cursors and local variables
772: --
773: l_proc VARCHAR2(72) := g_package||'update_assignment_rate_value';
774: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
775: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
776: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
777: l_effective_date DATE;
778: l_temp_ovn number := p_object_version_number;
779: --
772: --
773: l_proc VARCHAR2(72) := g_package||'update_assignment_rate_value';
774: l_object_version_number pay_grade_rules_f.object_version_number%TYPE;
775: l_effective_start_date pay_grade_rules_f.effective_start_date%TYPE;
776: l_effective_end_date pay_grade_rules_f.effective_END_date%TYPE;
777: l_effective_date DATE;
778: l_temp_ovn number := p_object_version_number;
779: --
780: BEGIN