[Home] [Help]
478: c_item_name varchar2(40);
479: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
480:
481: BEGIN
482: hr_utility.trace('Start of GET_ITEM_DATA ');
483: hr_utility.trace('Parameter Input Values ...');
484: hr_utility.trace('Ccontext value p_assignemnt_id = '
485: || to_char(p_assignment_id));
486: hr_utility.trace(' p_date_earned = '
479: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
480:
481: BEGIN
482: hr_utility.trace('Start of GET_ITEM_DATA ');
483: hr_utility.trace('Parameter Input Values ...');
484: hr_utility.trace('Ccontext value p_assignemnt_id = '
485: || to_char(p_assignment_id));
486: hr_utility.trace(' p_date_earned = '
487: ||p_date_earned);
480:
481: BEGIN
482: hr_utility.trace('Start of GET_ITEM_DATA ');
483: hr_utility.trace('Parameter Input Values ...');
484: hr_utility.trace('Ccontext value p_assignemnt_id = '
485: || to_char(p_assignment_id));
486: hr_utility.trace(' p_date_earned = '
487: ||p_date_earned);
488: hr_utility.trace(' p_tax_unit_id is = '
482: hr_utility.trace('Start of GET_ITEM_DATA ');
483: hr_utility.trace('Parameter Input Values ...');
484: hr_utility.trace('Ccontext value p_assignemnt_id = '
485: || to_char(p_assignment_id));
486: hr_utility.trace(' p_date_earned = '
487: ||p_date_earned);
488: hr_utility.trace(' p_tax_unit_id is = '
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
484: hr_utility.trace('Ccontext value p_assignemnt_id = '
485: || to_char(p_assignment_id));
486: hr_utility.trace(' p_date_earned = '
487: ||p_date_earned);
488: hr_utility.trace(' p_tax_unit_id is = '
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
486: hr_utility.trace(' p_date_earned = '
487: ||p_date_earned);
488: hr_utility.trace(' p_tax_unit_id is = '
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
487: ||p_date_earned);
488: hr_utility.trace(' p_tax_unit_id is = '
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
488: hr_utility.trace(' p_tax_unit_id is = '
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
489: || to_char(p_tax_unit_id));
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
490: hr_utility.trace('p_effective_date is : '|| p_effective_date);
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
491: hr_utility.trace('p_item_name is : '|| p_item_name);
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
492: hr_utility.trace('p_report_type is : '|| p_report_type);
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
493: hr_utility.trace('p_format is : '|| p_format);
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
501: hr_utility.trace('p_validate is : '|| p_validate );
494: hr_utility.trace('p_report_qualifier is : '|| p_report_qualifier );
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
501: hr_utility.trace('p_validate is : '|| p_validate );
502:
495: hr_utility.trace('p_record_name is : '|| p_record_name );
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
501: hr_utility.trace('p_validate is : '|| p_validate );
502:
503: -- p_item_name parameter is checked to decide which
496: hr_utility.trace('p_input_1 is : '|| p_input_1 );
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
501: hr_utility.trace('p_validate is : '|| p_validate );
502:
503: -- p_item_name parameter is checked to decide which
504: -- procedure to call for Address or contact info
497: hr_utility.trace('p_input_2 is : '|| p_input_2 );
498: hr_utility.trace('p_input_3 is : '|| p_input_3 );
499: hr_utility.trace('p_input_4 is : '|| p_input_4 );
500: hr_utility.trace('p_input_5 is : '|| p_input_5 );
501: hr_utility.trace('p_validate is : '|| p_validate );
502:
503: -- p_item_name parameter is checked to decide which
504: -- procedure to call for Address or contact info
505: --
505: --
506: IF p_item_name = 'CR_ADDRESS' THEN --p_item_name
507: l_input_1:=replace(p_input_1,' ');
508: IF l_input_1 IS NULL THEN
509: hr_utility.trace('p_input_1 is null');
510: c_item_name := NULL;
511: l_valid_address := FALSE;
512: ELSE -- l_input_1 IS NOT NULL THEN
513: hr_utility.trace('p_input_1 is not null');
509: hr_utility.trace('p_input_1 is null');
510: c_item_name := NULL;
511: l_valid_address := FALSE;
512: ELSE -- l_input_1 IS NOT NULL THEN
513: hr_utility.trace('p_input_1 is not null');
514: c_tax_unit_id := to_number(p_input_1);
515: c_item_name := 'ER_ADDRESS';
516: END IF;
517: ELSIF p_item_name = 'ER_ADDRESS' THEN
514: c_tax_unit_id := to_number(p_input_1);
515: c_item_name := 'ER_ADDRESS';
516: END IF;
517: ELSIF p_item_name = 'ER_ADDRESS' THEN
518: hr_utility.trace(p_item_name);
519: c_tax_unit_id := p_tax_unit_id;
520: c_item_name := 'ER_ADDRESS';
521: hr_utility.trace('c_tax_unit_id = '||to_char(c_tax_unit_id));
522: ELSIF p_item_name = 'EE_ADDRESS' THEN
517: ELSIF p_item_name = 'ER_ADDRESS' THEN
518: hr_utility.trace(p_item_name);
519: c_tax_unit_id := p_tax_unit_id;
520: c_item_name := 'ER_ADDRESS';
521: hr_utility.trace('c_tax_unit_id = '||to_char(c_tax_unit_id));
522: ELSIF p_item_name = 'EE_ADDRESS' THEN
523: c_item_name:='EE_ADDRESS';
524: ELSIF p_item_name = 'CR_PERSON' THEN
525: c_item_name:='CR_PERSON';
532: IF c_item_name = 'CR_PERSON' THEN --c_item_name
533: --
534: -- Following function is called to fetch Contact Person info
535: --
536: hr_utility.trace('Calling get_cr_person_info');
537: sp_out_1 := pay_us_get_item_data_pkg.get_contact_person_info(
538: p_assignment_id,
539: p_date_earned,
540: p_tax_unit_id,
591: ELSIF c_item_name = 'EE_ADDRESS' THEN
592: --
593: -- Following function is called to fetch Employee Address
594: --
595: hr_utility.trace('EE_ADDRESS Calling get_mmref_employee_address');
596: sp_out_1 := pay_us_get_item_data_pkg.get_mmref_employee_address(
597: p_assignment_id,
598: p_date_earned,
599: p_tax_unit_id,
620: sp_out_8,
621: sp_out_9,
622: sp_out_10
623: );
624: hr_utility.trace('EE_ADDRESS get_mmref_employee_address completed sucessfully');
625: ELSIF c_item_name = 'ER_ADDRESS' THEN
626: --
627: -- Following function is called to fetch Employer Address
628: --
625: ELSIF c_item_name = 'ER_ADDRESS' THEN
626: --
627: -- Following function is called to fetch Employer Address
628: --
629: hr_utility.trace('ER_ADDRESS Calling get_mmref_employer_address');
630: sp_out_1 := pay_us_get_item_data_pkg.get_mmref_employer_address(
631: p_assignment_id,
632: p_date_earned,
633: p_tax_unit_id,
654: sp_out_8,
655: sp_out_9,
656: sp_out_10
657: );
658: hr_utility.trace('ER_ADDRESS get_mmref_employer_address completed sucessfully');
659: END IF; --c_item_name
660:
661: IF p_exclude_from_output IS NULL THEN
662: p_exclude_from_output := 'N';
677: IF p_item_name <> 'CR_PERSON' THEN
678: sp_out_4 := Character_check(sp_out_4);
679: END IF;
680:
681: hr_utility.trace('Return Values of Get_Item_Data ..');
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
678: sp_out_4 := Character_check(sp_out_4);
679: END IF;
680:
681: hr_utility.trace('Return Values of Get_Item_Data ..');
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
679: END IF;
680:
681: hr_utility.trace('Return Values of Get_Item_Data ..');
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
680:
681: hr_utility.trace('Return Values of Get_Item_Data ..');
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
681: hr_utility.trace('Return Values of Get_Item_Data ..');
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
682: hr_utility.trace('Value of sp_out_1 = '||sp_out_1);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
683: hr_utility.trace('Value of sp_out_2 = '||sp_out_2);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
684: hr_utility.trace('Value of sp_out_3 = '||sp_out_3);
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
685: hr_utility.trace('Value of sp_out_4 = '||sp_out_4);
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
686: hr_utility.trace('Value of sp_out_5 = '||sp_out_5);
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
687: hr_utility.trace('Value of sp_out_6 = '||sp_out_6);
688: hr_utility.trace('Value of sp_out_7 = '||sp_out_7);
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
689: hr_utility.trace('Value of sp_out_8 = '||sp_out_8);
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
690: hr_utility.trace('Value of sp_out_9 = '||sp_out_9);
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
691: hr_utility.trace('Value of sp_out_10 = '||sp_out_10);
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
692:
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
693: hr_utility.trace('Befor the final return. Length of the fields. ');
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
694: hr_utility.trace('length of sp_out_1 = '||to_char(length(sp_out_1)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
695: hr_utility.trace('length of sp_out_2 = '||to_char(length(sp_out_2)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
703: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
696: hr_utility.trace('length of sp_out_3 = '||to_char(length(sp_out_3)));
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
703: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
704:
697: hr_utility.trace('length of sp_out_4 = '||to_char(length(sp_out_4)));
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
703: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
704:
705: RETURN sp_out_1;
698: hr_utility.trace('length of sp_out_5 = '||to_char(length(sp_out_5)));
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
703: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
704:
705: RETURN sp_out_1;
706: END; -- End of function GET_ITEM_DATA
699: hr_utility.trace('length of sp_out_6 = '||to_char(length(sp_out_6)));
700: hr_utility.trace('length of sp_out_7 = '||to_char(length(sp_out_7)));
701: hr_utility.trace('length of sp_out_8 = '||to_char(length(sp_out_8)));
702: hr_utility.trace('length of sp_out_9 = '||to_char(length(sp_out_9)));
703: hr_utility.trace('length of sp_out_10 = '||to_char(length(sp_out_10)));
704:
705: RETURN sp_out_1;
706: END; -- End of function GET_ITEM_DATA
707:
764:
765:
766: BEGIN
767: l_report_format := p_input_1;
768: hr_utility.trace('Begin Checking ');
769: IF p_format = 'MMREF' THEN
770: IF p_record_name = 'RA' THEN
771: hr_utility.trace('RA record');
772: header_string :=
767: l_report_format := p_input_1;
768: hr_utility.trace('Begin Checking ');
769: IF p_format = 'MMREF' THEN
770: IF p_record_name = 'RA' THEN
771: hr_utility.trace('RA record');
772: header_string :=
773: pay_us_mmrf_print_rec_header.mmrf_format_ra_record_header(
774: p_report_type,
775: p_format,
776: p_report_qualifier,
777: p_record_name
778: );
779: ELSIF p_record_name = 'RE' THEN --1028 length
780: hr_utility.trace('RE record');
781: header_string :=
782: pay_us_mmrf_print_rec_header.mmrf_format_re_record_header(
783: p_report_type,
784: p_format,
785: p_report_qualifier,
786: p_record_name
787: );
788: ELSIF p_record_name = 'RW' THEN
789: hr_utility.trace('RW record'); --2189 length
790: header_string :=
791: pay_us_mmrf_print_rec_header.mmrf_format_rw_record_header(
792: p_report_type,
793: p_format,
794: p_report_qualifier,
795: p_record_name
796: );
797: ELSIF p_record_name = 'RO' THEN
798: hr_utility.trace('RO record'); --1398 length
799: header_string:=
800: pay_us_mmrf_print_rec_header.mmrf_format_ro_record_header(
801: p_report_type,
802: p_format,
803: p_report_qualifier,
804: p_record_name
805: );
806: ELSIF p_record_name = 'RS' THEN
807: hr_utility.trace('RS record'); -- 1715 length
808: IF p_report_type = 'W2' THEN
809: header_string:=
810: pay_us_mmrf_print_rec_header.mmrf_format_w2_rs_rec_header(
811: p_report_type,
824: p_input_1
825: );
826: END IF;
827: ELSIF p_record_name = 'RSSUMM' THEN
828: hr_utility.trace('RSSUMM record'); -- 1503 length
829: IF p_report_type = 'SQWL' THEN
830: header_string:=
831: pay_us_mmrf_print_rec_header.mmrf_format_rssumm_rec_header(
832: p_report_type,
835: p_record_name
836: );
837: END IF;
838: ELSIF p_record_name = 'RT' THEN
839: hr_utility.trace('RT record'); -- 1503 length
840: header_string:=
841: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
842: p_report_type,
843: p_format,
844: p_report_qualifier,
845: p_record_name
846: );
847: ELSIF p_record_name = 'RU' THEN
848: hr_utility.trace('RU record'); -- 1295 length
849: header_string:=
850: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
851: p_report_type,
852: p_format,
853: p_report_qualifier,
854: p_record_name
855: );
856: ELSIF p_record_name = 'RF' THEN
857: hr_utility.trace('RF record');
858: header_string:=
859: pay_us_mmrf_print_rec_header.mmrf_format_rt_record_header(
860: p_report_type,
861: p_format,
868: IF p_record_name = 'A' or
869: p_record_name = 'H' or
870: p_record_name = 'D'
871: THEN
872: hr_utility.trace(p_record_name||' record'); -- 117 length
873: IF p_report_type = 'SQWL' THEN
874: header_string:=
875: pay_us_mmrf_print_rec_header.mmrf_format_sqwl_rs_rec_header(
876: p_report_type,
881: );
882: END IF;
883: END IF;
884: END IF; /* p_format */
885: hr_utility.trace('splitting the header string ');
886: return_header_string := substr(header_string,1,200);
887: sp_out_1:=substr(header_string,201,200);
888: sp_out_2:=substr(header_string,401,200);
889: sp_out_3:=substr(header_string,601,200);
894: sp_out_8:=substr(header_string,1601,200);
895: sp_out_9:=substr(header_string,1801,200);
896: sp_out_10:=substr(header_string,2001,300);
897: p_exclude_from_output:='N';
898: hr_utility.trace('return_header_string = '||return_header_string);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
895: sp_out_9:=substr(header_string,1801,200);
896: sp_out_10:=substr(header_string,2001,300);
897: p_exclude_from_output:='N';
898: hr_utility.trace('return_header_string = '||return_header_string);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
896: sp_out_10:=substr(header_string,2001,300);
897: p_exclude_from_output:='N';
898: hr_utility.trace('return_header_string = '||return_header_string);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
897: p_exclude_from_output:='N';
898: hr_utility.trace('return_header_string = '||return_header_string);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
898: hr_utility.trace('return_header_string = '||return_header_string);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
899: hr_utility.trace('sp_out_1:='||sp_out_1);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
900: hr_utility.trace('sp_out_2:='||sp_out_2);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
908: hr_utility.trace('sp_out_10:='||sp_out_10);
901: hr_utility.trace('sp_out_3:='||sp_out_3);
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
908: hr_utility.trace('sp_out_10:='||sp_out_10);
909:
902: hr_utility.trace('sp_out_4:='||sp_out_4);
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
908: hr_utility.trace('sp_out_10:='||sp_out_10);
909:
910: RETURN return_header_string;
903: hr_utility.trace('sp_out_5:='||sp_out_5);
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
908: hr_utility.trace('sp_out_10:='||sp_out_10);
909:
910: RETURN return_header_string;
911: END;
904: hr_utility.trace('sp_out_6:='||sp_out_6);
905: hr_utility.trace('sp_out_7:='||sp_out_7);
906: hr_utility.trace('sp_out_8:='||sp_out_8);
907: hr_utility.trace('sp_out_9:='||sp_out_9);
908: hr_utility.trace('sp_out_10:='||sp_out_10);
909:
910: RETURN return_header_string;
911: END;
912:
1053: pay_core_utils.push_token('field_name',substr(p_input_3,1,50));
1054: pay_core_utils.push_token('description',substr(l_description,1,50));
1055: /* Error in RW record for employee 1234 in Medicare wages.
1056: The number is bigger than the given length 11 */
1057: hr_utility.trace(p_input_3 ||' '||l_description);
1058: END IF;
1059: l_err:=TRUE;
1060: END IF;
1061:
1058: END IF;
1059: l_err:=TRUE;
1060: END IF;
1061:
1062: hr_utility.trace('l_input_2 = '|| l_input_2);
1063: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1064: hr_utility.trace('l_length = '|| l_length);
1065: hr_utility.trace('After Number length check');
1066: IF to_number(l_input_2) < 0 THEN
1059: l_err:=TRUE;
1060: END IF;
1061:
1062: hr_utility.trace('l_input_2 = '|| l_input_2);
1063: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1064: hr_utility.trace('l_length = '|| l_length);
1065: hr_utility.trace('After Number length check');
1066: IF to_number(l_input_2) < 0 THEN
1067: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1060: END IF;
1061:
1062: hr_utility.trace('l_input_2 = '|| l_input_2);
1063: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1064: hr_utility.trace('l_length = '|| l_length);
1065: hr_utility.trace('After Number length check');
1066: IF to_number(l_input_2) < 0 THEN
1067: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1068: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1061:
1062: hr_utility.trace('l_input_2 = '|| l_input_2);
1063: hr_utility.trace('l_input_2 in number = '|| to_char(to_number(l_input_2)));
1064: hr_utility.trace('l_length = '|| l_length);
1065: hr_utility.trace('After Number length check');
1066: IF to_number(l_input_2) < 0 THEN
1067: return_value:='-'||lpad(nvl(replace(l_input_2,'-'),0),l_length-1,0);
1068: IF( p_record_name in ('RO','RW','RS','RCW','RCO','D','RSSUMM') OR
1069: (p_record_name = 'D' AND p_report_qualifier = 'AK_SQWL')) THEN
1076:
1077: /* sample mesg*/
1078: /* Error in RW record for employee 1234 in Medicare wages.
1079: The value is negative -2345 */
1080: hr_utility.trace(l_description);
1081: END IF;
1082: l_err:=TRUE;
1083: ELSE
1084: hr_utility.trace('l_input_2 = '|| l_input_2);
1080: hr_utility.trace(l_description);
1081: END IF;
1082: l_err:=TRUE;
1083: ELSE
1084: hr_utility.trace('l_input_2 = '|| l_input_2);
1085: hr_utility.trace('l_length = '|| l_length);
1086: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1087: hr_utility.trace('return_value = '|| return_value);
1088: END IF; /* to_number(l_input_2) */
1081: END IF;
1082: l_err:=TRUE;
1083: ELSE
1084: hr_utility.trace('l_input_2 = '|| l_input_2);
1085: hr_utility.trace('l_length = '|| l_length);
1086: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1087: hr_utility.trace('return_value = '|| return_value);
1088: END IF; /* to_number(l_input_2) */
1089: END IF; /* p_input_1 */
1083: ELSE
1084: hr_utility.trace('l_input_2 = '|| l_input_2);
1085: hr_utility.trace('l_length = '|| l_length);
1086: return_value:=lpad(nvl(replace(l_input_2,'-'),0),l_length,0);
1087: hr_utility.trace('return_value = '|| return_value);
1088: END IF; /* to_number(l_input_2) */
1089: END IF; /* p_input_1 */
1090:
1091: hr_utility.trace('Before returning the value = '||return_value);
1087: hr_utility.trace('return_value = '|| return_value);
1088: END IF; /* to_number(l_input_2) */
1089: END IF; /* p_input_1 */
1090:
1091: hr_utility.trace('Before returning the value = '||return_value);
1092: hr_utility.trace('p_validate = '||p_validate);
1093:
1094: IF p_validate= 'Y' THEN
1095: IF l_err THEN
1088: END IF; /* to_number(l_input_2) */
1089: END IF; /* p_input_1 */
1090:
1091: hr_utility.trace('Before returning the value = '||return_value);
1092: hr_utility.trace('p_validate = '||p_validate);
1093:
1094: IF p_validate= 'Y' THEN
1095: IF l_err THEN
1096: p_exclude_from_output:='Y';
1097: ELSE
1098: p_exclude_from_output:='N';
1099: END IF;
1100: END IF;
1101: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1102: RETURN return_value;
1103:
1104: END DATA_VALIDATION;
1105:
1189: l_exclude_from_output_chk boolean;
1190: main_return_string varchar2(300);
1191: BEGIN
1192:
1193: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1190: main_return_string varchar2(300);
1191: BEGIN
1192:
1193: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1191: BEGIN
1192:
1193: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1192:
1193: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1193: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1194: hr_utility.trace(' p_record_name = ' ||p_record_name);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1195: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1196: hr_utility.trace(' p_input_2 = ' ||p_input_2);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1197: hr_utility.trace(' p_input_3 = ' ||p_input_3);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1198: hr_utility.trace(' p_input_4 = ' ||p_input_4);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1199: hr_utility.trace(' p_input_5 = ' ||p_input_5);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1200: hr_utility.trace(' p_input_6 = ' ||p_input_6);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1201: hr_utility.trace(' p_input_7 = ' ||p_input_7);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1202: hr_utility.trace(' p_input_8 = ' ||p_input_8);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1203: hr_utility.trace(' p_input_9 = ' ||p_input_9);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1204: hr_utility.trace(' p_input_10 = ' ||p_input_10);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1205: hr_utility.trace(' p_input_11 = ' ||p_input_11);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1206: hr_utility.trace(' p_input_12 = ' ||p_input_12);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1207: hr_utility.trace(' p_input_13 = ' ||p_input_13);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1208: hr_utility.trace(' p_input_14 = ' ||p_input_14);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1209: hr_utility.trace(' p_input_15 = ' ||p_input_15);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1210: hr_utility.trace(' p_input_16 = ' ||p_input_16);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1211: hr_utility.trace(' p_input_17 = ' ||p_input_17);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1212: hr_utility.trace(' p_input_18 = ' ||p_input_18);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1213: hr_utility.trace(' p_input_19 = ' ||p_input_19);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1214: hr_utility.trace(' p_input_20 = ' ||p_input_20);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1215: hr_utility.trace(' p_input_21 = ' ||p_input_21);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1216: hr_utility.trace(' p_input_22 = ' ||p_input_22);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1217: hr_utility.trace(' p_input_23 = ' ||p_input_23);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1218: hr_utility.trace(' p_input_24 = ' ||p_input_24);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1219: hr_utility.trace(' p_input_25 = ' ||p_input_25);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1220: hr_utility.trace(' p_input_26 = ' ||p_input_26);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1221: hr_utility.trace(' p_input_27 = ' ||p_input_27);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1222: hr_utility.trace(' p_input_28 = ' ||p_input_28);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1223: hr_utility.trace(' p_input_29 = ' ||p_input_29);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1224: hr_utility.trace(' p_input_30 = ' ||p_input_30);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1225: hr_utility.trace(' p_input_31 = ' ||p_input_31);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1226: hr_utility.trace(' p_input_32 = ' ||p_input_32);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1227: hr_utility.trace(' p_input_33 = ' ||p_input_33);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1228: hr_utility.trace(' p_input_34 = ' ||p_input_34);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1229: hr_utility.trace(' p_input_35 = ' ||p_input_35);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1230: hr_utility.trace(' p_input_36 = ' ||p_input_36);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1238: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1231: hr_utility.trace(' p_input_37 = ' ||p_input_37);
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1238: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1239:
1232: hr_utility.trace(' p_input_38 = ' ||p_input_38);
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1238: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1239:
1240: IF p_format = 'MMREF' THEN -- p_format
1233: hr_utility.trace(' p_input_39 = ' ||p_input_39);
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1238: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1239:
1240: IF p_format = 'MMREF' THEN -- p_format
1241: --{
1234: hr_utility.trace(' p_input_40 = ' ||p_input_40);
1235: hr_utility.trace(' p_input_41 = ' ||p_input_41);
1236: hr_utility.trace(' p_input_42 = ' ||p_input_42);
1237: hr_utility.trace(' p_input_43 = ' ||p_input_43);
1238: hr_utility.trace(' p_input_44 = ' ||p_input_44);
1239:
1240: IF p_format = 'MMREF' THEN -- p_format
1241: --{
1242: IF (p_report_type = 'W2') THEN
2081: END IF; --p_report_type
2082: --}
2083: ELSIF p_format = 'CUSTOM' THEN
2084: --{
2085: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2086:
2087: IF p_record_name = 'H' THEN -- p_record_name
2088: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2089: return_value :=
2084: --{
2085: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_format);
2086:
2087: IF p_record_name = 'H' THEN -- p_record_name
2088: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2089: return_value :=
2090: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYER(
2091: p_effective_date,
2092: p_report_type,
2144: l_exclude_from_output_chk
2145: );
2146:
2147: ELSIF p_record_name = 'D' THEN
2148: hr_utility.trace('In pay_us_reporting_utils_pkg.format_record ' || p_record_name);
2149: return_value :=
2150: pay_us_custom_sqwl_format_rec.format_SQWL_CUSTOM_EMPLOYEE(
2151: p_effective_date,
2152: p_report_type,
2225: p_exclude_from_output := 'Y';
2226: ELSE
2227: p_exclude_from_output := 'N';
2228: END IF;
2229: hr_utility.trace('main_return_string = '||main_return_string);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2226: ELSE
2227: p_exclude_from_output := 'N';
2228: END IF;
2229: hr_utility.trace('main_return_string = '||main_return_string);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2227: p_exclude_from_output := 'N';
2228: END IF;
2229: hr_utility.trace('main_return_string = '||main_return_string);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2228: END IF;
2229: hr_utility.trace('main_return_string = '||main_return_string);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2229: hr_utility.trace('main_return_string = '||main_return_string);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2230: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2231: hr_utility.trace('sp_out_1 = '||sp_out_1);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2232: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2233: hr_utility.trace('sp_out_2 = '||sp_out_2);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2241: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2234: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2241: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2242:
2235: hr_utility.trace('sp_out_3 = '||sp_out_3);
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2241: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2242:
2243: RETURN main_return_string;
2236: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2241: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2242:
2243: RETURN main_return_string;
2244: END Format_Record;
2237: hr_utility.trace('sp_out_4 = '||sp_out_4);
2238: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
2239: hr_utility.trace('sp_out_5 = '||sp_out_5);
2240: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
2241: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
2242:
2243: RETURN main_return_string;
2244: END Format_Record;
2245:
2350: /* 3rd context of state jurisdiction_code*/
2351:
2352: BEGIN
2353:
2354: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2355: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2356: dbi_table(1).p_user_name:='A_TERRITORY_RETIRE_CONTRIB_PER_GRE_YTD';
2357: dbi_table(2).p_user_name:='A_TERRITORY_TAXABLE_ALLOW_PER_GRE_YTD';
2358: dbi_table(3).p_user_name:='A_TERRITORY_TAXABLE_COMM_PER_GRE_YTD';
2351:
2352: BEGIN
2353:
2354: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2355: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2356: dbi_table(1).p_user_name:='A_TERRITORY_RETIRE_CONTRIB_PER_GRE_YTD';
2357: dbi_table(2).p_user_name:='A_TERRITORY_TAXABLE_ALLOW_PER_GRE_YTD';
2358: dbi_table(3).p_user_name:='A_TERRITORY_TAXABLE_COMM_PER_GRE_YTD';
2359: dbi_table(4).p_user_name:='A_TERRITORY_TAXABLE_TIPS_PER_GRE_YTD';
2361: dbi_table(6).p_user_name:='A_PER_MARITAL_STATUS';
2362: dbi_table(7).p_user_name:='A_CON_NATIONAL_IDENTIFIER';
2363:
2364: l_jurisdiction_code:='72-000-0000';
2365: hr_utility.trace('Get PR Values');
2366:
2367: FOR i in dbi_table.first .. dbi_table.last loop
2368:
2369: OPEN get_user_entity_id(dbi_table(i).p_user_name);
2375: dbi_table(i).p_archived_value:='00000000000';
2376:
2377: ELSIF get_user_entity_id%FOUND THEN
2378:
2379: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2380: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2381: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2382:
2383: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2376:
2377: ELSIF get_user_entity_id%FOUND THEN
2378:
2379: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2380: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2381: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2382:
2383: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2384: open get_jd_archived_values(l_entity_id,
2377: ELSIF get_user_entity_id%FOUND THEN
2378:
2379: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
2380: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
2381: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
2382:
2383: IF dbi_table(i).p_user_name like '%PER_JD_GRE_YTD' THEN
2384: open get_jd_archived_values(l_entity_id,
2385: p_assignment_action_id,
2404: p_exclude_from_output,
2405: sp_out_1,
2406: sp_out_2);
2407:
2408: hr_utility.trace('Archived_value = '||dbi_table(i).p_archived_value);
2409:
2410: IF p_exclude_from_output = 'Y' THEN
2411: l_err:=TRUE;
2412: END IF;
2426: ELSE
2427: dbi_table(i).p_archived_value:='00000000000';
2428: END IF;
2429:
2430: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2431: ELSIF get_archived_values%FOUND THEN
2432:
2433: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2434: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2429:
2430: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2431: ELSIF get_archived_values%FOUND THEN
2432:
2433: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2434: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2435:
2436: IF ((dbi_table(i).p_user_name = 'A_PER_MARITAL_STATUS') OR
2437: (dbi_table(i).p_user_name = 'A_CON_NATIONAL_IDENTIFIER')) THEN
2430: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
2431: ELSIF get_archived_values%FOUND THEN
2432:
2433: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
2434: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
2435:
2436: IF ((dbi_table(i).p_user_name = 'A_PER_MARITAL_STATUS') OR
2437: (dbi_table(i).p_user_name = 'A_CON_NATIONAL_IDENTIFIER')) THEN
2438: dbi_table(i).p_archived_value := l_archived_value;
2467: p_exclude_from_output,
2468: sp_out_1,
2469: sp_out_2);
2470:
2471: hr_utility.trace('Archived_value = '||dbi_table(i).p_archived_value);
2472:
2473: IF p_exclude_from_output = 'Y' THEN
2474: l_err:=TRUE;
2475: END IF;
2482:
2483: END LOOP;
2484:
2485:
2486: hr_utility.trace('before Call to retrieve state_wages');
2487:
2488: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2489: (p_assignment_action_id,'A_W2_STATE_WAGES',
2490: p_tax_unit_id,l_jurisdiction_code,2);
2488: l_state_wage := HR_US_W2_REP.GET_W2_ARCH_BAL
2489: (p_assignment_action_id,'A_W2_STATE_WAGES',
2490: p_tax_unit_id,l_jurisdiction_code,2);
2491:
2492: hr_utility.trace('l_state_wage = '||l_state_wage);
2493: sp_out_5:= data_validation ( p_effective_date,
2494: p_report_type,
2495: p_format,
2496: p_report_qualifier,
2518: sp_out_6:=dbi_table(6).p_archived_value;
2519: sp_out_7:=dbi_table(7).p_archived_value;
2520:
2521:
2522: hr_utility.trace('l_main_return = '||l_main_return);
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2519: sp_out_7:=dbi_table(7).p_archived_value;
2520:
2521:
2522: hr_utility.trace('l_main_return = '||l_main_return);
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2520:
2521:
2522: hr_utility.trace('l_main_return = '||l_main_return);
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2521:
2522: hr_utility.trace('l_main_return = '||l_main_return);
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2529: hr_utility.trace('sp_out_7 = '||sp_out_7);
2522: hr_utility.trace('l_main_return = '||l_main_return);
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2529: hr_utility.trace('sp_out_7 = '||sp_out_7);
2530:
2523: hr_utility.trace('sp_out_1 = '||sp_out_1);
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2529: hr_utility.trace('sp_out_7 = '||sp_out_7);
2530:
2531:
2524: hr_utility.trace('sp_out_2 = '||sp_out_2);
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2529: hr_utility.trace('sp_out_7 = '||sp_out_7);
2530:
2531:
2532: IF p_validate = 'Y' THEN
2525: hr_utility.trace('sp_out_3 = '||sp_out_3);
2526: hr_utility.trace('sp_out_4 = '||sp_out_4);
2527: hr_utility.trace('sp_out_5 = '||sp_out_5);
2528: hr_utility.trace('sp_out_6 = '||sp_out_6);
2529: hr_utility.trace('sp_out_7 = '||sp_out_7);
2530:
2531:
2532: IF p_validate = 'Y' THEN
2533: IF l_err THEN
2612: Begin
2613:
2614: l_value := 'N';
2615:
2616: hr_utility.trace('Formula_Check');
2617: hr_utility.trace('p_report_format = '||p_report_format);
2618: hr_utility.trace('p_formula_name = '||p_formula_name);
2619:
2620:
2613:
2614: l_value := 'N';
2615:
2616: hr_utility.trace('Formula_Check');
2617: hr_utility.trace('p_report_format = '||p_report_format);
2618: hr_utility.trace('p_formula_name = '||p_formula_name);
2619:
2620:
2621: OPEN formula_exist(p_report_format,
2614: l_value := 'N';
2615:
2616: hr_utility.trace('Formula_Check');
2617: hr_utility.trace('p_report_format = '||p_report_format);
2618: hr_utility.trace('p_formula_name = '||p_formula_name);
2619:
2620:
2621: OPEN formula_exist(p_report_format,
2622: p_formula_name);
2624: FETCH formula_exist INTO l_value;
2625:
2626: CLOSE formula_exist;
2627:
2628: hr_utility.trace('l_value = '||l_value);
2629:
2630: RETURN l_value;
2631:
2632: END;
2786:
2787:
2788: BEGIN
2789:
2790: --hr_utility.trace('p_db_item_name is '||p_db_item_name);
2791:
2792: OPEN csr_defined_balance;
2793: FETCH csr_defined_balance INTO l_defined_balance_id;
2794: IF csr_defined_balance%notfound THEN
2792: OPEN csr_defined_balance;
2793: FETCH csr_defined_balance INTO l_defined_balance_id;
2794: IF csr_defined_balance%notfound THEN
2795: CLOSE csr_defined_balance;
2796: RAISE hr_utility.hr_error;
2797: ELSE
2798: CLOSE csr_defined_balance;
2799: END IF;
2800:
2797: ELSE
2798: CLOSE csr_defined_balance;
2799: END IF;
2800:
2801: --hr_utility.trace('l_defined_balance_id is '||to_char(l_defined_balance_id));
2802: RETURN (l_defined_balance_id);
2803:
2804: END bal_db_item;
2805:
2849: OPEN get_effective_date(p_assignment_action_id);
2850: FETCH get_effective_date INTO l_effective_start_date
2851: ,l_effective_end_date;
2852:
2853: hr_utility.trace('l_effective_start_date = '||l_effective_start_date);
2854: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2855:
2856: IF get_effective_date%NOTFOUND THEN
2857:
2850: FETCH get_effective_date INTO l_effective_start_date
2851: ,l_effective_end_date;
2852:
2853: hr_utility.trace('l_effective_start_date = '||l_effective_start_date);
2854: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2855:
2856: IF get_effective_date%NOTFOUND THEN
2857:
2858: hr_utility.trace('Effective Date not found for given
2854: hr_utility.trace('l_effective_end_date = '||l_effective_end_date);
2855:
2856: IF get_effective_date%NOTFOUND THEN
2857:
2858: hr_utility.trace('Effective Date not found for given
2859: assignment_action_id ='||to_char(p_assignment_action_id));
2860:
2861: END IF;
2862:
2870:
2871:
2872: If get_balance_feed_exist%NOTFOUND THEN
2873:
2874: hr_utility.trace('get_balance_feed_exist%NOTFOUND');
2875: return 0;
2876:
2877: ELSE
2878:
2877: ELSE
2878:
2879: /* Live Balance Call Procedure */
2880: l_bal_id := bal_db_item('W2_GOVT_EE_CONTRIB_PER_GRE_YTD');
2881: hr_utility.trace('get_balance_feed_exist FOUND');
2882: lv_bal_amt := nvl(pay_balance_pkg.get_value
2883: (p_defined_balance_id => l_bal_id,
2884: p_assignment_action_id => p_assignment_action_id),0);
2885: return (to_char(lv_bal_amt));
2911:
2912:
2913: BEGIN
2914: lv_return_value := 0;
2915: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2916:
2917: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2918: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2919:
2913: BEGIN
2914: lv_return_value := 0;
2915: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2916:
2917: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2918: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2919:
2920: /*
2921:
2914: lv_return_value := 0;
2915: hr_utility.trace('In pay_us_reporting_utils_pkg.get_ff_archive_value');
2916:
2917: hr_utility.trace('p_tax_unit_id = '||p_tax_unit_id);
2918: hr_utility.trace('p_assignment_action_id = '||p_action_id);
2919:
2920: /*
2921:
2922: -- remarked by tmehra, as discussed with Dipen and Mehul
2948: p_tax_unit_id,
2949: l_jurisdiction_code
2950: ));
2951:
2952: hr_utility.trace('lv_return_value = ' || lv_return_value);
2953:
2954:
2955: RETURN nvl(lv_return_value,0);
2956:
2962: p_state varchar2 default null
2963: ) RETURN number IS
2964: lv_employee_count number ;
2965: BEGIN
2966: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2967: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2968: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2969:
2970: select count(*)
2963: ) RETURN number IS
2964: lv_employee_count number ;
2965: BEGIN
2966: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2967: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2968: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2969:
2970: select count(*)
2971: into lv_employee_count
2964: lv_employee_count number ;
2965: BEGIN
2966: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_employee_count') ;
2967: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
2968: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
2969:
2970: select count(*)
2971: into lv_employee_count
2972: from pay_payroll_actions ppa,
2974: where ppa.payroll_action_id = p_payroll_action_id
2975: and paa.tax_unit_id = p_tax_unit_id
2976: and ppa.payroll_action_id = paa.payroll_action_id ;
2977:
2978: hr_utility.trace('lv_employee_count := '||lv_employee_count) ;
2979: RETURN lv_employee_count ;
2980:
2981: END get_employee_count ;
2982:
3141: i NUMBER ;
3142:
3143: BEGIN
3144:
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3142:
3143: BEGIN
3144:
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3150: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3143: BEGIN
3144:
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3150: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3151:
3144:
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3150: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3151:
3152: lv_total_wages := 0 ;
3145: hr_utility.trace('Inside pay_us_reporting_utils_pkg.get_total_wages') ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3150: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3151:
3152: lv_total_wages := 0 ;
3153: lv_employee_count := 0 ;
3146: hr_utility.trace('p_payroll_action_id := '||p_payroll_action_id) ;
3147: hr_utility.trace('p_tax_unit_id := ' || p_tax_unit_id) ;
3148: hr_utility.trace('p_state := ' || p_state) ;
3149: hr_utility.trace('p_report_type := ' || p_report_type) ;
3150: hr_utility.trace('p_balance_name := ' || p_balance_name) ;
3151:
3152: lv_total_wages := 0 ;
3153: lv_employee_count := 0 ;
3154:
3200: lv_total_wages := lv_tot_wage_tab(j).summed_balance_value ;
3201: EXIT ;
3202: END IF ;
3203: END LOOP ;
3204: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3205: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3206:
3207: RETURN lv_total_wages ;
3208:
3201: EXIT ;
3202: END IF ;
3203: END LOOP ;
3204: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3205: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3206:
3207: RETURN lv_total_wages ;
3208:
3209: ELSIF p_balance_name = 'State taxable Wages' THEN
3216: ELSIF lv_tot_wage_tab(j).dbi_name = 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' THEN
3217: lv_total_wages := lv_total_wages - lv_tot_wage_tab(j).summed_balance_value ;
3218: END IF ;
3219: END LOOP ;
3220: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3221: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3222:
3223: RETURN lv_total_wages ;
3224:
3217: lv_total_wages := lv_total_wages - lv_tot_wage_tab(j).summed_balance_value ;
3218: END IF ;
3219: END LOOP ;
3220: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3221: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3222:
3223: RETURN lv_total_wages ;
3224:
3225: ELSIF p_balance_name = 'Other State Data' THEN
3229: lv_total_wages := lv_tot_wage_tab(j).summed_balance_value ;
3230: EXIT ;
3231: END IF ;
3232: END LOOP ;
3233: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3234: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3235:
3236: RETURN lv_total_wages ;
3237: END IF ; -- p_balance_name
3230: EXIT ;
3231: END IF ;
3232: END LOOP ;
3233: hr_utility.trace('p_balance_name := '||p_balance_name) ;
3234: hr_utility.trace('lv_total_wages := '||lv_total_wages) ;
3235:
3236: RETURN lv_total_wages ;
3237: END IF ; -- p_balance_name
3238: END IF ; -- p_state
3377: return(0);
3378:
3379: END GET_SUI_WAGES;
3380: --BEGIN
3381: --hr_utility.trace_on(null,'MMREF');
3382:
3383: END pay_us_reporting_utils_pkg;