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_US_ARCHIVE dependencies on FND_DATE

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

54: to be Archived.
55: 05-JAN-2007 sackumar 115.97 5745950 Modified cursor c_get_disability_plan_scl_info
56: 13-DEC-2006 kvsankar 115.96 5696031 Modified cursor c_get_latest_asg
57: to remove the order by clause.
58: 13-NOV-2006 sodhingr 115.95 5656018 removed fnd_date.canonical_to_date
59: for A_ONLINE_W2
60: 30-AUG-2006 sodhingr 115.94 5499805 Added a check to archive null if
61: if View Online W2 profile option
62: is blank

Line 502: p_creation_date := fnd_date.canonical_to_date(

498: p_person_id := ln_person_id;
499: p_ssn := ln_ssn;
500: p_asg_set := ln_asg_set;
501: p_year := ln_year;
502: p_creation_date := fnd_date.canonical_to_date(
503: substr(fnd_date.date_to_canonical(ln_creation_date),1,10));
504:
505: hr_utility.trace('ld_end_date = ' ||
506: to_char(ld_end_date));

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

499: p_ssn := ln_ssn;
500: p_asg_set := ln_asg_set;
501: p_year := ln_year;
502: p_creation_date := fnd_date.canonical_to_date(
503: substr(fnd_date.date_to_canonical(ln_creation_date),1,10));
504:
505: hr_utility.trace('ld_end_date = ' ||
506: to_char(ld_end_date));
507: hr_utility.trace('ld_start_date = ' ||

Line 3462: l_corrected_date := fnd_date.canonical_to_date(

3458: l_profile_date VARCHAR2(20);
3459: l_add_archive VARCHAR2(10);
3460: BEGIN
3461:
3462: l_corrected_date := fnd_date.canonical_to_date(
3463: substr(fnd_date.date_to_canonical(sysdate),1,10));
3464: hr_utility.trace('Archive Date : ' || l_corrected_date);
3465:
3466: l_profile_date := fnd_date.canonical_to_date(

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

3459: l_add_archive VARCHAR2(10);
3460: BEGIN
3461:
3462: l_corrected_date := fnd_date.canonical_to_date(
3463: substr(fnd_date.date_to_canonical(sysdate),1,10));
3464: hr_utility.trace('Archive Date : ' || l_corrected_date);
3465:
3466: l_profile_date := fnd_date.canonical_to_date(
3467: pay_us_archive_util.get_archive_value(l_payroll_action_id,

Line 3466: l_profile_date := fnd_date.canonical_to_date(

3462: l_corrected_date := fnd_date.canonical_to_date(
3463: substr(fnd_date.date_to_canonical(sysdate),1,10));
3464: hr_utility.trace('Archive Date : ' || l_corrected_date);
3465:
3466: l_profile_date := fnd_date.canonical_to_date(
3467: pay_us_archive_util.get_archive_value(l_payroll_action_id,
3468: 'A_VIEW_ONLINE_W2',
3469: l_taxunitid));
3470:

Line 3506: l_corrected_date := fnd_date.canonical_to_date(

3502: l_profile_date VARCHAR2(20);
3503: l_add_archive VARCHAR2(10);
3504: BEGIN
3505:
3506: l_corrected_date := fnd_date.canonical_to_date(
3507: substr(fnd_date.date_to_canonical(sysdate),1,10));
3508: hr_utility.trace('Archive Date : ' || l_corrected_date);
3509:
3510: l_profile_date := fnd_date.canonical_to_date(

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

3503: l_add_archive VARCHAR2(10);
3504: BEGIN
3505:
3506: l_corrected_date := fnd_date.canonical_to_date(
3507: substr(fnd_date.date_to_canonical(sysdate),1,10));
3508: hr_utility.trace('Archive Date : ' || l_corrected_date);
3509:
3510: l_profile_date := fnd_date.canonical_to_date(
3511: pay_us_archive_util.get_archive_value(l_payroll_action_id,

Line 3510: l_profile_date := fnd_date.canonical_to_date(

3506: l_corrected_date := fnd_date.canonical_to_date(
3507: substr(fnd_date.date_to_canonical(sysdate),1,10));
3508: hr_utility.trace('Archive Date : ' || l_corrected_date);
3509:
3510: l_profile_date := fnd_date.canonical_to_date(
3511: pay_us_archive_util.get_archive_value(l_payroll_action_id,
3512: 'A_HR_ORIG_1099R_BEF',
3513: l_taxunitid));
3514:

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

4008: pay_archive.g_context_values.name(l_count) := 'ASSIGNMENT_ID';
4009: pay_archive.g_context_values.value(l_count) := l_asgid;
4010: l_count := l_count + 1;
4011: pay_archive.g_context_values.name(l_count) := 'DATE_EARNED';
4012: pay_archive.g_context_values.value(l_count) := fnd_date.date_to_canonical(l_date_earned);
4013: l_count := l_count + 1;
4014: pay_archive.g_context_values.name(l_count) := 'TAX_UNIT_ID';
4015: pay_archive.g_context_values.value(l_count) := l_taxunitid;
4016:

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

4660: from per_contact_relationships ctr1
4661: where ctr1.person_id = l_person_id
4662: and ctr1.date_start <= l_year_end
4663: and nvl(ctr1.date_end,
4664: fnd_date.canonical_to_date('4712/12/31 00:00:00'))
4665: >= l_year_start);
4666:
4667:
4668: exception when no_data_found then

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

5084: l_step := 109;
5085:
5086: l_user_entity_id_tab(1) := g_archive_date;
5087: /* Bug# 4137906 - Time Info not required for the Date. So suppressing it */
5088: l_value_tab(1) := substr(fnd_date.date_to_canonical(sysdate),1,10);
5089:
5090: l_step := 110;
5091: hr_utility.trace('l_user_entity_id_tab is '||l_user_entity_id_tab(1));
5092: hr_utility.trace(' l_value_tab is '||l_value_tab(1));