DBA Data[Home] [Help]

APPS.PAY_ITERATIVE_RULES_API dependencies on PAY_ITERATIVE_RULES_F

Line 52: l_iterative_rule_id pay_iterative_rules_f.iterative_rule_id%TYPE;

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: --

Line 53: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;

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

Line 54: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;

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: --

Line 55: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;

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);

Line 230: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;

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

Line 231: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;

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: --

Line 232: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;

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);

Line 405: l_object_version_number pay_iterative_rules_f.object_version_number%TYPE;

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

Line 406: l_effective_start_date pay_iterative_rules_f.effective_start_date%TYPE;

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: --

Line 407: l_effective_end_date pay_iterative_rules_f.effective_end_date%TYPE;

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);