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.PYIEEXC dependencies on HR_UTILITY

Line 150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);

146: p_expiry_information out NOCOPY date -- dimension expired flag.
147: ) is
148: l_period_start_date date;
149: begin
150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

Line 151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);

147: ) is
148: l_period_start_date date;
149: begin
150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

Line 152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);

148: l_period_start_date date;
149: begin
150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

Line 153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);

149: begin
150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
157: p_expiry_information := next_period(p_owner_payroll_action_id,

Line 154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

150: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
157: p_expiry_information := next_period(p_owner_payroll_action_id,
158: p_owner_effective_date) - 1;

Line 155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

151: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
157: p_expiry_information := next_period(p_owner_payroll_action_id,
158: p_owner_effective_date) - 1;
159:

Line 156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

152: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
153: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
154: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
155: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
157: p_expiry_information := next_period(p_owner_payroll_action_id,
158: p_owner_effective_date) - 1;
159:
160: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

Line 160: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

156: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
157: p_expiry_information := next_period(p_owner_payroll_action_id,
158: p_owner_effective_date) - 1;
159:
160: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
161: end ASG_PTD_EC;
162:
163: /*------------------------------ ASG_YTD_EC ----------------------------*/
164: /*

Line 225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);

221: ) is
222: l_tax_year_start date;
223: l_user_payroll_id number;
224: begin
225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

Line 226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);

222: l_tax_year_start date;
223: l_user_payroll_id number;
224: begin
225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

Line 227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);

223: l_user_payroll_id number;
224: begin
225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

Line 228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);

224: begin
225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
232: p_expiry_information := next_year(p_owner_effective_date) -1;

Line 229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

225: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
232: p_expiry_information := next_year(p_owner_effective_date) -1;
233:

Line 230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

226: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
232: p_expiry_information := next_year(p_owner_effective_date) -1;
233:
234: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

Line 231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

227: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
228: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
229: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
232: p_expiry_information := next_year(p_owner_effective_date) -1;
233:
234: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
235:

Line 234: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

230: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
231: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
232: p_expiry_information := next_year(p_owner_effective_date) -1;
233:
234: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
235:
236: end ASG_YTD_EC;
237:
238: /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/

Line 302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);

298: ) is
299: l_user_time_period_id number;
300: l_owner_time_period_id number;
301: begin
302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

Line 303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);

299: l_user_time_period_id number;
300: l_owner_time_period_id number;
301: begin
302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

Line 304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);

300: l_owner_time_period_id number;
301: begin
302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

Line 305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);

301: begin
302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
309:

Line 306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

302: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
309:
310: p_expiry_information := next_period(p_owner_payroll_action_id,

Line 307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

303: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
309:
310: p_expiry_information := next_period(p_owner_payroll_action_id,
311: p_owner_effective_date) - 1;

Line 308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

304: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
305: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
306: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
307: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
309:
310: p_expiry_information := next_period(p_owner_payroll_action_id,
311: p_owner_effective_date) - 1;
312: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

Line 312: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

308: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
309:
310: p_expiry_information := next_period(p_owner_payroll_action_id,
311: p_owner_effective_date) - 1;
312: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
313: end ASG_PROC_PTD_EC;
314: /*------------------------------ ASG_QTD_EC ----------------------------*/
315: /*
316: NAME

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

332: p_dimension_name in varchar2, -- balance dimension name.
333: p_expiry_information out NOCOPY number -- dimension expired flag.
334: ) is
335: begin
336: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
337: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
338: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
339: THEN
340: hr_utility.trace(' 1 ');

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

333: p_expiry_information out NOCOPY number -- dimension expired flag.
334: ) is
335: begin
336: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
337: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
338: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
339: THEN
340: hr_utility.trace(' 1 ');
341: P_expiry_information := 1; -- Expired!

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

336: hr_utility.trace('p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'));
337: hr_utility.trace('p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'));
338: IF p_user_effective_date >= trunc(add_months(p_owner_effective_date,3),'Q')
339: THEN
340: hr_utility.trace(' 1 ');
341: P_expiry_information := 1; -- Expired!
342: ELSE
343: hr_utility.trace(' 0 ');
344: P_expiry_information := 0; -- OK!

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

339: THEN
340: hr_utility.trace(' 1 ');
341: P_expiry_information := 1; -- Expired!
342: ELSE
343: hr_utility.trace(' 0 ');
344: P_expiry_information := 0; -- OK!
345: END IF;
346: end ASG_QTD_EC;
347:

Line 361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);

357: p_dimension_name in varchar2, -- balance dimension name.
358: p_expiry_information out NOCOPY date -- dimension expired flag.
359: ) is
360: begin
361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

Line 362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);

358: p_expiry_information out NOCOPY date -- dimension expired flag.
359: ) is
360: begin
361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

Line 363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);

359: ) is
360: begin
361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

Line 364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);

360: begin
361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
368: p_expiry_information := next_quarter(p_owner_effective_date) - 1;

Line 365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

361: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
368: p_expiry_information := next_quarter(p_owner_effective_date) - 1;
369:

Line 366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

362: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
368: p_expiry_information := next_quarter(p_owner_effective_date) - 1;
369:
370: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

Line 367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

363: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
364: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
365: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
368: p_expiry_information := next_quarter(p_owner_effective_date) - 1;
369:
370: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
371: end ASG_QTD_EC;

Line 370: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

366: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
367: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
368: p_expiry_information := next_quarter(p_owner_effective_date) - 1;
369:
370: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
371: end ASG_QTD_EC;
372: /*------------------------------ ASG_TWO_YTD_EC ----------------------------*/
373: /*
374: NAME

Line 434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);

430: ) is
431: l_tax_year_start date;
432: l_user_payroll_id number;
433: begin
434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

Line 435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);

431: l_tax_year_start date;
432: l_user_payroll_id number;
433: begin
434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

Line 436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);

432: l_user_payroll_id number;
433: begin
434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

Line 437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);

433: begin
434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
441: p_expiry_information := next_two_year(p_owner_effective_date) -1;

Line 438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);

434: hr_utility.set_location('k:p_owner_payroll_action_id ' || p_owner_payroll_action_id,10);
435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
441: p_expiry_information := next_two_year(p_owner_effective_date) -1;
442:

Line 439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);

435: hr_utility.set_location('k:p_user_payroll_action_id ' || p_user_payroll_action_id,20);
436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
441: p_expiry_information := next_two_year(p_owner_effective_date) -1;
442:
443: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

Line 440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);

436: hr_utility.set_location('k:p_owner_assignment_action_id ' || p_owner_assignment_action_id,30);
437: hr_utility.set_location('k:p_user_assignment_action_id ' || p_user_assignment_action_id,40);
438: hr_utility.set_location('k:p_user_effective_date ' || to_char(p_user_effective_date,'dd-mon-yyyy'),50);
439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
441: p_expiry_information := next_two_year(p_owner_effective_date) -1;
442:
443: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
444:

Line 443: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);

439: hr_utility.set_location('k:p_owner_effective_date ' || to_char(p_owner_effective_date,'dd-mon-yyyy'),60);
440: hr_utility.set_location('k:p_dimension_name ' || p_dimension_name,70);
441: p_expiry_information := next_two_year(p_owner_effective_date) -1;
442:
443: hr_utility.set_location('k:p_expiry_information ' || to_char(p_expiry_information,'dd-mon-yyyy'),70);
444:
445: end ASG_TWO_YTD_EC;
446: ----------------------------------------------------------------------------
447: -- Procedure: PROC_TWO_YTD_START