APPS.HR_LEG_RULE dependencies on HR_LEG_RULE

Line 1: package body hr_leg_rule as

1: package body hr_leg_rule as
2: /* $Header: pylegrle.pkb 115.1 99/07/17 06:15:33 porting ship $ */
3: --
4: -- these two variables cache the independent_time_periods flag
5: last_tested_business_group_id number;

Line 17: if hr_leg_rule.last_tested_business_group_id is null or

13: For efficiency (since the value is likely to be the same
14: for any given installation) we "cache" the flag's value
15: against business_group_id.
16: */
17: if hr_leg_rule.last_tested_business_group_id is null or
18: hr_leg_rule.last_tested_business_group_id <> l_business_group_id then
19: --
20: -- we need to fetch the value
21: begin

Line 18: hr_leg_rule.last_tested_business_group_id <> l_business_group_id then

14: for any given installation) we "cache" the flag's value
15: against business_group_id.
16: */
17: if hr_leg_rule.last_tested_business_group_id is null or
18: hr_leg_rule.last_tested_business_group_id <> l_business_group_id then
19: --
20: -- we need to fetch the value
21: begin
22: select LR.rule_mode

Line 23: into hr_leg_rule.last_found_flag

19: --
20: -- we need to fetch the value
21: begin
22: select LR.rule_mode
23: into hr_leg_rule.last_found_flag
24: from pay_legislation_rules LR
25: where LR.rule_type = 'I'
26: and LR.legislation_code =
27: (select BG.legislation_code

Line 32: when no_data_found then hr_leg_rule.last_found_flag := 'Y';

28: from per_business_groups BG
29: where BG.business_group_id = l_business_group_id);
30: exception
31: -- if there is no rule, we set a default (independent periods).
32: when no_data_found then hr_leg_rule.last_found_flag := 'Y';
33: end;
34: --
35: hr_leg_rule.last_tested_business_group_id := l_business_group_id;
36: end if;

Line 35: hr_leg_rule.last_tested_business_group_id := l_business_group_id;

31: -- if there is no rule, we set a default (independent periods).
32: when no_data_found then hr_leg_rule.last_found_flag := 'Y';
33: end;
34: --
35: hr_leg_rule.last_tested_business_group_id := l_business_group_id;
36: end if;
37: return hr_leg_rule.last_found_flag;
38: --
39: end get_independent_periods;

Line 37: return hr_leg_rule.last_found_flag;

33: end;
34: --
35: hr_leg_rule.last_tested_business_group_id := l_business_group_id;
36: end if;
37: return hr_leg_rule.last_found_flag;
38: --
39: end get_independent_periods;
40: --
41: -- Initialisation Section

Line 45: hr_leg_rule.last_tested_business_group_id := null;

41: -- Initialisation Section
42: -- ----------------------
43: --
44: begin
45: hr_leg_rule.last_tested_business_group_id := null;
46: --
47: end hr_leg_rule;

Line 47: end hr_leg_rule;

43: --
44: begin
45: hr_leg_rule.last_tested_business_group_id := null;
46: --
47: end hr_leg_rule;