APPS.HXC_ALIAS_UTILITY dependencies on HXC_PREFERENCE_EVALUATION

Line 1303: l_pref_table hxc_preference_evaluation.t_pref_table;

1299: l_comp_index NUMBER;
1300:
1301: l_layout_id NUMBER;
1302:
1303: l_pref_table hxc_preference_evaluation.t_pref_table;
1304:
1305: l_layout_comp_id NUMBER := NULL;
1306: l_att_cat varchar2(80) := NULL;
1307: l_alias_ref varchar2(80) := NULL;

Line 1378: hxc_preference_evaluation.resource_preferences(

1374: -- preference at the sysdate
1375: IF l_layout_id is null THEN
1376:
1377: l_layout_id := to_number(
1378: hxc_preference_evaluation.resource_preferences(
1379: p_resource_id ,'TC_W_TCRD_LAYOUT',2));
1380: END IF;
1381:
1382: IF l_timecard_layout_id is null THEN

Line 1385: hxc_preference_evaluation.resource_preferences(

1381:
1382: IF l_timecard_layout_id is null THEN
1383:
1384: l_timecard_layout_id:= to_number(
1385: hxc_preference_evaluation.resource_preferences(
1386: p_resource_id ,'TC_W_TCRD_LAYOUT',1));
1387: END IF;
1388:
1389:

Line 1645: hxc_preference_evaluation.resource_preferences(

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

Line 1651: hxc_preference_evaluation.resource_preferences(

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

Line 2230: l_pref_table hxc_preference_evaluation.t_pref_table;

2226:
2227: l_index NUMBER;
2228: l_index_global NUMBER;
2229:
2230: l_pref_table hxc_preference_evaluation.t_pref_table;
2231:
2232:
2233: BEGIN
2234:

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

2255: END IF;
2256:
2257: -- otherwise we need to do the calculation
2258: -- first we need to find the preference for the timekeeper
2259: hxc_preference_evaluation.resource_preferences(p_resource_id => p_timekeeper_id,
2260: p_pref_table => l_pref_table,
2261: p_evaluation_date => sysdate );
2262:
2263: --

Line 4375: l_pref_table hxc_preference_evaluation.t_pref_table;

4371: l_alias_def_comma VARCHAR2(80) := null;
4372: l_alternate_name_index NUMBER;
4373:
4374: l_pref_index NUMBER;
4375: l_pref_table hxc_preference_evaluation.t_pref_table;
4376:
4377: l_alias_type hxc_alias_types.alias_type%TYPE;
4378: l_reference_object hxc_alias_types.reference_object%TYPE;
4379: l_prompt hxc_alias_definitions_tl.prompt%TYPE;

Line 4393: hxc_preference_evaluation.resource_preferences(

4389: ' p_resource_id:'||p_resource_id);
4390:
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);

Line 4910: l_pref_table hxc_preference_evaluation.t_pref_table;

4906: ,p_stop_time IN VARCHAR2
4907: ,p_resource_id IN NUMBER) RETURN t_alias_def_item IS
4908:
4909:
4910: l_pref_table hxc_preference_evaluation.t_pref_table;
4911: l_alias_definition t_alias_def_item;
4912: l_index NUMBER;
4913: l_pref_value t_alias_def_item;
4914: l_index_pref_val NUMBER;

Line 4934: hxc_preference_evaluation.resource_preferences(

4930: ' p_resource_id:'||p_resource_id);
4931: */
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);