DBA Data[Home] [Help]

APPS.PAY_STATUS_PROCESSING_RULE_API dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;

28: ) is
29: --
30: l_proc varchar2(72) := g_package||'create_status_process_rule';
31: l_effective_date date;
32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;
35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
36: l_comment_id pay_status_processing_rules_f.comment_id%type;

Line 33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;

29: --
30: l_proc varchar2(72) := g_package||'create_status_process_rule';
31: l_effective_date date;
32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;
35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
36: l_comment_id pay_status_processing_rules_f.comment_id%type;
37: l_formula_mismatch_warning boolean;

Line 34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;

30: l_proc varchar2(72) := g_package||'create_status_process_rule';
31: l_effective_date date;
32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;
35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
36: l_comment_id pay_status_processing_rules_f.comment_id%type;
37: l_formula_mismatch_warning boolean;
38: --

Line 35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;

31: l_effective_date date;
32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;
35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
36: l_comment_id pay_status_processing_rules_f.comment_id%type;
37: l_formula_mismatch_warning boolean;
38: --
39: begin

Line 36: l_comment_id pay_status_processing_rules_f.comment_id%type;

32: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
33: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
34: l_status_processing_rule_id pay_status_processing_rules_f.status_processing_rule_id%type;
35: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
36: l_comment_id pay_status_processing_rules_f.comment_id%type;
37: l_formula_mismatch_warning boolean;
38: --
39: begin
40: --

Line 185: l_object_version_number pay_status_processing_rules_f.object_version_number%type;

181: --
182: -- Declare cursors and local variables
183: --
184: l_proc varchar2(72) := g_package||'update_status_process_rule';
185: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
186: l_effective_date date;
187: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
188: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;

Line 187: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;

183: --
184: l_proc varchar2(72) := g_package||'update_status_process_rule';
185: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
186: l_effective_date date;
187: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
188: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;
190: l_formula_mismatch_warning boolean;
191: --

Line 188: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;

184: l_proc varchar2(72) := g_package||'update_status_process_rule';
185: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
186: l_effective_date date;
187: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
188: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;
190: l_formula_mismatch_warning boolean;
191: --
192: begin

Line 189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;

185: l_object_version_number pay_status_processing_rules_f.object_version_number%type;
186: l_effective_date date;
187: l_effective_start_date pay_status_processing_rules_f.effective_start_date%type;
188: l_effective_end_date pay_status_processing_rules_f.effective_end_date%type;
189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;
190: l_formula_mismatch_warning boolean;
191: --
192: begin
193: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 329: l_object_version_number pay_status_processing_rules_f.object_version_number%TYPE;

325: --
326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'delete_status_process_rule';
329: l_object_version_number pay_status_processing_rules_f.object_version_number%TYPE;
330: l_effective_start_date pay_status_processing_rules_f.effective_start_date%TYPE;
331: l_effective_end_date pay_status_processing_rules_f.effective_end_date%TYPE;
332: l_effective_date date;
333: l_temp_ovn number := p_object_version_number;

Line 330: l_effective_start_date pay_status_processing_rules_f.effective_start_date%TYPE;

326: -- Declare cursors and local variables
327: --
328: l_proc varchar2(72) := g_package||'delete_status_process_rule';
329: l_object_version_number pay_status_processing_rules_f.object_version_number%TYPE;
330: l_effective_start_date pay_status_processing_rules_f.effective_start_date%TYPE;
331: l_effective_end_date pay_status_processing_rules_f.effective_end_date%TYPE;
332: l_effective_date date;
333: l_temp_ovn number := p_object_version_number;
334: --

Line 331: l_effective_end_date pay_status_processing_rules_f.effective_end_date%TYPE;

327: --
328: l_proc varchar2(72) := g_package||'delete_status_process_rule';
329: l_object_version_number pay_status_processing_rules_f.object_version_number%TYPE;
330: l_effective_start_date pay_status_processing_rules_f.effective_start_date%TYPE;
331: l_effective_end_date pay_status_processing_rules_f.effective_end_date%TYPE;
332: l_effective_date date;
333: l_temp_ovn number := p_object_version_number;
334: --
335: BEGIN