APPS.HXT_BATCH_PROCESS dependencies on FND_PROFILE

Line 428: RETURN fnd_profile_option_values.profile_option_value%TYPE

424:
425: /* Function to set the default value for the profile 'HXT_MERGE_BATCH_TIMECARDS' */
426:
427: FUNCTION merge_batches
428: RETURN fnd_profile_option_values.profile_option_value%TYPE
429: AS
430: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
431: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
432:

Line 430: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;

426:
427: FUNCTION merge_batches
428: RETURN fnd_profile_option_values.profile_option_value%TYPE
429: AS
430: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
431: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
432:
433: BEGIN
434: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');

Line 431: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';

427: FUNCTION merge_batches
428: RETURN fnd_profile_option_values.profile_option_value%TYPE
429: AS
430: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
431: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
432:
433: BEGIN
434: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');
435:

Line 434: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');

430: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
431: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
432:
433: BEGIN
434: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');
435:
436: IF (l_merge_batches IS NULL)
437: THEN
438: l_merge_batches := l_merge_batches_default;

Line 2038: AND NVL(FND_PROFILE.VALUE('HXT_ALLOW_SUM_CUSTOM_ATTRIBUTE'),'N') = 'N'

2034:
2035: IF lv_pbl_flag = 'N' --THEN
2036: -- Bug 13639441
2037: -- Added code here
2038: AND NVL(FND_PROFILE.VALUE('HXT_ALLOW_SUM_CUSTOM_ATTRIBUTE'),'N') = 'N'
2039: THEN
2040:
2041: hr_utility.trace('Coming into new code as if profile is turned OFF');
2042:

Line 2457: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN

2453: g_iv_upgrade := get_upgrade_status(p_batch_id);
2454: --
2455: -- If profile value set to 'Y', sum hours only to send to BEE
2456: --
2457: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
2458: OPEN hxt_hours_cur;
2459: FETCH hxt_hours_cur into l_values_rec;
2460: IF hxt_hours_cur%FOUND THEN
2461: we_have_lines := TRUE;

Line 2483: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN

2479: dtl_to_BEE(l_values_rec, p_sum_retcode,l_batch_sequence);
2480: --
2481: -- If profile value set to 'Y', then we're sending sum of hours only
2482: --
2483: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
2484: FETCH hxt_hours_cur into l_values_rec;
2485: IF hxt_hours_cur%FOUND THEN
2486: we_have_lines := TRUE;
2487: l_batch_sequence := l_batch_sequence + 1;

Line 2507: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN

2503: END LOOP;
2504: --
2505: -- Close appropriate cursor
2506: --
2507: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
2508: CLOSE hxt_hours_cur;
2509: ELSE
2510: CLOSE hxt_values_cur;
2511: END IF;

Line 2515: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN

2511: END IF;
2512: --
2513: -- If profile value is set to 'Y', now send amounts only to BEE
2514: --
2515: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
2516: OPEN hxt_amounts_cur;
2517: FETCH hxt_amounts_cur into l_values_rec;
2518: IF hxt_amounts_cur%FOUND THEN
2519: we_have_lines := TRUE;