492: c_item_name varchar2(40);
493: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
494:
495: BEGIN
496: hr_utility.trace('Start of GET_ITEM_DATA ');
497: hr_utility.trace('Parameter Input Values ...');
498: hr_utility.trace('Ccontext value p_assignemnt_id = '
499: || to_char(p_assignment_id));
500: hr_utility.trace(' p_date_earned = '
493: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
494:
495: BEGIN
496: hr_utility.trace('Start of GET_ITEM_DATA ');
497: hr_utility.trace('Parameter Input Values ...');
498: hr_utility.trace('Ccontext value p_assignemnt_id = '
499: || to_char(p_assignment_id));
500: hr_utility.trace(' p_date_earned = '
501: ||p_date_earned);
494:
495: BEGIN
496: hr_utility.trace('Start of GET_ITEM_DATA ');
497: hr_utility.trace('Parameter Input Values ...');
498: hr_utility.trace('Ccontext value p_assignemnt_id = '
499: || to_char(p_assignment_id));
500: hr_utility.trace(' p_date_earned = '
501: ||p_date_earned);
502: hr_utility.trace(' p_tax_unit_id is = '
496: hr_utility.trace('Start of GET_ITEM_DATA ');
497: hr_utility.trace('Parameter Input Values ...');
498: hr_utility.trace('Ccontext value p_assignemnt_id = '
499: || to_char(p_assignment_id));
500: hr_utility.trace(' p_date_earned = '
501: ||p_date_earned);
502: hr_utility.trace(' p_tax_unit_id is = '
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
498: hr_utility.trace('Ccontext value p_assignemnt_id = '
499: || to_char(p_assignment_id));
500: hr_utility.trace(' p_date_earned = '
501: ||p_date_earned);
502: hr_utility.trace(' p_tax_unit_id is = '
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
500: hr_utility.trace(' p_date_earned = '
501: ||p_date_earned);
502: hr_utility.trace(' p_tax_unit_id is = '
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
501: ||p_date_earned);
502: hr_utility.trace(' p_tax_unit_id is = '
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
502: hr_utility.trace(' p_tax_unit_id is = '
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
503: || to_char(p_tax_unit_id));
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
504: hr_utility.trace('p_effective_date is : '|| p_effective_date);
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
505: hr_utility.trace('p_item_name is : '|| p_item_name);
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
506: hr_utility.trace('p_report_type is : '|| p_report_type);
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
507: hr_utility.trace('p_format is : '|| p_format);
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
515: hr_utility.trace('p_validate is : '|| p_validate );
508: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
515: hr_utility.trace('p_validate is : '|| p_validate );
516:
509: hr_utility.trace('p_record_name is : '|| p_record_name );
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
515: hr_utility.trace('p_validate is : '|| p_validate );
516:
517: -- p_item_name parameter is checked to decide which
510: hr_utility.trace('p_input_1 is : '|| p_input_1 );
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
515: hr_utility.trace('p_validate is : '|| p_validate );
516:
517: -- p_item_name parameter is checked to decide which
518: -- procedure to call for Address or contact info
511: hr_utility.trace('p_input_2 is : '|| p_input_2 );
512: hr_utility.trace('p_input_3 is : '|| p_input_3 );
513: hr_utility.trace('p_input_4 is : '|| p_input_4 );
514: hr_utility.trace('p_input_5 is : '|| p_input_5 );
515: hr_utility.trace('p_validate is : '|| p_validate );
516:
517: -- p_item_name parameter is checked to decide which
518: -- procedure to call for Address or contact info
519: --
519: --
520: IF p_item_name = 'CR_ADDRESS' THEN --p_item_name
521: l_input_1:=replace(p_input_1,' ');
522: IF l_input_1 IS NULL THEN
523: hr_utility.trace('p_input_1 is null');
524: c_item_name := NULL;
525: l_valid_address := FALSE;
526: ELSE -- l_input_1 IS NOT NULL THEN
527: hr_utility.trace('p_input_1 is not null');
523: hr_utility.trace('p_input_1 is null');
524: c_item_name := NULL;
525: l_valid_address := FALSE;
526: ELSE -- l_input_1 IS NOT NULL THEN
527: hr_utility.trace('p_input_1 is not null');
528: c_tax_unit_id := to_number(p_input_1);
529: c_item_name := 'ER_ADDRESS';
530: END IF;
531: ELSIF p_item_name = 'ER_ADDRESS' THEN
528: c_tax_unit_id := to_number(p_input_1);
529: c_item_name := 'ER_ADDRESS';
530: END IF;
531: ELSIF p_item_name = 'ER_ADDRESS' THEN
532: hr_utility.trace(p_item_name);
533: c_tax_unit_id := p_tax_unit_id;
534: c_item_name := 'ER_ADDRESS';
535: hr_utility.trace('c_tax_unit_id = '||to_char(c_tax_unit_id));
536: ELSIF p_item_name = 'EE_ADDRESS' THEN
531: ELSIF p_item_name = 'ER_ADDRESS' THEN
532: hr_utility.trace(p_item_name);
533: c_tax_unit_id := p_tax_unit_id;
534: c_item_name := 'ER_ADDRESS';
535: hr_utility.trace('c_tax_unit_id = '||to_char(c_tax_unit_id));
536: ELSIF p_item_name = 'EE_ADDRESS' THEN
537: c_item_name:='EE_ADDRESS';
538: ELSIF p_item_name = 'CR_PERSON' THEN
539: c_item_name:='CR_PERSON';
546: IF c_item_name = 'CR_PERSON' THEN --c_item_name
547: --
548: -- Following function is called to fetch Contact Person info
549: --
550: hr_utility.trace('Calling get_cr_person_info');
551: sp_out_1 := pay_us_get_item_data_pkg.get_contact_person_info(
552: p_assignment_id,
553: p_date_earned,
554: p_tax_unit_id,
605: ELSIF c_item_name = 'EE_ADDRESS' THEN
606: --
607: -- Following function is called to fetch Employee Address
608: --
609: hr_utility.trace('EE_ADDRESS Calling get_mmref_employee_address');
610: sp_out_1 := pay_us_get_item_data_pkg.get_mmref_employee_address(
611: p_assignment_id,
612: p_date_earned,
613: p_tax_unit_id,
634: sp_out_8,
635: sp_out_9,
636: sp_out_10
637: );
638: hr_utility.trace('EE_ADDRESS get_mmref_employee_address completed sucessfully');
639: ELSIF c_item_name = 'ER_ADDRESS' THEN
640: --
641: -- Following function is called to fetch Employer Address
642: --
639: ELSIF c_item_name = 'ER_ADDRESS' THEN
640: --
641: -- Following function is called to fetch Employer Address
642: --
643: hr_utility.trace('ER_ADDRESS Calling get_mmref_employer_address');
644: sp_out_1 := pay_us_get_item_data_pkg.get_mmref_employer_address(
645: p_assignment_id,
646: p_date_earned,
647: p_tax_unit_id,
668: sp_out_8,
669: sp_out_9,
670: sp_out_10
671: );
672: hr_utility.trace('ER_ADDRESS get_mmref_employer_address completed sucessfully');
673: END IF; --c_item_name
674:
675: IF p_exclude_from_output IS NULL THEN
676: p_exclude_from_output := 'N';
691: IF p_item_name <> 'CR_PERSON' THEN
692: sp_out_4 := Character_check(sp_out_4);
693: END IF;
694:
695: hr_utility.trace('Return Values of Get_Item_Data ..');
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
692: sp_out_4 := Character_check(sp_out_4);
693: END IF;
694:
695: hr_utility.trace('Return Values of Get_Item_Data ..');
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
693: END IF;
694:
695: hr_utility.trace('Return Values of Get_Item_Data ..');
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
694:
695: hr_utility.trace('Return Values of Get_Item_Data ..');
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
695: hr_utility.trace('Return Values of Get_Item_Data ..');
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
696: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
697: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
698: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
699: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
700: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
701: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
702: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
703: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
704: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
705: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
706:
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
707: hr_utility.trace('Befor the final return. Length of the fields. ');
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
708: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
709: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
717: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
710: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
717: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
718:
711: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
717: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
718:
719: RETURN sp_out_1;
712: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
717: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
718:
719: RETURN sp_out_1;
720: END; -- End of function GET_ITEM_DATA
713: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
714: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
715: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
716: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
717: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
718:
719: RETURN sp_out_1;
720: END; -- End of function GET_ITEM_DATA
721:
778:
779:
780: BEGIN
781: l_report_format := p_input_1;
782: hr_utility.trace('Begin Checking ');
783: IF p_format = 'MMREF' THEN
784: IF p_record_name = 'RA' THEN
785: hr_utility.trace('RA record');
786: header_string :=
781: l_report_format := p_input_1;
782: hr_utility.trace('Begin Checking ');
783: IF p_format = 'MMREF' THEN
784: IF p_record_name = 'RA' THEN
785: hr_utility.trace('RA record');
786: header_string :=
787: pay_us_mmrf_print_rec_header.mmrf_format_ra_record_header(
788: p_report_type,
789: p_format,
790: p_report_qualifier,
791: p_record_name
792: );
793: ELSIF p_record_name = 'RE' THEN --1028 length
794: hr_utility.trace('RE record');
795: header_string :=
796: pay_us_mmrf_print_rec_header.mmrf_format_re_record_header(
797: p_report_type,
798: p_format,
799: p_report_qualifier,
800: p_record_name
801: );
802: ELSIF p_record_name = 'RW' THEN
803: hr_utility.trace('RW record'); --2189 length
804: header_string :=
805: pay_us_mmrf_print_rec_header.mmrf_format_rw_record_header(
806: p_report_type,
807: p_format,
808: p_report_qualifier,
809: p_record_name
810: );
811: ELSIF p_record_name = 'RO' THEN
812: hr_utility.trace('RO record'); --1398 length
813: header_string:=
814: pay_us_mmrf_print_rec_header.mmrf_format_ro_record_header(
815: p_report_type,
816: p_format,
817: p_report_qualifier,
818: p_record_name
819: );
820: ELSIF p_record_name = 'RS' THEN
821: hr_utility.trace('RS record'); -- 1715 length
822: IF p_report_type = 'W2' THEN
823: header_string:=
824: pay_us_mmrf_print_rec_header.mmrf_format_w2_rs_rec_header(
825: p_report_type,
838: p_input_1
839: );
840: END IF;
841: ELSIF p_record_name = 'RSSUMM' THEN
842: hr_utility.trace('RSSUMM record'); -- 1503 length
843: IF p_report_type = 'SQWL' THEN
844: header_string:=
845: pay_us_mmrf_print_rec_header.mmrf_format_rssumm_rec_header(
846: p_report_type,
849: p_record_name
850: );
851: END IF;
852: ELSIF p_record_name = 'RT' THEN
853: hr_utility.trace('RT record'); -- 1503 length
854: header_string:=
855: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
856: p_report_type,
857: p_format,
858: p_report_qualifier,
859: p_record_name
860: );
861: ELSIF p_record_name = 'RU' THEN
862: hr_utility.trace('RU record'); -- 1295 length
863: header_string:=
864: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
865: p_report_type,
866: p_format,
867: p_report_qualifier,
868: p_record_name
869: );
870: ELSIF p_record_name = 'RF' THEN
871: hr_utility.trace('RF record');
872: header_string:=
873: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
874: p_report_type,
875: p_format,
882: IF p_record_name = 'A' or
883: p_record_name = 'H' or
884: p_record_name = 'D'
885: THEN
886: hr_utility.trace(p_record_name||' record'); -- 117 length
887: IF p_report_type = 'SQWL' THEN
888: header_string:=
889: pay_us_mmrf_print_rec_header.mmrf_format_sqwl_rs_rec_header(
890: p_report_type,
895: );
896: END IF;
897: END IF;
898: END IF; /* p_format */
899: hr_utility.trace('splitting the header string ');
900: return_header_string := substr(header_string,1,200);
901: sp_out_1:=substr(header_string,201,200);
902: sp_out_2:=substr(header_string,401,200);
903: sp_out_3:=substr(header_string,601,200);
908: sp_out_8:=substr(header_string,1601,200);
909: sp_out_9:=substr(header_string,1801,200);
910: sp_out_10:=substr(header_string,2001,300);
911: p_exclude_from_output:='N';
912: hr_utility.trace('return_header_string = '||return_header_string);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
909: sp_out_9:=substr(header_string,1801,200);
910: sp_out_10:=substr(header_string,2001,300);
911: p_exclude_from_output:='N';
912: hr_utility.trace('return_header_string = '||return_header_string);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
910: sp_out_10:=substr(header_string,2001,300);
911: p_exclude_from_output:='N';
912: hr_utility.trace('return_header_string = '||return_header_string);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
911: p_exclude_from_output:='N';
912: hr_utility.trace('return_header_string = '||return_header_string);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
912: hr_utility.trace('return_header_string = '||return_header_string);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
913: hr_utility.trace('sp_out_1:='||sp_out_1);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
914: hr_utility.trace('sp_out_2:='||sp_out_2);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
922: hr_utility.trace('sp_out_10:='||sp_out_10);
915: hr_utility.trace('sp_out_3:='||sp_out_3);
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
922: hr_utility.trace('sp_out_10:='||sp_out_10);
923:
916: hr_utility.trace('sp_out_4:='||sp_out_4);
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
922: hr_utility.trace('sp_out_10:='||sp_out_10);
923:
924: RETURN return_header_string;
917: hr_utility.trace('sp_out_5:='||sp_out_5);
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
922: hr_utility.trace('sp_out_10:='||sp_out_10);
923:
924: RETURN return_header_string;
925: END;
918: hr_utility.trace('sp_out_6:='||sp_out_6);
919: hr_utility.trace('sp_out_7:='||sp_out_7);
920: hr_utility.trace('sp_out_8:='||sp_out_8);
921: hr_utility.trace('sp_out_9:='||sp_out_9);
922: hr_utility.trace('sp_out_10:='||sp_out_10);
923:
924: RETURN return_header_string;
925: END;
926:
1067: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1068: pay_core_utils.push_token('description',substr(l_description,1,50));
1069: /* Error in RW record for employee 1234 in Medicare wages.
1070: The number is bigger than the given length 11 */
1071: hr_utility.trace(p_input_3 ||' '||l_description);
1072: END IF;
1073: l_err:=TRUE;
1074: END IF;
1075:
1072: END IF;
1073: l_err:=TRUE;
1074: END IF;
1075:
1076: hr_utility.trace('l_input_2 = '|| l_input_2);
1077: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1078: hr_utility.trace('l_length = '|| l_length);
1079: hr_utility.trace('After Number length check');
1080: IF to_number(l_input_2) < 0 THEN
1073: l_err:=TRUE;
1074: END IF;
1075:
1076: hr_utility.trace('l_input_2 = '|| l_input_2);
1077: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1078: hr_utility.trace('l_length = '|| l_length);
1079: hr_utility.trace('After Number length check');
1080: IF to_number(l_input_2) < 0 THEN
1081: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1074: END IF;
1075:
1076: hr_utility.trace('l_input_2 = '|| l_input_2);
1077: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1078: hr_utility.trace('l_length = '|| l_length);
1079: hr_utility.trace('After Number length check');
1080: IF to_number(l_input_2) < 0 THEN
1081: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1082: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1075:
1076: hr_utility.trace('l_input_2 = '|| l_input_2);
1077: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1078: hr_utility.trace('l_length = '|| l_length);
1079: hr_utility.trace('After Number length check');
1080: IF to_number(l_input_2) < 0 THEN
1081: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1082: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1083: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1090:
1091: /* sample mesg*/
1092: /* Error in RW record for employee 1234 in Medicare wages.
1093: The value is negative -2345 */
1094: hr_utility.trace(l_description);
1095: END IF;
1096: l_err:=TRUE;
1097: ELSE
1098: hr_utility.trace('l_input_2 = '|| l_input_2);
1094: hr_utility.trace(l_description);
1095: END IF;
1096: l_err:=TRUE;
1097: ELSE
1098: hr_utility.trace('l_input_2 = '|| l_input_2);
1099: hr_utility.trace('l_length = '|| l_length);
1100: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1101: hr_utility.trace('return_value = '|| return_value);
1102: END IF; /* to_number(l_input_2) */
1095: END IF;
1096: l_err:=TRUE;
1097: ELSE
1098: hr_utility.trace('l_input_2 = '|| l_input_2);
1099: hr_utility.trace('l_length = '|| l_length);
1100: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1101: hr_utility.trace('return_value = '|| return_value);
1102: END IF; /* to_number(l_input_2) */
1103: END IF; /* p_input_1 */
1097: ELSE
1098: hr_utility.trace('l_input_2 = '|| l_input_2);
1099: hr_utility.trace('l_length = '|| l_length);
1100: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1101: hr_utility.trace('return_value = '|| return_value);
1102: END IF; /* to_number(l_input_2) */
1103: END IF; /* p_input_1 */
1104:
1105: hr_utility.trace('Before returning the value = '||return_value);
1101: hr_utility.trace('return_value = '|| return_value);
1102: END IF; /* to_number(l_input_2) */
1103: END IF; /* p_input_1 */
1104:
1105: hr_utility.trace('Before returning the value = '||return_value);
1106: hr_utility.trace('p_validate = '||p_validate);
1107:
1108: IF p_validate= 'Y' THEN
1109: IF l_err THEN
1102: END IF; /* to_number(l_input_2) */
1103: END IF; /* p_input_1 */
1104:
1105: hr_utility.trace('Before returning the value = '||return_value);
1106: hr_utility.trace('p_validate = '||p_validate);
1107:
1108: IF p_validate= 'Y' THEN
1109: IF l_err THEN
1110: p_exclude_from_output:='Y';
1111: ELSE
1112: p_exclude_from_output:='N';
1113: END IF;
1114: END IF;
1115: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1116: RETURN return_value;
1117:
1118: END DATA_VALIDATION;
1119:
1204: l_exclude_from_output_chk boolean;
1205: main_return_string varchar2(300);
1206: BEGIN
1207:
1208: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1205: main_return_string varchar2(300);
1206: BEGIN
1207:
1208: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1206: BEGIN
1207:
1208: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1207:
1208: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1208: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1209: hr_utility.trace(' p_record_name = ' ||p_record_name);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1210: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1211: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1212: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1213: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1214: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1215: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1216: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1217: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1218: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1219: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1220: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1221: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1222: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1223: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1224: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1225: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1226: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1227: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1228: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1229: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1230: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1231: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1232: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1233: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1234: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1235: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1236: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1237: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1238: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1239: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1240: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1241: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1242: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1243: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1244: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1245: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1253: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1246: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1253: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1254:
1247: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1253: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1254:
1255: IF p_format = 'MMREF' THEN -- p_format
1248: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1253: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1254:
1255: IF p_format = 'MMREF' THEN -- p_format
1256: --{
1249: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1250: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1251: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1252: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1253: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1254:
1255: IF p_format = 'MMREF' THEN -- p_format
1256: --{
1257: IF (p_report_type = 'W2') THEN
2098: END IF; --p_report_type
2099: --}
2100: ELSIF p_format = 'CUSTOM' THEN
2101: --{
2102: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2103:
2104: IF p_record_name = 'H' THEN -- p_record_name
2105: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2106: return_value :=
2101: --{
2102: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2103:
2104: IF p_record_name = 'H' THEN -- p_record_name
2105: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2106: return_value :=
2107: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYER(
2108: p_effective_date,
2109: p_report_type,
2161: l_exclude_from_output_chk
2162: );
2163:
2164: ELSIF p_record_name = 'D' THEN
2165: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2166: return_value :=
2167: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYEE(
2168: p_effective_date,
2169: p_report_type,
2242: p_exclude_from_output := 'Y';
2243: ELSE
2244: p_exclude_from_output := 'N';
2245: END IF;
2246: hr_utility.trace('main_return_string = '||main_return_string);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2243: ELSE
2244: p_exclude_from_output := 'N';
2245: END IF;
2246: hr_utility.trace('main_return_string = '||main_return_string);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2244: p_exclude_from_output := 'N';
2245: END IF;
2246: hr_utility.trace('main_return_string = '||main_return_string);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2245: END IF;
2246: hr_utility.trace('main_return_string = '||main_return_string);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2246: hr_utility.trace('main_return_string = '||main_return_string);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2247: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2248: hr_utility.trace('sp_out_1 = '||sp_out_1);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2249: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2250: hr_utility.trace('sp_out_2 = '||sp_out_2);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2258: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2251: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2258: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2259:
2252: hr_utility.trace('sp_out_3 = '||sp_out_3);
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2258: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2259:
2260: RETURN main_return_string;
2253: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2258: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2259:
2260: RETURN main_return_string;
2261: END Format_Record;
2254: hr_utility.trace('sp_out_4 = '||sp_out_4);
2255: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2256: hr_utility.trace('sp_out_5 = '||sp_out_5);
2257: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2258: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2259:
2260: RETURN main_return_string;
2261: END Format_Record;
2262:
2367: /* 3rd context of state jurisdiction_code*/
2368:
2369: BEGIN
2370:
2371: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2372: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2373: dbi_table(1).p_user_name:='A_TERRITORY_RETIRE_CONTRIB_PER_GRE_YTD';
2374: dbi_table(2).p_user_name:='A_TERRITORY_TAXABLE_ALLOW_PER_GRE_YTD';
2375: dbi_table(3).p_user_name:='A_TERRITORY_TAXABLE_COMM_PER_GRE_YTD';
2368:
2369: BEGIN
2370:
2371: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2372: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2373: dbi_table(1).p_user_name:='A_TERRITORY_RETIRE_CONTRIB_PER_GRE_YTD';
2374: dbi_table(2).p_user_name:='A_TERRITORY_TAXABLE_ALLOW_PER_GRE_YTD';
2375: dbi_table(3).p_user_name:='A_TERRITORY_TAXABLE_COMM_PER_GRE_YTD';
2376: dbi_table(4).p_user_name:='A_TERRITORY_TAXABLE_TIPS_PER_GRE_YTD';
2378: dbi_table(6).p_user_name:='A_PER_MARITAL_STATUS';
2379: dbi_table(7).p_user_name:='A_CON_NATIONAL_IDENTIFIER';
2380:
2381: l_jurisdiction_code:='72-000-0000';
2382: hr_utility.trace('Get PR Values');
2383:
2384: FOR i in dbi_table.first .. dbi_table.last loop
2385:
2386: OPEN get_user_entity_id(dbi_table(i).p_user_name);
2392: dbi_table(i).p_archived_value:='00000000000';
2393:
2394: ELSIF get_user_entity_id%FOUND THEN
2395:
2396: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2397: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2398: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2399:
2400: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2393:
2394: ELSIF get_user_entity_id%FOUND THEN
2395:
2396: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2397: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2398: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2399:
2400: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2401: open get_jd_archived_values(l_entity_id,
2394: ELSIF get_user_entity_id%FOUND THEN
2395:
2396: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2397: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2398: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2399:
2400: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2401: open get_jd_archived_values(l_entity_id,
2402: p_assignment_action_id,
2421: p_exclude_from_output,
2422: sp_out_1,
2423: sp_out_2);
2424:
2425: hr_utility.trace('Archived_value = '||dbi_table(i).p_archived_value);
2426:
2427: IF p_exclude_from_output = 'Y' THEN
2428: l_err:=TRUE;
2429: END IF;
2443: ELSE
2444: dbi_table(i).p_archived_value:='00000000000';
2445: END IF;
2446:
2447: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2448: ELSIF get_archived_values%FOUND THEN
2449:
2450: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2451: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2446:
2447: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2448: ELSIF get_archived_values%FOUND THEN
2449:
2450: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2451: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2452:
2453: IF ((dbi_table(i).p_user_name = 'A_PER_MARITAL_STATUS') OR
2454: (dbi_table(i).p_user_name = 'A_CON_NATIONAL_IDENTIFIER')) THEN
2447: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2448: ELSIF get_archived_values%FOUND THEN
2449:
2450: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2451: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2452:
2453: IF ((dbi_table(i).p_user_name = 'A_PER_MARITAL_STATUS') OR
2454: (dbi_table(i).p_user_name = 'A_CON_NATIONAL_IDENTIFIER')) THEN
2455: dbi_table(i).p_archived_value := l_archived_value;
2484: p_exclude_from_output,
2485: sp_out_1,
2486: sp_out_2);
2487:
2488: hr_utility.trace('Archived_value = '||dbi_table(i).p_archived_value);
2489:
2490: IF p_exclude_from_output = 'Y' THEN
2491: l_err:=TRUE;
2492: END IF;
2499:
2500: END LOOP;
2501:
2502:
2503: hr_utility.trace('before Call to retrieve state_wages');
2504:
2505: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2506: (p_assignment_action_id,'A_W2_STATE_WAGES',
2507: p_tax_unit_id,l_jurisdiction_code,2);
2505: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2506: (p_assignment_action_id,'A_W2_STATE_WAGES',
2507: p_tax_unit_id,l_jurisdiction_code,2);
2508:
2509: hr_utility.trace('l_state_wage = '||l_state_wage);
2510: sp_out_5:= data_validation ( p_effective_date,
2511: p_report_type,
2512: p_format,
2513: p_report_qualifier,
2535: sp_out_6:=dbi_table(6).p_archived_value;
2536: sp_out_7:=dbi_table(7).p_archived_value;
2537:
2538:
2539: hr_utility.trace('l_main_return = '||l_main_return);
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2536: sp_out_7:=dbi_table(7).p_archived_value;
2537:
2538:
2539: hr_utility.trace('l_main_return = '||l_main_return);
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2537:
2538:
2539: hr_utility.trace('l_main_return = '||l_main_return);
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2538:
2539: hr_utility.trace('l_main_return = '||l_main_return);
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2546: hr_utility.trace('sp_out_7 = '||sp_out_7);
2539: hr_utility.trace('l_main_return = '||l_main_return);
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2546: hr_utility.trace('sp_out_7 = '||sp_out_7);
2547:
2540: hr_utility.trace('sp_out_1 = '||sp_out_1);
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2546: hr_utility.trace('sp_out_7 = '||sp_out_7);
2547:
2548:
2541: hr_utility.trace('sp_out_2 = '||sp_out_2);
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2546: hr_utility.trace('sp_out_7 = '||sp_out_7);
2547:
2548:
2549: IF p_validate = 'Y' THEN
2542: hr_utility.trace('sp_out_3 = '||sp_out_3);
2543: hr_utility.trace('sp_out_4 = '||sp_out_4);
2544: hr_utility.trace('sp_out_5 = '||sp_out_5);
2545: hr_utility.trace('sp_out_6 = '||sp_out_6);
2546: hr_utility.trace('sp_out_7 = '||sp_out_7);
2547:
2548:
2549: IF p_validate = 'Y' THEN
2550: IF l_err THEN
2629: Begin
2630:
2631: l_value := 'N';
2632:
2633: hr_utility.trace('Formula_Check');
2634: hr_utility.trace('p_report_format = '||p_report_format);
2635: hr_utility.trace('p_formula_name = '||p_formula_name);
2636:
2637:
2630:
2631: l_value := 'N';
2632:
2633: hr_utility.trace('Formula_Check');
2634: hr_utility.trace('p_report_format = '||p_report_format);
2635: hr_utility.trace('p_formula_name = '||p_formula_name);
2636:
2637:
2638: OPEN formula_exist(p_report_format,
2631: l_value := 'N';
2632:
2633: hr_utility.trace('Formula_Check');
2634: hr_utility.trace('p_report_format = '||p_report_format);
2635: hr_utility.trace('p_formula_name = '||p_formula_name);
2636:
2637:
2638: OPEN formula_exist(p_report_format,
2639: p_formula_name);
2641: FETCH formula_exist INTO l_value;
2642:
2643: CLOSE formula_exist;
2644:
2645: hr_utility.trace('l_value = '||l_value);
2646:
2647: RETURN l_value;
2648:
2649: END;
2805:
2806:
2807: BEGIN
2808:
2809: --hr_utility.trace('p_db_item_name is '||p_db_item_name);
2810:
2811: OPEN csr_defined_balance;
2812: FETCH csr_defined_balance INTO l_defined_balance_id;
2813: IF csr_defined_balance%notfound THEN
2811: OPEN csr_defined_balance;
2812: FETCH csr_defined_balance INTO l_defined_balance_id;
2813: IF csr_defined_balance%notfound THEN
2814: CLOSE csr_defined_balance;
2815: RAISE hr_utility.hr_error;
2816: ELSE
2817: CLOSE csr_defined_balance;
2818: END IF;
2819:
2816: ELSE
2817: CLOSE csr_defined_balance;
2818: END IF;
2819:
2820: --hr_utility.trace('l_defined_balance_id is '||to_char(l_defined_balance_id));
2821: RETURN (l_defined_balance_id);
2822:
2823: END bal_db_item;
2824:
2868: OPEN get_effective_date(p_assignment_action_id);
2869: FETCH get_effective_date INTO l_effective_start_date
2870: ,l_effective_end_date;
2871:
2872: hr_utility.trace('l_effective_start_date = '||l_effective_start_date);
2873: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2874:
2875: IF get_effective_date%NOTFOUND THEN
2876:
2869: FETCH get_effective_date INTO l_effective_start_date
2870: ,l_effective_end_date;
2871:
2872: hr_utility.trace('l_effective_start_date = '||l_effective_start_date);
2873: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2874:
2875: IF get_effective_date%NOTFOUND THEN
2876:
2877: hr_utility.trace('Effective Date not found for given
2873: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2874:
2875: IF get_effective_date%NOTFOUND THEN
2876:
2877: hr_utility.trace('Effective Date not found for given
2878: assignment_action_id ='||to_char(p_assignment_action_id));
2879:
2880: END IF;
2881:
2889:
2890:
2891: If get_balance_feed_exist%NOTFOUND THEN
2892:
2893: hr_utility.trace('get_balance_feed_exist%NOTFOUND');
2894: return 0;
2895:
2896: ELSE
2897:
2896: ELSE
2897:
2898: /* Live Balance Call Procedure */
2899: l_bal_id := bal_db_item('W2_GOVT_EE_CONTRIB_PER_GRE_YTD');
2900: hr_utility.trace('get_balance_feed_exist FOUND');
2901: lv_bal_amt := nvl(pay_balance_pkg.get_value
2902: (p_defined_balance_id => l_bal_id,
2903: p_assignment_action_id => p_assignment_action_id),0);
2904: return (to_char(lv_bal_amt));
2930:
2931:
2932: BEGIN
2933: lv_return_value := 0;
2934: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2935:
2936: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2937: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2938:
2932: BEGIN
2933: lv_return_value := 0;
2934: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2935:
2936: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2937: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2938:
2939: /*
2940:
2933: lv_return_value := 0;
2934: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2935:
2936: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2937: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2938:
2939: /*
2940:
2941: -- remarked by tmehra, as discussed with Dipen and Mehul
2967: p_tax_unit_id,
2968: l_jurisdiction_code
2969: ));
2970:
2971: hr_utility.trace('lv_return_value = ' || lv_return_value);
2972:
2973:
2974: RETURN nvl(lv_return_value,0);
2975:
2981: p_state varchar2 default null
2982: ) RETURN number IS
2983: lv_employee_count number ;
2984: BEGIN
2985: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2986: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2987: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2988:
2989: select count(*)
2982: ) RETURN number IS
2983: lv_employee_count number ;
2984: BEGIN
2985: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2986: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2987: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2988:
2989: select count(*)
2990: into lv_employee_count
2983: lv_employee_count number ;
2984: BEGIN
2985: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2986: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2987: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2988:
2989: select count(*)
2990: into lv_employee_count
2991: from pay_payroll_actions ppa,
2993: where ppa.payroll_action_id = p_payroll_action_id
2994: and paa.tax_unit_id = p_tax_unit_id
2995: and ppa.payroll_action_id = paa.payroll_action_id ;
2996:
2997: hr_utility.trace('lv_employee_count := '||lv_employee_count) ;
2998: RETURN lv_employee_count ;
2999:
3000: END get_employee_count ;
3001:
3301: i NUMBER ;
3302:
3303: BEGIN
3304:
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3302:
3303: BEGIN
3304:
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3310: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3303: BEGIN
3304:
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3310: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3311:
3304:
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3310: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3311:
3312: lv_total_wages := 0 ;
3305: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3310: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3311:
3312: lv_total_wages := 0 ;
3313: lv_employee_count := 0 ;
3306: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3307: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3308: hr_utility.trace('p_state := ' || p_state) ;
3309: hr_utility.trace('p_report_type := ' || p_report_type) ;
3310: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3311:
3312: lv_total_wages := 0 ;
3313: lv_employee_count := 0 ;
3314:
3381: lv_total_wages := lv_tot_wage_tab(j).summed_balance_value ;
3382: EXIT ;
3383: END IF ;
3384: END LOOP ;
3385: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3386: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3387:
3388: RETURN lv_total_wages ;
3389:
3382: EXIT ;
3383: END IF ;
3384: END LOOP ;
3385: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3386: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3387:
3388: RETURN lv_total_wages ;
3389:
3390: ELSIF p_balance_name = 'State taxable Wages' THEN
3397: ELSIF lv_tot_wage_tab(j).dbi_name = 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' THEN
3398: lv_total_wages := lv_total_wages - lv_tot_wage_tab(j).summed_balance_value ;
3399: END IF ;
3400: END LOOP ;
3401: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3402: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3403:
3404: RETURN lv_total_wages ;
3405:
3398: lv_total_wages := lv_total_wages - lv_tot_wage_tab(j).summed_balance_value ;
3399: END IF ;
3400: END LOOP ;
3401: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3402: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3403:
3404: RETURN lv_total_wages ;
3405:
3406: ELSIF p_balance_name = 'Other State Data' THEN
3410: lv_total_wages := lv_tot_wage_tab(j).summed_balance_value ;
3411: EXIT ;
3412: END IF ;
3413: END LOOP ;
3414: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3415: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3416:
3417: RETURN lv_total_wages ;
3418: END IF ; -- p_balance_name
3411: EXIT ;
3412: END IF ;
3413: END LOOP ;
3414: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3415: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3416:
3417: RETURN lv_total_wages ;
3418: END IF ; -- p_balance_name
3419: END IF ; -- p_state
3576: and fdi3.user_name = 'A_SUI_ER_GROSS_PER_JD_GRE_QTD'
3577: and length(translate(trim(fai.value),' .0123456789',' ')) is null
3578: and length(translate(trim(fai2.value),' .0123456789',' ')) is null ;
3579:
3580: hr_utility.trace('Actual SUI Taxable Amount'||p_sui_taxable);
3581:
3582: open cur_fl_sqwl;
3583: fetch cur_fl_sqwl into l_fl_sqwl;
3584: if l_fl_sqwl = 'Y'
3582: open cur_fl_sqwl;
3583: fetch cur_fl_sqwl into l_fl_sqwl;
3584: if l_fl_sqwl = 'Y'
3585: then
3586: hr_utility.trace('Getting the Adjusted Taxable for Florida');
3587:
3588: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3589: into p_sui_taxable
3590: from pay_payroll_actions ppa,
3599: and fdi.user_name = 'SUI_ER_FL_ADJ_TAXABLE_PER_JD_GRE_QTD'
3600: and length(translate(trim(fai.value),' .0123456789',' ')) is null;
3601:
3602:
3603: hr_utility.trace('Adjusted SUI Taxable Amount for Florida'||p_sui_taxable);
3604:
3605: end if;
3606: close cur_fl_sqwl;
3607:
3610:
3611: if l_oh_sqwl = 'Y'
3612: then
3613:
3614: hr_utility.trace('Getting the Out of State Taxable for Ohio');
3615:
3616: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3617: into p_sui_taxable
3618: from pay_payroll_actions ppa,
3637: return(0);
3638:
3639: END GET_SUI_WAGES;
3640: --BEGIN
3641: --hr_utility.trace_on(null,'MMREF');
3642:
3643: END pay_us_reporting_utils_pkg;