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.PAY_HK_AVG_PAY dependencies on HR_UTILITY

Line 29: g_debug := hr_utility.debug_enabled;

25: AND ppa.payroll_action_id=paa.payroll_action_id;
26:
27: BEGIN
28:
29: g_debug := hr_utility.debug_enabled;
30: IF g_debug THEN
31: hr_utility.set_location('Entering TIME_START',1);
32: hr_utility.set_location('In Parameter p_effective_date '||p_effective_date,1);
33: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id ,1);

Line 31: hr_utility.set_location('Entering TIME_START',1);

27: BEGIN
28:
29: g_debug := hr_utility.debug_enabled;
30: IF g_debug THEN
31: hr_utility.set_location('Entering TIME_START',1);
32: hr_utility.set_location('In Parameter p_effective_date '||p_effective_date,1);
33: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id ,1);
34: END if;
35:

Line 32: hr_utility.set_location('In Parameter p_effective_date '||p_effective_date,1);

28:
29: g_debug := hr_utility.debug_enabled;
30: IF g_debug THEN
31: hr_utility.set_location('Entering TIME_START',1);
32: hr_utility.set_location('In Parameter p_effective_date '||p_effective_date,1);
33: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id ,1);
34: END if;
35:
36: OPEN get_date_earned;

Line 33: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id ,1);

29: g_debug := hr_utility.debug_enabled;
30: IF g_debug THEN
31: hr_utility.set_location('Entering TIME_START',1);
32: hr_utility.set_location('In Parameter p_effective_date '||p_effective_date,1);
33: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id ,1);
34: END if;
35:
36: OPEN get_date_earned;
37: FETCH get_date_earned INTO l_date_earned,l_assignment_id;

Line 41: hr_utility.set_location('After Cursor get_date_earned',1);

37: FETCH get_date_earned INTO l_date_earned,l_assignment_id;
38: CLOSE get_date_earned;
39:
40: IF g_debug THEN
41: hr_utility.set_location('After Cursor get_date_earned',1);
42: hr_utility.set_location('l_date_earned '||l_date_earned,1);
43: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
44: END if;
45:

Line 42: hr_utility.set_location('l_date_earned '||l_date_earned,1);

38: CLOSE get_date_earned;
39:
40: IF g_debug THEN
41: hr_utility.set_location('After Cursor get_date_earned',1);
42: hr_utility.set_location('l_date_earned '||l_date_earned,1);
43: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
44: END if;
45:
46: /* To fetch the start_date from absence element*/

Line 43: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);

39:
40: IF g_debug THEN
41: hr_utility.set_location('After Cursor get_date_earned',1);
42: hr_utility.set_location('l_date_earned '||l_date_earned,1);
43: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
44: END if;
45:
46: /* To fetch the start_date from absence element*/
47: l_start_date := specified_date_absence(l_date_earned,l_assignment_id);

Line 65: hr_utility.set_location('Retruned specified Date '||l_start_date,1);

61: l_start_date := add_months(l_start_date,-13);
62: l_start_date := last_day(l_start_date) + 1;
63:
64: IF g_debug THEN
65: hr_utility.set_location('Retruned specified Date '||l_start_date,1);
66: END if;
67:
68: RETURN l_start_date;
69:

Line 99: g_debug := hr_utility.debug_enabled;

95: AND p_date_earned between paa.effective_start_date and paa.effective_end_date;
96:
97: BEGIN
98:
99: g_debug := hr_utility.debug_enabled;
100: IF g_debug THEN
101: hr_utility.set_location('Entering SPECIFIED_DATE_ABSENCE',1);
102: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
103: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);

Line 101: hr_utility.set_location('Entering SPECIFIED_DATE_ABSENCE',1);

97: BEGIN
98:
99: g_debug := hr_utility.debug_enabled;
100: IF g_debug THEN
101: hr_utility.set_location('Entering SPECIFIED_DATE_ABSENCE',1);
102: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
103: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
104: END if;
105:

Line 102: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);

98:
99: g_debug := hr_utility.debug_enabled;
100: IF g_debug THEN
101: hr_utility.set_location('Entering SPECIFIED_DATE_ABSENCE',1);
102: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
103: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
104: END if;
105:
106: OPEN csr_get_specified_date;

Line 103: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);

99: g_debug := hr_utility.debug_enabled;
100: IF g_debug THEN
101: hr_utility.set_location('Entering SPECIFIED_DATE_ABSENCE',1);
102: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
103: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
104: END if;
105:
106: OPEN csr_get_specified_date;
107: FETCH csr_get_specified_date INTO l_start_date;

Line 111: hr_utility.set_location('Retruned specified Date '||l_start_date,1);

107: FETCH csr_get_specified_date INTO l_start_date;
108: CLOSE csr_get_specified_date;
109:
110: IF g_debug THEN
111: hr_utility.set_location('Retruned specified Date '||l_start_date,1);
112: END if;
113:
114: RETURN l_start_date;
115:

Line 150: g_debug := hr_utility.debug_enabled;

146: AND p_date_earned between pivf.effective_start_date and pivf.effective_end_date;
147:
148: BEGIN
149:
150: g_debug := hr_utility.debug_enabled;
151: IF g_debug THEN
152: hr_utility.set_location('Entering SPECIFIED_DATE_ELEMENT',1);
153: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
154: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);

Line 152: hr_utility.set_location('Entering SPECIFIED_DATE_ELEMENT',1);

148: BEGIN
149:
150: g_debug := hr_utility.debug_enabled;
151: IF g_debug THEN
152: hr_utility.set_location('Entering SPECIFIED_DATE_ELEMENT',1);
153: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
154: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
155: END if;
156:

Line 153: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);

149:
150: g_debug := hr_utility.debug_enabled;
151: IF g_debug THEN
152: hr_utility.set_location('Entering SPECIFIED_DATE_ELEMENT',1);
153: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
154: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
155: END if;
156:
157: OPEN csr_get_specified_date;

Line 154: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);

150: g_debug := hr_utility.debug_enabled;
151: IF g_debug THEN
152: hr_utility.set_location('Entering SPECIFIED_DATE_ELEMENT',1);
153: hr_utility.set_location('In Parameter p_date_earned '||p_date_earned,1);
154: hr_utility.set_location('In Parameter p_assignment_id '||p_assignment_id ,1);
155: END if;
156:
157: OPEN csr_get_specified_date;
158: FETCH csr_get_specified_date INTO l_start_date;

Line 162: hr_utility.set_location('Retruned specified Date '||l_start_date,1);

158: FETCH csr_get_specified_date INTO l_start_date;
159: CLOSE csr_get_specified_date;
160:
161: IF g_debug THEN
162: hr_utility.set_location('Retruned specified Date '||l_start_date,1);
163: END if;
164:
165: RETURN l_start_date;
166:

Line 209: g_debug := hr_utility.debug_enabled;

205:
206: BEGIN
207:
208:
209: g_debug := hr_utility.debug_enabled;
210: IF g_debug THEN
211: hr_utility.set_location('Entering NO_OF_DAYS',1);
212: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id,1);
213: END if;

Line 211: hr_utility.set_location('Entering NO_OF_DAYS',1);

207:
208:
209: g_debug := hr_utility.debug_enabled;
210: IF g_debug THEN
211: hr_utility.set_location('Entering NO_OF_DAYS',1);
212: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id,1);
213: END if;
214:
215: OPEN get_date_earned;

Line 212: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id,1);

208:
209: g_debug := hr_utility.debug_enabled;
210: IF g_debug THEN
211: hr_utility.set_location('Entering NO_OF_DAYS',1);
212: hr_utility.set_location('In Parameter p_assignment_action_id '||p_assignment_action_id,1);
213: END if;
214:
215: OPEN get_date_earned;
216: FETCH get_date_earned INTO l_date_earned,l_assignment_id,l_effective_date;

Line 221: hr_utility.set_location('After Cursor get_date_earned',1);

217: CLOSE get_date_earned;
218:
219:
220: IF g_debug THEN
221: hr_utility.set_location('After Cursor get_date_earned',1);
222: hr_utility.set_location('l_date_earned '||l_date_earned,1);
223: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
224: hr_utility.set_location('l_effective_date '||l_effective_date ,1);
225: END if;

Line 222: hr_utility.set_location('l_date_earned '||l_date_earned,1);

218:
219:
220: IF g_debug THEN
221: hr_utility.set_location('After Cursor get_date_earned',1);
222: hr_utility.set_location('l_date_earned '||l_date_earned,1);
223: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
224: hr_utility.set_location('l_effective_date '||l_effective_date ,1);
225: END if;
226:

Line 223: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);

219:
220: IF g_debug THEN
221: hr_utility.set_location('After Cursor get_date_earned',1);
222: hr_utility.set_location('l_date_earned '||l_date_earned,1);
223: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
224: hr_utility.set_location('l_effective_date '||l_effective_date ,1);
225: END if;
226:
227: /* To fetch the start_date from absence element*/

Line 224: hr_utility.set_location('l_effective_date '||l_effective_date ,1);

220: IF g_debug THEN
221: hr_utility.set_location('After Cursor get_date_earned',1);
222: hr_utility.set_location('l_date_earned '||l_date_earned,1);
223: hr_utility.set_location('l_assignment_id '||l_assignment_id ,1);
224: hr_utility.set_location('l_effective_date '||l_effective_date ,1);
225: END if;
226:
227: /* To fetch the start_date from absence element*/
228: l_specified_date := specified_date_absence(l_date_earned,l_assignment_id);

Line 248: hr_utility.set_location('After Cursor csr_hire_date',1);

244: FETCH csr_hire_date into l_hire_date;
245: CLOSE csr_hire_date;
246:
247: IF g_debug THEN
248: hr_utility.set_location('After Cursor csr_hire_date',1);
249: hr_utility.set_location('l_hire_date '||l_hire_date,1);
250: END if;
251:
252: l_start_date := last_day(add_months(l_specified_date,-13))+1;

Line 249: hr_utility.set_location('l_hire_date '||l_hire_date,1);

245: CLOSE csr_hire_date;
246:
247: IF g_debug THEN
248: hr_utility.set_location('After Cursor csr_hire_date',1);
249: hr_utility.set_location('l_hire_date '||l_hire_date,1);
250: END if;
251:
252: l_start_date := last_day(add_months(l_specified_date,-13))+1;
253: l_end_date := last_day(add_months(l_specified_date,-1));

Line 256: hr_utility.set_location('l_start_date '||l_start_date,1);

252: l_start_date := last_day(add_months(l_specified_date,-13))+1;
253: l_end_date := last_day(add_months(l_specified_date,-1));
254:
255: IF g_debug THEN
256: hr_utility.set_location('l_start_date '||l_start_date,1);
257: hr_utility.set_location('l_end_date '||l_end_date,1);
258: END if;
259:
260:

Line 257: hr_utility.set_location('l_end_date '||l_end_date,1);

253: l_end_date := last_day(add_months(l_specified_date,-1));
254:
255: IF g_debug THEN
256: hr_utility.set_location('l_start_date '||l_start_date,1);
257: hr_utility.set_location('l_end_date '||l_end_date,1);
258: END if;
259:
260:
261: /*If hire_date is more then l_start_date */

Line 270: hr_utility.set_location('Retruned l_no_of_days '||l_no_of_days,1);

266:
267: l_no_of_days := trunc (l_end_date - l_start_date + 1);
268:
269: IF g_debug THEN
270: hr_utility.set_location('Retruned l_no_of_days '||l_no_of_days,1);
271: END if;
272:
273: RETURN l_no_of_days;
274: