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

Line 59: hr_utility.set_location(gv_package_name || '.data_string', 10);

55:
56: lv_format varchar2(32000);
57:
58: BEGIN
59: hr_utility.set_location(gv_package_name || '.data_string', 10);
60:
61: if p_output_file_type = 'CSV' then
62:
63:

Line 64: hr_utility.set_location(gv_package_name || '.data_string', 20);

60:
61: if p_output_file_type = 'CSV' then
62:
63:
64: hr_utility.set_location(gv_package_name || '.data_string', 20);
65:
66: lv_format := gc_csv_data_delimiter || p_input_string ||
67: gc_csv_data_delimiter || gc_csv_delimiter;
68:

Line 71: hr_utility.set_location(gv_package_name || '.data_string', 60);

67: gc_csv_data_delimiter || gc_csv_delimiter;
68:
69: end if;
70:
71: hr_utility.set_location(gv_package_name || '.data_string', 60);
72:
73: return lv_format;
74:
75: END data_string;

Line 94: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

90: lv_format2 varchar2(32000);
91:
92: BEGIN
93:
94: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
95:
96: IF p_header = 'Header1' THEN
97:
98: lv_format1 := data_string (p_input_string => gv_title

Line 324: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

320:
321:
322: BEGIN
323:
324: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
325: lv_format1 :=
326: data_string (p_input_string => p_employer_name
327: ,p_output_file_type => p_output_file_type)||
328: data_string (p_input_string => p_federal_ein

Line 429: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

425: ,p_output_file_type => p_output_file_type);
426:
427:
428:
429: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
430:
431:
432: hr_utility.trace('Static Data1 = ' || lv_format1);
433: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

Line 432: hr_utility.trace('Static Data1 = ' || lv_format1);

428:
429: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
430:
431:
432: hr_utility.trace('Static Data1 = ' || lv_format1);
433: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
434:
435: return (lv_format1);
436: END;

Line 433: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

429: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
430:
431:
432: hr_utility.trace('Static Data1 = ' || lv_format1);
433: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
434:
435: return (lv_format1);
436: END;
437:

Line 570: --hr_utility.trace_on(null, 'W3CAUDIT');

566: l_incorrect_name pay_us_rpt_totals.attribute27%TYPE := ' ';
567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN
569:
570: --hr_utility.trace_on(null, 'W3CAUDIT');
571: hr_utility.trace ('Entered Main package');
572: hr_utility.trace ('p_seq_num = '||p_seq_num);
573:
574:

Line 571: hr_utility.trace ('Entered Main package');

567: l_incorrect_ssn pay_us_rpt_totals.attribute28%TYPE := ' ';
568: BEGIN
569:
570: --hr_utility.trace_on(null, 'W3CAUDIT');
571: hr_utility.trace ('Entered Main package');
572: hr_utility.trace ('p_seq_num = '||p_seq_num);
573:
574:
575: open c_get_data(p_seq_num);

Line 572: hr_utility.trace ('p_seq_num = '||p_seq_num);

568: BEGIN
569:
570: --hr_utility.trace_on(null, 'W3CAUDIT');
571: hr_utility.trace ('Entered Main package');
572: hr_utility.trace ('p_seq_num = '||p_seq_num);
573:
574:
575: open c_get_data(p_seq_num);
576:

Line 577: hr_utility.trace('Opened c_get_data cursor');

573:
574:
575: open c_get_data(p_seq_num);
576:
577: hr_utility.trace('Opened c_get_data cursor');
578:
579: loop
580:
581: l_tax_unit_id :=0;

Line 705: hr_utility.trace('l_employer_name = '||l_employer_name);

701: l_employer_name := replace(l_employer_name,',');
702: l_employee_name := replace(l_employee_name,',');
703:
704:
705: hr_utility.trace('l_employer_name = '||l_employer_name);
706: hr_utility.trace('l_employee_name = '||l_employee_name);
707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);

Line 706: hr_utility.trace('l_employee_name = '||l_employee_name);

702: l_employee_name := replace(l_employee_name,',');
703:
704:
705: hr_utility.trace('l_employer_name = '||l_employer_name);
706: hr_utility.trace('l_employee_name = '||l_employee_name);
707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);

Line 708: hr_utility.trace('l_record_type = '||l_record_type);

704:
705: hr_utility.trace('l_employer_name = '||l_employer_name);
706: hr_utility.trace('l_employee_name = '||l_employee_name);
707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);

Line 709: hr_utility.trace('l_federal_ein = '||l_federal_ein);

705: hr_utility.trace('l_employer_name = '||l_employer_name);
706: hr_utility.trace('l_employee_name = '||l_employee_name);
707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);

Line 710: hr_utility.trace('l_fed_ein = '||l_fed_ein);

706: hr_utility.trace('l_employee_name = '||l_employee_name);
707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);

Line 711: hr_utility.trace('l_employee_name = '||l_employee_name);

707:
708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));

Line 712: hr_utility.trace('l_ssn = '||l_ssn);

708: hr_utility.trace('l_record_type = '||l_record_type);
709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));

Line 713: hr_utility.trace('l_record_type = '||l_record_type);

709: hr_utility.trace('l_federal_ein = '||l_federal_ein);
710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));

Line 714: hr_utility.trace('l_tax_year = '||l_tax_year);

710: hr_utility.trace('l_fed_ein = '||l_fed_ein);
711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));

Line 715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));

711: hr_utility.trace('l_employee_name = '||l_employee_name);
712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));

Line 716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));

712: hr_utility.trace('l_ssn = '||l_ssn);
713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));

Line 717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));

713: hr_utility.trace('l_record_type = '||l_record_type);
714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));

Line 718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));

714: hr_utility.trace('l_tax_year = '||l_tax_year);
715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));

Line 719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));

715: hr_utility.trace('l_wages_old = '||to_char(l_wages_old));
716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));

Line 720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));

716: hr_utility.trace('l_wages_new = '||to_char(l_wages_new));
717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));

Line 721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));

717: hr_utility.trace('l_fit_old = '||to_char(l_fit_old));
718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));

Line 722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));

718: hr_utility.trace('l_fit_new = '||to_char(l_fit_new));
719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));

Line 723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));

719: hr_utility.trace('l_ss_wages_old = '||to_char(l_ss_wages_old));
720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));

Line 724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));

720: hr_utility.trace('l_ss_wages_new = '||to_char(l_ss_wages_new));
721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));

Line 725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));

721: hr_utility.trace('l_ss_withheld_old = '||to_char(l_ss_withheld_old));
722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));

Line 726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));

722: hr_utility.trace('l_ss_withheld_new = '||to_char(l_ss_withheld_new));
723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));

Line 727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));

723: hr_utility.trace('l_medi_wages_old = '||to_char(l_medi_wages_old));
724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));

Line 728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));

724: hr_utility.trace('l_medi_wages_new = '||to_char(l_medi_wages_new));
725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));

Line 729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));

725: hr_utility.trace('l_medi_withheld_old = '||to_char(l_medi_withheld_old));
726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));

Line 730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));

726: hr_utility.trace('l_medi_withheld_new = '||to_char(l_medi_withheld_new));
727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));

Line 731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));

727: hr_utility.trace('l_ss_tips_old = '||to_char(l_ss_tips_old));
728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));

Line 732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));

728: hr_utility.trace('l_ss_tips_new = '||to_char(l_ss_tips_new));
729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));

Line 733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));

729: hr_utility.trace('l_alloc_tips_old = '||to_char(l_alloc_tips_old));
730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));

Line 734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));

730: hr_utility.trace('l_alloc_tips_new = '||to_char(l_alloc_tips_new));
731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));

Line 735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));

731: hr_utility.trace('l_eic_old = '||to_char(l_eic_old));
732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);

Line 736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));

732: hr_utility.trace('l_eic_new = '||to_char(l_eic_new));
733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);

Line 737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));

733: hr_utility.trace('l_depcare_old = '||to_char(l_depcare_old));
734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);

Line 738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));

734: hr_utility.trace('l_depcare_new = '||to_char(l_depcare_new));
735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);

Line 739: hr_utility.trace('l_box_12_code = '||l_box_12_code);

735: hr_utility.trace('l_nonqual_old = '||to_char(l_nonqual_old));
736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);

Line 740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);

736: hr_utility.trace('l_nonqual_new = '||to_char(l_nonqual_new));
737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);

Line 741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);

737: hr_utility.trace('l_third_party_sick_old = '||to_char(l_third_party_sick_old));
738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);

Line 742: hr_utility.trace('l_box_14_code = '||l_box_14_code);

738: hr_utility.trace('l_third_party_sick_new = '||to_char(l_third_party_sick_new));
739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);

Line 743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);

739: hr_utility.trace('l_box_12_code = '||l_box_12_code);
740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);

Line 744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);

740: hr_utility.trace('l_box_12_value_old = '||l_box_12_value_old);
741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);

Line 745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);

741: hr_utility.trace('l_box_12_value_new = '||l_box_12_value_new);
742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);

Line 746: hr_utility.trace('l_state_id_number = '||l_state_id_number);

742: hr_utility.trace('l_box_14_code = '||l_box_14_code);
743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);

Line 747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);

743: hr_utility.trace('l_box_14_value_old = '||l_box_14_value_old);
744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);

Line 748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);

744: hr_utility.trace('l_box_14_value_new = '||l_box_14_value_new);
745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);

Line 749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);

745: hr_utility.trace('l_state_abbrev = '||l_state_abbrev);
746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);

Line 750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);

746: hr_utility.trace('l_state_id_number = '||l_state_id_number);
747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);

Line 751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);

747: hr_utility.trace('l_state_id_sring = '||l_state_id_sring);
748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);

Line 752: hr_utility.trace('l_sit_old = '||l_sit_old);

748: hr_utility.trace('l_state_inco_id_number = '||l_state_inco_id_number);
749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);

Line 753: hr_utility.trace('l_sit_new = '||l_sit_new);

749: hr_utility.trace('l_state_inco_id_string = '||l_state_inco_id_string);
750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);

Line 754: hr_utility.trace('l_state_local_name = '||l_state_local_name);

750: hr_utility.trace('l_ss_wages_tips_old = '||l_ss_wages_tips_old);
751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);

Line 755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);

751: hr_utility.trace('l_ss_wages_tips_new = '||l_ss_wages_tips_new);
752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);

Line 756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);

752: hr_utility.trace('l_sit_old = '||l_sit_old);
753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);
760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);

Line 757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);

753: hr_utility.trace('l_sit_new = '||l_sit_new);
754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);
760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);
761:

Line 758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);

754: hr_utility.trace('l_state_local_name = '||l_state_local_name);
755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);
760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);
761:
762: exit when c_get_data%NOTFOUND;

Line 759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);

755: hr_utility.trace('l_local_wages_old = '||l_local_wages_old);
756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);
760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);
761:
762: exit when c_get_data%NOTFOUND;
763:

Line 760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);

756: hr_utility.trace('l_local_wages_new = '||l_local_wages_new);
757: hr_utility.trace('l_local_withheld_old = '||l_local_withheld_old);
758: hr_utility.trace('l_local_withheld_new = '||l_local_withheld_new);
759: hr_utility.trace('l_incorrect_name = '||l_incorrect_name);
760: hr_utility.trace('l_incorrect_ssn = '||l_incorrect_ssn);
761:
762: exit when c_get_data%NOTFOUND;
763:
764: if c_get_data%ROWCOUNT =1 THEN

Line 767: hr_utility.trace('row_count = 1');

763:
764: if c_get_data%ROWCOUNT =1 THEN
765:
766:
767: hr_utility.trace('row_count = 1');
768:
769: fnd_file.put_line(fnd_file.output,report_header('CSV','Header1'));
770: fnd_file.put_line(fnd_file.output,report_header('CSV','Header2'));
771:

Line 774: hr_utility.trace ('Writing report data = ');

770: fnd_file.put_line(fnd_file.output,report_header('CSV','Header2'));
771:
772: end if;
773:
774: hr_utility.trace ('Writing report data = ');
775:
776: fnd_file.put_line(fnd_file.output,report_data(
777: l_employer_name,
778: l_fed_ein,

Line 832: hr_utility.trace ('out of loop = ');

828:
829: end loop;
830:
831:
832: hr_utility.trace ('out of loop = ');
833:
834: DELETE FROM pay_us_rpt_totals
835: WHERE session_id = p_seq_num ;
836: