eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_EOY_ARCHIVE dependencies on FND_DATE

Line 391: -- Cover on the fnd_date function, but with exception handling

387: END get_nearest_scon;
388: --
389: FUNCTION canonical_to_date(p_chardate IN VARCHAR2)
390: RETURN DATE
391: -- Cover on the fnd_date function, but with exception handling
392: IS
393: l_return_date DATE;
394: BEGIN
395: l_return_date := fnd_date.canonical_to_date(p_chardate);

Line 395: l_return_date := fnd_date.canonical_to_date(p_chardate);

391: -- Cover on the fnd_date function, but with exception handling
392: IS
393: l_return_date DATE;
394: BEGIN
395: l_return_date := fnd_date.canonical_to_date(p_chardate);
396: RETURN l_return_date;
397: EXCEPTION
398: WHEN OTHERS THEN
399: RETURN NULL;

Line 548: RETURN fnd_date.canonical_to_date(get_arch_str(p_action_id,

544: -- This could not be achieved by overloading get_arch_str as the views
545: -- wouldn't know which return data type was required.
546: IS
547: BEGIN
548: RETURN fnd_date.canonical_to_date(get_arch_str(p_action_id,
549: p_user_entity_name,
550: p_context_value1,
551: p_context_value2,
552: p_context_value3));

Line 652: nvl(fnd_date.canonical_to_date

648: p_user_entity_id => p_permit_ueid,
649: p_context_value1 => payroll_rec.payroll_id);
650: g_min_start_year :=
651: least(g_min_start_year,
652: nvl(fnd_date.canonical_to_date
653: (g_payroll_start_yr_tab(payroll_rec.payroll_id)),
654: g_min_start_year));
655: g_max_end_year :=
656: greatest(g_max_end_year,

Line 657: nvl(fnd_date.canonical_to_date

653: (g_payroll_start_yr_tab(payroll_rec.payroll_id)),
654: g_min_start_year));
655: g_max_end_year :=
656: greatest(g_max_end_year,
657: nvl(fnd_date.canonical_to_date
658: (g_payroll_end_yr_tab(payroll_rec.payroll_id)),
659: g_max_end_year));
660: END LOOP;
661: --

Line 887: RETURN fnd_date.canonical_to_date('0001/01/01 00:00:00');

883: CLOSE get_first_active_start;
884: --
885: IF l_min_active IS NULL THEN
886: --modified format for bug fix 4991467
887: RETURN fnd_date.canonical_to_date('0001/01/01 00:00:00');
888: END IF;
889: -- check if any of the other assignments of this employee
890: -- that were active before this assignment
891: LOOP

Line 1087: RETURN fnd_date.canonical_to_date('4712/12/31 00:00:00');

1083: CLOSE get_last_active_end;
1084: --
1085: IF l_max_active IS NULL THEN
1086: --modified format for bug fix 4991467
1087: RETURN fnd_date.canonical_to_date('4712/12/31 00:00:00');
1088: END IF;
1089: --
1090: -- check if any of the other assignments of
1091: -- this employee that were active after this assignment

Line 1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));

1116: --
1117: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1119: 'End Of Year Process - Errors and Warnings Report'||
1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1123: 'Request Id: '||fnd_global.conc_request_id);
1124: fnd_file.put_line(fnd_file.output, ' ');

Line 1592: fnd_date.date_to_canonical(l_payroll_end_year));

1588: l_payroll_period_type_eid,
1589: l_payroll_period_type);
1590: archive_payroll_info(pactid, rec_payroll.payroll_id,
1591: l_payroll_end_year_eid,
1592: fnd_date.date_to_canonical(l_payroll_end_year));
1593: archive_payroll_info(pactid, rec_payroll.payroll_id,
1594: l_payroll_start_year_eid,
1595: fnd_date.date_to_canonical(l_payroll_start_year));
1596: END LOOP;

Line 1595: fnd_date.date_to_canonical(l_payroll_start_year));

1591: l_payroll_end_year_eid,
1592: fnd_date.date_to_canonical(l_payroll_end_year));
1593: archive_payroll_info(pactid, rec_payroll.payroll_id,
1594: l_payroll_start_year_eid,
1595: fnd_date.date_to_canonical(l_payroll_start_year));
1596: END LOOP;
1597: EXCEPTION
1598: -- Propagate error through by means of the X_PAYROLL_ACTION_MESSAGE UE.
1599: -- Start of BUG 5909829 EOY

Line 1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1754: from per_all_assignments_f paf2
1755: where paf2.assignment_id = paf.assignment_id
1756: AND paf2.effective_end_date > paf.effective_end_date
1757: AND paf2.effective_end_date >=
1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1759: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1760: AND paf2.effective_start_date <=
1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1762: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));

Line 1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1757: AND paf2.effective_end_date >=
1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1759: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1760: AND paf2.effective_start_date <=
1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1762: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));
1763: --
1764: cursor csr_assignments ( p_min_start_year_date DATE,
1765: p_max_end_year_date DATE,

Line 2042: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2038: hr_utility.trace(l_proc||' Fetched assignment_id='||
2039: rec_assignment.assignment_id||', g_asg_set_id='||g_asg_set_id);
2040: l_process_asg := FALSE;
2041: l_payroll_start_date :=
2042: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2043: (pactid,'X_START_YEAR',
2044: to_char(rec_assignment.payroll_id)));
2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2046: l_payroll_end_date :=

Line 2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));

2041: l_payroll_start_date :=
2042: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2043: (pactid,'X_START_YEAR',
2044: to_char(rec_assignment.payroll_id)));
2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2046: l_payroll_end_date :=
2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2048: (pactid,'X_END_YEAR',
2049: to_char(rec_assignment.payroll_id)));

Line 2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2043: (pactid,'X_START_YEAR',
2044: to_char(rec_assignment.payroll_id)));
2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2046: l_payroll_end_date :=
2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2048: (pactid,'X_END_YEAR',
2049: to_char(rec_assignment.payroll_id)));
2050: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2051: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);

Line 2050: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));

2046: l_payroll_end_date :=
2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2048: (pactid,'X_END_YEAR',
2049: to_char(rec_assignment.payroll_id)));
2050: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2051: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);
2052: IF nvl(rec_assignment.tax_ref_xfer,' ') = 'N' AND csr_assignments%FOUND
2053: THEN
2054: hr_utility.trace(l_proc||' opening cursor csr_sub_asg.');

Line 2068: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));

2064: end loop;
2065: ELSIF nvl(rec_assignment.tax_ref_xfer,' ') = 'Y' AND csr_assignments%FOUND
2066: THEN
2067: hr_utility.trace(l_proc||' tax ref xfer=Y and found record by csr_assignments cursor.');
2068: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2069: hr_utility.trace(l_proc||' rec_assignment.effective_start_date='||fnd_date.date_to_displaydate(rec_assignment.effective_start_date));
2070: IF rec_assignment.effective_end_date >= l_payroll_start_date
2071: AND rec_assignment.effective_start_date <= l_payroll_end_date
2072: THEN

Line 2069: hr_utility.trace(l_proc||' rec_assignment.effective_start_date='||fnd_date.date_to_displaydate(rec_assignment.effective_start_date));

2065: ELSIF nvl(rec_assignment.tax_ref_xfer,' ') = 'Y' AND csr_assignments%FOUND
2066: THEN
2067: hr_utility.trace(l_proc||' tax ref xfer=Y and found record by csr_assignments cursor.');
2068: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2069: hr_utility.trace(l_proc||' rec_assignment.effective_start_date='||fnd_date.date_to_displaydate(rec_assignment.effective_start_date));
2070: IF rec_assignment.effective_end_date >= l_payroll_start_date
2071: AND rec_assignment.effective_start_date <= l_payroll_end_date
2072: THEN
2073: l_process_asg := TRUE;

Line 2083: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));

2079: hr_utility.trace(l_proc||' rec_assignment.person_id='||rec_assignment.person_id);
2080: hr_utility.trace(l_proc||' rec_prev_asg.person_id='||rec_prev_asg.person_id);
2081: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2082: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2083: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2084: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2085: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2086: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2087: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);

Line 2084: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));

2080: hr_utility.trace(l_proc||' rec_prev_asg.person_id='||rec_prev_asg.person_id);
2081: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2082: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2083: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2084: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2085: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2086: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2087: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2088: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);

Line 2085: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));

2081: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2082: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2083: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2084: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2085: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2086: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2087: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2088: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);
2089: IF (csr_assignments%NOTFOUND

Line 2086: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));

2082: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2083: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2084: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2085: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2086: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2087: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2088: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);
2089: IF (csr_assignments%NOTFOUND
2090: OR rec_assignment.person_id <> rec_prev_asg.person_id

Line 2121: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));

2117: EXIT WHEN csr_assignments%NOTFOUND;
2118: hr_utility.set_location(l_proc,15);
2119: hr_utility.trace(l_proc||' rec_assignment.assignment_id='||rec_assignment.assignment_id);
2120: hr_utility.trace(l_proc||' rec_prev_asg.assignment_id='||rec_prev_asg.assignment_id);
2121: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2122: hr_utility.trace(l_proc||' rec_prev_asg.effective_end_date='||fnd_date.date_to_displaydate(rec_prev_asg.effective_end_date));
2123: IF (rec_assignment.assignment_id <> rec_prev_asg.assignment_id
2124: OR rec_assignment.effective_end_date <> rec_prev_asg.effective_end_date)
2125: AND l_process_asg

Line 2122: hr_utility.trace(l_proc||' rec_prev_asg.effective_end_date='||fnd_date.date_to_displaydate(rec_prev_asg.effective_end_date));

2118: hr_utility.set_location(l_proc,15);
2119: hr_utility.trace(l_proc||' rec_assignment.assignment_id='||rec_assignment.assignment_id);
2120: hr_utility.trace(l_proc||' rec_prev_asg.assignment_id='||rec_prev_asg.assignment_id);
2121: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2122: hr_utility.trace(l_proc||' rec_prev_asg.effective_end_date='||fnd_date.date_to_displaydate(rec_prev_asg.effective_end_date));
2123: IF (rec_assignment.assignment_id <> rec_prev_asg.assignment_id
2124: OR rec_assignment.effective_end_date <> rec_prev_asg.effective_end_date)
2125: AND l_process_asg
2126: -- if the current row is the first row

Line 2143: p_archive_value => fnd_date.date_to_canonical

2139: -- archive the effective end date
2140: ff_archive_api.create_archive_item
2141: (p_archive_item_id => l_archive_item_id,
2142: p_user_entity_id => g_effective_end_date_eid,
2143: p_archive_value => fnd_date.date_to_canonical
2144: (rec_assignment.effective_end_date),
2145: p_archive_type => 'AAC',
2146: p_action_id => l_actid,
2147: p_legislation_code => 'GB',

Line 2168: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_start),

2164: IF rec_assignment.multiple_asg_flag = 'Y' THEN
2165: ff_archive_api.create_archive_item
2166: (p_archive_item_id => l_archive_item_id,
2167: p_user_entity_id => g_agg_active_start_eid,
2168: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_start),
2169: p_archive_type => 'AAC',
2170: p_action_id => l_actid,
2171: p_legislation_code => 'GB',
2172: p_object_version_number => l_ovn,

Line 2178: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_end),

2174: --
2175: ff_archive_api.create_archive_item
2176: (p_archive_item_id => l_archive_item_id,
2177: p_user_entity_id => g_agg_active_end_eid,
2178: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_end),
2179: p_archive_type => 'AAC',
2180: p_action_id => l_actid,
2181: p_legislation_code => 'GB',
2182: p_object_version_number => l_ovn,

Line 2257: fnd_date.canonical_to_date(fai.VALUE) start_year,

2253: --
2254: cursor csr_payroll_info(p_pactid NUMBER) IS
2255: SELECT
2256: to_number(aic.context) payroll_id,
2257: fnd_date.canonical_to_date(fai.VALUE) start_year,
2258: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2259: g_payroll_end_year_eid,
2260: aic.context)) end_year,
2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,

Line 2258: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,

2254: cursor csr_payroll_info(p_pactid NUMBER) IS
2255: SELECT
2256: to_number(aic.context) payroll_id,
2257: fnd_date.canonical_to_date(fai.VALUE) start_year,
2258: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2259: g_payroll_end_year_eid,
2260: aic.context)) end_year,
2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2262: aic.context) period_type,

Line 3148: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3144: ASG_ACTION_ERROR EXCEPTION;
3145: --
3146: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3147: SELECT act.assignment_id,
3148: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3149: (act.assignment_action_id,
3150: g_effective_end_date_eid)) end_date,
3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,

Line 3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3149: (act.assignment_action_id,
3150: g_effective_end_date_eid)) end_date,
3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,

Line 3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,
3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3159: FROM pay_assignment_actions act
3160: WHERE act.assignment_action_id = p_asgactid;

Line 3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3245: AND nroll.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3246: AND ass.assignment_id = pass.assignment_id
3247: AND pass.effective_end_date = (ass.effective_start_date - 1)
3248: AND pass.effective_end_date >=
3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3250: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3251: AND pass.effective_start_date <=
3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3253: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))

Line 3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3248: AND pass.effective_end_date >=
3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3250: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3251: AND pass.effective_start_date <=
3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3253: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))
3254: AND proll.payroll_id = pass.payroll_id
3255: AND pass.payroll_id <> ass.payroll_id
3256: AND ass.effective_start_date BETWEEN

Line 3583: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||

3579: USE_NL(assact2, pact, r2) */
3580: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3581: ||r2.source_type||
3582: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3583: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3584: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3585: FROM pay_assignment_actions assact2,
3586: pay_payroll_actions pact,
3587: pay_run_results r2

Line 3584: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date

3580: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3581: ||r2.source_type||
3582: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3583: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3584: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3585: FROM pay_assignment_actions assact2,
3586: pay_payroll_actions pact,
3587: pay_run_results r2
3588: WHERE assact2.assignment_id = p_assignment_id

Line 3597: /* Bug 4278570 fnd_date.canonical_to_date

3593: AND pact.action_type IN ( 'Q','R','B','I')
3594: AND assact2.action_status = 'C'
3595: AND pact.effective_date BETWEEN
3596: g_start_year AND g_end_year
3597: /* Bug 4278570 fnd_date.canonical_to_date
3598: (pay_gb_eoy_archive.get_arch_str(
3599: g_payroll_action_id,
3600: g_payroll_start_year_eid,
3601: to_char(pact.payroll_id)))

Line 3602: AND fnd_date.canonical_to_date

3598: (pay_gb_eoy_archive.get_arch_str(
3599: g_payroll_action_id,
3600: g_payroll_start_year_eid,
3601: to_char(pact.payroll_id)))
3602: AND fnd_date.canonical_to_date
3603: (pay_gb_eoy_archive.get_arch_str(
3604: g_payroll_action_id,
3605: g_payroll_end_year_eid,
3606: to_char(pact.payroll_id)))

Line 3629: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||

3625: USE_NL(assact2, pact, r2) */
3626: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3627: ||r2.source_type||
3628: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3629: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3630: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3631: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3632: -- r2.run_result_id),16))
3633: FROM pay_assignment_actions assact2,

Line 3630: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date

3626: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3627: ||r2.source_type||
3628: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3629: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3630: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3631: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3632: -- r2.run_result_id),16))
3633: FROM pay_assignment_actions assact2,
3634: pay_payroll_actions pact,

Line 3645: /* Bug 4278570 fnd_date.canonical_to_date

3641: AND pact.action_type IN ( 'Q','R','B','I')
3642: AND assact2.action_status = 'C'
3643: AND pact.effective_date BETWEEN
3644: g_start_year AND g_end_year
3645: /* Bug 4278570 fnd_date.canonical_to_date
3646: (pay_gb_eoy_archive.get_arch_str(
3647: g_payroll_action_id,
3648: g_payroll_start_year_eid,
3649: to_char(pact.payroll_id)))

Line 3650: AND fnd_date.canonical_to_date

3646: (pay_gb_eoy_archive.get_arch_str(
3647: g_payroll_action_id,
3648: g_payroll_start_year_eid,
3649: to_char(pact.payroll_id)))
3650: AND fnd_date.canonical_to_date
3651: (pay_gb_eoy_archive.get_arch_str(
3652: g_payroll_action_id,
3653: g_payroll_end_year_eid,
3654: to_char(pact.payroll_id)))

Line 4186: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));

4182: l_agg_active_start,
4183: l_agg_active_end;
4184: CLOSE csr_asg_act_info;
4185: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4186: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4187: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4188: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4189: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4190: -- Bug fix for 3699865 - get the final process date

Line 4188: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));

4184: CLOSE csr_asg_act_info;
4185: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4186: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4187: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4188: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4189: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4190: -- Bug fix for 3699865 - get the final process date
4191: OPEN csr_asg_last_process_date(l_assignment_id);
4192: FETCH csr_asg_last_process_date INTO l_final_process_date;

Line 4189: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));

4185: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4186: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4187: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4188: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4189: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4190: -- Bug fix for 3699865 - get the final process date
4191: OPEN csr_asg_last_process_date(l_assignment_id);
4192: FETCH csr_asg_last_process_date INTO l_final_process_date;
4193: CLOSE csr_asg_last_process_date;

Line 4194: hr_utility.trace('After csr_asg_last_process_date, l_final_process_date='||fnd_date.date_to_displaydate(l_final_process_date));

4190: -- Bug fix for 3699865 - get the final process date
4191: OPEN csr_asg_last_process_date(l_assignment_id);
4192: FETCH csr_asg_last_process_date INTO l_final_process_date;
4193: CLOSE csr_asg_last_process_date;
4194: hr_utility.trace('After csr_asg_last_process_date, l_final_process_date='||fnd_date.date_to_displaydate(l_final_process_date));
4195: IF l_final_process_date is not null
4196: and nvl(l_tax_ref_transfer, 'N') = 'N'
4197: and l_final_process_date < l_effective_end_date THEN
4198: -- added extra conditions above for 5199746, so that final process date

Line 4246: hr_utility.trace('After csr_basic_inf_current, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));

4242: l_period_of_service_id;
4243: IF csr_basic_inf_current%FOUND then
4244: -- Set the eff end to the one of the current row
4245: l_effective_end_date := l_adj_eff_end_date;
4246: hr_utility.trace('After csr_basic_inf_current, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));
4247: hr_utility.trace('l_payroll_id='||l_payroll_id);
4248: hr_utility.trace('l_assignment_number='||l_assignment_number);
4249: hr_utility.trace('l_person_id='||l_person_id);
4250: hr_utility.trace('l_organization_id='||l_organization_id);

Line 4280: /* hr_utility.trace('After csr_basic_inf_term, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));

4276: IF csr_basic_inf_term%FOUND then
4277: -- Set the eff end to the adjusted one from the
4278: -- terminated assignment.
4279: l_effective_end_date := l_adj_eff_end_date;
4280: /* hr_utility.trace('After csr_basic_inf_term, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));
4281: hr_utility.trace('l_payroll_id='||l_payroll_id);
4282: hr_utility.trace('l_assignment_number='||l_assignment_number);
4283: hr_utility.trace('l_person_id='||l_person_id);
4284: hr_utility.trace('l_organization_id='||l_organization_id);

Line 4309: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);

4305: -- Assignment number is not null
4306: IF l_payroll_id IS NULL THEN
4307: -- Payroll is null
4308: l_assignment_message :=
4309: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);
4310: archive_asg_info(g_assignment_message_eid, l_assignment_message);
4311: END IF;
4312: END IF;
4313: ELSE

Line 4318: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);

4314: -- Assignment number is not null
4315: IF l_payroll_id IS NULL THEN
4316: -- Payroll is null
4317: l_assignment_message :=
4318: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);
4319: archive_asg_info(g_assignment_message_eid, l_assignment_message);
4320: END IF;
4321: --
4322: END IF;

Line 4359: hr_utility.trace('After csr_asg_start, l_effective_start_date='||fnd_date.date_to_displaydate(l_effective_start_date));

4355: OPEN csr_asg_start(l_assignment_id, l_effective_end_date,
4356: l_payroll_start_year, l_payroll_end_year);
4357: FETCH csr_asg_start INTO l_effective_start_date;
4358: CLOSE csr_asg_start;
4359: hr_utility.trace('After csr_asg_start, l_effective_start_date='||fnd_date.date_to_displaydate(l_effective_start_date));
4360: --
4361: hr_utility.trace('Action type: '||l_action_type);
4362: --
4363: -- Get basic person info

Line 4380: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));

4376: CLOSE csr_person_info;
4377: hr_utility.trace('After csr_person_info, l_last_name='||l_last_name);
4378: hr_utility.trace('l_first_name='||l_first_name);
4379: hr_utility.trace('l_middle_name='||l_middle_name);
4380: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
4381: hr_utility.trace('l_title='||l_title);
4382: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
4383: hr_utility.trace('l_ni_number='||l_ni_number);
4384: hr_utility.trace('l_sex='||l_sex);

Line 4396: hr_utility.trace('l_active_start='||fnd_date.date_to_displaydate(l_active_start));

4392: OPEN get_asg_active_range(l_assignment_id, l_payroll_tax_dist||'/'||l_payroll_tax_ref);
4393: FETCH get_asg_active_range INTO l_active_start, l_active_end;
4394: CLOSE get_asg_active_range;
4395: hr_utility.trace('After get_asg_active_range.');
4396: hr_utility.trace('l_active_start='||fnd_date.date_to_displaydate(l_active_start));
4397: hr_utility.trace('l_active_end='||fnd_date.date_to_displaydate(l_active_end));
4398: --
4399: -- set termination type and date.
4400: IF l_tax_ref_transfer = 'N' THEN

Line 4397: hr_utility.trace('l_active_end='||fnd_date.date_to_displaydate(l_active_end));

4393: FETCH get_asg_active_range INTO l_active_start, l_active_end;
4394: CLOSE get_asg_active_range;
4395: hr_utility.trace('After get_asg_active_range.');
4396: hr_utility.trace('l_active_start='||fnd_date.date_to_displaydate(l_active_start));
4397: hr_utility.trace('l_active_end='||fnd_date.date_to_displaydate(l_active_end));
4398: --
4399: -- set termination type and date.
4400: IF l_tax_ref_transfer = 'N' THEN
4401: --

Line 4410: hr_utility.trace('After csr_termination, l_actual_termination_date='||fnd_date.date_to_displaydate(l_actual_termination_date));

4406: FETCH csr_termination INTO l_actual_termination_date,
4407: l_last_std_process_date,
4408: l_termination_type;
4409: CLOSE csr_termination;
4410: hr_utility.trace('After csr_termination, l_actual_termination_date='||fnd_date.date_to_displaydate(l_actual_termination_date));
4411: hr_utility.trace('l_last_std_process_date='||fnd_date.date_to_displaydate(l_last_std_process_date));
4412: hr_utility.trace('l_termination_type='||l_termination_type);
4413: IF l_multiple_asg_flag = 'Y' THEN
4414: -- for multiple assignment check if aggregated active end date

Line 4411: hr_utility.trace('l_last_std_process_date='||fnd_date.date_to_displaydate(l_last_std_process_date));

4407: l_last_std_process_date,
4408: l_termination_type;
4409: CLOSE csr_termination;
4410: hr_utility.trace('After csr_termination, l_actual_termination_date='||fnd_date.date_to_displaydate(l_actual_termination_date));
4411: hr_utility.trace('l_last_std_process_date='||fnd_date.date_to_displaydate(l_last_std_process_date));
4412: hr_utility.trace('l_termination_type='||l_termination_type);
4413: IF l_multiple_asg_flag = 'Y' THEN
4414: -- for multiple assignment check if aggregated active end date
4415: -- is before the actual termination date and EOY, if yes then set

Line 4455: hr_utility.trace('After get_p45_eit_manual_issue_dt, manual issue date='||fnd_date.date_to_displaydate(l_date_of_manual_p45_issue));

4451: -- termination date else ensire l_termination_date is null
4452: -- so that P60 can be generated
4453: l_date_of_manual_p45_issue := NULL;
4454: l_date_of_manual_p45_issue := pay_p45_pkg.get_p45_eit_manual_issue_dt(l_assignment_id);
4455: hr_utility.trace('After get_p45_eit_manual_issue_dt, manual issue date='||fnd_date.date_to_displaydate(l_date_of_manual_p45_issue));
4456: --
4457: IF l_date_of_manual_p45_issue IS NOT NULL
4458: AND l_date_of_manual_p45_issue <= g_end_year THEN
4459: -- manual P45 issued in current tax year hence leave

Line 4475: hr_utility.trace('After get_p45_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));

4471: pay_p45_pkg.get_p45_asg_action_id(l_assignment_id,
4472: l_p45_action_id,
4473: l_p45_issue_date,
4474: l_p45_action_seq);
4475: hr_utility.trace('After get_p45_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));
4476: hr_utility.trace('l_p45_action_id='||l_p45_action_id);
4477:
4478: IF l_p45_issue_date IS NULL THEN
4479: pay_p45_pkg.get_p45_agg_asg_action_id(l_assignment_id,

Line 4484: hr_utility.trace('After get_p45_agg_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));

4480: l_p45_agg_asg_id,
4481: l_p45_final_pay_date,
4482: l_p45_issue_date,
4483: l_p45_action_id);
4484: hr_utility.trace('After get_p45_agg_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));
4485:
4486: END IF;
4487:
4488: -- Start of BUG 5671777-1

Line 4540: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

4536: FETCH csr_last_action INTO l_last_asg_action_id,
4537: l_last_effective_date;
4538: CLOSE csr_last_action;
4539: hr_utility.trace('After csr_last_action, l_last_asg_action_id='||l_last_asg_action_id);
4540: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4541: --
4542: IF l_last_asg_action_id IS NOT NULL THEN
4543: OPEN csr_action_details(l_last_asg_action_id);
4544: FETCH csr_action_details into l_action_type;

Line 4606: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

4602: IF l_tax_paye_run_result_id IS NULL THEN
4603: -- if paye was not calculated in last run then
4604: -- get the latest run in which it was
4605: hr_utility.trace('Before csr_tax_last_paye_run, l_assignment_id='||l_assignment_id);
4606: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4607: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4608: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4609: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4610: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

Line 4610: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

4606: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4607: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4608: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4609: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4610: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4611: CLOSE csr_tax_latest_paye_run;
4612: ELSE
4613: -- PAYE run result found hence effective date for paye details is
4614: -- date of last assignment action

Line 4616: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

4612: ELSE
4613: -- PAYE run result found hence effective date for paye details is
4614: -- date of last assignment action
4615: l_paye_eff_date := l_last_effective_date;
4616: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4617: END IF;
4618: CLOSE csr_tax_last_paye_run;
4619: -- most people will have had paye calculated on the last run.
4620: -- Pick these up

Line 4629: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

4625: IF l_tax_run_result_id IS NULL THEN
4626: -- find the latest update
4627: hr_utility.trace('calling csr_tax_latest_run, non reversal');
4628: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
4629: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4630: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4631: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4632: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4633: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

Line 4633: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

4629: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4630: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4631: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4632: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4633: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4634: CLOSE csr_tax_latest_run;
4635: ELSE
4636: l_paye_details_eff_date := l_last_effective_date;
4637: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

Line 4637: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

4633: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4634: CLOSE csr_tax_latest_run;
4635: ELSE
4636: l_paye_details_eff_date := l_last_effective_date;
4637: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4638: END IF;
4639: CLOSE csr_tax_last_run;
4640: ELSE
4641: -- find the latest update, as reversal action

Line 4644: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

4640: ELSE
4641: -- find the latest update, as reversal action
4642: hr_utility.trace('calling csr_tax_latest_run, reversal');
4643: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
4644: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4645: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4646: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4647: CLOSE csr_tax_latest_run;
4648: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);

Line 4649: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

4645: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4646: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4647: CLOSE csr_tax_latest_run;
4648: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4649: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4650: --
4651: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4652: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4653: CLOSE csr_tax_latest_paye_run;

Line 4655: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

4651: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4652: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4653: CLOSE csr_tax_latest_paye_run;
4654: hr_utility.trace('After csr_tax_latest_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4655: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4656: END IF;
4657: --
4658: archive_asg_info(g_tax_run_result_id_eid, nvl(l_tax_paye_run_result_id, l_tax_run_result_id));
4659: --

Line 4721: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));

4717: l_w1_m1_indicator := 'W';
4718: end if;
4719: end if;
4720: hr_utility.trace('Aggregated tax code found so far='||g_agg_balance_totals.tax_code);
4721: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));
4722: -- this tax code is from the PAYE Details Entry, since it is an
4723: -- aggregated assignment therefore check if we already have a
4724: -- a tax code from a previously processed assignment of this employee
4725: IF g_agg_balance_totals.tax_code is NULL THEN

Line 4734: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');

4730: g_agg_balance_totals.tax_code := l_tax_code;
4731: g_agg_balance_totals.tax_basis := l_w1_m1_indicator;
4732: g_agg_balance_totals.pay_previous := l_previous_taxable_pay;
4733: g_agg_balance_totals.tax_previous := l_previous_tax_paid;
4734: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');
4735: END IF;
4736: --
4737: IF nvl(g_agg_balance_totals.week_53, ' ') = ' ' THEN
4738: g_agg_balance_totals.week_53 := l_week_53_indicator;

Line 4918: fnd_date.date_to_canonical(l_effective_start_date));

4914: archive_asg_info(g_organization_id_eid,l_organization_id);
4915: archive_asg_info(g_location_id_eid,l_location_id);
4916: archive_asg_info(g_people_group_id_eid,l_people_group_id);
4917: archive_asg_info(g_effective_start_date_eid,
4918: fnd_date.date_to_canonical(l_effective_start_date));
4919: archive_asg_info(g_termination_date_eid,
4920: fnd_date.date_to_canonical(l_termination_date));
4921: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
4922: archive_asg_info(g_last_effective_date_eid,

Line 4920: fnd_date.date_to_canonical(l_termination_date));

4916: archive_asg_info(g_people_group_id_eid,l_people_group_id);
4917: archive_asg_info(g_effective_start_date_eid,
4918: fnd_date.date_to_canonical(l_effective_start_date));
4919: archive_asg_info(g_termination_date_eid,
4920: fnd_date.date_to_canonical(l_termination_date));
4921: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
4922: archive_asg_info(g_last_effective_date_eid,
4923: fnd_date.date_to_canonical(l_last_effective_date));
4924: --

Line 4923: fnd_date.date_to_canonical(l_last_effective_date));

4919: archive_asg_info(g_termination_date_eid,
4920: fnd_date.date_to_canonical(l_termination_date));
4921: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
4922: archive_asg_info(g_last_effective_date_eid,
4923: fnd_date.date_to_canonical(l_last_effective_date));
4924: --
4925: -- Now fetch more asg info.
4926: --
4927: IF l_multiple_asg_flag = 'Y' THEN

Line 5017: fnd_date.date_to_canonical(l_date_of_birth));

5013: archive_asg_info(g_last_name_eid,l_last_name);
5014: archive_asg_info(g_first_name_eid,l_first_name);
5015: archive_asg_info(g_middle_name_eid,l_middle_name);
5016: archive_asg_info(g_date_of_birth_eid,
5017: fnd_date.date_to_canonical(l_date_of_birth));
5018: archive_asg_info(g_title_eid,l_title);
5019: archive_asg_info(g_expense_check_to_address_eid,
5020: l_expense_check_to_address);
5021: archive_asg_info(g_ni_number_eid,l_ni_number);

Line 5028: fnd_date.date_to_canonical(l_start_of_emp));

5024: archive_asg_info(g_multiple_asg_flag_eid,l_multiple_asg_flag);
5025: archive_asg_info(g_aggregated_paye_flag_eid, l_aggregated_paye_flag);
5026: archive_asg_info(g_director_indicator_eid,l_director_indicator);
5027: archive_asg_info(g_start_of_emp_eid,
5028: fnd_date.date_to_canonical(l_start_of_emp));
5029: archive_asg_info(g_address_line1_eid,l_address_line1);
5030: archive_asg_info(g_address_line2_eid,l_address_line2);
5031: archive_asg_info(g_address_line3_eid,l_address_line3);
5032: archive_asg_info(g_town_or_city_eid,l_town_or_city);

Line 5096: fnd_date.date_to_displaydate(l_week_53_start));

5092: FETCH get_week_53_start INTO l_week_53_start;
5093: CLOSE get_week_53_start;
5094: --
5095: hr_utility.trace('After get_week_53_start, l_week_53_start='||
5096: fnd_date.date_to_displaydate(l_week_53_start));
5097: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
5098: l_week_53_indicator := substr(to_char(l_payroll_max_period_number),2,1);
5099: END IF;
5100: else

Line 5126: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

5122: IF l_tax_paye_run_result_id IS NULL THEN
5123: -- if paye was not calculated in last run then
5124: -- get the latest run in which it was
5125: hr_utility.trace('Before csr_tax_last_paye_run, l_assignment_id='||l_assignment_id);
5126: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5127: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5128: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5129: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5130: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

Line 5130: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

5126: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5127: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5128: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5129: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5130: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5131: CLOSE csr_tax_latest_paye_run;
5132: ELSE
5133: -- PAYE run result found hence effective date for paye details is
5134: -- date of last assignment action

Line 5136: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

5132: ELSE
5133: -- PAYE run result found hence effective date for paye details is
5134: -- date of last assignment action
5135: l_paye_eff_date := l_last_effective_date;
5136: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5137: END IF;
5138: CLOSE csr_tax_last_paye_run;
5139: -- most people will have had paye calculated on the last run.
5140: -- Pick these up

Line 5149: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

5145: IF l_tax_run_result_id IS NULL THEN
5146: -- find the latest update
5147: hr_utility.trace('calling csr_tax_latest_run, non reversal');
5148: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
5149: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5150: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5151: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5152: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5153: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

Line 5153: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

5149: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5150: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5151: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5152: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5153: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5154: CLOSE csr_tax_latest_run;
5155: ELSE
5156: l_paye_details_eff_date := l_last_effective_date;
5157: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

Line 5157: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

5153: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5154: CLOSE csr_tax_latest_run;
5155: ELSE
5156: l_paye_details_eff_date := l_last_effective_date;
5157: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5158: END IF;
5159: CLOSE csr_tax_last_run;
5160: ELSE
5161: -- find the latest update, as reversal action

Line 5164: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

5160: ELSE
5161: -- find the latest update, as reversal action
5162: hr_utility.trace('calling csr_tax_latest_run, reversal');
5163: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
5164: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5165: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5166: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5167: CLOSE csr_tax_latest_run;
5168: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);

Line 5169: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

5165: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5166: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5167: CLOSE csr_tax_latest_run;
5168: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5169: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5170: --
5171: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5172: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5173: CLOSE csr_tax_latest_paye_run;

Line 5175: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

5171: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5172: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5173: CLOSE csr_tax_latest_paye_run;
5174: hr_utility.trace('After csr_tax_latest_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5175: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5176: END IF;
5177: --
5178: --
5179: -- archive_asg_info(g_tax_run_result_id_eid, nvl(l_tax_paye_run_result_id, l_tax_run_result_id));

Line 5242: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));

5238: l_w1_m1_indicator := 'W';
5239: end if;
5240: end if;
5241: hr_utility.trace('Aggregated tax code found so far='||g_agg_balance_totals.tax_code);
5242: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));
5243: -- this tax code is from the PAYE Details Entry, since it is an
5244: -- aggregated assignment therefore check if we already have a
5245: -- a tax code from a previously processed assignment of this employee
5246: IF g_agg_balance_totals.tax_code is NULL THEN

Line 5255: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');

5251: g_agg_balance_totals.tax_code := l_tax_code;
5252: g_agg_balance_totals.tax_basis := l_w1_m1_indicator;
5253: g_agg_balance_totals.pay_previous := l_previous_taxable_pay;
5254: g_agg_balance_totals.tax_previous := l_previous_tax_paid;
5255: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');
5256: END IF;
5257: --
5258: IF nvl(g_agg_balance_totals.week_53, ' ') = ' ' THEN
5259: g_agg_balance_totals.week_53 := l_week_53_indicator;