APPS.PAY_FI_ARCHIVE_PSTA dependencies on FND_DATE

Line 238: select fnd_date.canonical_to_date (g_year || '12/31')

234: if g_archive = 'Y' then
235: g_payroll_type := hr_general.decode_lookup ('FI_PROC_PERIOD_TYPE', g_payroll_type_code);
236:
237: /* Get the Last Date of the Year */
238: select fnd_date.canonical_to_date (g_year || '12/31')
239: into g_year_last_date
240: from dual;
241:
242: /* Get the First Date of the Year */

Line 786: p_action_information6 => fnd_date.date_to_canonical (

782: p_action_information1 => 'PYFIPSTA',
783: p_action_information2 => 'Benefit Details',
784: p_action_information3 => benefit_archive_details (k).person_id,
785: p_action_information5 => benefit_archive_details (k).person_id,
786: p_action_information6 => fnd_date.date_to_canonical (
787: nvl (
788: benefit_archive_details (k).pay_period_start_date,
789: g_year_last_date
790: )

Line 792: p_action_information7 => fnd_date.date_to_canonical (

788: benefit_archive_details (k).pay_period_start_date,
789: g_year_last_date
790: )
791: ),
792: p_action_information7 => fnd_date.date_to_canonical (
793: benefit_archive_details (k).pay_period_end_date
794: ),
795: p_action_information11 => benefit_archive_details (k).benefit_name,
796: p_action_information12 => fnd_number.number_to_canonical (

Line 841: p_action_information6 => fnd_date.date_to_canonical (

837: p_action_information1 => 'PYFIPSTA',
838: p_action_information2 => 'Car Benefit Details',
839: p_action_information3 => benefit_archive_details (k).person_id,
840: -- p_action_information5 => benefit_archive_details (k).person_id,
841: p_action_information6 => fnd_date.date_to_canonical (
842: benefit_archive_details (k).pay_period_start_date
843: ),
844: p_action_information7 => fnd_date.date_to_canonical (
845: nvl (

Line 844: p_action_information7 => fnd_date.date_to_canonical (

840: -- p_action_information5 => benefit_archive_details (k).person_id,
841: p_action_information6 => fnd_date.date_to_canonical (
842: benefit_archive_details (k).pay_period_start_date
843: ),
844: p_action_information7 => fnd_date.date_to_canonical (
845: nvl (
846: benefit_archive_details (k).pay_period_end_date,
847: g_year_last_date
848: )

Line 885: select fnd_date.canonical_to_date (g_year || '12/31')

881:
882: --
883: --
884: /* Get the Last Date of the Year */
885: select fnd_date.canonical_to_date (g_year || '12/31')
886: into g_year_last_date
887: from dual;
888:
889: /* Get the First Date of the Year */

Line 1411: pay_balance_pkg.set_context ('DATE_EARNED', fnd_date.date_to_canonical (g_year_last_date));

1407: close get_element_details;
1408: end if;
1409:
1410: /* Set the context for Date Earned as the Effective Date */
1411: pay_balance_pkg.set_context ('DATE_EARNED', fnd_date.date_to_canonical (g_year_last_date));
1412: --
1413: --
1414: /* Set the context forTAX_UNIT_ID as the Legal Employer Id */
1415: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);

Line 1505: p_action_information21 => fnd_date.date_to_canonical (i.date_of_birth),

1501: p_action_information17 => rl_primary_address.al3,
1502: p_action_information18 => l_postal_code,
1503: p_action_information19 => l_country,
1504: p_action_information20 => g_emp_local_unit_id,
1505: p_action_information21 => fnd_date.date_to_canonical (i.date_of_birth),
1506: p_action_information22 => l_job_name,
1507: p_action_information23 => rl_permanent_address.al1,
1508: p_action_information24 => rl_permanent_address.al2,
1509: p_action_information25 => rl_permanent_address.al3,

Line 1651: p_action_information6 => fnd_date.date_to_canonical (g_pay_period_start_date),

1647: p_action_information2 => 'Payroll Details',
1648: p_action_information3 => i.person_id,
1649: p_action_information4 => g_payroll_id,
1650: p_action_information5 => g_pay_period,
1651: p_action_information6 => fnd_date.date_to_canonical (g_pay_period_start_date),
1652: p_action_information7 => fnd_date.date_to_canonical (g_pay_period_end_date),
1653: p_action_information8 => g_period_type,
1654: p_action_information9 => fnd_number.number_to_canonical (l_salary_income),
1655: p_action_information10 => fnd_number.number_to_canonical (l_benefits_in_kind),

Line 1652: p_action_information7 => fnd_date.date_to_canonical (g_pay_period_end_date),

1648: p_action_information3 => i.person_id,
1649: p_action_information4 => g_payroll_id,
1650: p_action_information5 => g_pay_period,
1651: p_action_information6 => fnd_date.date_to_canonical (g_pay_period_start_date),
1652: p_action_information7 => fnd_date.date_to_canonical (g_pay_period_end_date),
1653: p_action_information8 => g_period_type,
1654: p_action_information9 => fnd_number.number_to_canonical (l_salary_income),
1655: p_action_information10 => fnd_number.number_to_canonical (l_benefits_in_kind),
1656: /* p_action_information11 => l_benefit_type,