48: ) is
49: --
50: l_proc varchar2(72) := g_package||'create_iterative_rule';
51: l_effective_date date;
52: l_iterative_rule_id pay_iterative_rules_f.iterative_rule_id%TYPE;
53: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
54: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
55: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
56: --
49: --
50: l_proc varchar2(72) := g_package||'create_iterative_rule';
51: l_effective_date date;
52: l_iterative_rule_id pay_iterative_rules_f.iterative_rule_id%TYPE;
53: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
54: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
55: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
56: --
57: begin
50: l_proc varchar2(72) := g_package||'create_iterative_rule';
51: l_effective_date date;
52: l_iterative_rule_id pay_iterative_rules_f.iterative_rule_id%TYPE;
53: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
54: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
55: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
56: --
57: begin
58: --
51: l_effective_date date;
52: l_iterative_rule_id pay_iterative_rules_f.iterative_rule_id%TYPE;
53: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
54: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
55: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
56: --
57: begin
58: --
59: hr_utility.set_location('Entering:'|| l_proc, 10);
226: -- Declare cursors and local variables
227: --
228: l_proc varchar2(72) := g_package||'update_iterative_rule';
229: l_effective_date date;
230: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
231: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
232: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
233: --
234: begin
227: --
228: l_proc varchar2(72) := g_package||'update_iterative_rule';
229: l_effective_date date;
230: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
231: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
232: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
233: --
234: begin
235: --
228: l_proc varchar2(72) := g_package||'update_iterative_rule';
229: l_effective_date date;
230: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
231: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
232: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
233: --
234: begin
235: --
236: hr_utility.set_location('Entering:'|| l_proc, 10);
401: -- Declare cursors and local variables
402: --
403: l_proc varchar2(72) := g_package||'delete_iterative_rule';
404: l_effective_date date;
405: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
406: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
407: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
408: --
409: begin
402: --
403: l_proc varchar2(72) := g_package||'delete_iterative_rule';
404: l_effective_date date;
405: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
406: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
407: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
408: --
409: begin
410: --
403: l_proc varchar2(72) := g_package||'delete_iterative_rule';
404: l_effective_date date;
405: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;
406: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;
407: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;
408: --
409: begin
410: --
411: hr_utility.set_location('Entering:'|| l_proc, 10);