APPS.HXC_ALIAS_UTILITY dependencies on HXC_PREFERENCE_EVALUATION

Line 1619: l_pref_table hxc_preference_evaluation.t_pref_table;

1615: l_comp_index NUMBER;
1616:
1617: l_layout_id NUMBER;
1618:
1619: l_pref_table hxc_preference_evaluation.t_pref_table;
1620:
1621: l_layout_comp_id NUMBER := NULL;
1622: l_att_cat varchar2(80) := NULL;
1623: l_alias_ref varchar2(80) := NULL;

Line 1694: hxc_preference_evaluation.resource_preferences(

1690: -- preference at the sysdate
1691: IF l_layout_id is null THEN
1692:
1693: l_layout_id := to_number(
1694: hxc_preference_evaluation.resource_preferences(
1695: p_resource_id ,'TC_W_TCRD_LAYOUT',2));
1696: END IF;
1697:
1698: IF l_timecard_layout_id is null THEN

Line 1701: hxc_preference_evaluation.resource_preferences(

1697:
1698: IF l_timecard_layout_id is null THEN
1699:
1700: l_timecard_layout_id:= to_number(
1701: hxc_preference_evaluation.resource_preferences(
1702: p_resource_id ,'TC_W_TCRD_LAYOUT',1));
1703: END IF;
1704:
1705:

Line 1961: hxc_preference_evaluation.resource_preferences(

1957: --dbms_output.put_line ('set 3 :');
1958:
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);

Line 1967: hxc_preference_evaluation.resource_preferences(

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 ,
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);

Line 2546: l_pref_table hxc_preference_evaluation.t_pref_table;

2542:
2543: l_index NUMBER;
2544: l_index_global NUMBER;
2545:
2546: l_pref_table hxc_preference_evaluation.t_pref_table;
2547:
2548:
2549: BEGIN
2550:

Line 2575: hxc_preference_evaluation.resource_preferences(p_resource_id => p_timekeeper_id,

2571: END IF;
2572:
2573: -- otherwise we need to do the calculation
2574: -- first we need to find the preference for the timekeeper
2575: hxc_preference_evaluation.resource_preferences(p_resource_id => p_timekeeper_id,
2576: p_pref_table => l_pref_table,
2577: p_evaluation_date => sysdate );
2578:
2579: --

Line 4691: l_pref_table hxc_preference_evaluation.t_pref_table;

4687: l_alias_def_comma VARCHAR2(80) := null;
4688: l_alternate_name_index NUMBER;
4689:
4690: l_pref_index NUMBER;
4691: l_pref_table hxc_preference_evaluation.t_pref_table;
4692:
4693: l_alias_type hxc_alias_types.alias_type%TYPE;
4694: l_reference_object hxc_alias_types.reference_object%TYPE;
4695: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

Line 4709: hxc_preference_evaluation.resource_preferences(

4705: ' p_resource_id:'||p_resource_id);
4706:
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);

Line 5226: l_pref_table hxc_preference_evaluation.t_pref_table;

5222: ,p_stop_time IN VARCHAR2
5223: ,p_resource_id IN NUMBER) RETURN t_alias_def_item IS
5224:
5225:
5226: l_pref_table hxc_preference_evaluation.t_pref_table;
5227: l_alias_definition t_alias_def_item;
5228: l_index NUMBER;
5229: l_pref_value t_alias_def_item;
5230: l_index_pref_val NUMBER;

Line 5250: hxc_preference_evaluation.resource_preferences(

5246: ' p_resource_id:'||p_resource_id);
5247: */
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);