DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on FND_NUMBER

Line 1980: := fnd_number.number_to_canonical(ln_rate);

1976: := ln_element_type_id;
1977: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;

Line 1982: := fnd_number.number_to_canonical(ln_hours);

1978: := lv_element_name;
1979: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
1980: := fnd_number.number_to_canonical(ln_rate);
1981: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);

Line 1986: := fnd_number.number_to_canonical(ln_multiple);

1982: := fnd_number.number_to_canonical(ln_hours);
1983: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);
1987: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1988: := fnd_number.number_to_canonical(ln_amount);
1989:
1990: /******************************************************

Line 1988: := fnd_number.number_to_canonical(ln_amount);

1984: := lv_processing_priority;
1985: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1986: := fnd_number.number_to_canonical(ln_multiple);
1987: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1988: := fnd_number.number_to_canonical(ln_amount);
1989:
1990: /******************************************************
1991: ** Insert into seperate table
1992: ******************************************************/

Line 2096: := fnd_number.number_to_canonical(ln_retro_rate);

2092: := ltr_hours_x_rate(z).element_type_id;
2093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;

Line 2098: := fnd_number.number_to_canonical(ln_retro_hours);

2094: := ltr_hours_x_rate(z).element_name;
2095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
2096: := fnd_number.number_to_canonical(ln_retro_rate);
2097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));

Line 2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));

2098: := fnd_number.number_to_canonical(ln_retro_hours);
2099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
2103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2104: := fnd_number.number_to_canonical(ln_retro_payvalue);
2105: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2106: end loop;

Line 2104: := fnd_number.number_to_canonical(ln_retro_payvalue);

2100: := ltr_hours_x_rate(z).processing_priority;
2101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
2102: := fnd_number.number_to_canonical(nvl(ln_retro_multiple,1));
2103: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
2104: := fnd_number.number_to_canonical(ln_retro_payvalue);
2105: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2106: end loop;
2107: close c_retro;
2108: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));

3498: := p_balance_type_id ;
3499: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
3505: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3506: := p_balance_name ;

Line 3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));

3500: := p_processing_priority;
3501: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
3502: := fnd_number.number_to_canonical(nvl(p_curr_withheld,0));
3503: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
3504: := fnd_number.number_to_canonical(nvl(p_ytd_withheld,0));
3505: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
3506: := p_balance_name ;
3507: OPEN get_display_name( p_balance_name ,p_jurisdiction ) ;
3508: FETCH get_display_name INTO lv_display_name ;

Line 3618: ln_bal_value := fnd_number.number_to_canonical(

3614:
3615: BEGIN
3616:
3617: if p_defined_balance_id is not null then
3618: ln_bal_value := fnd_number.number_to_canonical(
3619: nvl(pay_balance_pkg.get_value(
3620: p_defined_balance_id,
3621: p_balcall_aaid),0));
3622: end if;

Line 6083: := fnd_number.number_to_canonical(

6079: := lv_fit_filing_status;
6080: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6081: := ln_fit_withholding_allowances;
6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6083: := fnd_number.number_to_canonical(
6084: ln_fit_additional_wa_amount);
6085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6086: := fnd_number.number_to_canonical(
6087: ln_fit_override_amount);

Line 6086: := fnd_number.number_to_canonical(

6082: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6083: := fnd_number.number_to_canonical(
6084: ln_fit_additional_wa_amount);
6085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6086: := fnd_number.number_to_canonical(
6087: ln_fit_override_amount);
6088: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6089: := ln_fit_override_rate;
6090:

Line 6170: := fnd_number.number_to_canonical(

6166: := lv_sit_filing_status;
6167: pay_ac_action_arch.lrr_act_tab(ln_index).act_info6
6168: := ln_sit_withholding_allowances;
6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6173: := fnd_number.number_to_canonical(ln_sit_override_amount);
6174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9

Line 6173: := fnd_number.number_to_canonical(ln_sit_override_amount);

6169: pay_ac_action_arch.lrr_act_tab(ln_index).act_info7
6170: := fnd_number.number_to_canonical(
6171: ln_sit_additional_wa_amount);
6172: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
6173: := fnd_number.number_to_canonical(ln_sit_override_amount);
6174: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
6175: := ln_sit_override_rate;
6176: end if;
6177: end loop;

Line 6295: and fnd_number.canonical_to_number(pet.element_information5) = pet_calc.element_type_id

6291: and pet.classification_id = pec.classification_id
6292: and pec.classification_name = 'Involuntary Deductions'
6293: and pec.legislation_code = 'US'
6294: and pec.business_group_id IS NULL
6295: and fnd_number.canonical_to_number(pet.element_information5) = pet_calc.element_type_id
6296: and pet_calc.element_name like pet.element_name || '%Calculator'
6297: and pet_calc.element_type_id = piv_pay.element_type_id
6298: and NVL(ppa.date_earned, ppa.effective_date) between piv_pay.effective_start_date and piv_pay.effective_end_date
6299: and piv_pay.input_value_id = prrv_pay.input_value_id

Line 6301: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value

6297: and pet_calc.element_type_id = piv_pay.element_type_id
6298: and NVL(ppa.date_earned, ppa.effective_date) between piv_pay.effective_start_date and piv_pay.effective_end_date
6299: and piv_pay.input_value_id = prrv_pay.input_value_id
6300: and upper(piv_pay.name) = 'PAY VALUE'
6301: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value
6302: and prr_pay.run_result_id = prrv_pay.run_result_id
6303: and prr_pay.assignment_action_id = paa.assignment_action_id
6304: and prr_pay.element_type_id = pet_calc.element_type_id
6305: and NVL(ppa.date_earned, ppa.effective_date) between pet.effective_start_date

Line 6375: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value

6371: and ppa.date_earned between peev_pay.effective_start_date
6372: and peev_pay.effective_end_date
6373: and piv_pay.input_value_id = prrv_pay.input_value_id
6374: and upper(piv_pay.name) = 'PAY VALUE'
6375: and fnd_number.number_to_canonical(ppp.value) = prrv_pay.result_value
6376: and peef.element_entry_id = peev.element_entry_id
6377: and peef.element_entry_id = peev_pay.element_entry_id
6378: and paa.assignment_Action_id = prr_att.assignment_Action_id
6379: and prr_att.run_result_id = prrv_att.run_result_id

Line 7084: := fnd_number.number_to_canonical(ln_value);

7080: hr_utility.trace('ln_org_payment_method_id'||ln_org_payment_method_id);
7081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info2
7082: := ln_pre_payment_id;
7083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info3
7084: := fnd_number.number_to_canonical(ln_value);
7085: pay_ac_action_arch.lrr_act_tab(ln_index).act_info4
7086: := ltt_actions(j);
7087: pay_ac_action_arch.lrr_act_tab(ln_index).act_info5
7088: := ln_org_payment_method_id;