DBA Data[Home] [Help]

APPS.BEN_CWB_BACK_OUT_CONC dependencies on FND_DATE

Line 659: ,p_effective_date => fnd_date.date_to_canonical

655: --
656: process(errbuf => l_errbuf
657: ,retcode => l_retcode
658: ,p_benefit_action_id => p_benefit_action_id
659: ,p_effective_date => fnd_date.date_to_canonical
660: (l_parameters.process_date)
661: ,p_validate => l_parameters.validate_flag
662: ,p_business_group_id => l_parameters.business_group_id
663: ,p_life_event_id => l_parameters.ler_id

Line 664: ,p_ocrd_date => fnd_date.date_to_canonical

660: (l_parameters.process_date)
661: ,p_validate => l_parameters.validate_flag
662: ,p_business_group_id => l_parameters.business_group_id
663: ,p_life_event_id => l_parameters.ler_id
664: ,p_ocrd_date => fnd_date.date_to_canonical
665: (l_parameters.date_from)
666: ,p_group_pl_id => l_parameters.pl_id
667: ,p_person_selection_rule_id => l_parameters.person_selection_rl
668: ,p_debug_messages => l_parameters.debug_messages_flag);

Line 810: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

806: dt_fndate.change_ses_date
807: (p_ses_date => l_effective_date,
808: p_commit => l_commit);
809: --
810: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
811: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
812: --
813: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
814: fnd_message.set_token('PROC','benutils.get_parameter');

Line 811: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));

807: (p_ses_date => l_effective_date,
808: p_commit => l_commit);
809: --
810: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
811: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
812: --
813: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
814: fnd_message.set_token('PROC','benutils.get_parameter');
815: benutils.get_parameter(p_business_group_id => p_business_group_id

Line 1302: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

1298: hr_utility.set_location ('p_person_id '||p_person_id,10);
1299: --
1300:
1301: --
1302: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
1303: l_ocrd_date:=trunc(fnd_date.canonical_to_date(p_ocrd_date));
1304:
1305: --
1306: dt_fndate.change_ses_date

Line 1303: l_ocrd_date:=trunc(fnd_date.canonical_to_date(p_ocrd_date));

1299: --
1300:
1301: --
1302: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
1303: l_ocrd_date:=trunc(fnd_date.canonical_to_date(p_ocrd_date));
1304:
1305: --
1306: dt_fndate.change_ses_date
1307: (p_ses_date => l_effective_date,

Line 1621: ,P_LF_EVT_OCRD_DT => fnd_date.date_to_canonical(l_ocrd_date)

1617: hr_utility.set_location('Refreshing BEN_CWB_COMP_DETAILS Table ',8);
1618: -- fix for 14096794
1619: BEN_CWB_CD_SUMMARY_PKG.BEN_CWB_CD_SUMMARY_PROC
1620: (l_errbuff,l_retcode,P_GROUP_PL_ID => p_group_pl_id
1621: ,P_LF_EVT_OCRD_DT => fnd_date.date_to_canonical(l_ocrd_date)
1622: ,P_PURGE => 'Y');
1623:
1624: --
1625: hr_utility.set_location('Deleting data from ben_cwb_pl_dsgn ',10);