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

Line 4: g_debug boolean:= hr_utility.debug_enabled;

1: PACKAGE BODY HXC_ALIAS_TRANSLATOR AS
2: /* $Header: hxcalttlr.pkb 120.8.12020000.2 2012/07/04 09:12:44 amnaraya ship $ */
3:
4: g_debug boolean:= hr_utility.debug_enabled;
5:
6: -- Bug 13511713
7: CURSOR g_csr_alias_values
8: IS

Line 66: g_debug:=hr_utility.debug_enabled;

62: --l_number_column_id NUMBER;
63:
64: BEGIN
65:
66: g_debug:=hr_utility.debug_enabled;
67:
68: if g_debug then
69: hr_utility.trace('BEFORE DEPOSIT');
70: end if;

Line 69: hr_utility.trace('BEFORE DEPOSIT');

65:
66: g_debug:=hr_utility.debug_enabled;
67:
68: if g_debug then
69: hr_utility.trace('BEFORE DEPOSIT');
70: end if;
71: --hxc_alias_utility.dump_bb_attribute_info(p_attributes);
72: if g_debug then
73: hr_utility.trace('------------------------');

Line 73: hr_utility.trace('------------------------');

69: hr_utility.trace('BEFORE DEPOSIT');
70: end if;
71: --hxc_alias_utility.dump_bb_attribute_info(p_attributes);
72: if g_debug then
73: hr_utility.trace('------------------------');
74: hr_utility.trace('------------------------');
75: hr_utility.trace('------------------------');
76: end if;
77:

Line 74: hr_utility.trace('------------------------');

70: end if;
71: --hxc_alias_utility.dump_bb_attribute_info(p_attributes);
72: if g_debug then
73: hr_utility.trace('------------------------');
74: hr_utility.trace('------------------------');
75: hr_utility.trace('------------------------');
76: end if;
77:
78: -- create the reference attribute index table for each tbb_id

Line 75: hr_utility.trace('------------------------');

71: --hxc_alias_utility.dump_bb_attribute_info(p_attributes);
72: if g_debug then
73: hr_utility.trace('------------------------');
74: hr_utility.trace('------------------------');
75: hr_utility.trace('------------------------');
76: end if;
77:
78: -- create the reference attribute index table for each tbb_id
79: hxc_alias_utility.get_tbb_id_reference_table

Line 99: hr_utility.trace('Joel : l_neg_attribute_id'||l_neg_attribute_id);

95: hxc_alias_utility.get_next_negative_attribute_id
96: (p_attributes => p_attributes);
97:
98: if g_debug then
99: hr_utility.trace('Joel : l_neg_attribute_id'||l_neg_attribute_id);
100: end if;
101:
102: -- now we are going to every attribute and if we need to we are doing the translation
103: l_index_attribute := p_attributes.first;

Line 114: hr_utility.trace('Joel : p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY'||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);

110: l_alias_old_value_id := NULL;
111: --l_alias_value_id := NULL;
112:
113: if g_debug then
114: hr_utility.trace('Joel : p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY'||p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY);
115: end if;
116:
117: -- we found an attribute to translate
118: IF (p_attributes(l_index_attribute).ATTRIBUTE_CATEGORY like 'OTL_ALIAS%') THEN

Line 126: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);

122: l_time_building_block_id := p_attributes(l_index_attribute).BUILDING_BLOCK_ID;
123: l_changed := p_attributes(l_index_attribute).CHANGED;
124:
125: if g_debug then
126: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
127: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
128: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
129: end if;
130:

Line 127: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);

123: l_changed := p_attributes(l_index_attribute).CHANGED;
124:
125: if g_debug then
126: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
127: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
128: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
129: end if;
130:
131: --l_alias_value_id := p_attributes(l_index_attribute).ATTRIBUTE1;

Line 128: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);

124:
125: if g_debug then
126: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
127: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
128: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
129: end if;
130:
131: --l_alias_value_id := p_attributes(l_index_attribute).ATTRIBUTE1;
132: -- look for the alias_definition_id associated

Line 152: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);

148: p_prompt => l_prompt);
149: END IF;
150:
151: if g_debug then
152: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
153: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
154: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
155: end if;
156:

Line 153: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);

149: END IF;
150:
151: if g_debug then
152: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
153: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
154: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
155: end if;
156:
157: IF l_alias_type = 'OTL_ALT_DDF' THEN

Line 154: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);

150:
151: if g_debug then
152: hr_utility.trace('l_alias_definition_id'||p_attributes(l_index_attribute).ATTRIBUTE2);
153: hr_utility.trace('l_alias_old_value_id'||p_attributes(l_index_attribute).ATTRIBUTE3);
154: hr_utility.trace('l_alias_type'||p_attributes(l_index_attribute).ATTRIBUTE4);
155: end if;
156:
157: IF l_alias_type = 'OTL_ALT_DDF' THEN
158: l_alias_old_value_id := to_number(p_attributes(l_index_attribute).ATTRIBUTE3);

Line 180: hr_utility.trace('before debug table');

176: -- debug
177: --
178:
179: if g_debug then
180: hr_utility.trace('before debug table');
181: end if;
182:
183: --hxc_alias_utility.dump_alias_val_att_to_match(l_alias_val_att_to_match);
184:

Line 186: hr_utility.trace('After debug table');

182:
183: --hxc_alias_utility.dump_alias_val_att_to_match(l_alias_val_att_to_match);
184:
185: if g_debug then
186: hr_utility.trace('After debug table');
187: end if;
188:
189: -- look for the attribute if the bld_blk_exists in the attributes table
190: -- already.

Line 220: hr_utility.trace('l_bld_blk_info_type_id '||l_bld_blk_info_type_id);

216: ,p_attribute_found => l_attribute_found
217: );
218:
219: if g_debug then
220: hr_utility.trace('l_bld_blk_info_type_id '||l_bld_blk_info_type_id);
221: hr_utility.trace('l_bld_blk_info_type '||l_bld_blk_info_type);
222: end if;
223: -- now we need to check if we need to create an attribute or do an update
224: IF l_attribute_found = FALSE AND l_att_to_delete = FALSE THEN

Line 221: hr_utility.trace('l_bld_blk_info_type '||l_bld_blk_info_type);

217: );
218:
219: if g_debug then
220: hr_utility.trace('l_bld_blk_info_type_id '||l_bld_blk_info_type_id);
221: hr_utility.trace('l_bld_blk_info_type '||l_bld_blk_info_type);
222: end if;
223: -- now we need to check if we need to create an attribute or do an update
224: IF l_attribute_found = FALSE AND l_att_to_delete = FALSE THEN
225:

Line 227: hr_utility.trace('create');

223: -- now we need to check if we need to create an attribute or do an update
224: IF l_attribute_found = FALSE AND l_att_to_delete = FALSE THEN
225:
226: if g_debug then
227: hr_utility.trace('create');
228: end if;
229: l_neg_attribute_id := l_neg_attribute_id -1;
230:
231: p_attributes.extend;

Line 292: hr_utility.trace('l_last_attribute '||l_last_attribute);

288: */
289:
290: -- now we need to place the id of this alias at the right place
291: if g_debug then
292: hr_utility.trace('l_last_attribute '||l_last_attribute);
293: hr_utility.trace('l_segment '||l_segment);
294: hr_utility.trace('p_value_to_set '||l_value);
295: end if;
296:

Line 293: hr_utility.trace('l_segment '||l_segment);

289:
290: -- now we need to place the id of this alias at the right place
291: if g_debug then
292: hr_utility.trace('l_last_attribute '||l_last_attribute);
293: hr_utility.trace('l_segment '||l_segment);
294: hr_utility.trace('p_value_to_set '||l_value);
295: end if;
296:
297: hxc_alias_utility.set_attribute_information

Line 294: hr_utility.trace('p_value_to_set '||l_value);

290: -- now we need to place the id of this alias at the right place
291: if g_debug then
292: hr_utility.trace('l_last_attribute '||l_last_attribute);
293: hr_utility.trace('l_segment '||l_segment);
294: hr_utility.trace('p_value_to_set '||l_value);
295: end if;
296:
297: hxc_alias_utility.set_attribute_information
298: (p_attributes => p_attributes,

Line 318: hr_utility.trace('l_segment'||l_segment);

314: ELSE
315: IF (l_attribute_found) THEN
316:
317: if g_debug then
318: hr_utility.trace('l_segment'||l_segment);
319: hr_utility.trace('l_value'||l_value);
320: hr_utility.trace('l_changed'||l_changed);
321: end if;
322: -- update the attribute

Line 319: hr_utility.trace('l_value'||l_value);

315: IF (l_attribute_found) THEN
316:
317: if g_debug then
318: hr_utility.trace('l_segment'||l_segment);
319: hr_utility.trace('l_value'||l_value);
320: hr_utility.trace('l_changed'||l_changed);
321: end if;
322: -- update the attribute
323: -- now we need to place the id of this alias at the right place

Line 320: hr_utility.trace('l_changed'||l_changed);

316:
317: if g_debug then
318: hr_utility.trace('l_segment'||l_segment);
319: hr_utility.trace('l_value'||l_value);
320: hr_utility.trace('l_changed'||l_changed);
321: end if;
322: -- update the attribute
323: -- now we need to place the id of this alias at the right place
324: IF l_att_to_delete = FALSE THEN

Line 332: hr_utility.trace('DELETE');

328: p_attribute_to_set => l_segment,
329: p_value_to_set => l_value);
330: ELSE
331: if g_debug then
332: hr_utility.trace('DELETE');
333: hr_utility.trace('l_attribute_index'||l_attribute_index);
334: hr_utility.trace('l_changed'||l_changed);
335: end if;
336: hxc_alias_utility.set_attribute_information

Line 333: hr_utility.trace('l_attribute_index'||l_attribute_index);

329: p_value_to_set => l_value);
330: ELSE
331: if g_debug then
332: hr_utility.trace('DELETE');
333: hr_utility.trace('l_attribute_index'||l_attribute_index);
334: hr_utility.trace('l_changed'||l_changed);
335: end if;
336: hxc_alias_utility.set_attribute_information
337: (p_attributes => p_attributes,

Line 334: hr_utility.trace('l_changed'||l_changed);

330: ELSE
331: if g_debug then
332: hr_utility.trace('DELETE');
333: hr_utility.trace('l_attribute_index'||l_attribute_index);
334: hr_utility.trace('l_changed'||l_changed);
335: end if;
336: hxc_alias_utility.set_attribute_information
337: (p_attributes => p_attributes,
338: p_index_in_table => l_attribute_index,

Line 349: hr_utility.trace('p_attributes(l_attribute_index).CHANGED'||p_attributes(l_attribute_index).CHANGED);

345: p_attributes(l_attribute_index).CHANGED :=
346: nvl(l_changed,p_attributes(l_attribute_index).CHANGED);
347: END IF;
348: if g_debug then
349: hr_utility.trace('p_attributes(l_attribute_index).CHANGED'||p_attributes(l_attribute_index).CHANGED);
350: end if;
351: END IF;
352:
353: END IF;

Line 384: hr_utility.trace(' AFTER TRANSLATION');

380: --
381: -- debug
382: --
383: if g_debug then
384: hr_utility.trace(' AFTER TRANSLATION');
385: end if;
386:
387: --hxc_alias_utility.dump_bb_attribute_info(p_attributes);
388:

Line 1048: g_debug:=hr_utility.debug_enabled;

1044: c_alias_value csr_alias_values%ROWTYPE;
1045:
1046: BEGIN
1047:
1048: g_debug:=hr_utility.debug_enabled;
1049:
1050:
1051: if g_debug then
1052: hr_utility.trace('p_start_time '||p_start_time);

Line 1052: hr_utility.trace('p_start_time '||p_start_time);

1048: g_debug:=hr_utility.debug_enabled;
1049:
1050:
1051: if g_debug then
1052: hr_utility.trace('p_start_time '||p_start_time);
1053: hr_utility.trace('p_stop_time '||p_stop_time);
1054: hr_utility.trace('p_resource_id '||p_resource_id);
1055: hr_utility.trace('p_processing_mode '||p_processing_mode);
1056: hr_utility.trace(dbms_utility.format_call_stack);

Line 1053: hr_utility.trace('p_stop_time '||p_stop_time);

1049:
1050:
1051: if g_debug then
1052: hr_utility.trace('p_start_time '||p_start_time);
1053: hr_utility.trace('p_stop_time '||p_stop_time);
1054: hr_utility.trace('p_resource_id '||p_resource_id);
1055: hr_utility.trace('p_processing_mode '||p_processing_mode);
1056: hr_utility.trace(dbms_utility.format_call_stack);
1057: end if;

Line 1054: hr_utility.trace('p_resource_id '||p_resource_id);

1050:
1051: if g_debug then
1052: hr_utility.trace('p_start_time '||p_start_time);
1053: hr_utility.trace('p_stop_time '||p_stop_time);
1054: hr_utility.trace('p_resource_id '||p_resource_id);
1055: hr_utility.trace('p_processing_mode '||p_processing_mode);
1056: hr_utility.trace(dbms_utility.format_call_stack);
1057: end if;
1058:

Line 1055: hr_utility.trace('p_processing_mode '||p_processing_mode);

1051: if g_debug then
1052: hr_utility.trace('p_start_time '||p_start_time);
1053: hr_utility.trace('p_stop_time '||p_stop_time);
1054: hr_utility.trace('p_resource_id '||p_resource_id);
1055: hr_utility.trace('p_processing_mode '||p_processing_mode);
1056: hr_utility.trace(dbms_utility.format_call_stack);
1057: end if;
1058:
1059: --p_attributes := hxc_alias_utility.convert_attribute_to_type(p_attributes_tmp);

Line 1056: hr_utility.trace(dbms_utility.format_call_stack);

1052: hr_utility.trace('p_start_time '||p_start_time);
1053: hr_utility.trace('p_stop_time '||p_stop_time);
1054: hr_utility.trace('p_resource_id '||p_resource_id);
1055: hr_utility.trace('p_processing_mode '||p_processing_mode);
1056: hr_utility.trace(dbms_utility.format_call_stack);
1057: end if;
1058:
1059: --p_attributes := hxc_alias_utility.convert_attribute_to_type(p_attributes_tmp);
1060: --p_blocks := hxc_alias_utility.convert_timecard_to_type(p_blocks_tmp);

Line 1119: hr_utility.trace('count '||l_alias_def_item_tab.count);

1115: p_start_time => l_start_time,
1116: p_stop_time => l_stop_time);
1117: /*
1118: if g_debug then
1119: hr_utility.trace('count '||l_alias_def_item_tab.count);
1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);

Line 1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);

1116: p_stop_time => l_stop_time);
1117: /*
1118: if g_debug then
1119: hr_utility.trace('count '||l_alias_def_item_tab.count);
1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);

Line 1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);

1117: /*
1118: if g_debug then
1119: hr_utility.trace('count '||l_alias_def_item_tab.count);
1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);

Line 1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);

1118: if g_debug then
1119: hr_utility.trace('count '||l_alias_def_item_tab.count);
1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);
1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);

Line 1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);

1119: hr_utility.trace('count '||l_alias_def_item_tab.count);
1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);
1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);
1127: end if;

Line 1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);

1120: hr_utility.trace('ALIAS_DEFINITION_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_DEFINITION_ID);
1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);
1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);
1127: end if;
1128: */

Line 1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);

1121: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||l_alias_def_item_tab(l_alias_def_item_tab.first).ITEM_ATTRIBUTE_CATEGORY);
1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);
1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);
1127: end if;
1128: */
1129: ELSIF p_processing_mode = HXC_ALIAS_UTILITY.c_tk_processing THEN

Line 1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);

1122: hr_utility.trace('RESOURCE_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).RESOURCE_ID);
1123: hr_utility.trace('LAYOUT_ID '||l_alias_def_item_tab(l_alias_def_item_tab.first).LAYOUT_ID);
1124: hr_utility.trace('ALIAS_LABEL '||l_alias_def_item_tab(l_alias_def_item_tab.first).ALIAS_LABEL);
1125: hr_utility.trace('PREF_START_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_START_DATE);
1126: hr_utility.trace('PREF_END_DATE '||l_alias_def_item_tab(l_alias_def_item_tab.first).PREF_END_DATE);
1127: end if;
1128: */
1129: ELSIF p_processing_mode = HXC_ALIAS_UTILITY.c_tk_processing THEN
1130: -- get from the timekeeper preference the list of alias definition

Line 1153: hr_utility.trace('Came here , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);

1149: (NOT l_alias_def_item_tab.exists(l_index_alias_def));
1150:
1151: IF g_debug
1152: THEN
1153: hr_utility.trace('Came here , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1154: END IF;
1155:
1156: -- get the type of the alias
1157: -- we need find out the information following the type of the alias

Line 1189: hr_utility.trace

1185: -- ('l_alias_type: '||l_alias_type);
1186: --dbms_output.put_line
1187: -- ('l_reference_object: '||l_reference_object);
1188: if g_debug then
1189: hr_utility.trace
1190: ('l_alias_def_item_tab(l_index_alias_def).alias_definition_id: '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1191: hr_utility.trace
1192: ('l_alias_type: '||l_alias_type);
1193: hr_utility.trace

Line 1191: hr_utility.trace

1187: -- ('l_reference_object: '||l_reference_object);
1188: if g_debug then
1189: hr_utility.trace
1190: ('l_alias_def_item_tab(l_index_alias_def).alias_definition_id: '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1191: hr_utility.trace
1192: ('l_alias_type: '||l_alias_type);
1193: hr_utility.trace
1194: ('l_reference_object: '||l_reference_object);
1195: end if;

Line 1193: hr_utility.trace

1189: hr_utility.trace
1190: ('l_alias_def_item_tab(l_index_alias_def).alias_definition_id: '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1191: hr_utility.trace
1192: ('l_alias_type: '||l_alias_type);
1193: hr_utility.trace
1194: ('l_reference_object: '||l_reference_object);
1195: end if;
1196:
1197: --reset the table.

Line 1214: hr_utility.trace('Came here again , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);

1210: -- again and again.
1211:
1212: IF g_debug
1213: THEN
1214: hr_utility.trace('Came here again , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1215: hr_utility.trace('Came here again date '||l_start_time);
1216: hr_utility.trace('Came here again date '||l_stop_time);
1217: END IF;
1218:

Line 1215: hr_utility.trace('Came here again date '||l_start_time);

1211:
1212: IF g_debug
1213: THEN
1214: hr_utility.trace('Came here again , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1215: hr_utility.trace('Came here again date '||l_start_time);
1216: hr_utility.trace('Came here again date '||l_stop_time);
1217: END IF;
1218:
1219: -- Create the inded for the Cache table by concatenating alias_def_id and dates.

Line 1216: hr_utility.trace('Came here again date '||l_stop_time);

1212: IF g_debug
1213: THEN
1214: hr_utility.trace('Came here again , Alias is '||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
1215: hr_utility.trace('Came here again date '||l_start_time);
1216: hr_utility.trace('Came here again date '||l_stop_time);
1217: END IF;
1218:
1219: -- Create the inded for the Cache table by concatenating alias_def_id and dates.
1220:

Line 1224: hr_utility.trace('Array index = '||l_array_index);

1220:
1221: l_array_index := to_char(l_alias_def_item_tab(l_index_alias_def).alias_definition_id)
1222: ||'-'||to_char(l_start_time,'yyyymmdd')
1223: ||'-'||to_char(l_stop_time,'yyyymmdd');
1224: hr_utility.trace('Array index = '||l_array_index);
1225:
1226: -- If the cache does not exist already,
1227:
1228: IF NOT g_ad_avtab.EXISTS(l_array_index)

Line 1231: hr_utility.trace('Picking up for '||l_array_index);

1227:
1228: IF NOT g_ad_avtab.EXISTS(l_array_index)
1229: THEN
1230:
1231: hr_utility.trace('Picking up for '||l_array_index);
1232:
1233: OPEN csr_alias_values(l_alias_def_item_tab(l_index_alias_def).alias_definition_id,
1234: l_start_time,
1235: l_stop_time);

Line 1243: hr_utility.trace('Using Cache here '||l_array_index);

1239: CLOSE csr_alias_values;
1240: -- If it exists, we will use cache.
1241: ELSE
1242:
1243: hr_utility.trace('Using Cache here '||l_array_index);
1244:
1245: END IF;
1246:
1247: IF g_ad_avtab.EXISTS(l_array_index)

Line 1266: hr_utility.trace

1262: ----dbms_output.put_line
1263: -- ('c_alias_value.alias_value_id: '||c_alias_value.alias_value_id);
1264:
1265: if g_debug then
1266: hr_utility.trace
1267: ('c_alias_value.alias_value_id: '||c_alias_value.alias_value_id);
1268: end if;
1269:
1270: --hxc_alias_utility.dump_alias_val_att_to_match( l_alias_val_att_to_match);

Line 1328: hr_utility.trace

1324: ----dbms_output.put_line
1325: -- ('c_alias_value.alias_value_id: '||c_alias_value.alias_value_id);
1326:
1327: if g_debug then
1328: hr_utility.trace
1329: ('c_alias_value.alias_value_id: '||c_alias_value.alias_value_id);
1330: end if;
1331:
1332: --hxc_alias_utility.dump_alias_val_att_to_match( l_alias_val_att_to_match);