DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on FND_PROFILE

Line 497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

493: avalue => l_tc_from_role);
494:
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:

Line 498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

494:
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();

Line 558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

554: itemkey => p_itemkey,
555: aname => 'TC_APPROVER_FROM_ROLE');
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:

Line 559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

555: aname => 'TC_APPROVER_FROM_ROLE');
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();

Line 1133: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN

1129: l_exclude_hours varchar2(1) := 'N';
1130:
1131: BEGIN
1132:
1133: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1134: -- Absence Integration Profile is ON
1135: hxc_preference_evaluation.resource_preferences
1136: (p_resource_id => p_resource_id,
1137: p_pref_code_list => 'TS_ABS_PREFERENCES',