eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_DETAIL dependencies on FND_PROFILE

Line 311: AND NVL(FND_PROFILE.VALUE('HXT_HOLIDAY_EXPLOSION'),'EX') = 'EX'

307: AND p_date_worked between effective_start_date and effective_end_date;
308:
309: IF (l_count_holiday_rules > c_no_rule)
310: -- Bug 8600894
311: AND NVL(FND_PROFILE.VALUE('HXT_HOLIDAY_EXPLOSION'),'EX') = 'EX'
312: THEN
313: l_holiday_rule_found := TRUE;
314: ELSE
315: l_holiday_rule_found := FALSE;

Line 1249: IF NVL(fnd_profile.value('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'

1245: hr_utility.trace(' Hol : G_date_worked'||g_date_worked);
1246:
1247: hr_utility.trace(' Hol : l_daily_total '||l_daily_total);
1248:
1249: IF NVL(fnd_profile.value('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'
1250: THEN
1251: OPEN daily_hol_total(g_det_session_date);
1252: FETCH daily_hol_total INTO l_daily_hol_total;
1253: CLOSE daily_hol_total;

Line 5153: IF NVL(FND_PROFILE.VALUE('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'

5149: THEN
5150: g_det_session_date := hxt_tim_col_util.return_session_date;
5151: END IF;
5152:
5153: IF NVL(FND_PROFILE.VALUE('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'
5154: -- Bug 16345397
5155: AND g_hol_yn = 'Y'
5156: THEN
5157: RETURN 0;

Line 10340: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'

10336: -- DT 1
10337: IF g_debug
10338: THEN
10339: hr_utility.TRACE
10340: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'
10341: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')
10342: );
10343: END IF;
10344:

Line 10341: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')

10337: IF g_debug
10338: THEN
10339: hr_utility.TRACE
10340: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'
10341: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')
10342: );
10343: END IF;
10344:
10345: -- If the following profile is set to 'YES', only then calculate the

Line 10347: IF (NVL (fnd_profile.VALUE ('HXT_CA_LABOR_RULE'), 'N') = 'Y')

10343: END IF;
10344:
10345: -- If the following profile is set to 'YES', only then calculate the
10346: -- combination points.
10347: IF (NVL (fnd_profile.VALUE ('HXT_CA_LABOR_RULE'), 'N') = 'Y')
10348: THEN
10349: IF g_debug
10350: THEN
10351: hr_utility.set_location (l_proc, 726);

Line 11260: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'

11256: IF g_debug
11257: THEN
11258: hr_utility.set_location (l_proc, 935);
11259: hr_utility.TRACE
11260: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'
11261: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')
11262: );
11263: END IF;
11264:

Line 11261: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')

11257: THEN
11258: hr_utility.set_location (l_proc, 935);
11259: hr_utility.TRACE
11260: ( 'fnd_profile.VALUE (''HXT_CA_LABOR_RULE''):'
11261: || fnd_profile.VALUE ('HXT_CA_LABOR_RULE')
11262: );
11263: END IF;
11264:
11265: -- IF the following profile set to 'Yes' then include combination

Line 11274: IF (NVL (fnd_profile.VALUE ('HXT_CA_LABOR_RULE'), 'N') = 'Y')

11270: -- as follows:
11271: -- Combination
11272: -- Weekly
11273: -- Daily
11274: IF (NVL (fnd_profile.VALUE ('HXT_CA_LABOR_RULE'), 'N') = 'Y')
11275: THEN
11276: IF g_debug
11277: THEN
11278: hr_utility.set_location (l_proc, 936);

Line 13137: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ( 'NO','OO')

13133:
13134:
13135: -- Bug 8600894
13136: IF g_hol_yn = 'Y'
13137: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ( 'NO','OO')
13138: AND g_reg_element.EXISTS(element_type_id_to_pay)
13139: THEN
13140: l_cache := g_pep_id;
13141: g_pep_id := NULL;

Line 13177: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ( 'NO','OO')

13173: );
13174:
13175: -- Bug 8600894
13176: IF g_hol_yn = 'Y'
13177: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ( 'NO','OO')
13178: AND g_reg_element.EXISTS(element_type_id_to_pay)
13179: THEN
13180: g_pep_id := l_cache;
13181: l_cache := NULL;

Line 13733: IF fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ('NO','OO')

13729: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));
13730: END IF;
13731:
13732: -- Bug 8600894
13733: IF fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ('NO','OO')
13734: THEN
13735: g_hdp_id := NULL;
13736: END IF;
13737:

Line 14789: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN( 'NO','OO')

14785: CLOSE csr_test_for_osp;
14786:
14787: -- Bug 8600894
14788: IF l_hol_yn = 'Y'
14789: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN( 'NO','OO')
14790: AND g_reg_element.EXISTS(a_pay_element_type_id)
14791: THEN
14792: l_pep_id := NULL;
14793: END IF;

Line 14877: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ('NO','OO')

14873: CLOSE csr_test_for_osp;
14874:
14875: -- Bug 8600894
14876: IF l_hol_yn = 'Y'
14877: AND fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ('NO','OO')
14878: AND g_reg_element.EXISTS(a_pay_element_type_id)
14879: THEN
14880: l_pep_id := NULL;
14881: END IF;

Line 15166: IF NVL(fnd_profile.value('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'

15162: END LOOP process_hrs;
15163: hr_utility.trace('Hol : l_daily_total for '||g_date_worked);
15164: hr_utility.trace('Hol : l_worked hours '||l_worked_hours);
15165:
15166: IF NVL(fnd_profile.value('HXT_HOLIDAY_EXPLOSION'),'EX') <> 'EX'
15167: THEN
15168: OPEN daily_hol_total(g_det_session_date);
15169: FETCH daily_hol_total INTO l_daily_hol_total;
15170: CLOSE daily_hol_total;