DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on FND_PROFILE

Line 3370: NVL(FND_PROFILE.value('HXC_VERIFY_APPLN_SET_FOR_APPROVAL'),'N'));

3366: IF g_debug THEN
3367: hr_utility.trace('l_approval_style ::'||l_approval_style);
3368: hr_utility.trace('l_elp_rule ::'||l_elp_rule);
3369: hr_utility.trace('Profile value of OTL: Verify Entry Level Application Set for Approval is :: '||
3370: NVL(FND_PROFILE.value('HXC_VERIFY_APPLN_SET_FOR_APPROVAL'),'N'));
3371: END IF;
3372:
3373: -- Bug 10164135
3374: -- Check if ELP rule is set. Call accordingly.

Line 3379: AND NVL(FND_PROFILE.value('HXC_VERIFY_APPLN_SET_FOR_APPROVAL'),'N')

3375: IF l_elp_rule <> 0
3376:
3377: -- Bug 11075779
3378: -- Added the profile option to toggle this behavior.
3379: AND NVL(FND_PROFILE.value('HXC_VERIFY_APPLN_SET_FOR_APPROVAL'),'N')
3380: = 'Y'
3381:
3382: THEN
3383: IF g_debug

Line 3554: IF NVL(FND_PROFILE.VALUE('HXC_ELA_RESTRUCTURED_TC'),'N') = 'Y'

3550: -- Added the first half of the following IF construct.
3551: -- New profile option used to switch on the behavior.
3552: -- Description inline.
3553:
3554: IF NVL(FND_PROFILE.VALUE('HXC_ELA_RESTRUCTURED_TC'),'N') = 'Y'
3555: THEN
3556:
3557: -- Delete everything from the GTT, just in case a previous timecard left something.
3558: DELETE FROM hxc_archive_temp;

Line 4644: l_defer FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%type;

4640: ,p_bb_new IN varchar2
4641: )is
4642:
4643: l_proc varchar2(70) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
4644: l_defer FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%type;
4645:
4646: Begin
4647: --
4648: -- Fetch the defer option

Line 4651: l_defer := fnd_profile.value('HXC_DEFER_WORKFLOW');

4647: --
4648: -- Fetch the defer option
4649: --
4650:
4651: l_defer := fnd_profile.value('HXC_DEFER_WORKFLOW');
4652:
4653: if(l_defer is null) then
4654: l_defer := 'Y';
4655: end if;