DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on FND_DATE

Line 600: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),

596: p_information_type => 'JP_ITAX_DEPENDENT',
597: p_cei_information_category => 'JP_ITAX_DEPENDENT',
598: p_cei_information2 => p_rec.occupation,
599: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
600: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
601: p_cei_information5 => p_rec.change_reason,
602: p_cei_information6 => p_rec.disability_type,
603: p_cei_information7 => p_rec.disability_details,
604: p_cei_information8 => p_rec.dep_type,

Line 630: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),

626: p_effective_date => p_rec.effective_date,
627: p_datetrack_update_mode => p_rec.datetrack_update_mode,
628: p_contact_extra_info_id => p_rec.contact_extra_info_id,
629: p_object_version_number => p_rec.cei_object_version_number,
630: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
631: p_cei_information5 => p_rec.change_reason,
632: p_cei_information8 => p_rec.dep_type,
633: p_cei_information2 => p_rec.occupation,
634: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),

Line 829: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),

825: p_contact_relationship_id => p_rec.contact_relationship_id,
826: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
827: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
828: p_cei_information1 => p_rec.occupation,
829: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
830: p_cei_information3 => p_rec.change_reason,
831: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
832: p_contact_extra_info_id => p_rec.contact_extra_info_id,
833: p_object_version_number => p_rec.cei_object_version_number,

Line 854: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),

850: p_effective_date => p_rec.effective_date,
851: p_datetrack_update_mode => p_rec.datetrack_update_mode,
852: p_contact_extra_info_id => p_rec.contact_extra_info_id,
853: p_object_version_number => p_rec.cei_object_version_number,
854: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
855: p_cei_information3 => p_rec.change_reason,
856: p_cei_information1 => p_rec.occupation,
857: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
858: p_effective_start_date => l_esd,

Line 2029: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

2025: g_leg_business_group_id := g_business_group_id;
2026: --
2027: end if;
2028: --
2029: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2030: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(p_assignment_id));
2031: l_itax_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_leg_business_group_id,g_legislation_code);
2032: --
2033: if g_debug then

Line 3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));

3621: --
3622: if p_expiry_date < l_assact_rec.effective_date
3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;
3629: --

Line 3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));

3622: if p_expiry_date < l_assact_rec.effective_date
3623: or p_expiry_date > l_year_end_date then
3624: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
3625: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
3626: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
3627: fnd_message.raise_error;
3628: end if;
3629: --
3630: insert_session(p_expiry_date);