DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on FND_NUMBER

Line 1701: p_figure => fnd_number.canonical_to_number(l_entry_value),

1697: l_converted_amt := Convert_Period_Type(
1698: p_bus_grp_id => p_business_group_id,
1699: p_payroll_id => p_payroll_id,
1700: p_asst_std_hours => p_normal_hours,
1701: p_figure => fnd_number.canonical_to_number(l_entry_value),
1702: p_from_freq => l_element_frequency,
1703: p_to_freq => p_commitment_calc_frequency,
1704: p_period_start_date => p_commit_calculation_dt,
1705: p_period_end_date => p_commit_calculation_end_dt,

Line 1799: Select fnd_number.canonical_to_number(pev.screen_entry_value),

1795: Cursor csr_salary_basis(p_input_value_id in number,
1796: p_assignment_id in number,
1797: p_commit_calculation_dt in date,
1798: p_commit_calculation_end_dt in date) is
1799: Select fnd_number.canonical_to_number(pev.screen_entry_value),
1800: pev.effective_start_date, pev.effective_end_date
1801: from pay_element_entry_values_f pev
1802: , pay_element_entries_f pee
1803: where pee.assignment_id = p_assignment_id

Line 3124: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.

3120: v_curr_date DATE;
3121: v_curr_day VARCHAR2(3); -- 3 char abbrev for day of wk.
3122: v_ws_name VARCHAR2(80); -- Work Schedule Name.
3123: v_gtv_hours VARCHAR2(80); -- get_table_value returns varchar2
3124: -- Remember to FND_NUMBER.CANONICAL_TO_NUMBER result.
3125: v_fnd_sess_row VARCHAR2(1);
3126: l_exists VARCHAR2(1);
3127:
3128: BEGIN -- work_schedule_total_hours

Line 3202: + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value

3198: hr_utility.set_location('curr_day = '||v_curr_day, 20);
3199: --
3200: hr_utility.set_location('work_schedule_total_hours.gettabval', 25);
3201: v_total_hours := v_total_hours
3202: + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value
3203: (p_bg_id,
3204: c_ws_tab_name,
3205: v_ws_name,
3206: v_curr_day));