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:
9: PROCEDURE initialize IS
10:
11: BEGIN

Line 127: g_debug:=hr_utility.debug_enabled;

123: l_prompt hxc_alias_definitions_tl.prompt%TYPE;
124:
125: BEGIN
126:
127: g_debug:=hr_utility.debug_enabled;
128:
129: -- first we look if the we have already
130: IF g_alias_att_info.exists(1) THEN
131: -- populate the out parameter

Line 162: --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);

158: l_reference_object,
159: l_prompt);
160:
161: --if g_debug then
162: --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);
163: --end if;
164:
165:
166: --IF l_alias_type like 'VALUE_SET%' THEN

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

499:
500: BEGIN
501:
502: --if g_debug then
503: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
504: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
505: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
506: --end if;
507:

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

500: BEGIN
501:
502: --if g_debug then
503: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
504: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
505: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
506: --end if;
507:
508: if p_attribute_to_set = 'ATTRIBUTE_CATEGORY' THEN

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

501:
502: --if g_debug then
503: --hr_utility.trace('p_bld_blk_info_type :'||p_bld_blk_info_type);
504: --hr_utility.trace('p_mapping_att_cat :'||p_mapping_att_cat);
505: --hr_utility.trace('p_attribute_to_set :'||p_attribute_to_set);
506: --end if;
507:
508: if p_attribute_to_set = 'ATTRIBUTE_CATEGORY' THEN
509: IF (p_bld_blk_info_type like 'Dummy%') THEN

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

615: -- get the index string
616: l_index_string := p_tbb_id_reference_table(p_time_building_block_id).ATTRIBUTE_INDEX;
617:
618: --if g_debug then
619: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
620: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
621: --hr_utility.trace('Joel : l_index_string'||l_index_string);
622: --end if;
623:

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

616: l_index_string := p_tbb_id_reference_table(p_time_building_block_id).ATTRIBUTE_INDEX;
617:
618: --if g_debug then
619: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
620: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
621: --hr_utility.trace('Joel : l_index_string'||l_index_string);
622: --end if;
623:
624: -- go through the string and check the to_check

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

617:
618: --if g_debug then
619: --hr_utility.trace('Joel : p_bld_blk_info_type_id'||p_bld_blk_info_type_id);
620: --hr_utility.trace('Joel : p_time_building_block_id'||p_time_building_block_id);
621: --hr_utility.trace('Joel : l_index_string'||l_index_string);
622: --end if;
623:
624: -- go through the string and check the to_check
625: l_index_start:=INSTR(l_index_string,'|',1,1)+1;

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

1572: -- in the table is different with the parameter we are deleting the
1573: -- table info.
1574:
1575: --if g_debug then
1576: --hr_utility.trace('layout_id '||l_layout_id);
1577: --hr_utility.trace('g_alias_def_item '||g_alias_def_item.first);
1578: --end if;
1579:
1580: l_index_global := g_alias_def_item.first;

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

1573: -- table info.
1574:
1575: --if g_debug then
1576: --hr_utility.trace('layout_id '||l_layout_id);
1577: --hr_utility.trace('g_alias_def_item '||g_alias_def_item.first);
1578: --end if;
1579:
1580: l_index_global := g_alias_def_item.first;
1581:

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

1617: END IF;
1618: -- finally we return
1619: /*
1620: if g_debug then
1621: hr_utility.trace('count '||p_alias_def_item.count);
1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);

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

1618: -- finally we return
1619: /*
1620: if g_debug then
1621: hr_utility.trace('count '||p_alias_def_item.count);
1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);

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

1619: /*
1620: if g_debug then
1621: hr_utility.trace('count '||p_alias_def_item.count);
1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);

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

1620: if g_debug then
1621: hr_utility.trace('count '||p_alias_def_item.count);
1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1628: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);

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

1621: hr_utility.trace('count '||p_alias_def_item.count);
1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1628: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1629: end if;

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

1622: hr_utility.trace('ALIAS_DEFINITION_ID '||p_alias_def_item(p_alias_def_item.first).ALIAS_DEFINITION_ID);
1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1628: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1629: end if;
1630: */

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

1623: hr_utility.trace('ITEM_ATTRIBUTE_CATEGORY '||p_alias_def_item(p_alias_def_item.first).ITEM_ATTRIBUTE_CATEGORY);
1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1628: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1629: end if;
1630: */
1631: return;

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

1624: hr_utility.trace('RESOURCE_ID '||p_alias_def_item(p_alias_def_item.first).RESOURCE_ID);
1625: hr_utility.trace('LAYOUT_ID '||p_alias_def_item(p_alias_def_item.first).LAYOUT_ID);
1626: hr_utility.trace('ALIAS_LABEL '||p_alias_def_item(p_alias_def_item.first).ALIAS_LABEL);
1627: hr_utility.trace('PREF_START_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_START_DATE);
1628: hr_utility.trace('PREF_END_DATE '||p_alias_def_item(p_alias_def_item.first).PREF_END_DATE);
1629: end if;
1630: */
1631: return;
1632: ELSE

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

2173: l_pref_index := l_pref_table.next(l_pref_index);
2174:
2175: END LOOP;
2176:
2177: --hr_utility.trace_on('','JOEL');
2178: --hr_utility.trace(' l_timecard_layout_id '||l_timecard_layout_id);
2179:
2180: -- add an extra check at the end of the procedure
2181: -- to make sure the g_comp_label is not null

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

2174:
2175: END LOOP;
2176:
2177: --hr_utility.trace_on('','JOEL');
2178: --hr_utility.trace(' l_timecard_layout_id '||l_timecard_layout_id);
2179:
2180: -- add an extra check at the end of the procedure
2181: -- to make sure the g_comp_label is not null
2182: IF (p_cache_label and g_comp_label.count = 0) THEN

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

2180: -- add an extra check at the end of the procedure
2181: -- to make sure the g_comp_label is not null
2182: IF (p_cache_label and g_comp_label.count = 0) THEN
2183:
2184: --hr_utility.trace(' inside loop ');
2185:
2186: FOR layout_comp IN csr_lay_alias_comp(l_timecard_layout_id) LOOP
2187:
2188: --l_layout_comp_id := layout_comp.layout_component_id;

Line 2210: --hr_utility.trace_off;

2206:
2207: END LOOP;
2208: END IF;
2209:
2210: --hr_utility.trace_off;
2211:
2212: -- associate the global table to the out parameters
2213: p_alias_def_item := g_alias_def_item;
2214:

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

3228: fnd_message.raise_error;
3229: END IF;
3230:
3231: --if g_debug then
3232: --hr_utility.trace('x_select'||x_select);
3233: --end if;
3234:
3235: END get_otl_an_context_type_select;
3236:

Line 3308: g_debug:=hr_utility.debug_enabled;

3304: l_result VARCHAR2(300);
3305:
3306: BEGIN
3307:
3308: g_debug:=hr_utility.debug_enabled;
3309:
3310: --if g_debug then
3311: --hr_utility.trace('p_select '||p_select);
3312: --end if;

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

3307:
3308: g_debug:=hr_utility.debug_enabled;
3309:
3310: --if g_debug then
3311: --hr_utility.trace('p_select '||p_select);
3312: --end if;
3313:
3314: OPEN c FOR p_select;
3315: FETCH c INTO l_result;

Line 3430: g_debug := hr_utility.debug_enabled;

3426:
3427:
3428: BEGIN
3429:
3430: g_debug := hr_utility.debug_enabled;
3431: l_value := p_original_value;
3432: p_att_to_delete := FALSE;
3433:
3434: -- look for the alias definition information

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

3434: -- look for the alias definition information
3435: -- get the alias attribute values to match with the attribute.
3436:
3437: --if g_debug then
3438: --hr_utility.trace('p_alias_type'||p_alias_type);
3439: --hr_utility.trace('p_alias_definition_id'||p_alias_definition_id);
3440: --end if;
3441:
3442: IF p_alias_type like 'VALUE_SET%' THEN

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

3435: -- get the alias attribute values to match with the attribute.
3436:
3437: --if g_debug then
3438: --hr_utility.trace('p_alias_type'||p_alias_type);
3439: --hr_utility.trace('p_alias_definition_id'||p_alias_definition_id);
3440: --end if;
3441:
3442: IF p_alias_type like 'VALUE_SET%' THEN
3443:

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

3604: ELSE
3605: -- little bit more compilcated here.
3606: -- first we need to check what this the next value
3607: --if g_debug then
3608: --hr_utility.trace('p_alias_old_value_id'||p_alias_old_value_id);
3609: --hr_utility.trace('p_original_value'||p_original_value);
3610: --end if;
3611: IF p_original_value is not null THEN
3612: -- find the attribute to match

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

3605: -- little bit more compilcated here.
3606: -- first we need to check what this the next value
3607: --if g_debug then
3608: --hr_utility.trace('p_alias_old_value_id'||p_alias_old_value_id);
3609: --hr_utility.trace('p_original_value'||p_original_value);
3610: --end if;
3611: IF p_original_value is not null THEN
3612: -- find the attribute to match
3613: get_alias_val_att_to_match

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

3812: p_cache_label => TRUE);
3813:
3814: -- now we are getting the attribute to match for the each alias_definition
3815: --if g_debug then
3816: --hr_utility.trace('--------------JOEL START----------------------------');
3817: --end if;
3818: --dump_alias_val_att_to_match(g_comp_label);
3819: --if g_debug then
3820: --hr_utility.trace('--------------JOEL END----------------------------');

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

3816: --hr_utility.trace('--------------JOEL START----------------------------');
3817: --end if;
3818: --dump_alias_val_att_to_match(g_comp_label);
3819: --if g_debug then
3820: --hr_utility.trace('--------------JOEL END----------------------------');
3821: --end if;
3822:
3823: l_index_alias_def := l_alias_def_item.first;
3824:

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

3868: EXIT WHEN
3869: (NOT g_comp_label.exists(l_index_comp));
3870: /*
3871: if g_debug then
3872: hr_utility.trace('-------STEP 1 ------');
3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

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

3869: (NOT g_comp_label.exists(l_index_comp));
3870: /*
3871: if g_debug then
3872: hr_utility.trace('-------STEP 1 ------');
3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3877: hr_utility.trace('-------------');

Line 3874: 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));

3870: /*
3871: if g_debug then
3872: hr_utility.trace('-------STEP 1 ------');
3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3877: hr_utility.trace('-------------');
3878: end if;

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

3871: if g_debug then
3872: hr_utility.trace('-------STEP 1 ------');
3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3877: hr_utility.trace('-------------');
3878: end if;
3879: */

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

3872: hr_utility.trace('-------STEP 1 ------');
3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3877: hr_utility.trace('-------------');
3878: end if;
3879: */
3880: IF nvl(upper(l_change_att_cat),-1) =

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

3873: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3874: 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));
3875: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3876: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3877: hr_utility.trace('-------------');
3878: end if;
3879: */
3880: IF nvl(upper(l_change_att_cat),-1) =
3881: nvl(upper(g_comp_label(l_index_comp).MAPPING_ATT_CAT),-1)

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

3884: -- populate the field name
3885: p_attr_change_table(l_index_change_att).field_name :=
3886: g_comp_label(l_index_comp).ATTRIBUTE1;
3887: --if g_debug then
3888: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);
3889: --end if;
3890: END IF;
3891:
3892: l_index_comp := g_comp_label.next(l_index_comp);

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

3934: EXIT WHEN
3935: (NOT g_comp_label.exists(l_index_comp));
3936: /*
3937: if g_debug then
3938: hr_utility.trace('-------STEP 2------');
3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));

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

3935: (NOT g_comp_label.exists(l_index_comp));
3936: /*
3937: if g_debug then
3938: hr_utility.trace('-------STEP 2------');
3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3943: hr_utility.trace('-------------');

Line 3940: 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));

3936: /*
3937: if g_debug then
3938: hr_utility.trace('-------STEP 2------');
3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3943: hr_utility.trace('-------------');
3944: end if;

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

3937: if g_debug then
3938: hr_utility.trace('-------STEP 2------');
3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3943: hr_utility.trace('-------------');
3944: end if;
3945: */

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

3938: hr_utility.trace('-------STEP 2------');
3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3943: hr_utility.trace('-------------');
3944: end if;
3945: */
3946:

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

3939: hr_utility.trace('upper(l_change_att_cat) '||nvl(upper(l_change_att_cat),-1));
3940: 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));
3941: hr_utility.trace('upper(l_changed_att) '||upper(l_changed_att));
3942: hr_utility.trace('upper(g_comp_label(l_index_comp).SEGMENT '||upper(g_comp_label(l_index_comp).SEGMENT));
3943: hr_utility.trace('-------------');
3944: end if;
3945: */
3946:
3947: IF nvl(upper(l_change_att_cat),-1)

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

3951: -- populate the field name
3952: p_attr_change_table(l_index_change_att).field_name :=
3953: g_comp_label(l_index_comp).ATTRIBUTE1;
3954: --if g_debug then
3955: --hr_utility.trace(' g_comp_label(l_index_comp).ATTRIBUTE1 '|| g_comp_label(l_index_comp).ATTRIBUTE1);
3956: --end if;
3957: END IF;
3958:
3959: l_index_comp := g_comp_label.next(l_index_comp);

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

3966:
3967: END IF;
3968:
3969: --if g_debug then
3970: --hr_utility.trace('--------------JOEL END---------------------------');
3971: --end if;
3972:
3973: /*
3974: FOR I IN 1..p_attr_change_table.COUNT LOOP

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

3972:
3973: /*
3974: FOR I IN 1..p_attr_change_table.COUNT LOOP
3975: if g_debug then
3976: hr_utility.trace(' catg ='|| p_attr_change_table(i).attribute_category ||
3977: ' changed ='|| p_attr_change_table(i).changed_attribute ||
3978: ' field name ='|| p_attr_change_table(i).field_name ||
3979: ' org_att_catg ='|| p_attr_change_table(i).org_attribute_category ||
3980: ' org_changed_attr ='|| p_attr_change_table(i).ORG_changed_attribute

Line 4116: g_debug := hr_utility.debug_enabled;

4112:
4113: BEGIN
4114:
4115: l_index := p_alias_val_att_to_match.first;
4116: g_debug := hr_utility.debug_enabled;
4117: LOOP
4118: EXIT WHEN
4119: (NOT p_alias_val_att_to_match.exists(l_index));
4120: /*

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

4118: EXIT WHEN
4119: (NOT p_alias_val_att_to_match.exists(l_index));
4120: /*
4121: if g_debug then
4122: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

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

4119: (NOT p_alias_val_att_to_match.exists(l_index));
4120: /*
4121: if g_debug then
4122: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

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

4120: /*
4121: if g_debug then
4122: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

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

4121: if g_debug then
4122: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

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

4122: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

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

4123: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

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

4124: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

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

4125: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

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

4126: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

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

4127: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

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

4128: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

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

4129: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

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

4130: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

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

4131: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4139: end if;

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

4132: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4139: end if;
4140: */

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

4133: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4139: end if;
4140: */
4141: if g_debug then

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

4134: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4135: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4136: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4137: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4139: end if;
4140: */
4141: if g_debug then
4142: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);

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

4138: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4139: end if;
4140: */
4141: if g_debug then
4142: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);
4143: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4144: end if;
4145: /*
4146: dbms_output.put_line('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');

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

4139: end if;
4140: */
4141: if g_debug then
4142: hr_utility.trace('MAPP:'||p_alias_val_att_to_match(l_index).MAPPING_ATT_CAT);
4143: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4144: end if;
4145: /*
4146: dbms_output.put_line('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4147: dbms_output.put_line('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);

Line 4185: g_debug :=hr_utility.debug_enabled;

4181:
4182: BEGIN
4183:
4184: l_index := p_attributes.first;
4185: g_debug :=hr_utility.debug_enabled;
4186: LOOP
4187: EXIT WHEN
4188: (NOT p_attributes.exists(l_index));
4189:

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

4188: (NOT p_attributes.exists(l_index));
4189:
4190: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4191: if g_debug then
4192: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);

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

4189:
4190: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4191: if g_debug then
4192: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);

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

4190: IF p_attributes(l_index).ATTRIBUTE_CATEGORY <> 'SECURITY' THEN
4191: if g_debug then
4192: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);

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

4191: if g_debug then
4192: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);

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

4192: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_bb_attribute_info');
4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);

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

4193: hr_utility.trace('time_attribute_id:'||p_attributes(l_index).TIME_ATTRIBUTE_ID);
4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);

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

4194: hr_utility.trace('index:'||l_index);
4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);

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

4195: hr_utility.trace('BBID:'||p_attributes(l_index).BUILDING_BLOCK_ID);
4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);

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

4196: hr_utility.trace('BBITYPE:'||p_attributes(l_index).BLD_BLK_INFO_TYPE);
4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);

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

4197: hr_utility.trace('BBITYPE_ID:'||p_attributes(l_index).BLD_BLK_INFO_TYPE_ID);
4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);

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

4198: hr_utility.trace('ATT_CAT:'||p_attributes(l_index).ATTRIBUTE_CATEGORY);
4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);

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

4199: hr_utility.trace('CHANGED :'||p_attributes(l_index).CHANGED);
4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);

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

4200: hr_utility.trace('NEW :'||p_attributes(l_index).NEW);
4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);

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

4201: hr_utility.trace(' ATT1:'||p_attributes(l_index).ATTRIBUTE1);
4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);

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

4202: hr_utility.trace(' ATT2:'||p_attributes(l_index).ATTRIBUTE2);
4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);

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

4203: hr_utility.trace(' ATT3:'||p_attributes(l_index).ATTRIBUTE3);
4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);

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

4204: hr_utility.trace(' ATT4:'||p_attributes(l_index).ATTRIBUTE4);
4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);

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

4205: hr_utility.trace(' ATT5:'||p_attributes(l_index).ATTRIBUTE5);
4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);

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

4206: hr_utility.trace(' ATT6:'||p_attributes(l_index).ATTRIBUTE6);
4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);

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

4207: hr_utility.trace(' ATT7:'||p_attributes(l_index).ATTRIBUTE7);
4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);

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

4208: hr_utility.trace(' ATT8:'||p_attributes(l_index).ATTRIBUTE8);
4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);

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

4209: hr_utility.trace(' ATT9:'||p_attributes(l_index).ATTRIBUTE9);
4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);

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

4210: hr_utility.trace(' ATT10:'||p_attributes(l_index).ATTRIBUTE10);
4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);

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

4211: hr_utility.trace(' ATT11:'||p_attributes(l_index).ATTRIBUTE11);
4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);

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

4212: hr_utility.trace(' ATT12:'||p_attributes(l_index).ATTRIBUTE12);
4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);

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

4213: hr_utility.trace(' ATT13:'||p_attributes(l_index).ATTRIBUTE13);
4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);

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

4214: hr_utility.trace(' ATT14:'||p_attributes(l_index).ATTRIBUTE14);
4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);

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

4215: hr_utility.trace(' ATT15:'||p_attributes(l_index).ATTRIBUTE15);
4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);

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

4216: hr_utility.trace(' ATT16:'||p_attributes(l_index).ATTRIBUTE16);
4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);

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

4217: hr_utility.trace(' ATT17:'||p_attributes(l_index).ATTRIBUTE17);
4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);

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

4218: hr_utility.trace(' ATT18:'||p_attributes(l_index).ATTRIBUTE18);
4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);

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

4219: hr_utility.trace(' ATT19:'||p_attributes(l_index).ATTRIBUTE19);
4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);

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

4220: hr_utility.trace(' ATT20:'||p_attributes(l_index).ATTRIBUTE20);
4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);

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

4221: hr_utility.trace(' ATT21:'||p_attributes(l_index).ATTRIBUTE21);
4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);

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

4222: hr_utility.trace(' ATT22:'||p_attributes(l_index).ATTRIBUTE22);
4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4230: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);

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

4223: hr_utility.trace(' ATT23:'||p_attributes(l_index).ATTRIBUTE23);
4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4230: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4231: end if;

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

4224: hr_utility.trace(' ATT24:'||p_attributes(l_index).ATTRIBUTE24);
4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4230: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4231: end if;
4232: END IF;

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

4225: hr_utility.trace(' ATT25:'||p_attributes(l_index).ATTRIBUTE25);
4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4230: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4231: end if;
4232: END IF;
4233:

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

4226: hr_utility.trace(' ATT26:'||p_attributes(l_index).ATTRIBUTE26);
4227: hr_utility.trace(' ATT27:'||p_attributes(l_index).ATTRIBUTE27);
4228: hr_utility.trace(' ATT28:'||p_attributes(l_index).ATTRIBUTE28);
4229: hr_utility.trace(' ATT29:'||p_attributes(l_index).ATTRIBUTE29);
4230: hr_utility.trace(' ATT30:'||p_attributes(l_index).ATTRIBUTE30);
4231: end if;
4232: END IF;
4233:
4234: l_index := p_attributes.next(l_index);

Line 4254: g_debug := hr_utility.debug_enabled;

4250: BEGIN
4251: --null;
4252:
4253: l_index := p_alias_def_item.first;
4254: g_debug := hr_utility.debug_enabled;
4255:
4256: LOOP
4257: EXIT WHEN
4258: (NOT p_alias_def_item.exists(l_index));

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

4257: EXIT WHEN
4258: (NOT p_alias_def_item.exists(l_index));
4259: /*
4260: if g_debug then
4261: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);

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

4258: (NOT p_alias_def_item.exists(l_index));
4259: /*
4260: if g_debug then
4261: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);

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

4259: /*
4260: if g_debug then
4261: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);

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

4260: if g_debug then
4261: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);

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

4261: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_attribute');
4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);

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

4262: hr_utility.trace('ATT_CAT:'||p_alias_val_att_to_match(l_index).attribute_category);
4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);

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

4263: hr_utility.trace('ATT1:'||p_alias_val_att_to_match(l_index).attribute1);
4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);

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

4264: hr_utility.trace('ATT2:'||p_alias_val_att_to_match(l_index).attribute2);
4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);

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

4265: hr_utility.trace('ATT3:'||p_alias_val_att_to_match(l_index).attribute3);
4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);

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

4266: hr_utility.trace('ATT4:'||p_alias_val_att_to_match(l_index).attribute4);
4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);

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

4267: hr_utility.trace('ATT5:'||p_alias_val_att_to_match(l_index).attribute5);
4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);

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

4268: hr_utility.trace('ATT6:'||p_alias_val_att_to_match(l_index).attribute6);
4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);

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

4269: hr_utility.trace('ATT7:'||p_alias_val_att_to_match(l_index).attribute7);
4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);

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

4270: hr_utility.trace('ATT8:'||p_alias_val_att_to_match(l_index).attribute8);
4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);

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

4271: hr_utility.trace('ATT9:'||p_alias_val_att_to_match(l_index).attribute9);
4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4279: end if;

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

4272: hr_utility.trace('ATT10:'||p_alias_val_att_to_match(l_index).attribute10);
4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4279: end if;
4280: */

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

4273: hr_utility.trace('BLD_BLK_INFO_TYPE:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE);
4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4279: end if;
4280: */
4281: if g_debug then

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

4274: hr_utility.trace('BLD_BLK_INFO_TYPE_ID:'||p_alias_val_att_to_match(l_index).BLD_BLK_INFO_TYPE_ID);
4275: hr_utility.trace('COMPONENT_TYPE:'||p_alias_val_att_to_match(l_index).COMPONENT_TYPE);
4276: hr_utility.trace('COMPONENT_NAME:'||p_alias_val_att_to_match(l_index).COMPONENT_NAME);
4277: hr_utility.trace('REFERENCE_OBJECT:'||p_alias_val_att_to_match(l_index).REFERENCE_OBJECT);
4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4279: end if;
4280: */
4281: if g_debug then
4282: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');

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

4278: hr_utility.trace('SEGMENT:'||p_alias_val_att_to_match(l_index).SEGMENT);
4279: end if;
4280: */
4281: if g_debug then
4282: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4283: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4284: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4285: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4286: end if;

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

4279: end if;
4280: */
4281: if g_debug then
4282: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4283: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4284: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4285: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4286: end if;
4287:

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

4280: */
4281: if g_debug then
4282: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4283: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4284: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4285: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4286: end if;
4287:
4288: l_index := p_alias_def_item.next(l_index);

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

4281: if g_debug then
4282: hr_utility.trace('HXC_ALIAS_TRANSLATOR.dump_alias_def_item');
4283: hr_utility.trace('ATT_DEF_ID: '||p_alias_def_item(l_index).ALIAS_DEFINITION_ID);
4284: hr_utility.trace('ATT_CATEGORY: '||p_alias_def_item(l_index).ITEM_ATTRIBUTE_CATEGORY);
4285: hr_utility.trace('LAYOUT_ID: '||p_alias_def_item(l_index).LAYOUT_ID);
4286: end if;
4287:
4288: l_index := p_alias_def_item.next(l_index);
4289: END LOOP;