APPS.HXC_ALIAS_UTILITY dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3:
4:
5: -- initialize the global variable
6:
7: g_debug boolean := hr_utility.debug_enabled;
8: -- Bug 13511713
9: -- New global variable to cache Alias values.
10:
11: TYPE ALIASREC IS RECORD

Line 191: g_debug:=hr_utility.debug_enabled;

187: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
188:
189: BEGIN
190:
191: g_debug:=hr_utility.debug_enabled;
192:
193: -- first we look if the we have already
194: IF g_alias_att_info.exists(1) THEN
195: -- populate the out parameter

Line 226: --hr_utility.trace('l_alias_def_item_tab(l_index_alias_def).alias_definition_id'||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);

222: l_reference_object,
223: l_prompt);
224:
225: --if g_debug then
226: --hr_utility.trace('l_alias_def_item_tab(l_index_alias_def).alias_definition_id'||l_alias_def_item_tab(l_index_alias_def).alias_definition_id);
227: --end if;
228:
229:
230: --IF l_alias_type like 'VALUE_SET%' THEN

Line 567: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);

563:
564: BEGIN
565:
566: --if g_debug then
567: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
568: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
569: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
570: --end if;
571:

Line 568: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);

564: BEGIN
565:
566: --if g_debug then
567: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
568: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
569: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
570: --end if;
571:
572: if p_attribute_to_set = 'ATTRIBUTE_CATEGORY' THEN

Line 569: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);

565:
566: --if g_debug then
567: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
568: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
569: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
570: --end if;
571:
572: if p_attribute_to_set = 'ATTRIBUTE_CATEGORY' THEN
573: IF (p_bld_blk_info_type like 'Dummy%') THEN

Line 683: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);

679: -- get the index string
680: l_index_string := p_tbb_id_reference_table(p_time_building_block_id).ATTRIBUTE_INDEX;
681:
682: --if g_debug then
683: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
684: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
685: --hr_utility.trace('Joel : l_index_string'||l_index_string);
686: --end if;
687:

Line 684: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);

680: l_index_string := p_tbb_id_reference_table(p_time_building_block_id).ATTRIBUTE_INDEX;
681:
682: --if g_debug then
683: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
684: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
685: --hr_utility.trace('Joel : l_index_string'||l_index_string);
686: --end if;
687:
688: -- go through the string and check the to_check

Line 685: --hr_utility.trace('Joel : l_index_string'||l_index_string);

681:
682: --if g_debug then
683: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
684: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
685: --hr_utility.trace('Joel : l_index_string'||l_index_string);
686: --end if;
687:
688: -- go through the string and check the to_check
689: l_index_start:=INSTR(l_index_string,'|',1,1)+1;

Line 1892: --hr_utility.trace('layout_id '||l_layout_id);

1888: -- in the table is different with the parameter we are deleting the
1889: -- table info.
1890:
1891: --if g_debug then
1892: --hr_utility.trace('layout_id '||l_layout_id);
1893: --hr_utility.trace('g_alias_def_item '||g_alias_def_item.first);
1894: --end if;
1895:
1896: l_index_global := g_alias_def_item.first;

Line 1893: --hr_utility.trace('g_alias_def_item '||g_alias_def_item.first);

1889: -- table info.
1890:
1891: --if g_debug then
1892: --hr_utility.trace('layout_id '||l_layout_id);
1893: --hr_utility.trace('g_alias_def_item '||g_alias_def_item.first);
1894: --end if;
1895:
1896: l_index_global := g_alias_def_item.first;
1897:

Line 1937: hr_utility.trace('count '||p_alias_def_item.count);

1933: END IF;
1934: -- finally we return
1935: /*
1936: if g_debug then
1937: hr_utility.trace('count '||p_alias_def_item.count);
1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);

Line 1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);

1934: -- finally we return
1935: /*
1936: if g_debug then
1937: hr_utility.trace('count '||p_alias_def_item.count);
1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);

Line 1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);

1935: /*
1936: if g_debug then
1937: hr_utility.trace('count '||p_alias_def_item.count);
1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);

Line 1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);

1936: if g_debug then
1937: hr_utility.trace('count '||p_alias_def_item.count);
1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);

Line 1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);

1937: hr_utility.trace('count '||p_alias_def_item.count);
1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1945: end if;

Line 1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);

1938: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1945: end if;
1946: */

Line 1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);

1939: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1945: end if;
1946: */
1947: return;

Line 1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);

1940: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1941: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1942: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1943: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1944: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1945: end if;
1946: */
1947: return;
1948: ELSE

Line 2493: --hr_utility.trace_on('','JOEL');

2489: l_pref_index := l_pref_table.next(l_pref_index);
2490:
2491: END LOOP;
2492:
2493: --hr_utility.trace_on('','JOEL');
2494: --hr_utility.trace(' l_timecard_layout_id '||l_timecard_layout_id);
2495:
2496: -- add an extra check at the end of the procedure
2497: -- to make sure the g_comp_label is not null

Line 2494: --hr_utility.trace(' l_timecard_layout_id '||l_timecard_layout_id);

2490:
2491: END LOOP;
2492:
2493: --hr_utility.trace_on('','JOEL');
2494: --hr_utility.trace(' l_timecard_layout_id '||l_timecard_layout_id);
2495:
2496: -- add an extra check at the end of the procedure
2497: -- to make sure the g_comp_label is not null
2498: IF (p_cache_label and g_comp_label.count = 0) THEN

Line 2500: --hr_utility.trace(' inside loop ');

2496: -- add an extra check at the end of the procedure
2497: -- to make sure the g_comp_label is not null
2498: IF (p_cache_label and g_comp_label.count = 0) THEN
2499:
2500: --hr_utility.trace(' inside loop ');
2501:
2502: FOR layout_comp IN csr_lay_alias_comp(l_timecard_layout_id) LOOP
2503:
2504: --l_layout_comp_id := layout_comp.layout_component_id;

Line 2526: --hr_utility.trace_off;

2522:
2523: END LOOP;
2524: END IF;
2525:
2526: --hr_utility.trace_off;
2527:
2528: -- associate the global table to the out parameters
2529: p_alias_def_item := g_alias_def_item;
2530:

Line 3548: --hr_utility.trace('x_select'||x_select);

3544: fnd_message.raise_error;
3545: END IF;
3546:
3547: --if g_debug then
3548: --hr_utility.trace('x_select'||x_select);
3549: --end if;
3550:
3551: END get_otl_an_context_type_select;
3552:

Line 3624: g_debug:=hr_utility.debug_enabled;

3620: l_result VARCHAR2(300);
3621:
3622: BEGIN
3623:
3624: g_debug:=hr_utility.debug_enabled;
3625:
3626: --if g_debug then
3627: --hr_utility.trace('p_select '||p_select);
3628: --end if;

Line 3627: --hr_utility.trace('p_select '||p_select);

3623:
3624: g_debug:=hr_utility.debug_enabled;
3625:
3626: --if g_debug then
3627: --hr_utility.trace('p_select '||p_select);
3628: --end if;
3629:
3630: OPEN c FOR p_select;
3631: FETCH c INTO l_result;

Line 3746: g_debug := hr_utility.debug_enabled;

3742:
3743:
3744: BEGIN
3745:
3746: g_debug := hr_utility.debug_enabled;
3747: l_value := p_original_value;
3748: p_att_to_delete := FALSE;
3749:
3750: -- look for the alias definition information

Line 3754: --hr_utility.trace('p_alias_type'||p_alias_type);

3750: -- look for the alias definition information
3751: -- get the alias attribute values to match with the attribute.
3752:
3753: --if g_debug then
3754: --hr_utility.trace('p_alias_type'||p_alias_type);
3755: --hr_utility.trace('p_alias_definition_id'||p_alias_definition_id);
3756: --end if;
3757:
3758: IF p_alias_type like 'VALUE_SET%' THEN

Line 3755: --hr_utility.trace('p_alias_definition_id'||p_alias_definition_id);

3751: -- get the alias attribute values to match with the attribute.
3752:
3753: --if g_debug then
3754: --hr_utility.trace('p_alias_type'||p_alias_type);
3755: --hr_utility.trace('p_alias_definition_id'||p_alias_definition_id);
3756: --end if;
3757:
3758: IF p_alias_type like 'VALUE_SET%' THEN
3759:

Line 3924: --hr_utility.trace('p_alias_old_value_id'||p_alias_old_value_id);

3920: ELSE
3921: -- little bit more compilcated here.
3922: -- first we need to check what this the next value
3923: --if g_debug then
3924: --hr_utility.trace('p_alias_old_value_id'||p_alias_old_value_id);
3925: --hr_utility.trace('p_original_value'||p_original_value);
3926: --end if;
3927: IF p_original_value is not null THEN
3928: -- find the attribute to match

Line 3925: --hr_utility.trace('p_original_value'||p_original_value);

3921: -- little bit more compilcated here.
3922: -- first we need to check what this the next value
3923: --if g_debug then
3924: --hr_utility.trace('p_alias_old_value_id'||p_alias_old_value_id);
3925: --hr_utility.trace('p_original_value'||p_original_value);
3926: --end if;
3927: IF p_original_value is not null THEN
3928: -- find the attribute to match
3929: get_alias_val_att_to_match

Line 4132: --hr_utility.trace('--------------JOEL START----------------------------');

4128: p_cache_label => TRUE);
4129:
4130: -- now we are getting the attribute to match for the each alias_definition
4131: --if g_debug then
4132: --hr_utility.trace('--------------JOEL START----------------------------');
4133: --end if;
4134: --dump_alias_val_att_to_match(g_comp_label);
4135: --if g_debug then
4136: --hr_utility.trace('--------------JOEL END----------------------------');

Line 4136: --hr_utility.trace('--------------JOEL END----------------------------');

4132: --hr_utility.trace('--------------JOEL START----------------------------');
4133: --end if;
4134: --dump_alias_val_att_to_match(g_comp_label);
4135: --if g_debug then
4136: --hr_utility.trace('--------------JOEL END----------------------------');
4137: --end if;
4138:
4139: l_index_alias_def := l_alias_def_item.first;
4140:

Line 4188: hr_utility.trace('-------STEP 1 ------');

4184: EXIT WHEN
4185: (NOT g_comp_label.exists(l_index_comp));
4186: /*
4187: if g_debug then
4188: hr_utility.trace('-------STEP 1 ------');
4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

Line 4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));

4185: (NOT g_comp_label.exists(l_index_comp));
4186: /*
4187: if g_debug then
4188: hr_utility.trace('-------STEP 1 ------');
4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4193: hr_utility.trace('-------------');

Line 4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));

4186: /*
4187: if g_debug then
4188: hr_utility.trace('-------STEP 1 ------');
4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4193: hr_utility.trace('-------------');
4194: end if;

Line 4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));

4187: if g_debug then
4188: hr_utility.trace('-------STEP 1 ------');
4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4193: hr_utility.trace('-------------');
4194: end if;
4195: */

Line 4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

4188: hr_utility.trace('-------STEP 1 ------');
4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4193: hr_utility.trace('-------------');
4194: end if;
4195: */
4196: IF nvl(upper(l_change_att_cat),-1) =

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

4189: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4190: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4191: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4192: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4193: hr_utility.trace('-------------');
4194: end if;
4195: */
4196: IF nvl(upper(l_change_att_cat),-1) =
4197: nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1)

Line 4204: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);

4200: -- populate the field name
4201: p_attr_change_table(l_index_change_att).field_name :=
4202: g_comp_label(l_index_comp).ATTRIBUTE1;
4203: --if g_debug then
4204: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);
4205: --end if;
4206: END IF;
4207:
4208: l_index_comp := g_comp_label.next(l_index_comp);

Line 4254: hr_utility.trace('-------STEP 2------');

4250: EXIT WHEN
4251: (NOT g_comp_label.exists(l_index_comp));
4252: /*
4253: if g_debug then
4254: hr_utility.trace('-------STEP 2------');
4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

Line 4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));

4251: (NOT g_comp_label.exists(l_index_comp));
4252: /*
4253: if g_debug then
4254: hr_utility.trace('-------STEP 2------');
4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4259: hr_utility.trace('-------------');

Line 4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));

4252: /*
4253: if g_debug then
4254: hr_utility.trace('-------STEP 2------');
4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4259: hr_utility.trace('-------------');
4260: end if;

Line 4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));

4253: if g_debug then
4254: hr_utility.trace('-------STEP 2------');
4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4259: hr_utility.trace('-------------');
4260: end if;
4261: */

Line 4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

4254: hr_utility.trace('-------STEP 2------');
4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4259: hr_utility.trace('-------------');
4260: end if;
4261: */
4262:

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

4255: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
4256: hr_utility.trace('upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT '||nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1));
4257: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
4258: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
4259: hr_utility.trace('-------------');
4260: end if;
4261: */
4262:
4263: IF nvl(upper(l_change_att_cat),-1)

Line 4271: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);

4267: -- populate the field name
4268: p_attr_change_table(l_index_change_att).field_name :=
4269: g_comp_label(l_index_comp).ATTRIBUTE1;
4270: --if g_debug then
4271: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);
4272: --end if;
4273: END IF;
4274:
4275: l_index_comp := g_comp_label.next(l_index_comp);

Line 4286: --hr_utility.trace('--------------JOEL END---------------------------');

4282:
4283: END IF;
4284:
4285: --if g_debug then
4286: --hr_utility.trace('--------------JOEL END---------------------------');
4287: --end if;
4288:
4289: /*
4290: FOR I IN 1..p_attr_change_table.COUNT LOOP

Line 4292: hr_utility.trace(' catg ='|| p_attr_change_table(i).attribute_category ||

4288:
4289: /*
4290: FOR I IN 1..p_attr_change_table.COUNT LOOP
4291: if g_debug then
4292: hr_utility.trace(' catg ='|| p_attr_change_table(i).attribute_category ||
4293: ' changed ='|| p_attr_change_table(i).changed_attribute ||
4294: ' field name ='|| p_attr_change_table(i).field_name ||
4295: ' org_att_catg ='|| p_attr_change_table(i).org_attribute_category ||
4296: ' org_changed_attr ='|| p_attr_change_table(i).ORG_changed_attribute

Line 4432: g_debug := hr_utility.debug_enabled;

4428:
4429: BEGIN
4430:
4431: l_index := p_alias_val_att_to_match.first;
4432: g_debug := hr_utility.debug_enabled;
4433: LOOP
4434: EXIT WHEN
4435: (NOT p_alias_val_att_to_match.exists(l_index));
4436: /*

Line 4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');

4434: EXIT WHEN
4435: (NOT p_alias_val_att_to_match.exists(l_index));
4436: /*
4437: if g_debug then
4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

Line 4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);

4435: (NOT p_alias_val_att_to_match.exists(l_index));
4436: /*
4437: if g_debug then
4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

Line 4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);

4436: /*
4437: if g_debug then
4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

Line 4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);

4437: if g_debug then
4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

Line 4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

4438: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

Line 4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

4439: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

Line 4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

4440: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

Line 4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

4441: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

Line 4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

4442: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

Line 4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

4443: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

Line 4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

4444: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

Line 4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

4445: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

Line 4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

4446: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

Line 4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

4447: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4455: end if;

Line 4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

4448: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4455: end if;
4456: */

Line 4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

4449: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4455: end if;
4456: */
4457: if g_debug then

Line 4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

4450: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4451: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4452: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4453: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4455: end if;
4456: */
4457: if g_debug then
4458: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);

Line 4458: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);

4454: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4455: end if;
4456: */
4457: if g_debug then
4458: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);
4459: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4460: end if;
4461: /*
4462: dbms_output.put_line('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');

Line 4459: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);

4455: end if;
4456: */
4457: if g_debug then
4458: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);
4459: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4460: end if;
4461: /*
4462: dbms_output.put_line('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4463: dbms_output.put_line('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);

Line 4501: g_debug :=hr_utility.debug_enabled;

4497:
4498: BEGIN
4499:
4500: l_index := p_attributes.first;
4501: g_debug :=hr_utility.debug_enabled;
4502: LOOP
4503: EXIT WHEN
4504: (NOT p_attributes.exists(l_index));
4505:

Line 4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');

4504: (NOT p_attributes.exists(l_index));
4505:
4506: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4507: if g_debug then
4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);

Line 4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);

4505:
4506: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4507: if g_debug then
4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);

Line 4510: hr_utility.trace('index:'||l_index);

4506: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4507: if g_debug then
4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);

Line 4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);

4507: if g_debug then
4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);

Line 4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);

4508: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);

Line 4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);

4509: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);

Line 4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);

4510: hr_utility.trace('index:'||l_index);
4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);

Line 4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);

4511: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);

Line 4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);

4512: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);

Line 4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);

4513: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);

Line 4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);

4514: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);

Line 4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);

4515: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);

Line 4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);

4516: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);

Line 4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);

4517: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);

Line 4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);

4518: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);

Line 4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);

4519: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);

Line 4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);

4520: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);

Line 4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);

4521: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);

Line 4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);

4522: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);

Line 4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);

4523: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);

Line 4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);

4524: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);

Line 4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);

4525: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);

Line 4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);

4526: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);

Line 4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);

4527: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);

Line 4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);

4528: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);

Line 4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);

4529: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);

Line 4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);

4530: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);

Line 4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);

4531: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);

Line 4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);

4532: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);

Line 4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);

4533: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);

Line 4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);

4534: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);

Line 4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);

4535: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);

Line 4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);

4536: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);

Line 4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);

4537: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);

Line 4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);

4538: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);

Line 4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);

4539: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4547: end if;

Line 4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);

4540: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4547: end if;
4548: END IF;

Line 4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);

4541: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4547: end if;
4548: END IF;
4549:

Line 4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);

4542: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4543: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4544: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4545: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4546: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4547: end if;
4548: END IF;
4549:
4550: l_index := p_attributes.next(l_index);

Line 4570: g_debug := hr_utility.debug_enabled;

4566: BEGIN
4567: --null;
4568:
4569: l_index := p_alias_def_item.first;
4570: g_debug := hr_utility.debug_enabled;
4571:
4572: LOOP
4573: EXIT WHEN
4574: (NOT p_alias_def_item.exists(l_index));

Line 4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');

4573: EXIT WHEN
4574: (NOT p_alias_def_item.exists(l_index));
4575: /*
4576: if g_debug then
4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

Line 4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);

4574: (NOT p_alias_def_item.exists(l_index));
4575: /*
4576: if g_debug then
4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

Line 4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);

4575: /*
4576: if g_debug then
4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

Line 4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);

4576: if g_debug then
4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

Line 4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

4577: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

Line 4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

4578: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

Line 4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

4579: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

Line 4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

4580: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

Line 4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

4581: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

Line 4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

4582: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

Line 4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

4583: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

Line 4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

4584: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

Line 4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

4585: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

Line 4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

4586: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);

Line 4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

4587: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4595: end if;

Line 4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

4588: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4595: end if;
4596: */

Line 4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

4589: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4595: end if;
4596: */
4597: if g_debug then

Line 4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);

4590: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4591: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4592: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4593: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4595: end if;
4596: */
4597: if g_debug then
4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');

Line 4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');

4594: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4595: end if;
4596: */
4597: if g_debug then
4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4599: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4600: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4601: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4602: end if;

Line 4599: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);

4595: end if;
4596: */
4597: if g_debug then
4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4599: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4600: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4601: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4602: end if;
4603:

Line 4600: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);

4596: */
4597: if g_debug then
4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4599: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4600: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4601: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4602: end if;
4603:
4604: l_index := p_alias_def_item.next(l_index);

Line 4601: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);

4597: if g_debug then
4598: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4599: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4600: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4601: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4602: end if;
4603:
4604: l_index := p_alias_def_item.next(l_index);
4605: END LOOP;