eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PYJPEXC dependencies on HR_UTILITY

Line 53: hr_utility.set_location('Entering : ' || c_proc, 10);

49: --
50: l_owner_time_period_id number;
51: l_user_time_period_id number;
52: begin
53: hr_utility.set_location('Entering : ' || c_proc, 10);
54: hr_utility.trace(p_dimension_name);
55: --
56: select ppa_owner.time_period_id,
57: ppa_user.time_period_id

Line 54: hr_utility.trace(p_dimension_name);

50: l_owner_time_period_id number;
51: l_user_time_period_id number;
52: begin
53: hr_utility.set_location('Entering : ' || c_proc, 10);
54: hr_utility.trace(p_dimension_name);
55: --
56: select ppa_owner.time_period_id,
57: ppa_user.time_period_id
58: into l_owner_time_period_id,

Line 68: hr_utility.trace('NOT expired');

64: --
65: -- Note this expiry checking mechanism has bug.2646992
66: --
67: if l_user_time_period_id = l_owner_time_period_id then
68: hr_utility.trace('NOT expired');
69: p_expiry_information := 0;
70: else
71: hr_utility.trace('expired');
72: p_expiry_information := 1;

Line 71: hr_utility.trace('expired');

67: if l_user_time_period_id = l_owner_time_period_id then
68: hr_utility.trace('NOT expired');
69: p_expiry_information := 0;
70: else
71: hr_utility.trace('expired');
72: p_expiry_information := 1;
73: end if;
74: --
75: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 75: hr_utility.set_location('Leaving : ' || c_proc, 20);

71: hr_utility.trace('expired');
72: p_expiry_information := 1;
73: end if;
74: --
75: hr_utility.set_location('Leaving : ' || c_proc, 20);
76: end ptd_ec;
77: -- ----------------------------------------------------------------------------
78: -- |--------------------------< ptd_ec (date mode)>---------------------------|
79: -- ----------------------------------------------------------------------------

Line 95: hr_utility.set_location('Entering : ' || c_proc, 10);

91: --
92: -- l_owner_time_period_id number;
93: -- l_user_time_period_id number;
94: begin
95: hr_utility.set_location('Entering : ' || c_proc, 10);
96: --
97: select ptp.end_date
98: into p_expiry_information
99: from pay_payroll_actions ppa,

Line 120: hr_utility.trace(p_dimension_name);

116: -- p_owner_effective_date = p_user_effective_date
117: -- This expiry checking is called for both owner and user payroll action,
118: -- then the expiry_date is compared.
119: --
120: hr_utility.trace(p_dimension_name);
121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));

Line 121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));

117: -- This expiry checking is called for both owner and user payroll action,
118: -- then the expiry_date is compared.
119: --
120: hr_utility.trace(p_dimension_name);
121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));

Line 122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));

118: -- then the expiry_date is compared.
119: --
120: hr_utility.trace(p_dimension_name);
121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));

Line 123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));

119: --
120: hr_utility.trace(p_dimension_name);
121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
127: --

Line 124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));

120: hr_utility.trace(p_dimension_name);
121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
127: --
128: -- Following SQL will return period end date in general.

Line 125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));

121: hr_utility.trace('owner_payroll_action_id : ' || to_char(p_owner_payroll_action_id));
122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
127: --
128: -- Following SQL will return period end date in general.
129: -- But the payroll is changed in the middle of the payroll period,

Line 126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));

122: hr_utility.trace('user_payroll_action_id : ' || to_char(p_user_payroll_action_id));
123: hr_utility.trace('owner_assignment_action_id : ' || to_char(p_owner_assignment_action_id));
124: hr_utility.trace('user_assignment_action_id : ' || to_char(p_user_assignment_action_id));
125: hr_utility.trace('owner_effective_date : ' || to_char(p_owner_effective_date));
126: hr_utility.trace('user_effective_date : ' || to_char(p_user_effective_date));
127: --
128: -- Following SQL will return period end date in general.
129: -- But the payroll is changed in the middle of the payroll period,
130: -- this returns the previous date of the date changed.

Line 174: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

170: p_expiry_information := p_user_effective_date;
171: end if;
172: */
173: --
174: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
175: hr_utility.set_location('Leaving : ' || c_proc, 20);
176: end ptd_ec;
177: -- ----------------------------------------------------------------------------
178: -- |--------------------------------< mtd_ec >--------------------------------|

Line 175: hr_utility.set_location('Leaving : ' || c_proc, 20);

171: end if;
172: */
173: --
174: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
175: hr_utility.set_location('Leaving : ' || c_proc, 20);
176: end ptd_ec;
177: -- ----------------------------------------------------------------------------
178: -- |--------------------------------< mtd_ec >--------------------------------|
179: -- ----------------------------------------------------------------------------

Line 192: hr_utility.set_location('Entering : ' || c_proc, 10);

188: p_expiry_information out nocopy number)
189: is
190: c_proc constant varchar2(61) := c_package || 'mtd_ec';
191: begin
192: hr_utility.set_location('Entering : ' || c_proc, 10);
193: hr_utility.trace(p_dimension_name);
194: --
195: if trunc(p_user_effective_date, 'MM') > p_owner_effective_date then
196: hr_utility.trace('expired');

Line 193: hr_utility.trace(p_dimension_name);

189: is
190: c_proc constant varchar2(61) := c_package || 'mtd_ec';
191: begin
192: hr_utility.set_location('Entering : ' || c_proc, 10);
193: hr_utility.trace(p_dimension_name);
194: --
195: if trunc(p_user_effective_date, 'MM') > p_owner_effective_date then
196: hr_utility.trace('expired');
197: p_expiry_information := 1;

Line 196: hr_utility.trace('expired');

192: hr_utility.set_location('Entering : ' || c_proc, 10);
193: hr_utility.trace(p_dimension_name);
194: --
195: if trunc(p_user_effective_date, 'MM') > p_owner_effective_date then
196: hr_utility.trace('expired');
197: p_expiry_information := 1;
198: else
199: hr_utility.trace('NOT expired');
200: p_expiry_information := 0;

Line 199: hr_utility.trace('NOT expired');

195: if trunc(p_user_effective_date, 'MM') > p_owner_effective_date then
196: hr_utility.trace('expired');
197: p_expiry_information := 1;
198: else
199: hr_utility.trace('NOT expired');
200: p_expiry_information := 0;
201: end if;
202: --
203: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 203: hr_utility.set_location('Leaving : ' || c_proc, 20);

199: hr_utility.trace('NOT expired');
200: p_expiry_information := 0;
201: end if;
202: --
203: hr_utility.set_location('Leaving : ' || c_proc, 20);
204: end mtd_ec;
205: -- ----------------------------------------------------------------------------
206: -- |--------------------------< mtd_ec (date mode)>---------------------------|
207: -- ----------------------------------------------------------------------------

Line 220: hr_utility.set_location('Entering : ' || c_proc, 10);

216: p_expiry_information out nocopy date)
217: is
218: c_proc constant varchar2(61) := c_package || 'mtd_ec (date mode)';
219: begin
220: hr_utility.set_location('Entering : ' || c_proc, 10);
221: hr_utility.trace(p_dimension_name);
222: --
223: p_expiry_information := last_day(p_owner_effective_date);
224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 221: hr_utility.trace(p_dimension_name);

217: is
218: c_proc constant varchar2(61) := c_package || 'mtd_ec (date mode)';
219: begin
220: hr_utility.set_location('Entering : ' || c_proc, 10);
221: hr_utility.trace(p_dimension_name);
222: --
223: p_expiry_information := last_day(p_owner_effective_date);
224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
225: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

220: hr_utility.set_location('Entering : ' || c_proc, 10);
221: hr_utility.trace(p_dimension_name);
222: --
223: p_expiry_information := last_day(p_owner_effective_date);
224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
225: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
226: --
227: hr_utility.set_location('Leaving : ' || c_proc, 20);
228: end mtd_ec;

Line 225: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

221: hr_utility.trace(p_dimension_name);
222: --
223: p_expiry_information := last_day(p_owner_effective_date);
224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
225: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
226: --
227: hr_utility.set_location('Leaving : ' || c_proc, 20);
228: end mtd_ec;
229: -- ----------------------------------------------------------------------------

Line 227: hr_utility.set_location('Leaving : ' || c_proc, 20);

223: p_expiry_information := last_day(p_owner_effective_date);
224: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
225: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
226: --
227: hr_utility.set_location('Leaving : ' || c_proc, 20);
228: end mtd_ec;
229: -- ----------------------------------------------------------------------------
230: -- |--------------------------------< qtd_ec >--------------------------------|
231: -- ----------------------------------------------------------------------------

Line 244: hr_utility.set_location('Entering : ' || c_proc, 10);

240: p_expiry_information out nocopy number)
241: is
242: c_proc constant varchar2(61) := c_package || 'qtd_ec';
243: begin
244: hr_utility.set_location('Entering : ' || c_proc, 10);
245: hr_utility.trace(p_dimension_name);
246: --
247: if trunc(p_user_effective_date, 'Q') > p_owner_effective_date then
248: hr_utility.trace('expired');

Line 245: hr_utility.trace(p_dimension_name);

241: is
242: c_proc constant varchar2(61) := c_package || 'qtd_ec';
243: begin
244: hr_utility.set_location('Entering : ' || c_proc, 10);
245: hr_utility.trace(p_dimension_name);
246: --
247: if trunc(p_user_effective_date, 'Q') > p_owner_effective_date then
248: hr_utility.trace('expired');
249: p_expiry_information := 1;

Line 248: hr_utility.trace('expired');

244: hr_utility.set_location('Entering : ' || c_proc, 10);
245: hr_utility.trace(p_dimension_name);
246: --
247: if trunc(p_user_effective_date, 'Q') > p_owner_effective_date then
248: hr_utility.trace('expired');
249: p_expiry_information := 1;
250: else
251: hr_utility.trace('NOT expired');
252: p_expiry_information := 0;

Line 251: hr_utility.trace('NOT expired');

247: if trunc(p_user_effective_date, 'Q') > p_owner_effective_date then
248: hr_utility.trace('expired');
249: p_expiry_information := 1;
250: else
251: hr_utility.trace('NOT expired');
252: p_expiry_information := 0;
253: end if;
254: --
255: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 255: hr_utility.set_location('Leaving : ' || c_proc, 20);

251: hr_utility.trace('NOT expired');
252: p_expiry_information := 0;
253: end if;
254: --
255: hr_utility.set_location('Leaving : ' || c_proc, 20);
256: end qtd_ec;
257: -- ----------------------------------------------------------------------------
258: -- |--------------------------< qtd_ec (date mode)>---------------------------|
259: -- ----------------------------------------------------------------------------

Line 272: hr_utility.set_location('Entering : ' || c_proc, 10);

268: p_expiry_information out nocopy date)
269: is
270: c_proc constant varchar2(61) := c_package || 'qtd_ec (date mode)';
271: begin
272: hr_utility.set_location('Entering : ' || c_proc, 10);
273: hr_utility.trace(p_dimension_name);
274: --
275: p_expiry_information := add_months(trunc(p_owner_effective_date, 'Q'), 3) - 1;
276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 273: hr_utility.trace(p_dimension_name);

269: is
270: c_proc constant varchar2(61) := c_package || 'qtd_ec (date mode)';
271: begin
272: hr_utility.set_location('Entering : ' || c_proc, 10);
273: hr_utility.trace(p_dimension_name);
274: --
275: p_expiry_information := add_months(trunc(p_owner_effective_date, 'Q'), 3) - 1;
276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
277: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

272: hr_utility.set_location('Entering : ' || c_proc, 10);
273: hr_utility.trace(p_dimension_name);
274: --
275: p_expiry_information := add_months(trunc(p_owner_effective_date, 'Q'), 3) - 1;
276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
277: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
278: --
279: hr_utility.set_location('Leaving : ' || c_proc, 20);
280: end qtd_ec;

Line 277: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

273: hr_utility.trace(p_dimension_name);
274: --
275: p_expiry_information := add_months(trunc(p_owner_effective_date, 'Q'), 3) - 1;
276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
277: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
278: --
279: hr_utility.set_location('Leaving : ' || c_proc, 20);
280: end qtd_ec;
281: -- ----------------------------------------------------------------------------

Line 279: hr_utility.set_location('Leaving : ' || c_proc, 20);

275: p_expiry_information := add_months(trunc(p_owner_effective_date, 'Q'), 3) - 1;
276: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
277: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
278: --
279: hr_utility.set_location('Leaving : ' || c_proc, 20);
280: end qtd_ec;
281: -- ----------------------------------------------------------------------------
282: -- |--------------------------------< ytd_ec >--------------------------------|
283: -- ----------------------------------------------------------------------------

Line 296: hr_utility.set_location('Entering : ' || c_proc, 10);

292: p_expiry_information out nocopy number)
293: is
294: c_proc constant varchar2(61) := c_package || 'ytd_ec';
295: begin
296: hr_utility.set_location('Entering : ' || c_proc, 10);
297: hr_utility.trace(p_dimension_name);
298: --
299: if trunc(p_user_effective_date, 'YYYY') > p_owner_effective_date then
300: hr_utility.trace('expired');

Line 297: hr_utility.trace(p_dimension_name);

293: is
294: c_proc constant varchar2(61) := c_package || 'ytd_ec';
295: begin
296: hr_utility.set_location('Entering : ' || c_proc, 10);
297: hr_utility.trace(p_dimension_name);
298: --
299: if trunc(p_user_effective_date, 'YYYY') > p_owner_effective_date then
300: hr_utility.trace('expired');
301: p_expiry_information := 1;

Line 300: hr_utility.trace('expired');

296: hr_utility.set_location('Entering : ' || c_proc, 10);
297: hr_utility.trace(p_dimension_name);
298: --
299: if trunc(p_user_effective_date, 'YYYY') > p_owner_effective_date then
300: hr_utility.trace('expired');
301: p_expiry_information := 1;
302: else
303: hr_utility.trace('NOT expired');
304: p_expiry_information := 0;

Line 303: hr_utility.trace('NOT expired');

299: if trunc(p_user_effective_date, 'YYYY') > p_owner_effective_date then
300: hr_utility.trace('expired');
301: p_expiry_information := 1;
302: else
303: hr_utility.trace('NOT expired');
304: p_expiry_information := 0;
305: end if;
306: --
307: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 307: hr_utility.set_location('Leaving : ' || c_proc, 20);

303: hr_utility.trace('NOT expired');
304: p_expiry_information := 0;
305: end if;
306: --
307: hr_utility.set_location('Leaving : ' || c_proc, 20);
308: end ytd_ec;
309: -- ----------------------------------------------------------------------------
310: -- |--------------------------< ytd_ec (date mode)>---------------------------|
311: -- ----------------------------------------------------------------------------

Line 324: hr_utility.set_location('Entering : ' || c_proc, 10);

320: p_expiry_information out nocopy date)
321: is
322: c_proc constant varchar2(61) := c_package || 'ytd_ec (date mode)';
323: begin
324: hr_utility.set_location('Entering : ' || c_proc, 10);
325: hr_utility.trace(p_dimension_name);
326: --
327: p_expiry_information := add_months(trunc(p_owner_effective_date, 'YYYY'), 12) - 1;
328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 325: hr_utility.trace(p_dimension_name);

321: is
322: c_proc constant varchar2(61) := c_package || 'ytd_ec (date mode)';
323: begin
324: hr_utility.set_location('Entering : ' || c_proc, 10);
325: hr_utility.trace(p_dimension_name);
326: --
327: p_expiry_information := add_months(trunc(p_owner_effective_date, 'YYYY'), 12) - 1;
328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
329: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

324: hr_utility.set_location('Entering : ' || c_proc, 10);
325: hr_utility.trace(p_dimension_name);
326: --
327: p_expiry_information := add_months(trunc(p_owner_effective_date, 'YYYY'), 12) - 1;
328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
329: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
330: --
331: hr_utility.set_location('Leaving : ' || c_proc, 20);
332: end ytd_ec;

Line 329: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

325: hr_utility.trace(p_dimension_name);
326: --
327: p_expiry_information := add_months(trunc(p_owner_effective_date, 'YYYY'), 12) - 1;
328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
329: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
330: --
331: hr_utility.set_location('Leaving : ' || c_proc, 20);
332: end ytd_ec;
333: -- ----------------------------------------------------------------------------

Line 331: hr_utility.set_location('Leaving : ' || c_proc, 20);

327: p_expiry_information := add_months(trunc(p_owner_effective_date, 'YYYY'), 12) - 1;
328: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
329: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
330: --
331: hr_utility.set_location('Leaving : ' || c_proc, 20);
332: end ytd_ec;
333: -- ----------------------------------------------------------------------------
334: -- |-------------------------------< aprtd_ec >-------------------------------|
335: -- ----------------------------------------------------------------------------

Line 348: hr_utility.set_location('Entering : ' || c_proc, 10);

344: p_expiry_information out nocopy number)
345: is
346: c_proc constant varchar2(61) := c_package || 'aprtd_ec';
347: begin
348: hr_utility.set_location('Entering : ' || c_proc, 10);
349: hr_utility.trace(p_dimension_name);
350: --
351: if add_months(trunc(add_months(p_user_effective_date, 9), 'YYYY'), -9) > p_owner_effective_date then
352: hr_utility.trace('expired');

Line 349: hr_utility.trace(p_dimension_name);

345: is
346: c_proc constant varchar2(61) := c_package || 'aprtd_ec';
347: begin
348: hr_utility.set_location('Entering : ' || c_proc, 10);
349: hr_utility.trace(p_dimension_name);
350: --
351: if add_months(trunc(add_months(p_user_effective_date, 9), 'YYYY'), -9) > p_owner_effective_date then
352: hr_utility.trace('expired');
353: p_expiry_information := 1;

Line 352: hr_utility.trace('expired');

348: hr_utility.set_location('Entering : ' || c_proc, 10);
349: hr_utility.trace(p_dimension_name);
350: --
351: if add_months(trunc(add_months(p_user_effective_date, 9), 'YYYY'), -9) > p_owner_effective_date then
352: hr_utility.trace('expired');
353: p_expiry_information := 1;
354: else
355: hr_utility.trace('NOT expired');
356: p_expiry_information := 0;

Line 355: hr_utility.trace('NOT expired');

351: if add_months(trunc(add_months(p_user_effective_date, 9), 'YYYY'), -9) > p_owner_effective_date then
352: hr_utility.trace('expired');
353: p_expiry_information := 1;
354: else
355: hr_utility.trace('NOT expired');
356: p_expiry_information := 0;
357: end if;
358: --
359: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 359: hr_utility.set_location('Leaving : ' || c_proc, 20);

355: hr_utility.trace('NOT expired');
356: p_expiry_information := 0;
357: end if;
358: --
359: hr_utility.set_location('Leaving : ' || c_proc, 20);
360: end aprtd_ec;
361: -- ----------------------------------------------------------------------------
362: -- |-------------------------< aprtd_ec (date mode)>--------------------------|
363: -- ----------------------------------------------------------------------------

Line 376: hr_utility.set_location('Entering : ' || c_proc, 10);

372: p_expiry_information out nocopy date)
373: is
374: c_proc constant varchar2(61) := c_package || 'aprtd_ec (date mode)';
375: begin
376: hr_utility.set_location('Entering : ' || c_proc, 10);
377: hr_utility.trace(p_dimension_name);
378: --
379: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 9), 'YYYY'), 3) - 1;
380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 377: hr_utility.trace(p_dimension_name);

373: is
374: c_proc constant varchar2(61) := c_package || 'aprtd_ec (date mode)';
375: begin
376: hr_utility.set_location('Entering : ' || c_proc, 10);
377: hr_utility.trace(p_dimension_name);
378: --
379: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 9), 'YYYY'), 3) - 1;
380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
381: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

376: hr_utility.set_location('Entering : ' || c_proc, 10);
377: hr_utility.trace(p_dimension_name);
378: --
379: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 9), 'YYYY'), 3) - 1;
380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
381: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
382: --
383: hr_utility.set_location('Leaving : ' || c_proc, 20);
384: end aprtd_ec;

Line 381: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

377: hr_utility.trace(p_dimension_name);
378: --
379: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 9), 'YYYY'), 3) - 1;
380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
381: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
382: --
383: hr_utility.set_location('Leaving : ' || c_proc, 20);
384: end aprtd_ec;
385: -- ----------------------------------------------------------------------------

Line 383: hr_utility.set_location('Leaving : ' || c_proc, 20);

379: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 9), 'YYYY'), 3) - 1;
380: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
381: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
382: --
383: hr_utility.set_location('Leaving : ' || c_proc, 20);
384: end aprtd_ec;
385: -- ----------------------------------------------------------------------------
386: -- |-------------------------------< aprtd_sd >-------------------------------|
387: -- ----------------------------------------------------------------------------

Line 397: hr_utility.set_location('Entering : ' || c_proc, 10);

393: p_asg_action in number)
394: is
395: c_proc constant varchar2(61) := c_package || 'aprtd_sd';
396: begin
397: hr_utility.set_location('Entering : ' || c_proc, 10);
398: --
399: p_start_date := add_months(trunc(add_months(p_effective_date, 9), 'YYYY'), -9);
400: hr_utility.trace('start_date : ' || to_char(p_start_date));
401: --

Line 400: hr_utility.trace('start_date : ' || to_char(p_start_date));

396: begin
397: hr_utility.set_location('Entering : ' || c_proc, 10);
398: --
399: p_start_date := add_months(trunc(add_months(p_effective_date, 9), 'YYYY'), -9);
400: hr_utility.trace('start_date : ' || to_char(p_start_date));
401: --
402: hr_utility.set_location('Leaving : ' || c_proc, 20);
403: end aprtd_sd;
404: -- ----------------------------------------------------------------------------

Line 402: hr_utility.set_location('Leaving : ' || c_proc, 20);

398: --
399: p_start_date := add_months(trunc(add_months(p_effective_date, 9), 'YYYY'), -9);
400: hr_utility.trace('start_date : ' || to_char(p_start_date));
401: --
402: hr_utility.set_location('Leaving : ' || c_proc, 20);
403: end aprtd_sd;
404: -- ----------------------------------------------------------------------------
405: -- |-------------------------------< jultd_ec >-------------------------------|
406: -- ----------------------------------------------------------------------------

Line 419: hr_utility.set_location('Entering : ' || c_proc, 10);

415: p_expiry_information out nocopy number)
416: is
417: c_proc constant varchar2(61) := c_package || 'jultd_ec';
418: begin
419: hr_utility.set_location('Entering : ' || c_proc, 10);
420: hr_utility.trace(p_dimension_name);
421: --
422: if add_months(trunc(add_months(p_user_effective_date, 6), 'YYYY'), -6) > p_owner_effective_date then
423: hr_utility.trace('expired');

Line 420: hr_utility.trace(p_dimension_name);

416: is
417: c_proc constant varchar2(61) := c_package || 'jultd_ec';
418: begin
419: hr_utility.set_location('Entering : ' || c_proc, 10);
420: hr_utility.trace(p_dimension_name);
421: --
422: if add_months(trunc(add_months(p_user_effective_date, 6), 'YYYY'), -6) > p_owner_effective_date then
423: hr_utility.trace('expired');
424: p_expiry_information := 1;

Line 423: hr_utility.trace('expired');

419: hr_utility.set_location('Entering : ' || c_proc, 10);
420: hr_utility.trace(p_dimension_name);
421: --
422: if add_months(trunc(add_months(p_user_effective_date, 6), 'YYYY'), -6) > p_owner_effective_date then
423: hr_utility.trace('expired');
424: p_expiry_information := 1;
425: else
426: hr_utility.trace('NOT expired');
427: p_expiry_information := 0;

Line 426: hr_utility.trace('NOT expired');

422: if add_months(trunc(add_months(p_user_effective_date, 6), 'YYYY'), -6) > p_owner_effective_date then
423: hr_utility.trace('expired');
424: p_expiry_information := 1;
425: else
426: hr_utility.trace('NOT expired');
427: p_expiry_information := 0;
428: end if;
429: --
430: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 430: hr_utility.set_location('Leaving : ' || c_proc, 20);

426: hr_utility.trace('NOT expired');
427: p_expiry_information := 0;
428: end if;
429: --
430: hr_utility.set_location('Leaving : ' || c_proc, 20);
431: end jultd_ec;
432: -- ----------------------------------------------------------------------------
433: -- |-------------------------< jultd_ec (date mode)>--------------------------|
434: -- ----------------------------------------------------------------------------

Line 447: hr_utility.set_location('Entering : ' || c_proc, 10);

443: p_expiry_information out nocopy date)
444: is
445: c_proc constant varchar2(61) := c_package || 'jultd_ec (date mode)';
446: begin
447: hr_utility.set_location('Entering : ' || c_proc, 10);
448: hr_utility.trace(p_dimension_name);
449: --
450: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 6), 'YYYY'), 6) - 1;
451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 448: hr_utility.trace(p_dimension_name);

444: is
445: c_proc constant varchar2(61) := c_package || 'jultd_ec (date mode)';
446: begin
447: hr_utility.set_location('Entering : ' || c_proc, 10);
448: hr_utility.trace(p_dimension_name);
449: --
450: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 6), 'YYYY'), 6) - 1;
451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
452: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

447: hr_utility.set_location('Entering : ' || c_proc, 10);
448: hr_utility.trace(p_dimension_name);
449: --
450: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 6), 'YYYY'), 6) - 1;
451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
452: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
453: --
454: hr_utility.set_location('Leaving : ' || c_proc, 20);
455: end jultd_ec;

Line 452: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

448: hr_utility.trace(p_dimension_name);
449: --
450: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 6), 'YYYY'), 6) - 1;
451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
452: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
453: --
454: hr_utility.set_location('Leaving : ' || c_proc, 20);
455: end jultd_ec;
456: -- ----------------------------------------------------------------------------

Line 454: hr_utility.set_location('Leaving : ' || c_proc, 20);

450: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 6), 'YYYY'), 6) - 1;
451: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
452: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
453: --
454: hr_utility.set_location('Leaving : ' || c_proc, 20);
455: end jultd_ec;
456: -- ----------------------------------------------------------------------------
457: -- |-------------------------------< jultd_sd >-------------------------------|
458: -- ----------------------------------------------------------------------------

Line 468: hr_utility.set_location('Entering : ' || c_proc, 10);

464: p_asg_action in number)
465: is
466: c_proc constant varchar2(61) := c_package || 'jultd_sd';
467: begin
468: hr_utility.set_location('Entering : ' || c_proc, 10);
469: --
470: p_start_date := add_months(trunc(add_months(p_effective_date, 6), 'YYYY'), -6);
471: hr_utility.trace('start_date : ' || to_char(p_start_date));
472: --

Line 471: hr_utility.trace('start_date : ' || to_char(p_start_date));

467: begin
468: hr_utility.set_location('Entering : ' || c_proc, 10);
469: --
470: p_start_date := add_months(trunc(add_months(p_effective_date, 6), 'YYYY'), -6);
471: hr_utility.trace('start_date : ' || to_char(p_start_date));
472: --
473: hr_utility.set_location('Leaving : ' || c_proc, 20);
474: end jultd_sd;
475: -- ----------------------------------------------------------------------------

Line 473: hr_utility.set_location('Leaving : ' || c_proc, 20);

469: --
470: p_start_date := add_months(trunc(add_months(p_effective_date, 6), 'YYYY'), -6);
471: hr_utility.trace('start_date : ' || to_char(p_start_date));
472: --
473: hr_utility.set_location('Leaving : ' || c_proc, 20);
474: end jultd_sd;
475: -- ----------------------------------------------------------------------------
476: -- |-------------------------------< augtd_ec >-------------------------------|
477: -- ----------------------------------------------------------------------------

Line 490: hr_utility.set_location('Entering : ' || c_proc, 10);

486: p_expiry_information out nocopy number)
487: is
488: c_proc constant varchar2(61) := c_package || 'augtd_ec';
489: begin
490: hr_utility.set_location('Entering : ' || c_proc, 10);
491: hr_utility.trace(p_dimension_name);
492: --
493: if add_months(trunc(add_months(p_user_effective_date, 5), 'YYYY'), -5) > p_owner_effective_date then
494: hr_utility.trace('expired');

Line 491: hr_utility.trace(p_dimension_name);

487: is
488: c_proc constant varchar2(61) := c_package || 'augtd_ec';
489: begin
490: hr_utility.set_location('Entering : ' || c_proc, 10);
491: hr_utility.trace(p_dimension_name);
492: --
493: if add_months(trunc(add_months(p_user_effective_date, 5), 'YYYY'), -5) > p_owner_effective_date then
494: hr_utility.trace('expired');
495: p_expiry_information := 1;

Line 494: hr_utility.trace('expired');

490: hr_utility.set_location('Entering : ' || c_proc, 10);
491: hr_utility.trace(p_dimension_name);
492: --
493: if add_months(trunc(add_months(p_user_effective_date, 5), 'YYYY'), -5) > p_owner_effective_date then
494: hr_utility.trace('expired');
495: p_expiry_information := 1;
496: else
497: hr_utility.trace('NOT expired');
498: p_expiry_information := 0;

Line 497: hr_utility.trace('NOT expired');

493: if add_months(trunc(add_months(p_user_effective_date, 5), 'YYYY'), -5) > p_owner_effective_date then
494: hr_utility.trace('expired');
495: p_expiry_information := 1;
496: else
497: hr_utility.trace('NOT expired');
498: p_expiry_information := 0;
499: end if;
500: --
501: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 501: hr_utility.set_location('Leaving : ' || c_proc, 20);

497: hr_utility.trace('NOT expired');
498: p_expiry_information := 0;
499: end if;
500: --
501: hr_utility.set_location('Leaving : ' || c_proc, 20);
502: end augtd_ec;
503: -- ----------------------------------------------------------------------------
504: -- |-------------------------< augtd_ec (date mode)>--------------------------|
505: -- ----------------------------------------------------------------------------

Line 518: hr_utility.set_location('Entering : ' || c_proc, 10);

514: p_expiry_information out nocopy date)
515: is
516: c_proc constant varchar2(61) := c_package || 'augtd_ec (date mode)';
517: begin
518: hr_utility.set_location('Entering : ' || c_proc, 10);
519: hr_utility.trace(p_dimension_name);
520: --
521: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 5), 'YYYY'), 7) - 1;
522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

Line 519: hr_utility.trace(p_dimension_name);

515: is
516: c_proc constant varchar2(61) := c_package || 'augtd_ec (date mode)';
517: begin
518: hr_utility.set_location('Entering : ' || c_proc, 10);
519: hr_utility.trace(p_dimension_name);
520: --
521: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 5), 'YYYY'), 7) - 1;
522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
523: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

Line 522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

518: hr_utility.set_location('Entering : ' || c_proc, 10);
519: hr_utility.trace(p_dimension_name);
520: --
521: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 5), 'YYYY'), 7) - 1;
522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
523: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
524: --
525: hr_utility.set_location('Leaving : ' || c_proc, 20);
526: end augtd_ec;

Line 523: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

519: hr_utility.trace(p_dimension_name);
520: --
521: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 5), 'YYYY'), 7) - 1;
522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
523: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
524: --
525: hr_utility.set_location('Leaving : ' || c_proc, 20);
526: end augtd_ec;
527: -- ----------------------------------------------------------------------------

Line 525: hr_utility.set_location('Leaving : ' || c_proc, 20);

521: p_expiry_information := add_months(trunc(add_months(p_owner_effective_date, 5), 'YYYY'), 7) - 1;
522: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
523: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
524: --
525: hr_utility.set_location('Leaving : ' || c_proc, 20);
526: end augtd_ec;
527: -- ----------------------------------------------------------------------------
528: -- |-------------------------------< augtd_sd >-------------------------------|
529: -- ----------------------------------------------------------------------------

Line 539: hr_utility.set_location('Entering : ' || c_proc, 10);

535: p_asg_action in number)
536: is
537: c_proc constant varchar2(61) := c_package || 'augtd_sd';
538: begin
539: hr_utility.set_location('Entering : ' || c_proc, 10);
540: --
541: p_start_date := add_months(trunc(add_months(p_effective_date, 5), 'YYYY'), -5);
542: hr_utility.trace('start_date : ' || to_char(p_start_date));
543: --

Line 542: hr_utility.trace('start_date : ' || to_char(p_start_date));

538: begin
539: hr_utility.set_location('Entering : ' || c_proc, 10);
540: --
541: p_start_date := add_months(trunc(add_months(p_effective_date, 5), 'YYYY'), -5);
542: hr_utility.trace('start_date : ' || to_char(p_start_date));
543: --
544: hr_utility.set_location('Leaving : ' || c_proc, 20);
545: end augtd_sd;
546: -- ----------------------------------------------------------------------------

Line 544: hr_utility.set_location('Leaving : ' || c_proc, 20);

540: --
541: p_start_date := add_months(trunc(add_months(p_effective_date, 5), 'YYYY'), -5);
542: hr_utility.trace('start_date : ' || to_char(p_start_date));
543: --
544: hr_utility.set_location('Leaving : ' || c_proc, 20);
545: end augtd_sd;
546: -- ----------------------------------------------------------------------------
547: -- |----------------------------< fy_start_date >-----------------------------|
548: -- ----------------------------------------------------------------------------

Line 560: hr_utility.set_location('Entering : ' || c_proc, 10);

556: from hr_organization_information
557: where organization_id = p_business_group_id
558: and org_information_context = 'Business Group Information';
559: begin
560: hr_utility.set_location('Entering : ' || c_proc, 10);
561: --
562: -- Once the fiscal year is derived from BG, the value is stored
563: -- in global variables to reduce the overhead.
564: --

Line 566: hr_utility.trace('cache available');

562: -- Once the fiscal year is derived from BG, the value is stored
563: -- in global variables to reduce the overhead.
564: --
565: if p_business_group_id = g_fy_cache.business_group_id then
566: hr_utility.trace('cache available');
567: l_fy_start_date := g_fy_cache.start_date;
568: else
569: hr_utility.trace('cache NOT available');
570: --

Line 569: hr_utility.trace('cache NOT available');

565: if p_business_group_id = g_fy_cache.business_group_id then
566: hr_utility.trace('cache available');
567: l_fy_start_date := g_fy_cache.start_date;
568: else
569: hr_utility.trace('cache NOT available');
570: --
571: open csr_fy_start_date(p_business_group_id);
572: fetch csr_fy_start_date into l_fy_start_date;
573: close csr_fy_start_date;

Line 583: hr_utility.trace('fy_start_date : ' || to_char(l_fy_start_date));

579: g_fy_cache.start_date := l_fy_start_date;
580: end if;
581: end if;
582: --
583: hr_utility.trace('fy_start_date : ' || to_char(l_fy_start_date));
584: hr_utility.set_location('Leaving : ' || c_proc, 20);
585: --
586: return l_fy_start_date;
587: end fy_start_date;

Line 584: hr_utility.set_location('Leaving : ' || c_proc, 20);

580: end if;
581: end if;
582: --
583: hr_utility.trace('fy_start_date : ' || to_char(l_fy_start_date));
584: hr_utility.set_location('Leaving : ' || c_proc, 20);
585: --
586: return l_fy_start_date;
587: end fy_start_date;
588: -- ----------------------------------------------------------------------------

Line 597: hr_utility.set_location('Entering : ' || c_proc, 10);

593: c_proc constant varchar2(61) := c_package || 'business_group_id';
594: --
595: l_business_group_id number;
596: begin
597: hr_utility.set_location('Entering : ' || c_proc, 10);
598: --
599: if p_payroll_action_id = g_pact_cache.payroll_action_id then
600: hr_utility.trace('cache available');
601: l_business_group_id := g_pact_cache.business_group_id;

Line 600: hr_utility.trace('cache available');

596: begin
597: hr_utility.set_location('Entering : ' || c_proc, 10);
598: --
599: if p_payroll_action_id = g_pact_cache.payroll_action_id then
600: hr_utility.trace('cache available');
601: l_business_group_id := g_pact_cache.business_group_id;
602: else
603: hr_utility.trace('cache NOT available');
604: --

Line 603: hr_utility.trace('cache NOT available');

599: if p_payroll_action_id = g_pact_cache.payroll_action_id then
600: hr_utility.trace('cache available');
601: l_business_group_id := g_pact_cache.business_group_id;
602: else
603: hr_utility.trace('cache NOT available');
604: --
605: select business_group_id
606: into l_business_group_id
607: from pay_payroll_actions

Line 616: hr_utility.set_location('Leaving : ' || c_proc, 20);

612: g_pact_cache.payroll_action_id := p_payroll_action_id;
613: g_pact_cache.business_group_id := l_business_group_id;
614: end if;
615: --
616: hr_utility.set_location('Leaving : ' || c_proc, 20);
617: --
618: return l_business_group_id;
619: end business_group_id;
620: -- ----------------------------------------------------------------------------

Line 638: hr_utility.set_location('Entering : ' || c_proc, 10);

634: --
635: l_fy_start_date date;
636: l_start_date date;
637: begin
638: hr_utility.set_location('Entering : ' || c_proc, 10);
639: hr_utility.trace(p_dimension_name);
640: --
641: -- Bind p_user_payroll_action_id not p_owner_payroll_action_id
642: -- to use cache as much as possible.

Line 639: hr_utility.trace(p_dimension_name);

635: l_fy_start_date date;
636: l_start_date date;
637: begin
638: hr_utility.set_location('Entering : ' || c_proc, 10);
639: hr_utility.trace(p_dimension_name);
640: --
641: -- Bind p_user_payroll_action_id not p_owner_payroll_action_id
642: -- to use cache as much as possible.
643: --

Line 648: hr_utility.trace('expired');

644: l_fy_start_date := fy_start_date(business_group_id(p_user_payroll_action_id));
645: l_start_date := add_months(l_fy_start_date, floor(months_between(p_user_effective_date, l_fy_start_date) / 3) * 3);
646: --
647: if l_start_date > p_owner_effective_date then
648: hr_utility.trace('expired');
649: p_expiry_information := 1;
650: else
651: hr_utility.trace('NOT expired');
652: p_expiry_information := 0;

Line 651: hr_utility.trace('NOT expired');

647: if l_start_date > p_owner_effective_date then
648: hr_utility.trace('expired');
649: p_expiry_information := 1;
650: else
651: hr_utility.trace('NOT expired');
652: p_expiry_information := 0;
653: end if;
654: --
655: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 655: hr_utility.set_location('Leaving : ' || c_proc, 20);

651: hr_utility.trace('NOT expired');
652: p_expiry_information := 0;
653: end if;
654: --
655: hr_utility.set_location('Leaving : ' || c_proc, 20);
656: end fqtd_ec;
657: -- ----------------------------------------------------------------------------
658: -- |--------------------------< fqtd_ec (date mode)>--------------------------|
659: -- ----------------------------------------------------------------------------

Line 674: hr_utility.set_location('Entering : ' || c_proc, 10);

670: c_proc constant varchar2(61) := c_package || 'fqtd_ec (date mode)';
671: --
672: l_fy_start_date date;
673: begin
674: hr_utility.set_location('Entering : ' || c_proc, 10);
675: hr_utility.trace(p_dimension_name);
676: --
677: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
678: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 3) + 1) * 3) - 1;

Line 675: hr_utility.trace(p_dimension_name);

671: --
672: l_fy_start_date date;
673: begin
674: hr_utility.set_location('Entering : ' || c_proc, 10);
675: hr_utility.trace(p_dimension_name);
676: --
677: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
678: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 3) + 1) * 3) - 1;
679: --

Line 680: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

676: --
677: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
678: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 3) + 1) * 3) - 1;
679: --
680: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
681: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
682: --
683: hr_utility.set_location('Leaving : ' || c_proc, 20);
684: end fqtd_ec;

Line 681: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

677: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
678: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 3) + 1) * 3) - 1;
679: --
680: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
681: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
682: --
683: hr_utility.set_location('Leaving : ' || c_proc, 20);
684: end fqtd_ec;
685: -- ----------------------------------------------------------------------------

Line 683: hr_utility.set_location('Leaving : ' || c_proc, 20);

679: --
680: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
681: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
682: --
683: hr_utility.set_location('Leaving : ' || c_proc, 20);
684: end fqtd_ec;
685: -- ----------------------------------------------------------------------------
686: -- |-------------------------------< fytd_ec >--------------------------------|
687: -- ----------------------------------------------------------------------------

Line 703: hr_utility.set_location('Entering : ' || c_proc, 10);

699: --
700: l_fy_start_date date;
701: l_start_date date;
702: begin
703: hr_utility.set_location('Entering : ' || c_proc, 10);
704: hr_utility.trace(p_dimension_name);
705: --
706: l_fy_start_date := fy_start_date(business_group_id(p_user_payroll_action_id));
707: l_start_date := add_months(l_fy_start_date, floor(months_between(p_user_effective_date, l_fy_start_date) / 12) * 12);

Line 704: hr_utility.trace(p_dimension_name);

700: l_fy_start_date date;
701: l_start_date date;
702: begin
703: hr_utility.set_location('Entering : ' || c_proc, 10);
704: hr_utility.trace(p_dimension_name);
705: --
706: l_fy_start_date := fy_start_date(business_group_id(p_user_payroll_action_id));
707: l_start_date := add_months(l_fy_start_date, floor(months_between(p_user_effective_date, l_fy_start_date) / 12) * 12);
708: --

Line 710: hr_utility.trace('expired');

706: l_fy_start_date := fy_start_date(business_group_id(p_user_payroll_action_id));
707: l_start_date := add_months(l_fy_start_date, floor(months_between(p_user_effective_date, l_fy_start_date) / 12) * 12);
708: --
709: if l_start_date > p_owner_effective_date then
710: hr_utility.trace('expired');
711: p_expiry_information := 1;
712: else
713: hr_utility.trace('NOT expired');
714: p_expiry_information := 0;

Line 713: hr_utility.trace('NOT expired');

709: if l_start_date > p_owner_effective_date then
710: hr_utility.trace('expired');
711: p_expiry_information := 1;
712: else
713: hr_utility.trace('NOT expired');
714: p_expiry_information := 0;
715: end if;
716: --
717: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 717: hr_utility.set_location('Leaving : ' || c_proc, 20);

713: hr_utility.trace('NOT expired');
714: p_expiry_information := 0;
715: end if;
716: --
717: hr_utility.set_location('Leaving : ' || c_proc, 20);
718: end fytd_ec;
719: -- ----------------------------------------------------------------------------
720: -- |--------------------------< fytd_ec (date mode)>--------------------------|
721: -- ----------------------------------------------------------------------------

Line 736: hr_utility.set_location('Entering : ' || c_proc, 10);

732: c_proc constant varchar2(61) := c_package || 'fytd_ec (date mode)';
733: --
734: l_fy_start_date date;
735: begin
736: hr_utility.set_location('Entering : ' || c_proc, 10);
737: hr_utility.trace(p_dimension_name);
738: --
739: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
740: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 12) + 1) * 12) - 1;

Line 737: hr_utility.trace(p_dimension_name);

733: --
734: l_fy_start_date date;
735: begin
736: hr_utility.set_location('Entering : ' || c_proc, 10);
737: hr_utility.trace(p_dimension_name);
738: --
739: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
740: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 12) + 1) * 12) - 1;
741: --

Line 742: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));

738: --
739: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
740: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 12) + 1) * 12) - 1;
741: --
742: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
743: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
744: --
745: hr_utility.set_location('Leaving : ' || c_proc, 20);
746: end fytd_ec;

Line 743: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));

739: l_fy_start_date := fy_start_date(business_group_id(p_owner_payroll_action_id));
740: p_expiry_information := add_months(l_fy_start_date, (floor(months_between(p_owner_effective_date, l_fy_start_date) / 12) + 1) * 12) - 1;
741: --
742: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
743: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
744: --
745: hr_utility.set_location('Leaving : ' || c_proc, 20);
746: end fytd_ec;
747: -- ----------------------------------------------------------------------------

Line 745: hr_utility.set_location('Leaving : ' || c_proc, 20);

741: --
742: hr_utility.trace('owner_date : ' || to_char(p_owner_effective_date));
743: hr_utility.trace('expiry_date : ' || to_char(p_expiry_information));
744: --
745: hr_utility.set_location('Leaving : ' || c_proc, 20);
746: end fytd_ec;
747: -- ----------------------------------------------------------------------------
748: -- |---------------------------< show_dim_periods >---------------------------|
749: -- ----------------------------------------------------------------------------

Line 848: -- hr_utility.trace_on('F', 'TTAGAWA');

844: end show_dim_periods;
845: */
846: --
847: --begin
848: -- hr_utility.trace_on('F', 'TTAGAWA');
849: end pyjpexc;