DBA Data[Home] [Help]

APPS.PYIEEXC dependencies on HR_UTILITY

Line 196: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));

192: p_dimension_name in varchar2, -- balance dimension name.
193: p_expiry_information out NOCOPY number -- dimension expired flag.
194: ) is
195: begin
196: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
197: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
198: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
199: THEN
200: hr_utility.trace(' 1 ');

Line 197: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));

193: p_expiry_information out NOCOPY number -- dimension expired flag.
194: ) is
195: begin
196: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
197: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
198: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
199: THEN
200: hr_utility.trace(' 1 ');
201: P_expiry_information := 1; -- Expired!

Line 200: hr_utility.trace(' 1 ');

196: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
197: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
198: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
199: THEN
200: hr_utility.trace(' 1 ');
201: P_expiry_information := 1; -- Expired!
202: ELSE
203: hr_utility.trace(' 0 ');
204: P_expiry_information := 0; -- OK!

Line 203: hr_utility.trace(' 0 ');

199: THEN
200: hr_utility.trace(' 1 ');
201: P_expiry_information := 1; -- Expired!
202: ELSE
203: hr_utility.trace(' 0 ');
204: P_expiry_information := 0; -- OK!
205: END IF;
206: end ASG_QTD_EC;
207: /*------------------------------ ASG_TWO_YTD_EC ----------------------------*/