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_CA_RL2_REG dependencies on HR_UTILITY

Line 78: --hr_utility.trace_on('Y','RL2');

74: l_taxyear varchar2(100);
75: l_pre_org_id varchar2(100);
76:
77: begin
78: --hr_utility.trace_on('Y','RL2');
79: hr_utility.trace('begining of range_cursor 1 ');
80:
81: select legislative_parameters
82: into leg_param

Line 79: hr_utility.trace('begining of range_cursor 1 ');

75: l_pre_org_id varchar2(100);
76:
77: begin
78: --hr_utility.trace_on('Y','RL2');
79: hr_utility.trace('begining of range_cursor 1 ');
80:
81: select legislative_parameters
82: into leg_param
83: from pay_payroll_actions ppa

Line 111: hr_utility.trace('End of range_cursor 2 ');

107: and paa_arch.serial_number = nvl(pay_ca_rl2_reg.get_parameter(''PER_ID'',ppa_reg.legislative_parameters),
108: paa_arch.serial_number)
109: order by to_number(paa_arch.serial_number)';
110:
111: hr_utility.trace('End of range_cursor 2 ');
112: end range_cursor;
113: /*
114: -------------------------------- action_creation ----------------------------------
115: */

Line 353: --hr_utility.trace_on('Y','RL2PAPER');

349: and paf.person_id = to_number(paa.serial_number))
350: order by 1,2;
351:
352: begin
353: --hr_utility.trace_on('Y','RL2PAPER');
354: hr_utility.set_location('procpyr',1);
355: hr_utility.trace('begining of action creation 1'||to_char(pactid));
356:
357: /* get report type and effective date */

Line 354: hr_utility.set_location('procpyr',1);

350: order by 1,2;
351:
352: begin
353: --hr_utility.trace_on('Y','RL2PAPER');
354: hr_utility.set_location('procpyr',1);
355: hr_utility.trace('begining of action creation 1'||to_char(pactid));
356:
357: /* get report type and effective date */
358:

Line 355: hr_utility.trace('begining of action creation 1'||to_char(pactid));

351:
352: begin
353: --hr_utility.trace_on('Y','RL2PAPER');
354: hr_utility.set_location('procpyr',1);
355: hr_utility.trace('begining of action creation 1'||to_char(pactid));
356:
357: /* get report type and effective date */
358:
359: select effective_date,

Line 378: hr_utility.trace('legislative parameters is '||l_legislative_parameters);

374: l_legislative_parameters
375: from pay_payroll_actions
376: where payroll_action_id = pactid;
377:
378: hr_utility.trace('legislative parameters is '||l_legislative_parameters);
379:
380: l_year := pay_ca_rl2_reg.get_parameter('TAX_YEAR',l_legislative_parameters);
381: l_year_start := trunc(to_date(l_year,'YYYY'), 'Y');
382: l_year_end := add_months(trunc(to_date(l_year,'YYYY'), 'Y'),12) - 1;

Line 391: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');

387: l_rlreg_pre_org_id := pay_ca_rl2_reg.get_parameter('PRE_ORGANIZATION_ID',l_legislative_parameters);
388:
389: if l_rlreg_pre_org_id is NULL then
390: open c_all_pres;
391: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');
392: else
393: l_pre_org_id := l_rlreg_pre_org_id;
394: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);
395: end if;

Line 394: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);

390: open c_all_pres;
391: hr_utility.trace('else condition after open c_all_pres c_all_asg cursor 6 ');
392: else
393: l_pre_org_id := l_rlreg_pre_org_id;
394: hr_utility.trace('begining of if condition 5 '||l_pre_org_id);
395: end if;
396:
397: -- Code modification for bug 10399514 starts here
398: /* Initializing variable */

Line 422: hr_utility.trace('Begining of else loop for c_all_pres 7 '|| l_pre_org_id);

418: if l_rlreg_pre_org_id is NULL then
419:
420: loop
421: fetch c_all_pres into l_pre_org_id;
422: hr_utility.trace('Begining of else loop for c_all_pres 7 '|| l_pre_org_id);
423:
424: exit when c_all_pres%notfound;
425:
426: open c_first_tax_unit_id(l_pre_org_id);

Line 436: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

432: l_pre_organization_id := to_number(l_pre_org_id);
433:
434: if l_asg_set_id is not null then
435: if l_person_on then
436: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
437: open c_all_asg_in_asgset_range(l_year_start , l_year_end);
438: else
439: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
440: open c_all_asg_in_asgset(l_year_start , l_year_end);

Line 439: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

435: if l_person_on then
436: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
437: open c_all_asg_in_asgset_range(l_year_start , l_year_end);
438: else
439: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
440: open c_all_asg_in_asgset(l_year_start , l_year_end);
441: end if;
442: elsif lv_per_id is not null then
443: hr_utility.trace('opening c_single_asg CURSOR');

Line 443: hr_utility.trace('opening c_single_asg CURSOR');

439: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
440: open c_all_asg_in_asgset(l_year_start , l_year_end);
441: end if;
442: elsif lv_per_id is not null then
443: hr_utility.trace('opening c_single_asg CURSOR');
444: open c_single_asg(l_year_start,l_year_end, lv_per_id);
445: else
446: if l_person_on then
447: hr_utility.trace('opening c_all_asg_range CURSOR');

Line 447: hr_utility.trace('opening c_all_asg_range CURSOR');

443: hr_utility.trace('opening c_single_asg CURSOR');
444: open c_single_asg(l_year_start,l_year_end, lv_per_id);
445: else
446: if l_person_on then
447: hr_utility.trace('opening c_all_asg_range CURSOR');
448: open c_all_asg_range(l_year_start, l_year_end);
449: else
450: hr_utility.trace('opening c_all_asg CURSOR');
451: open c_all_asg(l_year_start, l_year_end);

Line 450: hr_utility.trace('opening c_all_asg CURSOR');

446: if l_person_on then
447: hr_utility.trace('opening c_all_asg_range CURSOR');
448: open c_all_asg_range(l_year_start, l_year_end);
449: else
450: hr_utility.trace('opening c_all_asg CURSOR');
451: open c_all_asg(l_year_start, l_year_end);
452: end if;
453: end if;
454:

Line 495: hr_utility.trace('Not creating assignment action');

491:
492: if (l_person_id = l_prev_person_id and
493: l_pre_org_id = l_prev_pre_org_id) then
494:
495: hr_utility.trace('Not creating assignment action');
496:
497: else
498:
499: /* Get the primary assignment as the primary

Line 521: hr_utility.raise_error;

517: open c_get_asg_id(l_person_id);
518: fetch c_get_asg_id into l_primary_asg,l_effective_end_date;
519: if c_get_asg_id%NOTFOUND then
520: close c_get_asg_id;
521: hr_utility.raise_error;
522: else
523: close c_get_asg_id;
524: end if;
525: end if;

Line 540: hr_utility.trace('No Archived Person Found');

536: fetch c_archived_person_info
537: into ln_arch_asgact_id,
538: ln_arch_pact_id;
539: if c_archived_person_info%notfound then
540: hr_utility.trace('No Archived Person Found');
541: else
542:
543: select pay_assignment_actions_s.nextval
544: into lockingactid

Line 553: hr_utility.trace('after hr_nonrun_asact.insact'||to_char(l_asg_id));

549: pactid,
550: chunk,
551: l_pre_organization_id);
552:
553: hr_utility.trace('after hr_nonrun_asact.insact'||to_char(l_asg_id));
554:
555: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
556: lpad(to_char(ln_arch_pact_id),14,0);
557:

Line 558: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

554:
555: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
556: lpad(to_char(ln_arch_pact_id),14,0);
557:
558: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
559:
560: update pay_assignment_actions paa
561: set paa.serial_number = lv_serial_number
562: where paa.assignment_action_id = lockingactid;

Line 593: hr_utility.trace('No GRE for this PRE ');

589: end if;
590:
591: else
592: close c_first_tax_unit_id;
593: hr_utility.trace('No GRE for this PRE ');
594:
595: end if;
596:
597: end loop;

Line 604: hr_utility.trace('In else');

600: else
601: open c_first_tax_unit_id(l_pre_org_id);
602: fetch c_first_tax_unit_id into l_tax_unit_id;
603:
604: hr_utility.trace('In else');
605: if c_first_tax_unit_id%FOUND then
606: close c_first_tax_unit_id;
607:
608: l_pre_organization_id := to_number(l_pre_org_id);

Line 612: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');

608: l_pre_organization_id := to_number(l_pre_org_id);
609:
610: if l_asg_set_id is not null then
611: if l_person_on then
612: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
613: open c_all_asg_in_asgset_range(l_year_start , l_year_end);
614: else
615: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
616: open c_all_asg_in_asgset(l_year_start , l_year_end);

Line 615: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');

611: if l_person_on then
612: hr_utility.trace('opening c_all_asg_in_asgset_range CURSOR');
613: open c_all_asg_in_asgset_range(l_year_start , l_year_end);
614: else
615: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
616: open c_all_asg_in_asgset(l_year_start , l_year_end);
617: end if;
618: elsif lv_per_id is not null then
619: hr_utility.trace('opening c_single_asg CURSOR');

Line 619: hr_utility.trace('opening c_single_asg CURSOR');

615: hr_utility.trace('opening c_all_asg_in_asgset CURSOR');
616: open c_all_asg_in_asgset(l_year_start , l_year_end);
617: end if;
618: elsif lv_per_id is not null then
619: hr_utility.trace('opening c_single_asg CURSOR');
620: open c_single_asg(l_year_start,l_year_end, lv_per_id);
621: else
622: if l_person_on then
623: hr_utility.trace('opening c_all_asg_range CURSOR');

Line 623: hr_utility.trace('opening c_all_asg_range CURSOR');

619: hr_utility.trace('opening c_single_asg CURSOR');
620: open c_single_asg(l_year_start,l_year_end, lv_per_id);
621: else
622: if l_person_on then
623: hr_utility.trace('opening c_all_asg_range CURSOR');
624: open c_all_asg_range(l_year_start, l_year_end);
625: else
626: hr_utility.trace('opening c_all_asg CURSOR');
627: open c_all_asg(l_year_start, l_year_end);

Line 626: hr_utility.trace('opening c_all_asg CURSOR');

622: if l_person_on then
623: hr_utility.trace('opening c_all_asg_range CURSOR');
624: open c_all_asg_range(l_year_start, l_year_end);
625: else
626: hr_utility.trace('opening c_all_asg CURSOR');
627: open c_all_asg(l_year_start, l_year_end);
628: end if;
629: end if;
630:

Line 673: hr_utility.trace('Not creating assignment action');

669:
670: if (l_person_id = l_prev_person_id and
671: l_pre_org_id = l_prev_pre_org_id) then
672:
673: hr_utility.trace('Not creating assignment action');
674:
675: else
676:
677: /* Get the primary assignment as the primary

Line 699: hr_utility.raise_error;

695: open c_get_asg_id(l_person_id);
696: fetch c_get_asg_id into l_primary_asg,l_effective_end_date;
697: if c_get_asg_id%NOTFOUND then
698: close c_get_asg_id;
699: hr_utility.raise_error;
700: else
701: close c_get_asg_id;
702: end if;
703: end if;

Line 718: hr_utility.trace('No Archived Person Found');

714: fetch c_archived_person_info
715: into ln_arch_asgact_id,
716: ln_arch_pact_id;
717: if c_archived_person_info%notfound then
718: hr_utility.trace('No Archived Person Found');
719: else
720:
721: select pay_assignment_actions_s.nextval
722: into lockingactid

Line 731: hr_utility.trace('after calling hr_nonrun_asact.insact '||to_char(lockingactid));

727: pactid,
728: chunk,
729: l_pre_organization_id);
730:
731: hr_utility.trace('after calling hr_nonrun_asact.insact '||to_char(lockingactid));
732:
733: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
734: lpad(to_char(ln_arch_pact_id),14,0);
735:

Line 736: hr_utility.trace('lv_serial_number :' ||lv_serial_number);

732:
733: lv_serial_number := 'QC' ||lpad(to_char(ln_arch_asgact_id),14,0)||
734: lpad(to_char(ln_arch_pact_id),14,0);
735:
736: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
737:
738: update pay_assignment_actions paa
739: set paa.serial_number = lv_serial_number
740: where paa.assignment_action_id = lockingactid;

Line 769: hr_utility.trace('End of cursor c_all_asg 12');

765: close c_all_asg;
766: end if;
767: end if;
768:
769: hr_utility.trace('End of cursor c_all_asg 12');
770: else
771: close c_first_tax_unit_id;
772: hr_utility.trace('No GRE for this PRE ');
773: end if;

Line 772: hr_utility.trace('No GRE for this PRE ');

768:
769: hr_utility.trace('End of cursor c_all_asg 12');
770: else
771: close c_first_tax_unit_id;
772: hr_utility.trace('No GRE for this PRE ');
773: end if;
774: end if;
775: end action_creation;
776: /*

Line 785: hr_utility.trace('Start of Sort_Action 1');

781: sqlstr in out nocopy varchar2, /* string holding the sql statement */
782: len out nocopy number) /* length of the sql string */
783: is
784: begin
785: hr_utility.trace('Start of Sort_Action 1');
786:
787: sqlstr := 'select paa1.rowid /* we need the row id of the assignment actions that are created by PYUGEN */
788: from hr_all_organization_units hou1,
789: hr_all_organization_units hou,

Line 827: hr_utility.trace('End of Sort_Action 2');

823: ''RL1_LOC'',loc.location_code,null)
824: ,ppf.last_name,ppf.first_name';
825:
826: len := length(sqlstr); -- return the length of the string.
827: hr_utility.trace('End of Sort_Action 2');
828: end sort_action;
829: /*
830: ------------------------------ get_parameter -------------------------------
831: */