[Home] [Help]
223: -- previous year.
224: -- PQP Addition, Do similar calculation for 2 year expiries, but
225: -- minus off another 1 year in relation to the YTD.
226: --
227: hr_utility.trace('Assignment ID: '||to_char(p_assignment_id));
228: hr_utility.trace('Dimension name: '||p_dimension_name);
229: --
230: l_date := to_date('06/04/' || to_char(p_upload_date,'YYYY'),'DD/MM/YYYY');
231: --
224: -- PQP Addition, Do similar calculation for 2 year expiries, but
225: -- minus off another 1 year in relation to the YTD.
226: --
227: hr_utility.trace('Assignment ID: '||to_char(p_assignment_id));
228: hr_utility.trace('Dimension name: '||p_dimension_name);
229: --
230: l_date := to_date('06/04/' || to_char(p_upload_date,'YYYY'),'DD/MM/YYYY');
231: --
232: if p_upload_date >= l_date then
307: ,l_stat_yr_start_date);
308: fetch csr_proc_year_start into l_stat_yr_proc_date;
309: close csr_proc_year_start;
310: --
311: hr_utility.trace('proc yr start: '||to_char(l_stat_yr_proc_date));
312: --
313: -- The expiry date must lie within the processing tax year for the
314: -- current payroll and at a time when the assignment belongs to the
315: -- current payroll.
332: ,p_upload_date);
333: fetch csr_period_start into l_period_start_date;
334: close csr_period_start;
335: --
336: hr_utility.trace('Period start: '||to_char(l_period_start_date));
337: -- Set the expiry date. This is the later of the period start date,
338: -- the assignment start date or the Start of tax year, incase the period
339: -- begins before the tax year end (e.g. 01-30 Apr).
340: --
387: ,l_stat_yr_start_date);
388: fetch csr_proc_year_start into l_stat_yr_proc_date;
389: close csr_proc_year_start;
390: --
391: hr_utility.trace('proc yr start: '||to_char(l_stat_yr_proc_date));
392: -- What is the edate of appointment as a director
393: --
394: open csr_appointment_as_director(p_assignment_id
395: ,p_upload_date
409: -- Return the date on which the dimension expires. If this has not been
410: -- set due to a cursor above not finding the correct info, set this to
411: -- End Of Time. The core process will then fail this upload.
412: --
413: hr_utility.trace('Returned date: '||to_char(l_expiry_date));
414: --
415: IF l_expiry_date is null then
416: --
417: l_expiry_date := END_OF_TIME;
441: p_dimension_name varchar2
442: ) return boolean is
443: begin
444: --
445: hr_utility.trace('Entering pay_uk_bal_upload.is_supported');
446: --
447: -- See if the dimension is supported.
448: --
449: if p_dimension_name in
476: else
477: return (FALSE);
478: end if;
479: --
480: hr_utility.trace('Exiting pay_uk_bal_upload.is_supported');
481: --
482: end is_supported;
483: --
484: -----------------------------------------------------------------------------
509: --
510: ret_val boolean;
511: begin
512: --
513: hr_utility.trace('Entering pay_uk_bal_upload.include_adjustment');
514: --
515: if (p_original_entry_id = p_bal_adjustment_rec.original_entry_id) or
516: (p_original_entry_id is null
517: and p_bal_adjustment_rec.original_entry_id is null) then
518: ret_val := TRUE;
519: else
520: ret_val := FALSE;
521: end if;
522: hr_utility.trace('Exiting pay_uk_bal_upload.include_adjustment');
523: --
524: return (ret_val);
525: --
526: end include_adjustment;
542: p_batch_id number
543: ) is
544: begin
545: --
546: hr_utility.trace('Entering pay_uk_bal_upload.validate_batch_lines');
547: --
548: hr_utility.trace('Exiting pay_uk_bal_upload.validate_batch_lines');
549: --
550: end validate_batch_lines;
544: begin
545: --
546: hr_utility.trace('Entering pay_uk_bal_upload.validate_batch_lines');
547: --
548: hr_utility.trace('Exiting pay_uk_bal_upload.validate_batch_lines');
549: --
550: end validate_batch_lines;
551: --
552: end pay_uk_bal_upload;