DBA Data[Home] [Help]

APPS.PAY_CONSUMED_ENTRY dependencies on HR_UTILITY

Line 19: g_debug boolean := hr_utility.debug_enabled;

15: v_consumed VARCHAR2(1) := 'N';
16: v_reversed VARCHAR2(1) := 'N';
17: l_period_start DATE;
18: l_period_end DATE;
19: g_debug boolean := hr_utility.debug_enabled;
20: --
21: BEGIN
22: --
23: if g_debug then

Line 24: hr_utility.set_location('consumed_entry', 10);

20: --
21: BEGIN
22: --
23: if g_debug then
24: hr_utility.set_location('consumed_entry', 10);
25: end if;
26: --
27: -- Find EARNED period dates
28: --

Line 38: hr_utility.set_location('consumed_entry', 20);

34: WHERE payroll_id = p_payroll_id
35: AND p_date_earned BETWEEN start_date AND end_date;
36: --
37: if g_debug then
38: hr_utility.set_location('consumed_entry', 20);
39: end if;
40: --
41: SELECT /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_PK)*/
42: DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')

Line 62: hr_utility.set_location('consumed_entry', 39);

58: AND PPA.date_earned BETWEEN l_period_start
59: AND l_period_end;
60: --
61: if g_debug then
62: hr_utility.set_location('consumed_entry', 39);
63: end if;
64:
65: RETURN v_consumed;
66:

Line 69: hr_utility.set_location('consumed_entry', 40);

65: RETURN v_consumed;
66:
67: exception when NO_DATA_FOUND then
68: if g_debug then
69: hr_utility.set_location('consumed_entry', 40);
70: end if;
71: RETURN v_consumed;
72: --
73: END consumed_entry;