APPS.HXT_BATCH_PROCESS dependencies on FND_PROFILE

Line 22: RETURN fnd_profile_option_values.profile_option_value%TYPE

18:
19: /* Function to set the default value for the profile 'HXT_MERGE_BATCH_TIMECARDS' */
20:
21: FUNCTION merge_batches
22: RETURN fnd_profile_option_values.profile_option_value%TYPE
23: AS
24: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
25: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
26:

Line 24: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;

20:
21: FUNCTION merge_batches
22: RETURN fnd_profile_option_values.profile_option_value%TYPE
23: AS
24: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
25: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
26:
27: BEGIN
28: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');

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

21: FUNCTION merge_batches
22: RETURN fnd_profile_option_values.profile_option_value%TYPE
23: AS
24: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
25: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
26:
27: BEGIN
28: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');
29:

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

24: l_merge_batches fnd_profile_option_values.profile_option_value%TYPE;
25: l_merge_batches_default CONSTANT fnd_profile_option_values.profile_option_value%TYPE := 'N';
26:
27: BEGIN
28: l_merge_batches := fnd_profile.VALUE ('HXT_MERGE_BATCH_TIMECARDS');
29:
30: IF (l_merge_batches IS NULL)
31: THEN
32: l_merge_batches := l_merge_batches_default;

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

1401: p_sum_retcode := 0;
1402: --
1403: -- If profile value set to 'Y', sum hours only to send to BEE
1404: --
1405: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
1406: OPEN hxt_hours_cur;
1407: FETCH hxt_hours_cur into l_values_rec;
1408: IF hxt_hours_cur%FOUND THEN
1409: we_have_lines := TRUE;

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

1427: dtl_to_BEE(l_values_rec, p_sum_retcode,l_batch_sequence);
1428: --
1429: -- If profile value set to 'Y', then we're sending sum of hours only
1430: --
1431: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
1432: FETCH hxt_hours_cur into l_values_rec;
1433: IF hxt_hours_cur%FOUND THEN
1434: we_have_lines := TRUE;
1435: l_batch_sequence := l_batch_sequence + 1;

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

1451: END LOOP;
1452: --
1453: -- Close appropriate cursor
1454: --
1455: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
1456: CLOSE hxt_hours_cur;
1457: ELSE
1458: CLOSE hxt_values_cur;
1459: END IF;

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

1459: END IF;
1460: --
1461: -- If profile value is set to 'Y', now send amounts only to BEE
1462: --
1463: IF (nvl(fnd_profile.value('HXT_ROLLUP_BATCH_HOURS'),'N') = 'Y') THEN
1464: OPEN hxt_amounts_cur;
1465: FETCH hxt_amounts_cur into l_values_rec;
1466: IF hxt_amounts_cur%FOUND THEN
1467: we_have_lines := TRUE;