DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on FND_NUMBER

Line 2009: total_pay := fnd_number.canonical_to_number(p_balance_value);

2005: begin
2006: --
2007: hr_utility.trace('Enter pay_personal_methods');
2008: g_pre_payments.delete;
2009: total_pay := fnd_number.canonical_to_number(p_balance_value);
2010: pay_left := total_pay;
2011: --
2012: -- Process any payment methods associated with the
2013: -- Run Types

Line 2240: pay_left := fnd_number.canonical_to_number(p_balance_value);

2236: --
2237: --
2238: -- First pay the pay separate runs to the override method
2239: --
2240: pay_left := fnd_number.canonical_to_number(p_balance_value);
2241: pay_run_type_override(p_assignment_action,
2242: p_def_balance,
2243: pay_left,
2244: p_master_aa_id);

Line 2285: fnd_number.canonical_to_number(rrv.result_value),

2281: -- to zero for a non pament.
2282: --
2283: begin
2284: select prr.source_id,
2285: fnd_number.canonical_to_number(rrv.result_value),
2286: prr.status,
2287: paa.assignment_id,
2288: prr.assignment_action_id,
2289: paa.payroll_action_id,

Line 2342: select fnd_number.canonical_to_number(rrv.result_value)

2338: then
2339: --
2340: /* Does the RR source Id point to the target or the adjustment */
2341: if (g_adjust_ee_source = 'T') then
2342: select fnd_number.canonical_to_number(rrv.result_value)
2343: into adj_value
2344: from
2345: pay_input_values_f piv,
2346: pay_element_types_f pet,

Line 2368: select fnd_number.canonical_to_number(rrv.result_value)

2364: piv.effective_start_date and piv.effective_end_date
2365: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2366: pet.effective_start_date and pet.effective_end_date;
2367: else
2368: select fnd_number.canonical_to_number(rrv.result_value)
2369: into adj_value
2370: from
2371: pay_element_entries_f pee,
2372: pay_input_values_f piv,

Line 2401: p_run_result_value := fnd_number.number_to_canonical(adj_value);

2397: end if;
2398: --
2399: if (status = 'R')
2400: then
2401: p_run_result_value := fnd_number.number_to_canonical(adj_value);
2402: elsif (status = 'PA')
2403: then
2404: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2405: else

Line 2404: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);

2400: then
2401: p_run_result_value := fnd_number.number_to_canonical(adj_value);
2402: elsif (status = 'PA')
2403: then
2404: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2405: else
2406: p_run_result_value := fnd_number.number_to_canonical(res_value);
2407: end if;
2408: p_entry := entry;

Line 2406: p_run_result_value := fnd_number.number_to_canonical(res_value);

2402: elsif (status = 'PA')
2403: then
2404: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2405: else
2406: p_run_result_value := fnd_number.number_to_canonical(res_value);
2407: end if;
2408: p_entry := entry;
2409: end get_run_result_value;
2410: --

Line 2506: if fnd_number.canonical_to_number(p_bal_value) <> 0 then

2502: )
2503: order by ppm.priority;
2504: --
2505: hr_utility.trace('Entered pay third party location 1 ');
2506: if fnd_number.canonical_to_number(p_bal_value) <> 0 then
2507: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
2508: payment_details.valid_days);
2509: --
2510: -- Check magnetic tape payments for prenote.

Line 2531: if fnd_number.canonical_to_number(p_bal_value) > 0

2527: --
2528: if valid_method = true then
2529: --
2530: --
2531: if fnd_number.canonical_to_number(p_bal_value) > 0
2532: or (negative_pay = 'Y' and
2533: payment_details.category IN ('MT', 'CA')) then
2534: --
2535: declare

Line 2562: create_payment(fnd_number.canonical_to_number(p_bal_value),

2558: --
2559: child_action_id := p_assignment_action;
2560: master_action_id := p_master_aa_id;
2561: --
2562: create_payment(fnd_number.canonical_to_number(p_bal_value),
2563: balance_currency,
2564: payment_details.payment_currency,
2565: -- exchange_rate,
2566: payment_details.personal_method,

Line 2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then

2809: hr_utility.trace('Amount to Pay '||l_bal_value);
2810: hr_utility.trace('Time Def '||payments.time_def_id);
2811: hr_utility.trace('Payment Date '||payments.payment_date);
2812: --
2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2814: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2815: payments.valid_days);
2816: --
2817: -- Check magnetic tape payments for prenote.

Line 2841: if fnd_number.canonical_to_number(l_bal_value) > 0

2837: --
2838: if valid_method = true then
2839: --
2840: --
2841: if fnd_number.canonical_to_number(l_bal_value) > 0
2842: or (negative_pay = 'Y' and
2843: payments.category IN ('MT', 'CA')) then
2844: --
2845: child_action_id := p_asg_act;

Line 2847: create_payment(fnd_number.canonical_to_number(l_bal_value),

2843: payments.category IN ('MT', 'CA')) then
2844: --
2845: child_action_id := p_asg_act;
2846: master_action_id := p_master_aa_id;
2847: create_payment(fnd_number.canonical_to_number(l_bal_value),
2848: balance_currency,
2849: payments.payment_currency,
2850: -- exchange_rate,
2851: payments.personal_method,