DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on FND_DATE

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

576: p_information_type => 'JP_ITAX_DEPENDENT',
577: p_cei_information_category => 'JP_ITAX_DEPENDENT',
578: p_cei_information2 => p_rec.occupation,
579: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),
580: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
581: p_cei_information5 => p_rec.change_reason,
582: p_cei_information6 => p_rec.disability_type,
583: p_cei_information7 => p_rec.disability_details,
584: p_cei_information8 => p_rec.dep_type,

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

606: p_effective_date => p_rec.effective_date,
607: p_datetrack_update_mode => p_rec.datetrack_update_mode,
608: p_contact_extra_info_id => p_rec.contact_extra_info_id,
609: p_object_version_number => p_rec.cei_object_version_number,
610: p_cei_information4 => fnd_date.date_to_canonical(p_rec.change_date),
611: p_cei_information5 => p_rec.change_reason,
612: p_cei_information8 => p_rec.dep_type,
613: p_cei_information2 => p_rec.occupation,
614: p_cei_information3 => fnd_number.number_to_canonical(p_rec.estimated_annual_income),

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

805: p_contact_relationship_id => p_rec.contact_relationship_id,
806: p_information_type => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
807: p_cei_information_category => 'JP_ITAX_DEPENDENT_ON_OTHER_EMP',
808: p_cei_information1 => p_rec.occupation,
809: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
810: p_cei_information3 => p_rec.change_reason,
811: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
812: p_contact_extra_info_id => p_rec.contact_extra_info_id,
813: p_object_version_number => p_rec.cei_object_version_number,

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

830: p_effective_date => p_rec.effective_date,
831: p_datetrack_update_mode => p_rec.datetrack_update_mode,
832: p_contact_extra_info_id => p_rec.contact_extra_info_id,
833: p_object_version_number => p_rec.cei_object_version_number,
834: p_cei_information2 => fnd_date.date_to_canonical(p_rec.change_date),
835: p_cei_information3 => p_rec.change_reason,
836: p_cei_information1 => p_rec.occupation,
837: p_cei_information5 => fnd_number.number_to_canonical(p_rec.oe_contact_relationship_id),
838: p_effective_start_date => l_esd,

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

2803: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
2804: if p_expiry_date < l_assact_rec.effective_date
2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;
2811: --

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

2804: if p_expiry_date < l_assact_rec.effective_date
2805: or p_expiry_date > l_year_end_date then
2806: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_EXPIRY_DATE');
2807: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
2808: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
2809: fnd_message.raise_error;
2810: end if;
2811: --
2812: insert_session(p_expiry_date);