[Home] [Help]
104: 30.45 12-Sep-97 550269 RThirlby Explicitly open csr_qualifying_pattern
105: to prevent invalid_cursor error.
106: 30.46 29-Sep-97 504386 RThirlby Call qualifying_days_in_period for the
107: absence as a whole so that the pl/sql
108: table in hr_calendar_pkg is populated
109: once for the whole sickness absence.
110: 30.47 03-Dec-97 589806 RThirlby Made allowance for open ended absence
111: in call to qualifying_days_in_period.
112: 30.48 05-Dec-97 593097 RThirlby Forces end_date to be the next
1897: -- Look for a personal SSP qualifying pattern.
1898: --
1899: l_primary_key_value := p_person_id;
1900: l_person_primary_key_value := l_primary_key_value;
1901: l_purpose_usage_id := hr_calendar_pkg.purpose_usage_id ('PERSON',
1902: 'QUALIFYING PATTERN');
1903: l_person_purpose_usage_id := l_purpose_usage_id;
1904: --
1905: l_first_absence := TRUE;
1923: then
1924: --6658285 end
1925: l_primary_key_value := p_business_group_id;
1926: l_bg_primary_key_value := l_primary_key_value;
1927: l_purpose_usage_id := hr_calendar_pkg.purpose_usage_id(
1928: 'ORGANIZATION',
1929: 'QUALIFYING PATTERN');
1930: l_bg_purpose_usage_id := l_purpose_usage_id;
1931: --
1960: then
1961: --6658285 end
1962: l_primary_key_value := p_business_group_id;
1963: l_bg_primary_key_value := l_primary_key_value;
1964: l_purpose_usage_id :=hr_calendar_pkg.purpose_usage_id(
1965: 'ORGANIZATION',
1966: 'QUALIFYING PATTERN');
1967: l_bg_purpose_usage_id := l_purpose_usage_id;
1968: --
2005: l_person_primary_key_value := null;
2006: l_person_purpose_usage_id := null;
2007: l_primary_key_value:= p_business_group_id;
2008: l_bg_primary_key_value := l_primary_key_value;
2009: l_purpose_usage_id := hr_calendar_pkg.purpose_usage_id(
2010: 'ORGANIZATION',
2011: 'QUALIFYING PATTERN');
2012: l_bg_purpose_usage_id := l_purpose_usage_id;
2013: --
2029: hr_utility.trace('BG PATTERN USAGE ID: '||l_bg_purpose_usage_id);
2030: hr_utility.trace('BG PRIMARY KEY VALUE: '||l_bg_primary_key_value);
2031: hr_utility.trace('PERIOD FROM/TO: '||p_period_from||' -> '||p_period_to);
2032: --
2033: -- call new overloaded version of hr_calendar_pkg.total_availability
2034: --
2035: l_qualifying_days := hr_calendar_pkg.total_availability (
2036: p_availability => 'QUALIFYING',
2037: p_person_purpose_usage_id => l_person_purpose_usage_id,
2031: hr_utility.trace('PERIOD FROM/TO: '||p_period_from||' -> '||p_period_to);
2032: --
2033: -- call new overloaded version of hr_calendar_pkg.total_availability
2034: --
2035: l_qualifying_days := hr_calendar_pkg.total_availability (
2036: p_availability => 'QUALIFYING',
2037: p_person_purpose_usage_id => l_person_purpose_usage_id,
2038: p_person_primary_key_value => l_person_primary_key_value,
2039: p_bg_purpose_usage_id => l_bg_purpose_usage_id,
2976: end if;
2977: end if;
2978: --
2979: -- Bug 504386 - Call qualifying_days_in_period for the whole sickness absence,
2980: -- so that the pl/sql table normal_pattern in hr_calendar_pkg only need be
2981: -- populated once.
2982: --
2983: -- Bug 655707 - Calling qualifying_days_in_period with PIW start/end dates, thus
2984: -- if there is more than absence then the calendar doesn't have to be rederived.
2986: -- Bug 589806 - If an open ended absence is entered then
2987: -- each_absence.sickness_end_date is defaulted to the 'end_of_time'. Hence
2988: -- performance is terrible. Now, if the is sickness_end_date is the end_of_time
2989: -- then 203 days are added to the sickness_start_date. 203 days will allow the
2990: -- pl/sql table normal_pattern in hr_calendar_pkg to be populated with the
2991: -- dates to cover the whole open ended absence.
2992: --
2993: -- Bug 655707 - Changed 203 to be Max SSP period, unless this is null, so that
2994: -- this is not legislation specific.