DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on FND_NUMBER

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

2000: begin
2001: --
2002: hr_utility.trace('Enter pay_personal_methods');
2003: g_pre_payments.delete;
2004: total_pay := fnd_number.canonical_to_number(p_balance_value);
2005: pay_left := total_pay;
2006: --
2007: -- Process any payment methods associated with the
2008: -- Run Types

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

2231: --
2232: --
2233: -- First pay the pay separate runs to the override method
2234: --
2235: pay_left := fnd_number.canonical_to_number(p_balance_value);
2236: pay_run_type_override(p_assignment_action,
2237: p_def_balance,
2238: pay_left,
2239: p_master_aa_id);

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

2276: -- to zero for a non pament.
2277: --
2278: begin
2279: select prr.source_id,
2280: fnd_number.canonical_to_number(rrv.result_value),
2281: prr.status,
2282: paa.assignment_id,
2283: prr.assignment_action_id,
2284: paa.payroll_action_id,

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

2329: then
2330: --
2331: /* Does the RR source Id point to the target or the adjustment */
2332: if (g_adjust_ee_source = 'T') then
2333: select fnd_number.canonical_to_number(rrv.result_value)
2334: into adj_value
2335: from
2336: pay_input_values_f piv,
2337: pay_element_types_f pet,

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

2355: piv.effective_start_date and piv.effective_end_date
2356: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2357: pet.effective_start_date and pet.effective_end_date;
2358: else
2359: select fnd_number.canonical_to_number(rrv.result_value)
2360: into adj_value
2361: from
2362: pay_element_entries_f pee,
2363: pay_input_values_f piv,

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

2388: end if;
2389: --
2390: if (status = 'R')
2391: then
2392: p_run_result_value := fnd_number.number_to_canonical(adj_value);
2393: elsif (status = 'PA')
2394: then
2395: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2396: else

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

2391: then
2392: p_run_result_value := fnd_number.number_to_canonical(adj_value);
2393: elsif (status = 'PA')
2394: then
2395: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2396: else
2397: p_run_result_value := fnd_number.number_to_canonical(res_value);
2398: end if;
2399: p_entry := entry;

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

2393: elsif (status = 'PA')
2394: then
2395: p_run_result_value := fnd_number.number_to_canonical(adj_value)+fnd_number.number_to_canonical(res_value);
2396: else
2397: p_run_result_value := fnd_number.number_to_canonical(res_value);
2398: end if;
2399: p_entry := entry;
2400: end get_run_result_value;
2401: --

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

2466: and ppa.date_earned between
2467: pee.effective_start_date and pee.effective_end_date
2468: order by ppm.priority;
2469: --
2470: if fnd_number.canonical_to_number(p_bal_value) <> 0 then
2471: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
2472: payment_details.valid_days);
2473: --
2474: -- Check magnetic tape payments for prenote.

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

2491: --
2492: if valid_method = true then
2493: --
2494: --
2495: if fnd_number.canonical_to_number(p_bal_value) > 0
2496: or (negative_pay = 'Y' and
2497: payment_details.category IN ('MT', 'CA')) then
2498: --
2499: declare

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

2522: --
2523: child_action_id := p_assignment_action;
2524: master_action_id := p_master_aa_id;
2525: --
2526: create_payment(fnd_number.canonical_to_number(p_bal_value),
2527: balance_currency,
2528: payment_details.payment_currency,
2529: -- exchange_rate,
2530: payment_details.personal_method,

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

2771: hr_utility.trace('Amount to Pay '||l_bal_value);
2772: hr_utility.trace('Time Def '||payments.time_def_id);
2773: hr_utility.trace('Payment Date '||payments.payment_date);
2774: --
2775: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2776: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2777: payments.valid_days);
2778: --
2779: -- Check magnetic tape payments for prenote.

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

2799: --
2800: if valid_method = true then
2801: --
2802: --
2803: if fnd_number.canonical_to_number(l_bal_value) > 0
2804: or (negative_pay = 'Y' and
2805: payments.category IN ('MT', 'CA')) then
2806: --
2807: child_action_id := p_asg_act;

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

2805: payments.category IN ('MT', 'CA')) then
2806: --
2807: child_action_id := p_asg_act;
2808: master_action_id := p_master_aa_id;
2809: create_payment(fnd_number.canonical_to_number(l_bal_value),
2810: balance_currency,
2811: payments.payment_currency,
2812: -- exchange_rate,
2813: payments.personal_method,