eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on FND_NUMBER

Line 1480: ,FND_NUMBER.Canonical_To_Number(scl.segment12) prev_year_sal

1476: ,p_date_earned IN DATE) IS
1477:
1478: CURSOR csr_nl_employee_details IS
1479: SELECT trim(scl.segment11) tax_code
1480: ,FND_NUMBER.Canonical_To_Number(scl.segment12) prev_year_sal
1481: ,scl.segment4 tax_reduction
1482: ,scl.segment7 labour_tax_reduction
1483: ,scl.segment9 add_senior_tax_reduction
1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours

Line 1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours

1480: ,FND_NUMBER.Canonical_To_Number(scl.segment12) prev_year_sal
1481: ,scl.segment4 tax_reduction
1482: ,scl.segment7 labour_tax_reduction
1483: ,scl.segment9 add_senior_tax_reduction
1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours
1485: FROM per_assignments_f paf
1486: ,hr_soft_coding_keyflex scl
1487: WHERE paf.assignment_id = p_assignment_id
1488: AND p_date_earned BETWEEN paf.effective_start_date

Line 1871: l_legal_min_payment := NVL(fnd_number.number_to_canonical((FND_NUMBER.CANONICAL_TO_NUMBER(l_ret) * l_min_wage_factor)),'');

1867: ,l_organization_Id);
1868: --
1869: --hr_utility.set_location('Inside ARCHIVE_NL_EMPLOYEE_DETAILS l_employer_id'||l_employer_id,1450);
1870: --Bug 3601121
1871: l_legal_min_payment := NVL(fnd_number.number_to_canonical((FND_NUMBER.CANONICAL_TO_NUMBER(l_ret) * l_min_wage_factor)),'');
1872:
1873: l_si_def_bal_id := get_defined_balance_id('Real Social Insurance Days'
1874: ,'_ASG_SIT_RUN');
1875:

Line 1925: ,p_action_information6 =>fnd_number.number_to_canonical(l_individual_working_hours)

1921: ,p_source_text => NULL
1922: ,p_action_information_category => 'NL OTHER EMPLOYEE DETAILS'
1923: ,p_action_information4 =>p_payroll_id
1924: ,p_action_information5 =>l_employer_id
1925: ,p_action_information6 =>fnd_number.number_to_canonical(l_individual_working_hours)
1926: ,p_action_information7 =>l_legal_min_payment
1927: ,p_action_information8 =>fnd_number.number_to_canonical(l_si_days));
1928:
1929: OPEN csr_get_hr_org_address(l_employer_id);

Line 1927: ,p_action_information8 =>fnd_number.number_to_canonical(l_si_days));

1923: ,p_action_information4 =>p_payroll_id
1924: ,p_action_information5 =>l_employer_id
1925: ,p_action_information6 =>fnd_number.number_to_canonical(l_individual_working_hours)
1926: ,p_action_information7 =>l_legal_min_payment
1927: ,p_action_information8 =>fnd_number.number_to_canonical(l_si_days));
1928:
1929: OPEN csr_get_hr_org_address(l_employer_id);
1930: FETCH csr_get_hr_org_address INTO csr_hr_org_address_rec;
1931: CLOSE csr_get_hr_org_address;

Line 1987: ,p_action_information14 =>fnd_number.number_to_canonical(l_regular_working_hours));

1983: ,p_action_information10 =>l_city
1984: ,p_action_information11 =>l_province
1985: ,p_action_information12 =>l_country
1986: ,p_action_information13 =>csr_hr_org_address_rec.po_box_no
1987: ,p_action_information14 =>fnd_number.number_to_canonical(l_regular_working_hours));
1988:
1989: --
1990: l_WAO := 'N';
1991: l_WW := 'N';

Line 2552: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)

2548: ,p_source_text => NULL
2549: ,p_action_information_category => 'EMEA BALANCES'
2550: ,p_action_information1 =>p_defined_bal_id
2551: ,p_action_information2 =>context_rec.value
2552: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)
2553: ,p_action_information5 =>l_record_count
2554: ,p_action_information6 =>l_si_type_name);
2555:
2556: END IF;

Line 2622: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)

2618: ,p_source_text => NULL
2619: ,p_action_information_category => 'EMEA BALANCES'
2620: ,p_action_information1 =>p_defined_bal_id
2621: ,p_action_information2 =>p_si_type
2622: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)
2623: ,p_action_information5 =>l_record_count
2624: ,p_action_information6 =>l_si_type_name);
2625: hr_utility.set_location('Inside process_balance l_action_info_id'||l_action_info_id,1900);
2626: END IF;

Line 2664: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)

2660: ,p_source_text => NULL
2661: ,p_action_information_category => 'EMEA BALANCES'
2662: ,p_action_information1 =>p_defined_bal_id
2663: ,p_action_information2 =>p_si_type
2664: ,p_action_information4 =>fnd_number.number_to_canonical(l_balance_value)
2665: ,p_action_information5 =>l_record_count
2666: ,p_action_information6 =>l_si_type_name);
2667:
2668: hr_utility.set_location('Inside process_balance l_action_info_id'||l_action_info_id,1900);

Line 3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null

3193: END IF;
3194: END IF;
3195: --
3196: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2123);
3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null
3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null
3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null
3200: OR l_rate is not null) THEN
3201: -- Archive NL CALCULATIONS

Line 3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null

3194: END IF;
3195: --
3196: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2123);
3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null
3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null
3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null
3200: OR l_rate is not null) THEN
3201: -- Archive NL CALCULATIONS
3202: --

Line 3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null

3195: --
3196: hr_utility.set_location('Inside archive_payslip_element_info1 l_rate'||l_rate,2123);
3197: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_standard_rate) is not null
3198: OR FND_NUMBER.canonical_to_number(l_special_rate) is not null
3199: OR FND_NUMBER.canonical_to_number(l_payable) is not null
3200: OR l_rate is not null) THEN
3201: -- Archive NL CALCULATIONS
3202: --
3203: --pay_action_information_api.create_action_information (..);

Line 3233: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)

3229: ,p_action_information9 =>element_value_rec.RDate --Retro Period
3230: ,p_action_information10 =>l_standard_rate
3231: ,p_action_information11 =>l_special_rate
3232: ,p_action_information12 =>l_payable
3233: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)
3234: ,p_action_information16 =>l_element_type_id /* 4389520*/
3235: ,p_action_information17 =>l_run_result_id );
3236:
3237:

Line 3239: g_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);

3235: ,p_action_information17 =>l_run_result_id );
3236:
3237:
3238: IF l_travel_flag = 1 THEN
3239: g_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);
3240: g_travel_allowance_ytd := l_rate;
3241: END IF;
3242: IF l_retro_travel_flag = 1 THEN
3243: g_retro_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);

Line 3243: g_retro_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);

3239: g_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);
3240: g_travel_allowance_ytd := l_rate;
3241: END IF;
3242: IF l_retro_travel_flag = 1 THEN
3243: g_retro_travel_allowance := FND_NUMBER.canonical_to_number(l_payable);
3244: g_retro_travel_allowance_ytd := l_rate;
3245: END IF;
3246:
3247: l_index := l_temp_index;

Line 3342: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));

3338: ,p_date_earned);
3339: FETCH csr_sec_classification INTO l_temp;
3340: IF csr_sec_classification%FOUND THEN
3341: l_standard_rate := retro_element_value_rec.value;
3342: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3343: ELSE
3344: l_standard_rate :=NULL;
3345: END IF;
3346: CLOSE csr_sec_classification;

Line 3357: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));

3353: ,p_date_earned);
3354: FETCH csr_sec_classification INTO l_temp;
3355: IF csr_sec_classification%FOUND THEN
3356: l_special_rate := retro_element_value_rec.value;
3357: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));
3358: ELSE
3359: l_special_rate :=NULL;
3360: END IF;
3361: CLOSE csr_sec_classification;

Line 3374: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_payable));

3370: IF p_payable_flag='Y' THEN
3371: l_payable := retro_element_value_rec.value;
3372: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3373: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3374: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_payable));
3375: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3376: END IF;
3377:
3378:

Line 3445: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

3441:
3442: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_pecentage_rate'||' '||l_pecentage_rate);
3443: END LOOP;
3444:
3445: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3446: l_sum_standard_rate:=NULL;
3447: END IF;
3448:
3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

Line 3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

3445: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3446: l_sum_standard_rate:=NULL;
3447: END IF;
3448:
3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3450: l_sum_special_rate:=NULL;
3451: END IF;
3452:
3453: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN

Line 3453: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN

3449: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3450: l_sum_special_rate:=NULL;
3451: END IF;
3452:
3453: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3454: l_sum_payable:=NULL;
3455: END IF;
3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);

Line 3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null

3455: END IF;
3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3462: OR l_rate is not null) THEN
3463: -- Archive NL CALCULATIONS

Line 3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null

3456: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3462: OR l_rate is not null) THEN
3463: -- Archive NL CALCULATIONS
3464: --

Line 3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null

3457: hr_utility.set_location('Retro Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3458:
3459: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3460: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3461: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3462: OR l_rate is not null) THEN
3463: -- Archive NL CALCULATIONS
3464: --
3465: --pay_action_information_api.create_action_information (..);

Line 3493: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)

3489: ,p_action_information9 =>l_date --Retro Period
3490: ,p_action_information10 =>l_sum_standard_rate
3491: ,p_action_information11 =>l_sum_special_rate
3492: ,p_action_information12 =>l_sum_payable
3493: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate)
3494: ,p_action_information16 =>l_element_type_id
3495: ,p_action_information17 =>l_run_result_id
3496: );
3497:

Line 3500: g_retro_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);

3496: );
3497:
3498:
3499: IF p_element_name = 'Retro Employer ZVW Contribution Standard Tax' THEN
3500: g_retro_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3501: g_retro_zvw_er_cont_std_ytd := l_rate;
3502: END IF;
3503: IF p_element_name = 'Retro Employer ZVW Contribution Special Tax' THEN
3504: g_retro_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);

Line 3504: g_retro_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);

3500: g_retro_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3501: g_retro_zvw_er_cont_std_ytd := l_rate;
3502: END IF;
3503: IF p_element_name = 'Retro Employer ZVW Contribution Special Tax' THEN
3504: g_retro_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);
3505: g_retro_zvw_er_cont_spl_ytd := l_rate;
3506: END IF;
3507:
3508: l_index := l_index + 1;

Line 3547: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));

3543: ,p_date_earned);
3544: FETCH csr_sec_classification INTO l_temp;
3545: IF csr_sec_classification%FOUND THEN
3546: l_standard_rate := element_value_rec.value;
3547: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
3548: ELSE
3549: l_standard_rate :=NULL;
3550: END IF;
3551: CLOSE csr_sec_classification;

Line 3561: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));

3557: ,p_date_earned);
3558: FETCH csr_sec_classification INTO l_temp;
3559: IF csr_sec_classification%FOUND THEN
3560: l_special_rate := element_value_rec.value;
3561: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));
3562: ELSE
3563: l_special_rate :=NULL;
3564: END IF;
3565: CLOSE csr_sec_classification;

Line 3573: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(nvl(l_payable,'0')));

3569:
3570: IF p_payable_flag='Y' THEN
3571: l_payable := element_value_rec.value;
3572: hr_utility.set_location('Inside archive_payslip_element_info2 l_payable'||l_payable,2120);
3573: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(nvl(l_payable,'0')));
3574: hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2120);
3575: END IF;
3576:
3577: --hr_utility.set_location('Inside archive_payslip_element_info2 element_name'||element_value_rec.element_name,2120);

Line 3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

3644: --hr_utility.set_location('Inside archive_payslip_element_info l_date'||l_date,2123);
3645: --
3646: END LOOP;
3647: END LOOP;
3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3649: l_sum_standard_rate:=NULL;
3650: END IF;
3651:
3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

Line 3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

3648: IF FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
3649: l_sum_standard_rate:=NULL;
3650: END IF;
3651:
3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3653: l_sum_special_rate:=NULL;
3654: END IF;
3655:
3656: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN

Line 3656: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN

3652: IF FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
3653: l_sum_special_rate:=NULL;
3654: END IF;
3655:
3656: IF FND_NUMBER.canonical_to_number(l_sum_payable)=0 THEN
3657: l_sum_payable:=NULL;
3658: END IF;
3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);

Line 3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null

3658: END IF;
3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3665: OR l_rate is not null) THEN
3666: -- Archive NL CALCULATIONS

Line 3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null

3659: --hr_utility.set_location('Inside archive_payslip_element_info2 l_rate'||l_rate,2123);
3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3665: OR l_rate is not null) THEN
3666: -- Archive NL CALCULATIONS
3667: --

Line 3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null

3660: --hr_utility.set_location('Inside archive_payslip_element_info2 l_sum_payable'||l_sum_payable,2123);
3661:
3662: IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) is not null
3663: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) is not null
3664: OR FND_NUMBER.canonical_to_number(l_sum_payable) is not null
3665: OR l_rate is not null) THEN
3666: -- Archive NL CALCULATIONS
3667: --
3668: --pay_action_information_api.create_action_information (..);

Line 3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));

3692: ,p_action_information9 =>l_date --Retro Period
3693: ,p_action_information10 =>l_sum_standard_rate
3694: ,p_action_information11 =>l_sum_special_rate
3695: ,p_action_information12 =>l_sum_payable
3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));
3697:
3698:
3699: IF p_element_name = 'Employer ZVW Contribution Standard Tax' THEN
3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);

Line 3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);

3696: ,p_action_information13 =>fnd_number.number_to_canonical(l_rate));
3697:
3698:
3699: IF p_element_name = 'Employer ZVW Contribution Standard Tax' THEN
3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3701: g_zvw_er_cont_std_ytd := l_rate;
3702: END IF;
3703: IF p_element_name = 'Employer ZVW Contribution Special Tax' THEN
3704: g_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);

Line 3704: g_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);

3700: g_zvw_er_cont_std_run := FND_NUMBER.canonical_to_number(l_sum_standard_rate);
3701: g_zvw_er_cont_std_ytd := l_rate;
3702: END IF;
3703: IF p_element_name = 'Employer ZVW Contribution Special Tax' THEN
3704: g_zvw_er_cont_spl_run := FND_NUMBER.canonical_to_number(l_sum_special_rate);
3705: g_zvw_er_cont_spl_ytd := l_rate;
3706: END IF;
3707:
3708: l_index := l_index + 1;

Line 4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)

4214: ,p_action_information6 =>l_balance_name
4215: ,p_action_information7 =>l_si_type_name
4216: ,p_action_information8 =>p_type
4217: ,p_action_information9 =>null
4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4222:

Line 4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)

4215: ,p_action_information7 =>l_si_type_name
4216: ,p_action_information8 =>p_type
4217: ,p_action_information9 =>null
4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4222:
4223: l_index:=l_index+1;

Line 4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)

4216: ,p_action_information8 =>p_type
4217: ,p_action_information9 =>null
4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4222:
4223: l_index:=l_index+1;
4224: END IF;

Line 4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));

4217: ,p_action_information9 =>null
4218: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4219: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4220: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4221: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4222:
4223: l_index:=l_index+1;
4224: END IF;
4225:

Line 4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)

4446: ,p_action_information6 =>l_balance_name
4447: ,p_action_information7 =>NULL
4448: ,p_action_information8 =>p_type
4449: ,p_action_information9 =>null
4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4454:

Line 4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)

4447: ,p_action_information7 =>NULL
4448: ,p_action_information8 =>p_type
4449: ,p_action_information9 =>null
4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4454:
4455: l_index:=l_index+1;

Line 4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)

4448: ,p_action_information8 =>p_type
4449: ,p_action_information9 =>null
4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4454:
4455: l_index:=l_index+1;
4456:

Line 4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));

4449: ,p_action_information9 =>null
4450: ,p_action_information10 =>fnd_number.number_to_canonical(l_sum_standard_rate_run)
4451: ,p_action_information11 =>fnd_number.number_to_canonical(l_sum_special_rate_run)
4452: ,p_action_information12 =>fnd_number.number_to_canonical(l_sum_payable)
4453: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
4454:
4455: l_index:=l_index+1;
4456:
4457: END IF;

Line 4560: SELECT sum(fnd_number.canonical_to_number(prrv.result_value)) result_value

4556: ,p_date_earned DATE
4557: ,p_retro_date DATE
4558: ,p_creator_type VARCHAR2
4559: ,p_classification_id NUMBER ) IS
4560: SELECT sum(fnd_number.canonical_to_number(prrv.result_value)) result_value
4561: ,pet.processing_priority priority
4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv

Line 4604: SELECT sum(fnd_number.canonical_to_number(prrv2.result_value))

4600: ,p_retro_date DATE
4601: ,p_si_type VARCHAR2
4602: ,p_creator_type VARCHAR2
4603: ,p_classification_id NUMBER) IS
4604: SELECT sum(fnd_number.canonical_to_number(prrv2.result_value))
4605: ,prrv1.result_value
4606: ,pet.processing_priority
4607: FROM pay_balance_feeds_f pbf
4608: ,pay_balance_types pbt

Line 4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));

4832: l_standard_rate := l_value;
4833:
4834: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
4835:
4836: l_sum_standard_rate :=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
4837:
4838: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
4839:
4840: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);

Line 4875: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));

4871: l_special_rate := l_value;
4872:
4873: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_rate'||' '||l_special_rate);
4874:
4875: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));
4876:
4877: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
4878:
4879: IF l_si_type_name IS NOT NULL THEN

Line 4914: l_sum_non_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_non_rate) +FND_NUMBER.canonical_to_number(l_non_rate));

4910: l_non_rate := l_value;
4911:
4912: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_non_rate'||' '||l_non_rate);
4913:
4914: l_sum_non_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_non_rate) +FND_NUMBER.canonical_to_number(l_non_rate));
4915:
4916: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_non_rate'||' '||l_sum_non_rate);
4917:
4918: IF l_si_type_name IS NOT NULL THEN

Line 4952: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) +FND_NUMBER.canonical_to_number(l_rate));

4948: l_rate := l_value;
4949:
4950: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_rate'||' '||l_rate);
4951:
4952: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) +FND_NUMBER.canonical_to_number(l_rate));
4953:
4954: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
4955:
4956: IF l_si_type_name IS NOT NULL THEN

Line 4974: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate)

4970: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
4971:
4972: IF p_payable_flag='Y' THEN
4973:
4974: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate)
4975: + FND_NUMBER.canonical_to_number(l_sum_special_rate) +FND_NUMBER.canonical_to_number(l_sum_non_rate));
4976:
4977: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
4978: END IF;

Line 4975: + FND_NUMBER.canonical_to_number(l_sum_special_rate) +FND_NUMBER.canonical_to_number(l_sum_non_rate));

4971:
4972: IF p_payable_flag='Y' THEN
4973:
4974: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate)
4975: + FND_NUMBER.canonical_to_number(l_sum_special_rate) +FND_NUMBER.canonical_to_number(l_sum_non_rate));
4976:
4977: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
4978: END IF;
4979:

Line 5028: FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

5024: --hr_utility.set_location('Inside archive_retro_balance_info l_balance_name'||l_balance_name,5150);
5025:
5026:
5027: IF l_balance_name='Retro Net Employee SI Contribution' and
5028: FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5029: l_sum_standard_rate:=NULL;
5030: END IF;
5031:
5032: IF l_balance_name='Retro Net Employee SI Contribution' and

Line 5033: FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

5029: l_sum_standard_rate:=NULL;
5030: END IF;
5031:
5032: IF l_balance_name='Retro Net Employee SI Contribution' and
5033: FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5034: l_sum_special_rate:=NULL;
5035: END IF;
5036:
5037: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN

Line 5037: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN

5033: FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5034: l_sum_special_rate:=NULL;
5035: END IF;
5036:
5037: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN
5038: l_sum_payable:=NULL;
5039: END IF;
5040: IF l_si_type_name='ZVW' THEN
5041: IF p_balance_name = 'Retro Employer SI Contribution' and l_index < 18750 THEN

Line 5060: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

5056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5057: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5058:
5059: IF p_archive_flag = 'Y'
5060: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:

Line 5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

5057: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5058:
5059: IF p_archive_flag = 'Y'
5060: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

Line 5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0

5058:
5059: IF p_archive_flag = 'Y'
5060: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

Line 5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

5061: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5069: -- Archive NL CALCULATIONS

Line 5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

5062: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5069: -- Archive NL CALCULATIONS
5070: --

Line 5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0

5063: OR l_sum_year <> 0) THEN
5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5069: -- Archive NL CALCULATIONS
5070: --
5071: --pay_action_information_api.create_action_information (..);

Line 5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/

5064:
5065: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5066: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5067: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5068: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5069: -- Archive NL CALCULATIONS
5070: --
5071: --pay_action_information_api.create_action_information (..);
5072: --

Line 5092: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));

5088: ,p_action_information9 =>l_date --Retro Period
5089: ,p_action_information10 =>l_sum_standard_rate
5090: ,p_action_information11 =>l_sum_special_rate
5091: ,p_action_information12 =>l_sum_payable
5092: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
5093: l_index := l_index + 1;
5094: END IF;
5095: END LOOP;
5096: END LOOP;

Line 5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *

5183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5184: l_flag:=0;
5185: IF csr_retro_values_nc%FOUND THEN
5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);

Line 5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));

5186: l_standard_rate := l_value;
5187: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5188: p_multiply_factor);
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5190: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_standard_rate));
5191: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5192: l_flag:=1;
5193: CLOSE csr_retro_values_nc;
5194: ELSIF p_standard_bal_name = 'Retro Standard Taxable Income' THEN

Line 5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *

5205: l_standard_rate := l_value;
5206: l_flag:=1;
5207: END IF;
5208: CLOSE csr_retro_values_nc;
5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5210: p_multiply_factor);
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));

Line 5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));

5209: l_standard_rate := FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_standard_rate),0) *
5210: p_multiply_factor);
5211:
5212: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_rate'||' '||l_standard_rate);
5213: l_sum_standard_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_standard_rate) +FND_NUMBER.canonical_to_number( l_standard_rate));
5214:
5215: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_standard_rate'||' '||l_sum_standard_rate);
5216: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5217:

Line 5270: l_special_rate :=FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_special_rate),0) *

5266:
5267: IF csr_retro_values_nc%FOUND THEN
5268: l_special_rate := l_value;
5269:
5270: l_special_rate :=FND_NUMBER.number_to_canonical(NVL(FND_NUMBER.canonical_to_number(l_special_rate),0) *
5271: p_multiply_factor);
5272:
5273: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_rate'||' '||l_special_rate);
5274:

Line 5275: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));

5271: p_multiply_factor);
5272:
5273: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_special_rate'||' '||l_special_rate);
5274:
5275: l_sum_special_rate:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_special_rate) + FND_NUMBER.canonical_to_number(l_special_rate));
5276:
5277: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_special_rate'||' '||l_sum_special_rate);
5278: l_flag:=1;
5279: CLOSE csr_retro_values_nc;

Line 5323: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_rate));

5319: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_priority'||' '||l_priority);
5320: IF csr_retro_values_nc%FOUND THEN
5321: l_rate := l_value;
5322: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_rate'||' '||l_rate);
5323: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_rate));
5324: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5325:
5326: CLOSE csr_retro_values_nc;
5327: --hr_utility.set_location('Inside archive_retro_balance_info non context p_balance_name'||p_balance_name,6220);

Line 5343: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_sum_special_rate));

5339:
5340: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_payable_flag'||' '||p_payable_flag);
5341:
5342: IF p_payable_flag='Y' THEN
5343: l_sum_payable:=FND_NUMBER.number_to_canonical(FND_NUMBER.canonical_to_number(l_sum_payable) + FND_NUMBER.canonical_to_number(l_sum_standard_rate) + FND_NUMBER.canonical_to_number(l_sum_special_rate));
5344: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_payable'||' '||l_sum_payable);
5345: END IF;
5346:
5347: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_standard_year'||' '||l_standard_year);

Line 5395: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

5391:
5392:
5393:
5394:
5395: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5396: l_sum_standard_rate:=NULL;
5397: END IF;
5398:
5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

Line 5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

5395: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5396: l_sum_standard_rate:=NULL;
5397: END IF;
5398:
5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5400: l_sum_special_rate:=NULL;
5401: END IF;
5402:
5403: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN

Line 5403: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN

5399: IF l_balance_name='Retro Employees Private Health' and FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5400: l_sum_special_rate:=NULL;
5401: END IF;
5402:
5403: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN
5404: l_sum_payable:=NULL;
5405: END IF;
5406:
5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

Line 5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN

5403: IF p_payable_flag='N' and FND_NUMBER.canonical_to_number(l_sum_payable) =0 THEN
5404: l_sum_payable:=NULL;
5405: END IF;
5406:
5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5408: l_sum_standard_rate:=NULL;
5409: END IF;
5410:
5411: IF p_special_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

Line 5411: IF p_special_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN

5407: IF p_standard_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_standard_rate)=0 THEN
5408: l_sum_standard_rate:=NULL;
5409: END IF;
5410:
5411: IF p_special_bal_name IS NULL AND FND_NUMBER.canonical_to_number(l_sum_special_rate)=0 THEN
5412: l_sum_special_rate:=NULL;
5413: END IF;
5414:
5415:

Line 5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR

5422: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_sum_year'||' '||l_sum_year);
5423:
5424: /* for 4253974 */
5425: IF ( p_archive_flag = 'Y' and l_date is not null and
5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))

Line 5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR

5423:
5424: /* for 4253974 */
5425: IF ( p_archive_flag = 'Y' and l_date is not null and
5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

Line 5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR

5424: /* for 4253974 */
5425: IF ( p_archive_flag = 'Y' and l_date is not null and
5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

Line 5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR

5425: IF ( p_archive_flag = 'Y' and l_date is not null and
5426: (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0 OR
5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0

Line 5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

5427: FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0 OR
5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:

Line 5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

5428: FND_NUMBER.canonical_to_number(l_sum_payable) <> 0 OR
5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

Line 5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0

5429: FND_NUMBER.canonical_to_number(l_sum_payable) IS NOT NULL OR
5430: l_sum_year <> 0))
5431: OR (FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

Line 5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0

5432: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5440: -- Archive NL CALCULATIONS

Line 5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0

5433: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5440: -- Archive NL CALCULATIONS
5441: --

Line 5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0

5434: OR l_sum_year <> 0) THEN
5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5440: -- Archive NL CALCULATIONS
5441: --
5442: --pay_action_information_api.create_action_information (..);

Line 5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/

5435:
5436: /* IF p_archive_flag = 'Y' OR(FND_NUMBER.canonical_to_number(l_sum_standard_rate) <> 0
5437: OR FND_NUMBER.canonical_to_number(l_sum_special_rate) <> 0
5438: OR FND_NUMBER.canonical_to_number(l_sum_payable) <> 0
5439: OR FND_NUMBER.canonical_to_number(l_sum_year) <> 0) THEN*/
5440: -- Archive NL CALCULATIONS
5441: --
5442: --pay_action_information_api.create_action_information (..);
5443: --

Line 5463: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));

5459: ,p_action_information9 =>l_date --Retro Period
5460: ,p_action_information10 =>l_sum_standard_rate
5461: ,p_action_information11 =>l_sum_special_rate
5462: ,p_action_information12 =>l_sum_payable
5463: ,p_action_information13 =>fnd_number.number_to_canonical(l_sum_year));
5464: l_index := l_index + 1;
5465:
5466: END IF;
5467: END LOOP;