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 1456: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);

1452:
1453: LOOP
1454: EXIT WHEN NOT p_blocks.exists(l_tbb_index);
1455:
1456: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);
1457: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).STOP_TIME);
1458: l_tbb_id := p_blocks(l_tbb_index).TIME_BUILDING_BLOCK_ID;
1459: l_scope := p_blocks(l_tbb_index).SCOPE;
1460:

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

1453: LOOP
1454: EXIT WHEN NOT p_blocks.exists(l_tbb_index);
1455:
1456: l_start_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).START_TIME);
1457: l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_blocks(l_tbb_index).STOP_TIME);
1458: l_tbb_id := p_blocks(l_tbb_index).TIME_BUILDING_BLOCK_ID;
1459: l_scope := p_blocks(l_tbb_index).SCOPE;
1460:
1461:

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

1959: -- we are calling the preference now for the resource
1960: if(l_public_template_for_pref_evl) THEN
1961: hxc_preference_evaluation.resource_preferences(
1962: p_resource_id => p_resource_id ,
1963: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1964: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1965: p_pref_table => l_pref_table);
1966: ELSE
1967: hxc_preference_evaluation.resource_preferences(

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

1960: if(l_public_template_for_pref_evl) THEN
1961: hxc_preference_evaluation.resource_preferences(
1962: p_resource_id => p_resource_id ,
1963: p_start_evaluation_date => SYSDATE,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1964: p_end_evaluation_date => hr_general.end_of_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1965: p_pref_table => l_pref_table);
1966: ELSE
1967: hxc_preference_evaluation.resource_preferences(
1968: p_resource_id => p_resource_id ,

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

1965: p_pref_table => l_pref_table);
1966: ELSE
1967: hxc_preference_evaluation.resource_preferences(
1968: p_resource_id => p_resource_id ,
1969: p_start_evaluation_date => p_start_time,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1970: p_end_evaluation_date => p_stop_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1971: p_pref_table => l_pref_table);
1972: END IF;
1973:

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

1966: ELSE
1967: hxc_preference_evaluation.resource_preferences(
1968: p_resource_id => p_resource_id ,
1969: p_start_evaluation_date => p_start_time,--FND_DATE.CANONICAL_TO_DATE(p_start_time),
1970: p_end_evaluation_date => p_stop_time,--FND_DATE.CANONICAL_TO_DATE(p_stop_time),
1971: p_pref_table => l_pref_table);
1972: END IF;
1973:
1974:

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

3801:
3802: 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'
3803: THEN
3804:
3805: l_value := FND_DATE.DATE_TO_CANONICAL(l_value);
3806:
3807: 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'
3808: THEN
3809: l_value := FND_NUMBER.NUMBER_TO_CANONICAL(l_value);

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

4707:
4708: -- we are calling the preference now for the resource
4709: hxc_preference_evaluation.resource_preferences(
4710: p_resource_id => p_resource_id ,
4711: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4712: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4713: p_pref_table => l_pref_table);
4714:
4715: -- find the index of the alternate name preference and

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

4708: -- we are calling the preference now for the resource
4709: hxc_preference_evaluation.resource_preferences(
4710: p_resource_id => p_resource_id ,
4711: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
4712: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
4713: p_pref_table => l_pref_table);
4714:
4715: -- find the index of the alternate name preference and
4716: -- we are taking care in the case of a null layout

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

5248: l_pref_table.DELETE;
5249:
5250: hxc_preference_evaluation.resource_preferences(
5251: p_resource_id => p_resource_id ,
5252: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
5253: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
5254: p_pref_table => l_pref_table);
5255:
5256: l_index:=l_pref_table.FIRST;

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

5249:
5250: hxc_preference_evaluation.resource_preferences(
5251: p_resource_id => p_resource_id ,
5252: p_start_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_start_time),
5253: p_end_evaluation_date => FND_DATE.CANONICAL_TO_DATE(p_stop_time),
5254: p_pref_table => l_pref_table);
5255:
5256: l_index:=l_pref_table.FIRST;
5257: /*

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

5759: c_tbb_info.tc_TIME_BUILDING_BLOCK_ID,
5760: null,
5761: null,
5762: null,
5763: fnd_date.date_to_canonical(c_tbb_info.tc_START_TIME),
5764: fnd_date.date_to_canonical(c_tbb_info.tc_STOP_TIME),
5765: c_tbb_info.tc_PARENT_BUILDING_BLOCK_ID,
5766: null,
5767: c_tbb_info.tc_SCOPE,

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

5760: null,
5761: null,
5762: null,
5763: fnd_date.date_to_canonical(c_tbb_info.tc_START_TIME),
5764: fnd_date.date_to_canonical(c_tbb_info.tc_STOP_TIME),
5765: c_tbb_info.tc_PARENT_BUILDING_BLOCK_ID,
5766: null,
5767: c_tbb_info.tc_SCOPE,
5768: c_tbb_info.tc_OBJECT_VERSION_NUMBER,

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

5788: c_tbb_info.day_TIME_BUILDING_BLOCK_ID,
5789: null,
5790: null,
5791: null,
5792: fnd_date.date_to_canonical(c_tbb_info.day_START_TIME),
5793: fnd_date.date_to_canonical(c_tbb_info.day_STOP_TIME),
5794: c_tbb_info.day_PARENT_BUILDING_BLOCK_ID,
5795: null,
5796: c_tbb_info.day_SCOPE,

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

5789: null,
5790: null,
5791: null,
5792: fnd_date.date_to_canonical(c_tbb_info.day_START_TIME),
5793: fnd_date.date_to_canonical(c_tbb_info.day_STOP_TIME),
5794: c_tbb_info.day_PARENT_BUILDING_BLOCK_ID,
5795: null,
5796: c_tbb_info.day_SCOPE,
5797: c_tbb_info.day_OBJECT_VERSION_NUMBER,

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

5817: c_tbb_info.detail_TIME_BUILDING_BLOCK_ID,
5818: null,
5819: null,
5820: null,
5821: fnd_date.date_to_canonical(c_tbb_info.detail_START_TIME),
5822: fnd_date.date_to_canonical(c_tbb_info.detail_STOP_TIME),
5823: c_tbb_info.detail_PARENT_BB_ID,
5824: null,
5825: c_tbb_info.detail_SCOPE,

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

5818: null,
5819: null,
5820: null,
5821: fnd_date.date_to_canonical(c_tbb_info.detail_START_TIME),
5822: fnd_date.date_to_canonical(c_tbb_info.detail_STOP_TIME),
5823: c_tbb_info.detail_PARENT_BB_ID,
5824: null,
5825: c_tbb_info.detail_SCOPE,
5826: c_tbb_info.detail_OBJECT_VERSION_NUMBER,