DBA Data[Home] [Help]

APPS.DK_CONSUMED_ENTRY dependencies on HR_UTILITY

Line 13: g_debug boolean := hr_utility.debug_enabled;

9: v_consumed VARCHAR2(1) := 'N';
10: v_reversed VARCHAR2(1) := 'N';
11: l_period_start DATE;
12: l_period_end DATE;
13: g_debug boolean := hr_utility.debug_enabled;
14: --
15: BEGIN
16: --
17: if g_debug then

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

14: --
15: BEGIN
16: --
17: if g_debug then
18: hr_utility.set_location('consumed_entry spl', 10);
19: end if;
20: --
21: -- Find EARNED period dates
22: --

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

28: WHERE payroll_id = p_payroll_id
29: AND p_date_earned BETWEEN start_date AND end_date;
30: --
31: if g_debug then
32: hr_utility.set_location('consumed_entry spl', 20);
33: end if;
34: --
35: SELECT DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')
36: INTO v_consumed

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

52: AND PPA.date_earned BETWEEN l_period_start
53: AND l_period_end;
54: --
55: if g_debug then
56: hr_utility.set_location('consumed_entry spl', 39);
57: end if;
58:
59: RETURN v_consumed;
60:

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

59: RETURN v_consumed;
60:
61: exception when NO_DATA_FOUND then
62: if g_debug then
63: hr_utility.set_location('consumed_entry spl', 40);
64: end if;
65: RETURN v_consumed;
66: --
67: END consumed_entry_spl;

Line 78: g_debug boolean := hr_utility.debug_enabled;

74: v_consumed VARCHAR2(1) := 'N';
75: v_reversed VARCHAR2(1) := 'N';
76: l_period_start DATE;
77: l_period_end DATE;
78: g_debug boolean := hr_utility.debug_enabled;
79: --
80: BEGIN
81: --
82: if g_debug then

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

79: --
80: BEGIN
81: --
82: if g_debug then
83: hr_utility.set_location('consumed_entry', 10);
84: end if;
85: --
86: -- Find EARNED period dates
87: --

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

93: WHERE payroll_id = p_payroll_id
94: AND p_date_earned BETWEEN start_date AND end_date;
95: --
96: if g_debug then
97: hr_utility.set_location('consumed_entry', 20);
98: end if;
99: --
100: /*
101: SELECT DECODE(COUNT(PRR.run_result_id), 0, 'N', 'Y')

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

145: AND PPA.date_earned BETWEEN l_period_start
146: AND l_period_end;
147: --
148: if g_debug then
149: hr_utility.set_location('consumed_entry', 39);
150: end if;
151:
152: RETURN v_consumed;
153:

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

152: RETURN v_consumed;
153:
154: exception when NO_DATA_FOUND then
155: if g_debug then
156: hr_utility.set_location('consumed_entry', 40);
157: end if;
158: RETURN v_consumed;
159: --
160: END consumed_entry_indirect;