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_NO_SSB_CODES dependencies on HR_UTILITY

Line 57: --hr_utility.set_location('In populate table',10);

53: else
54: l_cache_index := 1;
55: End If;
56:
57: --hr_utility.set_location('In populate table',10);
58:
59: for csr_get_processed_elements_rec in csr_get_processed_elements (p_assignment_action_id, p_effective_date)
60: LOOP
61:

Line 69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);

65: g_ssb_codes_table(l_cache_index).ssb_code := csr_get_processed_elements_rec.ssb_code;
66: g_ssb_codes_table(l_cache_index).add_detail := csr_get_processed_elements_rec.add_detail;
67:
68:
69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);
70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);
71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );
72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);
73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);

Line 70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);

66: g_ssb_codes_table(l_cache_index).add_detail := csr_get_processed_elements_rec.add_detail;
67:
68:
69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);
70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);
71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );
72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);
73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);
74: */

Line 71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );

67:
68:
69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);
70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);
71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );
72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);
73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);
74: */
75: l_cache_index := l_cache_index +1;

Line 72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);

68:
69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);
70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);
71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );
72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);
73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);
74: */
75: l_cache_index := l_cache_index +1;
76: END LOOP;

Line 73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);

69: /*hr_utility.set_location('g_ssb_codes_table(l_cache_index).element_type_id: ' || g_ssb_codes_table(l_cache_index).element_type_id, 10);
70: hr_utility.set_location('g_ssb_codes_table(l_cache_index).input_value_id: ' || g_ssb_codes_table(l_cache_index).input_value_id, 10);
71: hr_utility.set_location('g_ssb_codes_table(l_cache_index).run_result_id: ' || g_ssb_codes_table(l_cache_index).run_result_id, 10 );
72: hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code: ' || g_ssb_codes_table(l_cache_index).ssb_code, 10);
73: hr_utility.set_location('g_ssb_codes_table(l_cache_index).add_detail: ' || g_ssb_codes_table(l_cache_index).add_detail, 10);
74: */
75: l_cache_index := l_cache_index +1;
76: END LOOP;
77: return 'Y';

Line 95: --hr_utility.set_location('in set next ssb code',10);

91: l_ssb_code:='XXXX';
92:
93: l_cache_index := g_ssb_codes_table.FIRST;
94:
95: --hr_utility.set_location('in set next ssb code',10);
96:
97:
98: WHILE l_cache_index IS NOT NULL
99: LOOP

Line 101: --hr_utility.set_location('in loop l_cache_index' || l_cache_index,10);

97:
98: WHILE l_cache_index IS NOT NULL
99: LOOP
100:
101: --hr_utility.set_location('in loop l_cache_index' || l_cache_index,10);
102: IF ( g_ssb_codes_table(l_cache_index).ssb_code = p_ssb_code )
103: THEN
104: l_ssb_code:=p_ssb_code;
105:

Line 117: --hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code' || g_ssb_codes_table(l_cache_index).ssb_code,10);

113: end if;
114:
115: IF l_ssb_code <> 'XXXX' and g_ssb_codes_table(l_cache_index).ssb_code <> p_ssb_code THEN
116: g_next_ssb_code :=g_ssb_codes_table(l_cache_index).ssb_code;
117: --hr_utility.set_location('g_ssb_codes_table(l_cache_index).ssb_code' || g_ssb_codes_table(l_cache_index).ssb_code,10);
118: return g_next_ssb_code;--g_next_ssb_code;
119: END IF;
120: END LOOP;
121:

Line 123: --hr_utility.set_location('out set next ssb code',10);

119: END IF;
120: END LOOP;
121:
122: g_next_ssb_code := 'NOT FOUND';
123: --hr_utility.set_location('out set next ssb code',10);
124: RETURN 'NOT FOUND';
125:
126: end set_next_cached_code;
127:

Line 203: --hr_utility.set_location('l_run_result_id: ' ||l_run_result_id,10);

199: l_add_detail := g_ssb_codes_table(l_cache_index).add_detail;
200: l_input_value_id := g_ssb_codes_table(l_cache_index).input_value_id;
201: l_run_result_id := g_ssb_codes_table(l_cache_index).run_result_id;
202:
203: --hr_utility.set_location('l_run_result_id: ' ||l_run_result_id,10);
204: --hr_utility.set_location('l_input_value_id: ' ||l_input_value_id,10);
205:
206: -- IF l_add_detail = 'SUMMARY' THEN
207: OPEN csr_sum_results (l_run_result_id, l_input_value_id);

Line 204: --hr_utility.set_location('l_input_value_id: ' ||l_input_value_id,10);

200: l_input_value_id := g_ssb_codes_table(l_cache_index).input_value_id;
201: l_run_result_id := g_ssb_codes_table(l_cache_index).run_result_id;
202:
203: --hr_utility.set_location('l_run_result_id: ' ||l_run_result_id,10);
204: --hr_utility.set_location('l_input_value_id: ' ||l_input_value_id,10);
205:
206: -- IF l_add_detail = 'SUMMARY' THEN
207: OPEN csr_sum_results (l_run_result_id, l_input_value_id);
208: FETCH csr_sum_results INTO l_value;

Line 210: --hr_utility.set_location('l_value: '|| l_value,10);

206: -- IF l_add_detail = 'SUMMARY' THEN
207: OPEN csr_sum_results (l_run_result_id, l_input_value_id);
208: FETCH csr_sum_results INTO l_value;
209: CLOSE csr_sum_results;
210: --hr_utility.set_location('l_value: '|| l_value,10);
211: l_value_sum := l_value_sum + l_value;
212: --hr_utility.set_location('l_value_sum: '|| l_value_sum,10);
213:
214: -- END IF;

Line 212: --hr_utility.set_location('l_value_sum: '|| l_value_sum,10);

208: FETCH csr_sum_results INTO l_value;
209: CLOSE csr_sum_results;
210: --hr_utility.set_location('l_value: '|| l_value,10);
211: l_value_sum := l_value_sum + l_value;
212: --hr_utility.set_location('l_value_sum: '|| l_value_sum,10);
213:
214: -- END IF;
215: --hr_utility.set_location('after end if sum',10);
216:

Line 215: --hr_utility.set_location('after end if sum',10);

211: l_value_sum := l_value_sum + l_value;
212: --hr_utility.set_location('l_value_sum: '|| l_value_sum,10);
213:
214: -- END IF;
215: --hr_utility.set_location('after end if sum',10);
216:
217: l_ssb_code:=p_ssb_code;
218: END IF;
219:

Line 242: --hr_utility.set_location('NVL(g_next_ssb_code): ' || NVL(g_next_ssb_code,'XXXX'), 10);

238:
239: FUNCTION get_next_cached_code RETURN VARCHAR2 IS
240:
241: BEGIN
242: --hr_utility.set_location('NVL(g_next_ssb_code): ' || NVL(g_next_ssb_code,'XXXX'), 10);
243: return NVL(g_next_ssb_code,'XXXX');
244: END get_next_cached_code ;
245:
246: FUNCTION get_current_cached_code RETURN VARCHAR2 IS

Line 273: --hr_utility.set_location('g_cache_index: ' || to_char (g_cache_index), 10);

269: IF g_ssb_codes_table(g_cache_index).ssb_code = NVL(g_current_ssb_code,'XXXX') THEN
270:
271: g_cache_index :=g_ssb_codes_table.NEXT(g_cache_index);
272:
273: --hr_utility.set_location('g_cache_index: ' || to_char (g_cache_index), 10);
274:
275: if g_cache_index is null then
276: exit;
277: end if;

Line 288: hr_utility.set_location('in while loop',10);

284: g_current_ssb_code:= g_ssb_codes_table(g_cache_index).ssb_code;
285: return NVL(g_current_ssb_code,'XXXX') ;
286: END IF;
287:
288: hr_utility.set_location('in while loop',10);
289: END LOOP;
290:
291: END IF;
292:

Line 295: --hr_utility.set_location('NVL(g_current_ssb_code): ' || NVL(g_current_ssb_code,'XXXX'), 10);

291: END IF;
292:
293: -- g_current_ssb_code:= g_ssb_codes_table(g_cache_index).ssb_code;
294:
295: --hr_utility.set_location('NVL(g_current_ssb_code): ' || NVL(g_current_ssb_code,'XXXX'), 10);
296: return NVL(g_current_ssb_code,'XXXX');
297: END get_current_cached_code ;
298:
299: FUNCTION clear_cached_table RETURN VARCHAR2 IS