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

Line 290: hr_utility.trace('Entering pay_ip_bal_upload.international_payroll');

286: p_legislation_code IN VARCHAR2) RETURN BOOLEAN IS
287: l_idx binary_integer;
288: l_route_name ff_routes.route_name%type;
289: BEGIN
290: hr_utility.trace('Entering pay_ip_bal_upload.international_payroll');
291:
292: --
293: -- Check to see if the dimension/route exists in the support list.
294: --

Line 306: hr_utility.trace('Exiting pay_ip_bal_upload.international_payroll');

302: else
303: return false;
304: end if;
305:
306: hr_utility.trace('Exiting pay_ip_bal_upload.international_payroll');
307: END international_payroll;
308:
309:
310: -- -------------------------------------------------------------------------

Line 395: hr_utility.trace('Entering pay_ip_bal_upload.expiry_date');

391: l_itd_start_date date;
392: l_oe_start_date date;
393: BEGIN
394:
395: hr_utility.trace('Entering pay_ip_bal_upload.expiry_date');
396:
397: l_route_name := get_dim_route_name
398: (p_dimension_name => p_dimension_name
399: ,p_legislation_code => p_legislation_code);

Line 401: hr_utility.trace('Route='||l_route_name);

397: l_route_name := get_dim_route_name
398: (p_dimension_name => p_dimension_name
399: ,p_legislation_code => p_legislation_code);
400:
401: hr_utility.trace('Route='||l_route_name);
402: --
403: -- Get the ITD start date.
404: --
405: get_expiry_date_info

Line 412: hr_utility.trace('Asg Start Date='||l_itd_start_date);

408: ,p_itd_start_date => l_itd_start_date
409: );
410:
411: --
412: hr_utility.trace('Asg Start Date='||l_itd_start_date);
413:
414: --
415: -- Get the original entry start date.
416: --

Line 428: hr_utility.trace('OE Start Date='||l_oe_start_date);

424: fetch csr_oe_start_date into l_oe_start_date;
425: close csr_oe_start_date;
426:
427: l_oe_start_date := nvl(l_oe_start_date, END_OF_TIME);
428: hr_utility.trace('OE Start Date='||l_oe_start_date);
429:
430: end if;
431:
432: IF l_route_name IN ( 'Global Assignment Processing Period To Date',

Line 439: hr_utility.trace('Period Start Date=' || l_expiry_date);

435:
436: open csr_start_of_date(p_assignment_id, p_upload_date);
437: fetch csr_start_of_date into l_expiry_date;
438: close csr_start_of_date;
439: hr_utility.trace('Period Start Date=' || l_expiry_date);
440:
441: ELSIF l_route_name IN ( 'Global Assignment Inception To Date',
442: 'Global Element Entry Inception To Date',
443: 'Global Assignment Within Tax Unit Inception To Date') THEN

Line 445: hr_utility.trace('Asg Start Date=' || l_expiry_date);

441: ELSIF l_route_name IN ( 'Global Assignment Inception To Date',
442: 'Global Element Entry Inception To Date',
443: 'Global Assignment Within Tax Unit Inception To Date') THEN
444: l_expiry_date := l_itd_start_date;
445: hr_utility.trace('Asg Start Date=' || l_expiry_date);
446:
447: ELSIF l_route_name IN ( 'Global Assignment Calendar Month To Date',
448: 'Global Element Entry Calendar Month To Date',
449: 'Global Assignment Within Tax Unit Calendar Month To Date') THEN

Line 451: hr_utility.trace('Mth Start Date=' || l_expiry_date);

447: ELSIF l_route_name IN ( 'Global Assignment Calendar Month To Date',
448: 'Global Element Entry Calendar Month To Date',
449: 'Global Assignment Within Tax Unit Calendar Month To Date') THEN
450: l_expiry_date := TRUNC(p_upload_date,'MM');
451: hr_utility.trace('Mth Start Date=' || l_expiry_date);
452:
453: ELSIF l_route_name IN ( 'Global Assignment Calendar Quarter To Date',
454: 'Global Element Entry Calendar Quarter To Date',
455: 'Global Assignment Within Tax Unit Calendar Quarter To Date') THEN

Line 457: hr_utility.trace('Qtr Start Date=' || l_expiry_date);

453: ELSIF l_route_name IN ( 'Global Assignment Calendar Quarter To Date',
454: 'Global Element Entry Calendar Quarter To Date',
455: 'Global Assignment Within Tax Unit Calendar Quarter To Date') THEN
456: l_expiry_date := TRUNC(p_upload_date,'Q');
457: hr_utility.trace('Qtr Start Date=' || l_expiry_date);
458:
459: ELSIF l_route_name IN ( 'Global Assignment Calendar Year To Date',
460: 'Global Element Entry Calendar Year To Date',
461: 'Global Assignment Within Tax Unit Calendar Year To Date') THEN

Line 463: hr_utility.trace('Year Start Date=' || l_expiry_date);

459: ELSIF l_route_name IN ( 'Global Assignment Calendar Year To Date',
460: 'Global Element Entry Calendar Year To Date',
461: 'Global Assignment Within Tax Unit Calendar Year To Date') THEN
462: l_expiry_date := TRUNC(p_upload_date,'Y');
463: hr_utility.trace('Year Start Date=' || l_expiry_date);
464:
465: ELSIF l_route_name IN ( 'Global Assignment Tax Quarter To Date',
466: 'Global Assignment Within Tax Unit Tax Quarter To Date') THEN
467: l_expiry_date := pay_ip_route_support.tax_quarter(p_business_group_id, p_upload_date);

Line 468: hr_utility.trace('Tax Qtr Start Date=' || l_expiry_date);

464:
465: ELSIF l_route_name IN ( 'Global Assignment Tax Quarter To Date',
466: 'Global Assignment Within Tax Unit Tax Quarter To Date') THEN
467: l_expiry_date := pay_ip_route_support.tax_quarter(p_business_group_id, p_upload_date);
468: hr_utility.trace('Tax Qtr Start Date=' || l_expiry_date);
469:
470: ELSIF l_route_name IN ( 'Global Assignment Tax Year To Date',
471: 'Global Assignment Within Tax Unit Tax Year To Date') THEN
472: l_expiry_date := pay_ip_route_support.tax_year(p_business_group_id, p_upload_date);

Line 473: hr_utility.trace('Tax Year Start Date=' || l_expiry_date);

469:
470: ELSIF l_route_name IN ( 'Global Assignment Tax Year To Date',
471: 'Global Assignment Within Tax Unit Tax Year To Date') THEN
472: l_expiry_date := pay_ip_route_support.tax_year(p_business_group_id, p_upload_date);
473: hr_utility.trace('Tax Year Start Date=' || l_expiry_date);
474:
475: ELSIF l_route_name IN ( 'Global Assignment Fiscal Quarter To Date',
476: 'Global Assignment Within Tax Unit Fiscal Quarter To Date') THEN
477: l_expiry_date := pay_ip_route_support.fiscal_quarter(p_business_group_id, p_upload_date);

Line 478: hr_utility.trace('FQ Start Date=' || l_expiry_date);

474:
475: ELSIF l_route_name IN ( 'Global Assignment Fiscal Quarter To Date',
476: 'Global Assignment Within Tax Unit Fiscal Quarter To Date') THEN
477: l_expiry_date := pay_ip_route_support.fiscal_quarter(p_business_group_id, p_upload_date);
478: hr_utility.trace('FQ Start Date=' || l_expiry_date);
479:
480: ELSIF l_route_name IN ( 'Global Assignment Fiscal Year To Date',
481: 'Global Assignment Within Tax Unit Fiscal Year To Date') THEN
482: l_expiry_date := pay_ip_route_support.fiscal_year(p_business_group_id, p_upload_date);

Line 483: hr_utility.trace('FY Start Date=' || l_expiry_date);

479:
480: ELSIF l_route_name IN ( 'Global Assignment Fiscal Year To Date',
481: 'Global Assignment Within Tax Unit Fiscal Year To Date') THEN
482: l_expiry_date := pay_ip_route_support.fiscal_year(p_business_group_id, p_upload_date);
483: hr_utility.trace('FY Start Date=' || l_expiry_date);
484:
485: ELSE
486: --
487: -- Dimension not supported.

Line 490: hr_utility.trace('Dimension Not Supported. ' || p_dimension_name);

486: --
487: -- Dimension not supported.
488: --
489: l_expiry_date := END_OF_TIME;
490: hr_utility.trace('Dimension Not Supported. ' || p_dimension_name);
491:
492: END IF;
493:
494: l_expiry_date := nvl(greatest(l_itd_start_date

Line 500: hr_utility.trace('Expiry date is later than upload_date! expiry_date='||l_expiry_date);

496: ,nvl(l_oe_start_date, l_expiry_date)
497: ), END_OF_TIME);
498:
499: if (l_expiry_date <> END_OF_TIME) and (l_expiry_date > p_upload_date) then
500: hr_utility.trace('Expiry date is later than upload_date! expiry_date='||l_expiry_date);
501: --
502: l_expiry_date := END_OF_TIME;
503: end if;
504:

Line 505: hr_utility.trace('Exiting pay_ip_bal_upload.expiry_date');

501: --
502: l_expiry_date := END_OF_TIME;
503: end if;
504:
505: hr_utility.trace('Exiting pay_ip_bal_upload.expiry_date');
506:
507: RETURN l_expiry_date;
508:
509: END expiry_date;

Line 565: hr_utility.trace('Entering pay_ip_bal_upload.include_adjustment');

561:
562: l_route_name FF_ROUTES.ROUTE_NAME%TYPE;
563: BEGIN
564:
565: hr_utility.trace('Entering pay_ip_bal_upload.include_adjustment');
566:
567: l_route_name := get_dim_route_name
568: (p_dimension_name => p_dimension_name
569: ,p_legislation_code => p_legislation_code);

Line 622: hr_utility.trace('Exiting pay_ip_bal_upload.include_adjustment');

618: ELSE
619: NULL;
620: END IF;
621:
622: hr_utility.trace('Exiting pay_ip_bal_upload.include_adjustment');
623:
624: RETURN l_include_adj;
625:
626: END include_adjustment;