APPS.PAY_US_ARCHIVE dependencies on FND_DATE

Line 27: 13-NOV-2006 sodhingr 115.95 5656018 removed fnd_date.canonical_to_date

23: to be Archived.
24: 05-JAN-2007 sackumar 115.97 5745950 Modified cursor c_get_disability_plan_scl_info
25: 13-DEC-2006 kvsankar 115.96 5696031 Modified cursor c_get_latest_asg
26: to remove the order by clause.
27: 13-NOV-2006 sodhingr 115.95 5656018 removed fnd_date.canonical_to_date
28: for A_ONLINE_W2
29: 30-AUG-2006 sodhingr 115.94 5499805 Added a check to archive null if
30: if View Online W2 profile option
31: is blank

Line 470: p_creation_date := fnd_date.canonical_to_date(

466: p_person_id := ln_person_id;
467: p_ssn := ln_ssn;
468: p_asg_set := ln_asg_set;
469: p_year := ln_year;
470: p_creation_date := fnd_date.canonical_to_date(
471: substr(fnd_date.date_to_canonical(ln_creation_date),1,10));
472:
473: hr_utility.trace('ld_end_date = ' ||
474: to_char(ld_end_date));

Line 471: substr(fnd_date.date_to_canonical(ln_creation_date),1,10));

467: p_ssn := ln_ssn;
468: p_asg_set := ln_asg_set;
469: p_year := ln_year;
470: p_creation_date := fnd_date.canonical_to_date(
471: substr(fnd_date.date_to_canonical(ln_creation_date),1,10));
472:
473: hr_utility.trace('ld_end_date = ' ||
474: to_char(ld_end_date));
475: hr_utility.trace('ld_start_date = ' ||

Line 2935: l_corrected_date := fnd_date.canonical_to_date(

2931: l_profile_date VARCHAR2(20);
2932: l_add_archive VARCHAR2(10);
2933: BEGIN
2934:
2935: l_corrected_date := fnd_date.canonical_to_date(
2936: substr(fnd_date.date_to_canonical(sysdate),1,10));
2937: hr_utility.trace('Archive Date : ' || l_corrected_date);
2938:
2939: l_profile_date := fnd_date.canonical_to_date(

Line 2936: substr(fnd_date.date_to_canonical(sysdate),1,10));

2932: l_add_archive VARCHAR2(10);
2933: BEGIN
2934:
2935: l_corrected_date := fnd_date.canonical_to_date(
2936: substr(fnd_date.date_to_canonical(sysdate),1,10));
2937: hr_utility.trace('Archive Date : ' || l_corrected_date);
2938:
2939: l_profile_date := fnd_date.canonical_to_date(
2940: pay_us_archive_util.get_archive_value(l_payroll_action_id,

Line 2939: l_profile_date := fnd_date.canonical_to_date(

2935: l_corrected_date := fnd_date.canonical_to_date(
2936: substr(fnd_date.date_to_canonical(sysdate),1,10));
2937: hr_utility.trace('Archive Date : ' || l_corrected_date);
2938:
2939: l_profile_date := fnd_date.canonical_to_date(
2940: pay_us_archive_util.get_archive_value(l_payroll_action_id,
2941: 'A_VIEW_ONLINE_W2',
2942: l_taxunitid));
2943:

Line 3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);

3376: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
3377: pay_archive.g_context_values.value(l_count) := l_asgid;
3378: l_count := l_count + 1;
3379: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
3380: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
3381: l_count := l_count + 1;
3382: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
3383: pay_archive.g_context_values.value(l_count) := l_taxunitid;
3384:

Line 4000: fnd_date.canonical_to_date('4712/12/31 00:00:00'))

3996: from per_contact_relationships ctr1
3997: where ctr1.person_id = l_person_id
3998: and ctr1.date_start <= l_year_end
3999: and nvl(ctr1.date_end,
4000: fnd_date.canonical_to_date('4712/12/31 00:00:00'))
4001: >= l_year_start);
4002:
4003:
4004: exception when no_data_found then

Line 4384: l_value_tab(1) := substr(fnd_date.date_to_canonical(sysdate),1,10);

4380: l_step := 109;
4381:
4382: l_user_entity_id_tab(1) := g_archive_date;
4383: /* Bug# 4137906 - Time Info not required for the Date. So suppressing it */
4384: l_value_tab(1) := substr(fnd_date.date_to_canonical(sysdate),1,10);
4385:
4386: l_step := 110;
4387: hr_utility.trace('l_user_entity_id_tab is '||l_user_entity_id_tab(1));
4388: hr_utility.trace(' l_value_tab is '||l_value_tab(1));