eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ALIAS_UTILITY dependencies on FND_DATE

Line 1140: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);

1136:
1137: LOOP
1138: EXIT WHEN NOT p_blocks.exists(l_tbb_index);
1139:
1140: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);
1141: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).STOP_TIME);
1142: l_tbb_id := p_blocks(l_tbb_index).TIME_BUILDING_BLOCK_ID;
1143: l_scope := p_blocks(l_tbb_index).SCOPE;
1144:

Line 1141: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).STOP_TIME);

1137: LOOP
1138: EXIT WHEN NOT p_blocks.exists(l_tbb_index);
1139:
1140: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);
1141: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).STOP_TIME);
1142: l_tbb_id := p_blocks(l_tbb_index).TIME_BUILDING_BLOCK_ID;
1143: l_scope := p_blocks(l_tbb_index).SCOPE;
1144:
1145:

Line 1647: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),

1643: -- we are calling the preference now for the resource
1644: if(l_public_template_for_pref_evl) THEN
1645: hxc_preference_evaluation.resource_preferences(
1646: p_resource_id => p_resource_id ,
1647: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1648: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1649: p_pref_table => l_pref_table);
1650: ELSE
1651: hxc_preference_evaluation.resource_preferences(

Line 1648: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),

1644: if(l_public_template_for_pref_evl) THEN
1645: hxc_preference_evaluation.resource_preferences(
1646: p_resource_id => p_resource_id ,
1647: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1648: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1649: p_pref_table => l_pref_table);
1650: ELSE
1651: hxc_preference_evaluation.resource_preferences(
1652: p_resource_id => p_resource_id ,

Line 1653: p_start_evaluation_date => p_start_time,--FND_DATE.CANONICAL_TO_DATE(p_start_time),

1649: p_pref_table => l_pref_table);
1650: ELSE
1651: hxc_preference_evaluation.resource_preferences(
1652: p_resource_id => p_resource_id ,
1653: p_start_evaluation_date => p_start_time,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1654: p_end_evaluation_date => p_stop_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1655: p_pref_table => l_pref_table);
1656: END IF;
1657:

Line 1654: p_end_evaluation_date => p_stop_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),

1650: ELSE
1651: hxc_preference_evaluation.resource_preferences(
1652: p_resource_id => p_resource_id ,
1653: p_start_evaluation_date => p_start_time,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1654: p_end_evaluation_date => p_stop_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1655: p_pref_table => l_pref_table);
1656: END IF;
1657:
1658:

Line 3489: l_value := FND_DATE.DATE_TO_CANONICAL(l_value);

3485:
3486: IF hxc_alias_translator.g_vset_fmt(TO_CHAR(l_alias_val_att_to_match(l_alias_val_att_to_match.FIRST).reference_object)) = 'X'
3487: THEN
3488:
3489: l_value := FND_DATE.DATE_TO_CANONICAL(l_value);
3490:
3491: ELSIF hxc_alias_translator.g_vset_fmt(TO_CHAR(l_alias_val_att_to_match(l_alias_val_att_to_match.FIRST).reference_object)) = 'N'
3492: THEN
3493: l_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_value);

Line 4395: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),

4391:
4392: -- we are calling the preference now for the resource
4393: hxc_preference_evaluation.resource_preferences(
4394: p_resource_id => p_resource_id ,
4395: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4396: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4397: p_pref_table => l_pref_table);
4398:
4399: -- find the index of the alternate name preference and

Line 4396: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),

4392: -- we are calling the preference now for the resource
4393: hxc_preference_evaluation.resource_preferences(
4394: p_resource_id => p_resource_id ,
4395: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4396: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4397: p_pref_table => l_pref_table);
4398:
4399: -- find the index of the alternate name preference and
4400: -- we are taking care in the case of a null layout

Line 4936: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),

4932: l_pref_table.DELETE;
4933:
4934: hxc_preference_evaluation.resource_preferences(
4935: p_resource_id => p_resource_id ,
4936: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4937: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4938: p_pref_table => l_pref_table);
4939:
4940: l_index:=l_pref_table.FIRST;

Line 4937: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),

4933:
4934: hxc_preference_evaluation.resource_preferences(
4935: p_resource_id => p_resource_id ,
4936: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4937: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4938: p_pref_table => l_pref_table);
4939:
4940: l_index:=l_pref_table.FIRST;
4941: /*

Line 5447: fnd_date.date_to_canonical(c_tbb_info.tc_START_TIME),

5443: c_tbb_info.tc_TIME_BUILDING_BLOCK_ID,
5444: null,
5445: null,
5446: null,
5447: fnd_date.date_to_canonical(c_tbb_info.tc_START_TIME),
5448: fnd_date.date_to_canonical(c_tbb_info.tc_STOP_TIME),
5449: c_tbb_info.tc_PARENT_BUILDING_BLOCK_ID,
5450: null,
5451: c_tbb_info.tc_SCOPE,

Line 5448: fnd_date.date_to_canonical(c_tbb_info.tc_STOP_TIME),

5444: null,
5445: null,
5446: null,
5447: fnd_date.date_to_canonical(c_tbb_info.tc_START_TIME),
5448: fnd_date.date_to_canonical(c_tbb_info.tc_STOP_TIME),
5449: c_tbb_info.tc_PARENT_BUILDING_BLOCK_ID,
5450: null,
5451: c_tbb_info.tc_SCOPE,
5452: c_tbb_info.tc_OBJECT_VERSION_NUMBER,

Line 5476: fnd_date.date_to_canonical(c_tbb_info.day_START_TIME),

5472: c_tbb_info.day_TIME_BUILDING_BLOCK_ID,
5473: null,
5474: null,
5475: null,
5476: fnd_date.date_to_canonical(c_tbb_info.day_START_TIME),
5477: fnd_date.date_to_canonical(c_tbb_info.day_STOP_TIME),
5478: c_tbb_info.day_PARENT_BUILDING_BLOCK_ID,
5479: null,
5480: c_tbb_info.day_SCOPE,

Line 5477: fnd_date.date_to_canonical(c_tbb_info.day_STOP_TIME),

5473: null,
5474: null,
5475: null,
5476: fnd_date.date_to_canonical(c_tbb_info.day_START_TIME),
5477: fnd_date.date_to_canonical(c_tbb_info.day_STOP_TIME),
5478: c_tbb_info.day_PARENT_BUILDING_BLOCK_ID,
5479: null,
5480: c_tbb_info.day_SCOPE,
5481: c_tbb_info.day_OBJECT_VERSION_NUMBER,

Line 5505: fnd_date.date_to_canonical(c_tbb_info.detail_START_TIME),

5501: c_tbb_info.detail_TIME_BUILDING_BLOCK_ID,
5502: null,
5503: null,
5504: null,
5505: fnd_date.date_to_canonical(c_tbb_info.detail_START_TIME),
5506: fnd_date.date_to_canonical(c_tbb_info.detail_STOP_TIME),
5507: c_tbb_info.detail_PARENT_BB_ID,
5508: null,
5509: c_tbb_info.detail_SCOPE,

Line 5506: fnd_date.date_to_canonical(c_tbb_info.detail_STOP_TIME),

5502: null,
5503: null,
5504: null,
5505: fnd_date.date_to_canonical(c_tbb_info.detail_START_TIME),
5506: fnd_date.date_to_canonical(c_tbb_info.detail_STOP_TIME),
5507: c_tbb_info.detail_PARENT_BB_ID,
5508: null,
5509: c_tbb_info.detail_SCOPE,
5510: c_tbb_info.detail_OBJECT_VERSION_NUMBER,