640: ,p_effective_date => l_ATS_Process_Date
641: ,p_source_id => NULL
642: ,p_source_text => NULL
643: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
644: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
645: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
646: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
647: ,p_action_information4 => l_wage
648: ,p_action_information5 => l_deduct_wage_tax_si_cont
641: ,p_source_id => NULL
642: ,p_source_text => NULL
643: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
644: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
645: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
646: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
647: ,p_action_information4 => l_wage
648: ,p_action_information5 => l_deduct_wage_tax_si_cont
649: ,p_action_information6 => l_asg_start_date
642: ,p_source_text => NULL
643: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
644: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
645: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
646: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
647: ,p_action_information4 => l_wage
648: ,p_action_information5 => l_deduct_wage_tax_si_cont
649: ,p_action_information6 => l_asg_start_date
650: ,p_action_information7 => l_asg_end_date
654: ,p_action_information11 => l_Income_Code
655: ,p_action_information12 => l_Special_Indicator
656: ,p_action_information13 => l_Amount_Special_Indicator
657: ,p_action_information14 => l_SI_Insured_Flag
658: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
659: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
655: ,p_action_information12 => l_Special_Indicator
656: ,p_action_information13 => l_Amount_Special_Indicator
657: ,p_action_information14 => l_SI_Insured_Flag
658: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
659: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
656: ,p_action_information13 => l_Amount_Special_Indicator
657: ,p_action_information14 => l_SI_Insured_Flag
658: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
659: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
658: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
659: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
659: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
667: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
660: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
667: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
668: ,p_action_information25 => l_User_Bal_String);
661: ,p_action_information18 => l_taxable_income
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
667: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
668: ,p_action_information25 => l_User_Bal_String);
669:
662: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
667: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
668: ,p_action_information25 => l_User_Bal_String);
669:
670: END IF;
663: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
664: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
665: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
666: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
667: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
668: ,p_action_information25 => l_User_Bal_String);
669:
670: END IF;
671: end if;
3444: ELSE
3445: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3446: END IF;
3447:
3448: l_balance_string := l_balance_string||fnd_number.number_to_canonical(ceil(l_balance_value))||'|';
3449:
3450: END LOOP;
3451:
3452: p_User_Bal_String := l_balance_string;