DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on FND_NUMBER

Line 484: open cur_dat(fnd_number.canonical_to_number(p_assignment_id), fnd_date.canonical_to_date(p_new_date));

480: --
481: -- Check that the assignment is on a payroll as of
482: -- the proposed effective date
483: --
484: open cur_dat(fnd_number.canonical_to_number(p_assignment_id), fnd_date.canonical_to_date(p_new_date));
485: fetch cur_dat into v_exists;
486: if cur_dat%notfound then
487: close cur_dat;
488: -- Error: You cannot change to this effective date, because the current

Line 4514: select fnd_number.canonical_to_number(parameter_value)

4510: from pay_payroll_actions
4511: where payroll_action_id = p_payroll_action_id;
4512: --
4513: cursor cur_max is
4514: select fnd_number.canonical_to_number(parameter_value)
4515: from pay_action_parameters
4516: where parameter_name = 'QUICKPAY_MAX_WAIT_SEC';
4517: --
4518: cursor cur_intw is

Line 4519: select fnd_number.canonical_to_number(parameter_value)

4515: from pay_action_parameters
4516: where parameter_name = 'QUICKPAY_MAX_WAIT_SEC';
4517: --
4518: cursor cur_intw is
4519: select fnd_number.canonical_to_number(parameter_value)
4520: from pay_action_parameters
4521: where parameter_name = 'QUICKPAY_INTERVAL_WAIT_SEC';
4522: --
4523: begin