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 415: -- Cover on the fnd_date function, but with exception handling

411: END get_nearest_scon;
412: --
413: FUNCTION canonical_to_date(p_chardate IN VARCHAR2)
414: RETURN DATE
415: -- Cover on the fnd_date function, but with exception handling
416: IS
417: l_return_date DATE;
418: BEGIN
419: l_return_date := fnd_date.canonical_to_date(p_chardate);

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

415: -- Cover on the fnd_date function, but with exception handling
416: IS
417: l_return_date DATE;
418: BEGIN
419: l_return_date := fnd_date.canonical_to_date(p_chardate);
420: RETURN l_return_date;
421: EXCEPTION
422: WHEN OTHERS THEN
423: RETURN NULL;

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

568: -- This could not be achieved by overloading get_arch_str as the views
569: -- wouldn't know which return data type was required.
570: IS
571: BEGIN
572: RETURN fnd_date.canonical_to_date(get_arch_str(p_action_id,
573: p_user_entity_name,
574: p_context_value1,
575: p_context_value2,
576: p_context_value3));

Line 676: nvl(fnd_date.canonical_to_date

672: p_user_entity_id => p_permit_ueid,
673: p_context_value1 => payroll_rec.payroll_id);
674: g_min_start_year :=
675: least(g_min_start_year,
676: nvl(fnd_date.canonical_to_date
677: (g_payroll_start_yr_tab(payroll_rec.payroll_id)),
678: g_min_start_year));
679: g_max_end_year :=
680: greatest(g_max_end_year,

Line 681: nvl(fnd_date.canonical_to_date

677: (g_payroll_start_yr_tab(payroll_rec.payroll_id)),
678: g_min_start_year));
679: g_max_end_year :=
680: greatest(g_max_end_year,
681: nvl(fnd_date.canonical_to_date
682: (g_payroll_end_yr_tab(payroll_rec.payroll_id)),
683: g_max_end_year));
684: END LOOP;
685: --

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

907: CLOSE get_first_active_start;
908: --
909: IF l_min_active IS NULL THEN
910: --modified format for bug fix 4991467
911: RETURN fnd_date.canonical_to_date('0001/01/01 00:00:00');
912: END IF;
913: -- check if any of the other assignments of this employee
914: -- that were active before this assignment
915: LOOP

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

1107: CLOSE get_last_active_end;
1108: --
1109: IF l_max_active IS NULL THEN
1110: --modified format for bug fix 4991467
1111: RETURN fnd_date.canonical_to_date('4712/12/31 00:00:00');
1112: END IF;
1113: --
1114: -- check if any of the other assignments of
1115: -- this employee that were active after this assignment

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

1140: --
1141: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1142: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1143: 'End Of Year Process - Errors and Warnings Report'||
1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1147: 'Request Id: '||fnd_global.conc_request_id);
1148: fnd_file.put_line(fnd_file.output, ' ');

Line 1622: fnd_date.date_to_canonical(l_payroll_end_year));

1618: l_payroll_period_type_eid,
1619: l_payroll_period_type);
1620: archive_payroll_info(pactid, rec_payroll.payroll_id,
1621: l_payroll_end_year_eid,
1622: fnd_date.date_to_canonical(l_payroll_end_year));
1623: archive_payroll_info(pactid, rec_payroll.payroll_id,
1624: l_payroll_start_year_eid,
1625: fnd_date.date_to_canonical(l_payroll_start_year));
1626: END LOOP;

Line 1625: fnd_date.date_to_canonical(l_payroll_start_year));

1621: l_payroll_end_year_eid,
1622: fnd_date.date_to_canonical(l_payroll_end_year));
1623: archive_payroll_info(pactid, rec_payroll.payroll_id,
1624: l_payroll_start_year_eid,
1625: fnd_date.date_to_canonical(l_payroll_start_year));
1626: END LOOP;
1627: EXCEPTION
1628: -- Propagate error through by means of the X_PAYROLL_ACTION_MESSAGE UE.
1629: -- Start of BUG 5909829 EOY

Line 1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1801: from per_all_assignments_f paf2
1802: where paf2.assignment_id = paf.assignment_id
1803: AND paf2.effective_end_date > paf.effective_end_date
1804: AND paf2.effective_end_date >=
1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1806: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1807: AND paf2.effective_start_date <=
1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1809: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));

Line 1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1804: AND paf2.effective_end_date >=
1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1806: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1807: AND paf2.effective_start_date <=
1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1809: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));
1810: --
1811: cursor csr_assignments ( p_min_start_year_date DATE,
1812: p_max_end_year_date DATE,

Line 2091: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2087: hr_utility.trace(l_proc||' Fetched assignment_id='||
2088: rec_assignment.assignment_id||', g_asg_set_id='||g_asg_set_id);
2089: l_process_asg := FALSE;
2090: l_payroll_start_date :=
2091: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2092: (pactid,'X_START_YEAR',
2093: to_char(rec_assignment.payroll_id)));
2094: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2095: l_payroll_end_date :=

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

2090: l_payroll_start_date :=
2091: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2092: (pactid,'X_START_YEAR',
2093: to_char(rec_assignment.payroll_id)));
2094: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2095: l_payroll_end_date :=
2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2097: (pactid,'X_END_YEAR',
2098: to_char(rec_assignment.payroll_id)));

Line 2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2092: (pactid,'X_START_YEAR',
2093: to_char(rec_assignment.payroll_id)));
2094: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2095: l_payroll_end_date :=
2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2097: (pactid,'X_END_YEAR',
2098: to_char(rec_assignment.payroll_id)));
2099: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2100: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);

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

2095: l_payroll_end_date :=
2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2097: (pactid,'X_END_YEAR',
2098: to_char(rec_assignment.payroll_id)));
2099: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2100: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);
2101: IF nvl(rec_assignment.tax_ref_xfer,' ') = 'N' AND csr_assignments%FOUND
2102: THEN
2103: hr_utility.trace(l_proc||' opening cursor csr_sub_asg.');

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

2113: end loop;
2114: ELSIF nvl(rec_assignment.tax_ref_xfer,' ') = 'Y' AND csr_assignments%FOUND
2115: THEN
2116: hr_utility.trace(l_proc||' tax ref xfer=Y and found record by csr_assignments cursor.');
2117: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2118: hr_utility.trace(l_proc||' rec_assignment.effective_start_date='||fnd_date.date_to_displaydate(rec_assignment.effective_start_date));
2119: IF rec_assignment.effective_end_date >= l_payroll_start_date
2120: AND rec_assignment.effective_start_date <= l_payroll_end_date
2121: THEN

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

2114: ELSIF nvl(rec_assignment.tax_ref_xfer,' ') = 'Y' AND csr_assignments%FOUND
2115: THEN
2116: hr_utility.trace(l_proc||' tax ref xfer=Y and found record by csr_assignments cursor.');
2117: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2118: hr_utility.trace(l_proc||' rec_assignment.effective_start_date='||fnd_date.date_to_displaydate(rec_assignment.effective_start_date));
2119: IF rec_assignment.effective_end_date >= l_payroll_start_date
2120: AND rec_assignment.effective_start_date <= l_payroll_end_date
2121: THEN
2122: l_process_asg := TRUE;

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

2128: hr_utility.trace(l_proc||' rec_assignment.person_id='||rec_assignment.person_id);
2129: hr_utility.trace(l_proc||' rec_prev_asg.person_id='||rec_prev_asg.person_id);
2130: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2131: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2132: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2133: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2134: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2135: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2136: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);

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

2129: hr_utility.trace(l_proc||' rec_prev_asg.person_id='||rec_prev_asg.person_id);
2130: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2131: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2132: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2133: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2134: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2135: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2136: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2137: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);

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

2130: hr_utility.trace(l_proc||' rec_assignment.period_of_service_id='||rec_assignment.period_of_service_id);
2131: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2132: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2133: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2134: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2135: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2136: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2137: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);
2138: IF (csr_assignments%NOTFOUND

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

2131: hr_utility.trace(l_proc||' rec_prev_asg.period_of_service_id='||rec_prev_asg.period_of_service_id);
2132: hr_utility.trace(l_proc||' rec_assignment.agg_active_start='||fnd_date.date_to_displaydate(rec_assignment.agg_active_start));
2133: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_start='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_start));
2134: hr_utility.trace(l_proc||' rec_assignment.agg_active_end='||fnd_date.date_to_displaydate(rec_assignment.agg_active_end));
2135: hr_utility.trace(l_proc||' rec_prev_asg.agg_active_end='||fnd_date.date_to_displaydate(rec_prev_asg.agg_active_end));
2136: hr_utility.trace(l_proc||' rec_assignment.tax_ref='||rec_assignment.tax_ref);
2137: hr_utility.trace(l_proc||' rec_prev_asg.tax_ref='||rec_prev_asg.tax_ref);
2138: IF (csr_assignments%NOTFOUND
2139: OR rec_assignment.person_id <> rec_prev_asg.person_id

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

2166: EXIT WHEN csr_assignments%NOTFOUND;
2167: hr_utility.set_location(l_proc,15);
2168: hr_utility.trace(l_proc||' rec_assignment.assignment_id='||rec_assignment.assignment_id);
2169: hr_utility.trace(l_proc||' rec_prev_asg.assignment_id='||rec_prev_asg.assignment_id);
2170: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2171: hr_utility.trace(l_proc||' rec_prev_asg.effective_end_date='||fnd_date.date_to_displaydate(rec_prev_asg.effective_end_date));
2172: IF (rec_assignment.assignment_id <> rec_prev_asg.assignment_id
2173: OR rec_assignment.effective_end_date <> rec_prev_asg.effective_end_date)
2174: AND l_process_asg

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

2167: hr_utility.set_location(l_proc,15);
2168: hr_utility.trace(l_proc||' rec_assignment.assignment_id='||rec_assignment.assignment_id);
2169: hr_utility.trace(l_proc||' rec_prev_asg.assignment_id='||rec_prev_asg.assignment_id);
2170: hr_utility.trace(l_proc||' rec_assignment.effective_end_date='||fnd_date.date_to_displaydate(rec_assignment.effective_end_date));
2171: hr_utility.trace(l_proc||' rec_prev_asg.effective_end_date='||fnd_date.date_to_displaydate(rec_prev_asg.effective_end_date));
2172: IF (rec_assignment.assignment_id <> rec_prev_asg.assignment_id
2173: OR rec_assignment.effective_end_date <> rec_prev_asg.effective_end_date)
2174: AND l_process_asg
2175: -- if the current row is the first row

Line 2192: p_archive_value => fnd_date.date_to_canonical

2188: -- archive the effective end date
2189: ff_archive_api.create_archive_item
2190: (p_archive_item_id => l_archive_item_id,
2191: p_user_entity_id => g_effective_end_date_eid,
2192: p_archive_value => fnd_date.date_to_canonical
2193: (rec_assignment.effective_end_date),
2194: p_archive_type => 'AAC',
2195: p_action_id => l_actid,
2196: p_legislation_code => 'GB',

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

2213: IF rec_assignment.multiple_asg_flag = 'Y' THEN
2214: ff_archive_api.create_archive_item
2215: (p_archive_item_id => l_archive_item_id,
2216: p_user_entity_id => g_agg_active_start_eid,
2217: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_start),
2218: p_archive_type => 'AAC',
2219: p_action_id => l_actid,
2220: p_legislation_code => 'GB',
2221: p_object_version_number => l_ovn,

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

2223: --
2224: ff_archive_api.create_archive_item
2225: (p_archive_item_id => l_archive_item_id,
2226: p_user_entity_id => g_agg_active_end_eid,
2227: p_archive_value => fnd_date.date_to_canonical(rec_assignment.agg_active_end),
2228: p_archive_type => 'AAC',
2229: p_action_id => l_actid,
2230: p_legislation_code => 'GB',
2231: p_object_version_number => l_ovn,

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

2302: --
2303: cursor csr_payroll_info(p_pactid NUMBER) IS
2304: SELECT
2305: to_number(aic.context) payroll_id,
2306: fnd_date.canonical_to_date(fai.VALUE) start_year,
2307: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2308: g_payroll_end_year_eid,
2309: aic.context)) end_year,
2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,

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

2303: cursor csr_payroll_info(p_pactid NUMBER) IS
2304: SELECT
2305: to_number(aic.context) payroll_id,
2306: fnd_date.canonical_to_date(fai.VALUE) start_year,
2307: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2308: g_payroll_end_year_eid,
2309: aic.context)) end_year,
2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2311: aic.context) period_type,

Line 3275: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3271: ASG_ACTION_ERROR EXCEPTION;
3272: --
3273: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3274: SELECT act.assignment_id,
3275: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3276: (act.assignment_action_id,
3277: g_effective_end_date_eid)) end_date,
3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,

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

3276: (act.assignment_action_id,
3277: g_effective_end_date_eid)) end_date,
3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,

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

3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,
3285: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3286: FROM pay_assignment_actions act
3287: WHERE act.assignment_action_id = p_asgactid;

Line 3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3372: AND nroll.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3373: AND ass.assignment_id = pass.assignment_id
3374: AND pass.effective_end_date = (ass.effective_start_date - 1)
3375: AND pass.effective_end_date >=
3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3377: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3378: AND pass.effective_start_date <=
3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3380: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))

Line 3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3375: AND pass.effective_end_date >=
3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3377: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3378: AND pass.effective_start_date <=
3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3380: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))
3381: AND proll.payroll_id = pass.payroll_id
3382: AND pass.payroll_id <> ass.payroll_id
3383: AND ass.effective_start_date BETWEEN

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

3718: USE_NL(assact2, pact, r2) */
3719: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3720: ||r2.source_type||
3721: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3722: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3723: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3724: FROM pay_assignment_actions assact2,
3725: pay_payroll_actions pact,
3726: pay_run_results r2

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

3719: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3720: ||r2.source_type||
3721: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3722: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3723: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3724: FROM pay_assignment_actions assact2,
3725: pay_payroll_actions pact,
3726: pay_run_results r2
3727: WHERE assact2.assignment_id = p_assignment_id

Line 3737: /* Bug 4278570 fnd_date.canonical_to_date

3733: --AND assact2.action_status = 'C'
3734: AND assact2.action_status in ('C','S') --Modified for the bug 10066755
3735: AND pact.effective_date BETWEEN
3736: g_start_year AND g_end_year
3737: /* Bug 4278570 fnd_date.canonical_to_date
3738: (pay_gb_eoy_archive.get_arch_str(
3739: g_payroll_action_id,
3740: g_payroll_start_year_eid,
3741: to_char(pact.payroll_id)))

Line 3742: AND fnd_date.canonical_to_date

3738: (pay_gb_eoy_archive.get_arch_str(
3739: g_payroll_action_id,
3740: g_payroll_start_year_eid,
3741: to_char(pact.payroll_id)))
3742: AND fnd_date.canonical_to_date
3743: (pay_gb_eoy_archive.get_arch_str(
3744: g_payroll_action_id,
3745: g_payroll_end_year_eid,
3746: to_char(pact.payroll_id)))

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

3765: USE_NL(assact2, pact, r2) */
3766: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3767: ||r2.source_type||
3768: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3769: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3770: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3771: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3772: -- r2.run_result_id),16))
3773: FROM pay_assignment_actions assact2,

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

3766: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')
3767: ||r2.source_type||
3768: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3769: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3770: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3771: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3772: -- r2.run_result_id),16))
3773: FROM pay_assignment_actions assact2,
3774: pay_payroll_actions pact,

Line 3786: /* Bug 4278570 fnd_date.canonical_to_date

3782: --AND assact2.action_status = 'C'
3783: AND assact2.action_status in ('C','S') --Modified for the bug 10066755
3784: AND pact.effective_date BETWEEN
3785: g_start_year AND g_end_year
3786: /* Bug 4278570 fnd_date.canonical_to_date
3787: (pay_gb_eoy_archive.get_arch_str(
3788: g_payroll_action_id,
3789: g_payroll_start_year_eid,
3790: to_char(pact.payroll_id)))

Line 3791: AND fnd_date.canonical_to_date

3787: (pay_gb_eoy_archive.get_arch_str(
3788: g_payroll_action_id,
3789: g_payroll_start_year_eid,
3790: to_char(pact.payroll_id)))
3791: AND fnd_date.canonical_to_date
3792: (pay_gb_eoy_archive.get_arch_str(
3793: g_payroll_action_id,
3794: g_payroll_end_year_eid,
3795: to_char(pact.payroll_id)))

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

4367: l_agg_active_start,
4368: l_agg_active_end;
4369: CLOSE csr_asg_act_info;
4370: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4371: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4372: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4373: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4374: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4375: -- Bug fix for 3699865 - get the final process date

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

4369: CLOSE csr_asg_act_info;
4370: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4371: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4372: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4373: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4374: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4375: -- Bug fix for 3699865 - get the final process date
4376: OPEN csr_asg_last_process_date(l_assignment_id);
4377: FETCH csr_asg_last_process_date INTO l_final_process_date;

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

4370: hr_utility.trace('After csr_asg_act_info, l_assignment_id='||l_assignment_id);
4371: hr_utility.trace('l_effective_end_date='||fnd_date.date_to_displaydate(l_effective_end_date));
4372: hr_utility.trace('l_tax_ref_transfer='||l_tax_ref_transfer);
4373: hr_utility.trace('l_agg_active_start='||fnd_date.date_to_displaydate(l_agg_active_start));
4374: hr_utility.trace('l_agg_active_end='||fnd_date.date_to_displaydate(l_agg_active_end));
4375: -- Bug fix for 3699865 - get the final process date
4376: OPEN csr_asg_last_process_date(l_assignment_id);
4377: FETCH csr_asg_last_process_date INTO l_final_process_date;
4378: CLOSE csr_asg_last_process_date;

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

4375: -- Bug fix for 3699865 - get the final process date
4376: OPEN csr_asg_last_process_date(l_assignment_id);
4377: FETCH csr_asg_last_process_date INTO l_final_process_date;
4378: CLOSE csr_asg_last_process_date;
4379: hr_utility.trace('After csr_asg_last_process_date, l_final_process_date='||fnd_date.date_to_displaydate(l_final_process_date));
4380: IF l_final_process_date is not null
4381: and nvl(l_tax_ref_transfer, 'N') = 'N'
4382: and l_final_process_date < l_effective_end_date THEN
4383: -- added extra conditions above for 5199746, so that final process date

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

4427: l_period_of_service_id;
4428: IF csr_basic_inf_current%FOUND then
4429: -- Set the eff end to the one of the current row
4430: l_effective_end_date := l_adj_eff_end_date;
4431: hr_utility.trace('After csr_basic_inf_current, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));
4432: hr_utility.trace('l_payroll_id='||l_payroll_id);
4433: hr_utility.trace('l_assignment_number='||l_assignment_number);
4434: hr_utility.trace('l_person_id='||l_person_id);
4435: hr_utility.trace('l_organization_id='||l_organization_id);

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

4461: IF csr_basic_inf_term%FOUND then
4462: -- Set the eff end to the adjusted one from the
4463: -- terminated assignment.
4464: l_effective_end_date := l_adj_eff_end_date;
4465: /* hr_utility.trace('After csr_basic_inf_term, l_adj_eff_end_date='||fnd_date.date_to_displaydate(l_adj_eff_end_date));
4466: hr_utility.trace('l_payroll_id='||l_payroll_id);
4467: hr_utility.trace('l_assignment_number='||l_assignment_number);
4468: hr_utility.trace('l_person_id='||l_person_id);
4469: hr_utility.trace('l_organization_id='||l_organization_id);

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

4490: -- Assignment number is not null
4491: IF l_payroll_id IS NULL THEN
4492: -- Payroll is null
4493: l_assignment_message :=
4494: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);
4495: archive_asg_info(g_assignment_message_eid, l_assignment_message);
4496: END IF;
4497: END IF;
4498: ELSE

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

4499: -- Assignment number is not null
4500: IF l_payroll_id IS NULL THEN
4501: -- Payroll is null
4502: l_assignment_message :=
4503: 'ERROR: Payroll not found on the assignment as at '||fnd_date.date_to_canonical(l_effective_end_date);
4504: archive_asg_info(g_assignment_message_eid, l_assignment_message);
4505: END IF;
4506: --
4507: END IF;

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

4540: OPEN csr_asg_start(l_assignment_id, l_effective_end_date,
4541: l_payroll_start_year, l_payroll_end_year);
4542: FETCH csr_asg_start INTO l_effective_start_date;
4543: CLOSE csr_asg_start;
4544: hr_utility.trace('After csr_asg_start, l_effective_start_date='||fnd_date.date_to_displaydate(l_effective_start_date));
4545: --
4546: hr_utility.trace('Action type: '||l_action_type);
4547: --
4548: -- Get basic person info

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

4561: CLOSE csr_person_info;
4562: hr_utility.trace('After csr_person_info, l_last_name='||l_last_name);
4563: hr_utility.trace('l_first_name='||l_first_name);
4564: hr_utility.trace('l_middle_name='||l_middle_name);
4565: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
4566: hr_utility.trace('l_title='||l_title);
4567: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
4568: hr_utility.trace('l_ni_number='||l_ni_number);
4569: hr_utility.trace('l_sex='||l_sex);

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

4577: OPEN get_asg_active_range(l_assignment_id, l_payroll_tax_dist||'/'||l_payroll_tax_ref);
4578: FETCH get_asg_active_range INTO l_active_start, l_active_end;
4579: CLOSE get_asg_active_range;
4580: hr_utility.trace('After get_asg_active_range.');
4581: hr_utility.trace('l_active_start='||fnd_date.date_to_displaydate(l_active_start));
4582: hr_utility.trace('l_active_end='||fnd_date.date_to_displaydate(l_active_end));
4583: --
4584: -- set termination type and date.
4585: IF l_tax_ref_transfer = 'N' THEN

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

4578: FETCH get_asg_active_range INTO l_active_start, l_active_end;
4579: CLOSE get_asg_active_range;
4580: hr_utility.trace('After get_asg_active_range.');
4581: hr_utility.trace('l_active_start='||fnd_date.date_to_displaydate(l_active_start));
4582: hr_utility.trace('l_active_end='||fnd_date.date_to_displaydate(l_active_end));
4583: --
4584: -- set termination type and date.
4585: IF l_tax_ref_transfer = 'N' THEN
4586: --

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

4591: FETCH csr_termination INTO l_actual_termination_date,
4592: l_last_std_process_date,
4593: l_termination_type;
4594: CLOSE csr_termination;
4595: hr_utility.trace('After csr_termination, l_actual_termination_date='||fnd_date.date_to_displaydate(l_actual_termination_date));
4596: hr_utility.trace('l_last_std_process_date='||fnd_date.date_to_displaydate(l_last_std_process_date));
4597: hr_utility.trace('l_termination_type='||l_termination_type);
4598: IF l_multiple_asg_flag = 'Y' THEN
4599: -- for multiple assignment check if aggregated active end date

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

4592: l_last_std_process_date,
4593: l_termination_type;
4594: CLOSE csr_termination;
4595: hr_utility.trace('After csr_termination, l_actual_termination_date='||fnd_date.date_to_displaydate(l_actual_termination_date));
4596: hr_utility.trace('l_last_std_process_date='||fnd_date.date_to_displaydate(l_last_std_process_date));
4597: hr_utility.trace('l_termination_type='||l_termination_type);
4598: IF l_multiple_asg_flag = 'Y' THEN
4599: -- for multiple assignment check if aggregated active end date
4600: -- is before the actual termination date and EOY, if yes then set

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

4636: -- termination date else ensire l_termination_date is null
4637: -- so that P60 can be generated
4638: l_date_of_manual_p45_issue := NULL;
4639: l_date_of_manual_p45_issue := pay_p45_pkg.get_p45_eit_manual_issue_dt(l_assignment_id);
4640: hr_utility.trace('After get_p45_eit_manual_issue_dt, manual issue date='||fnd_date.date_to_displaydate(l_date_of_manual_p45_issue));
4641: --
4642: IF l_date_of_manual_p45_issue IS NOT NULL
4643: AND l_date_of_manual_p45_issue <= g_end_year THEN
4644: -- manual P45 issued in current tax year hence leave

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

4656: pay_p45_pkg.get_p45_asg_action_id(l_assignment_id,
4657: l_p45_action_id,
4658: l_p45_issue_date,
4659: l_p45_action_seq);
4660: hr_utility.trace('After get_p45_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));
4661: hr_utility.trace('l_p45_action_id='||l_p45_action_id);
4662:
4663: IF l_p45_issue_date IS NULL THEN
4664: pay_p45_pkg.get_p45_agg_asg_action_id(l_assignment_id,

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

4665: l_p45_agg_asg_id,
4666: l_p45_final_pay_date,
4667: l_p45_issue_date,
4668: l_p45_action_id);
4669: hr_utility.trace('After get_p45_agg_asg_action_id, l_p45_issue_date='||fnd_date.date_to_displaydate(l_p45_issue_date));
4670:
4671: END IF;
4672:
4673: -- Start of BUG 5671777-1

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

4721: FETCH csr_last_action INTO l_last_asg_action_id,
4722: l_last_effective_date;
4723: CLOSE csr_last_action;
4724: hr_utility.trace('After csr_last_action, l_last_asg_action_id='||l_last_asg_action_id);
4725: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4726: --
4727: IF l_last_asg_action_id IS NOT NULL THEN
4728: OPEN csr_action_details(l_last_asg_action_id);
4729: FETCH csr_action_details into l_action_type;

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

4798: IF l_tax_paye_run_result_id IS NULL THEN
4799: -- if paye was not calculated in last run then
4800: -- get the latest run in which it was
4801: hr_utility.trace('Before csr_tax_last_paye_run, l_assignment_id='||l_assignment_id);
4802: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4803: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4804: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4805: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4806: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

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

4802: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4803: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4804: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4805: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4806: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4807: CLOSE csr_tax_latest_paye_run;
4808: ELSE
4809: -- PAYE run result found hence effective date for paye details is
4810: -- date of last assignment action

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

4808: ELSE
4809: -- PAYE run result found hence effective date for paye details is
4810: -- date of last assignment action
4811: l_paye_eff_date := l_last_effective_date;
4812: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4813: END IF;
4814: CLOSE csr_tax_last_paye_run;
4815: -- most people will have had paye calculated on the last run.
4816: -- Pick these up

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

4821: IF l_tax_run_result_id IS NULL THEN
4822: -- find the latest update
4823: hr_utility.trace('calling csr_tax_latest_run, non reversal');
4824: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
4825: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4826: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4827: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4828: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4829: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

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

4825: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4826: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4827: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4828: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4829: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4830: CLOSE csr_tax_latest_run;
4831: ELSE
4832: l_paye_details_eff_date := l_last_effective_date;
4833: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

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

4829: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4830: CLOSE csr_tax_latest_run;
4831: ELSE
4832: l_paye_details_eff_date := l_last_effective_date;
4833: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4834: END IF;
4835: CLOSE csr_tax_last_run;
4836: ELSE
4837: -- find the latest update, as reversal action

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

4836: ELSE
4837: -- find the latest update, as reversal action
4838: hr_utility.trace('calling csr_tax_latest_run, reversal');
4839: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
4840: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
4841: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4842: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4843: CLOSE csr_tax_latest_run;
4844: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);

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

4841: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
4842: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
4843: CLOSE csr_tax_latest_run;
4844: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
4845: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
4846: --
4847: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4848: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4849: CLOSE csr_tax_latest_paye_run;

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

4847: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
4848: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
4849: CLOSE csr_tax_latest_paye_run;
4850: hr_utility.trace('After csr_tax_latest_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
4851: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
4852: END IF;
4853: --
4854: archive_asg_info(g_tax_run_result_id_eid, nvl(l_tax_paye_run_result_id, l_tax_run_result_id));
4855: --

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

4913: l_w1_m1_indicator := 'W';
4914: end if;
4915: end if;
4916: hr_utility.trace('Aggregated tax code found so far='||g_agg_balance_totals.tax_code);
4917: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));
4918: -- this tax code is from the PAYE Details Entry, since it is an
4919: -- aggregated assignment therefore check if we already have a
4920: -- a tax code from a previously processed assignment of this employee
4921: IF g_agg_balance_totals.tax_code is NULL THEN

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

4926: g_agg_balance_totals.tax_code := l_tax_code;
4927: g_agg_balance_totals.tax_basis := l_w1_m1_indicator;
4928: g_agg_balance_totals.pay_previous := l_previous_taxable_pay;
4929: g_agg_balance_totals.tax_previous := l_previous_tax_paid;
4930: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');
4931: END IF;
4932: --
4933: IF nvl(g_agg_balance_totals.week_53, ' ') = ' ' THEN
4934: g_agg_balance_totals.week_53 := l_week_53_indicator;

Line 5116: fnd_date.date_to_canonical(l_effective_start_date));

5112: archive_asg_info(g_organization_id_eid,l_organization_id);
5113: archive_asg_info(g_location_id_eid,l_location_id);
5114: archive_asg_info(g_people_group_id_eid,l_people_group_id);
5115: archive_asg_info(g_effective_start_date_eid,
5116: fnd_date.date_to_canonical(l_effective_start_date));
5117: archive_asg_info(g_termination_date_eid,
5118: fnd_date.date_to_canonical(l_termination_date));
5119: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
5120: archive_asg_info(g_last_effective_date_eid,

Line 5118: fnd_date.date_to_canonical(l_termination_date));

5114: archive_asg_info(g_people_group_id_eid,l_people_group_id);
5115: archive_asg_info(g_effective_start_date_eid,
5116: fnd_date.date_to_canonical(l_effective_start_date));
5117: archive_asg_info(g_termination_date_eid,
5118: fnd_date.date_to_canonical(l_termination_date));
5119: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
5120: archive_asg_info(g_last_effective_date_eid,
5121: fnd_date.date_to_canonical(l_last_effective_date));
5122: --

Line 5121: fnd_date.date_to_canonical(l_last_effective_date));

5117: archive_asg_info(g_termination_date_eid,
5118: fnd_date.date_to_canonical(l_termination_date));
5119: archive_asg_info(g_last_asg_action_id_eid,l_last_asg_action_id);
5120: archive_asg_info(g_last_effective_date_eid,
5121: fnd_date.date_to_canonical(l_last_effective_date));
5122: --
5123: -- Now fetch more asg info.
5124: --
5125: IF l_multiple_asg_flag = 'Y' THEN

Line 5228: fnd_date.date_to_canonical(l_date_of_birth));

5224: archive_asg_info(g_last_name_eid,l_last_name);
5225: archive_asg_info(g_first_name_eid,l_first_name);
5226: archive_asg_info(g_middle_name_eid,l_middle_name);
5227: archive_asg_info(g_date_of_birth_eid,
5228: fnd_date.date_to_canonical(l_date_of_birth));
5229: archive_asg_info(g_title_eid,l_title);
5230: archive_asg_info(g_expense_check_to_address_eid,
5231: l_expense_check_to_address);
5232: archive_asg_info(g_ni_number_eid,l_ni_number);

Line 5239: fnd_date.date_to_canonical(l_start_of_emp));

5235: archive_asg_info(g_multiple_asg_flag_eid,l_multiple_asg_flag);
5236: archive_asg_info(g_aggregated_paye_flag_eid, l_aggregated_paye_flag);
5237: archive_asg_info(g_director_indicator_eid,l_director_indicator);
5238: archive_asg_info(g_start_of_emp_eid,
5239: fnd_date.date_to_canonical(l_start_of_emp));
5240: archive_asg_info(g_address_line1_eid,l_address_line1);
5241: archive_asg_info(g_address_line2_eid,l_address_line2);
5242: archive_asg_info(g_address_line3_eid,l_address_line3);
5243: archive_asg_info(g_town_or_city_eid,l_town_or_city);

Line 5313: fnd_date.date_to_displaydate(l_week_53_start));

5309: FETCH get_week_53_start INTO l_week_53_start;
5310: CLOSE get_week_53_start;
5311: --
5312: hr_utility.trace('After get_week_53_start, l_week_53_start='||
5313: fnd_date.date_to_displaydate(l_week_53_start));
5314: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
5315: l_week_53_indicator := substr(to_char(l_payroll_max_period_number),2,1);
5316: END IF;
5317: else

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

5339: IF l_tax_paye_run_result_id IS NULL THEN
5340: -- if paye was not calculated in last run then
5341: -- get the latest run in which it was
5342: hr_utility.trace('Before csr_tax_last_paye_run, l_assignment_id='||l_assignment_id);
5343: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5344: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5345: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5346: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5347: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));

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

5343: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5344: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5345: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5346: hr_utility.trace('After csr_tax_last_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5347: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5348: CLOSE csr_tax_latest_paye_run;
5349: ELSE
5350: -- PAYE run result found hence effective date for paye details is
5351: -- date of last assignment action

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

5349: ELSE
5350: -- PAYE run result found hence effective date for paye details is
5351: -- date of last assignment action
5352: l_paye_eff_date := l_last_effective_date;
5353: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5354: END IF;
5355: CLOSE csr_tax_last_paye_run;
5356: -- most people will have had paye calculated on the last run.
5357: -- Pick these up

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

5362: IF l_tax_run_result_id IS NULL THEN
5363: -- find the latest update
5364: hr_utility.trace('calling csr_tax_latest_run, non reversal');
5365: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
5366: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5367: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5368: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5369: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5370: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

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

5366: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5367: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5368: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5369: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5370: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5371: CLOSE csr_tax_latest_run;
5372: ELSE
5373: l_paye_details_eff_date := l_last_effective_date;
5374: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));

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

5370: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5371: CLOSE csr_tax_latest_run;
5372: ELSE
5373: l_paye_details_eff_date := l_last_effective_date;
5374: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5375: END IF;
5376: CLOSE csr_tax_last_run;
5377: ELSE
5378: -- find the latest update, as reversal action

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

5377: ELSE
5378: -- find the latest update, as reversal action
5379: hr_utility.trace('calling csr_tax_latest_run, reversal');
5380: hr_utility.trace('Before csr_tax_latest_run, l_assignment_id='||l_assignment_id);
5381: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
5382: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5383: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5384: CLOSE csr_tax_latest_run;
5385: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);

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

5382: OPEN csr_tax_latest_run(l_assignment_id, l_last_effective_date);
5383: FETCH csr_tax_latest_run INTO l_tax_run_result_id, l_paye_details_eff_date;
5384: CLOSE csr_tax_latest_run;
5385: hr_utility.trace('After csr_tax_latest_run, l_tax_run_result_id='||l_tax_run_result_id);
5386: hr_utility.trace('l_paye_details_eff_date='||fnd_date.date_to_displaydate(l_paye_details_eff_date));
5387: --
5388: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5389: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5390: CLOSE csr_tax_latest_paye_run;

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

5388: OPEN csr_tax_latest_paye_run(l_assignment_id, l_last_effective_date);
5389: FETCH csr_tax_latest_paye_run INTO l_tax_paye_run_result_id, l_paye_eff_date;
5390: CLOSE csr_tax_latest_paye_run;
5391: hr_utility.trace('After csr_tax_latest_paye_run, l_tax_paye_run_result_id='||l_tax_paye_run_result_id);
5392: hr_utility.trace('l_paye_eff_date='||fnd_date.date_to_displaydate(l_paye_eff_date));
5393: END IF;
5394: --
5395: --
5396: -- archive_asg_info(g_tax_run_result_id_eid, nvl(l_tax_paye_run_result_id, l_tax_run_result_id));

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

5455: l_w1_m1_indicator := 'W';
5456: end if;
5457: end if;
5458: hr_utility.trace('Aggregated tax code found so far='||g_agg_balance_totals.tax_code);
5459: hr_utility.trace('g_agg_balance_totals.paye_eff_date = '||fnd_date.date_to_displaydate(g_agg_balance_totals.paye_eff_date));
5460: -- this tax code is from the PAYE Details Entry, since it is an
5461: -- aggregated assignment therefore check if we already have a
5462: -- a tax code from a previously processed assignment of this employee
5463: IF g_agg_balance_totals.tax_code is NULL THEN

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

5468: g_agg_balance_totals.tax_code := l_tax_code;
5469: g_agg_balance_totals.tax_basis := l_w1_m1_indicator;
5470: g_agg_balance_totals.pay_previous := l_previous_taxable_pay;
5471: g_agg_balance_totals.tax_previous := l_previous_tax_paid;
5472: g_agg_balance_totals.paye_eff_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');
5473: END IF;
5474: --
5475: IF nvl(g_agg_balance_totals.week_53, ' ') = ' ' THEN
5476: g_agg_balance_totals.week_53 := l_week_53_indicator;