DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_PREFERENCE_EVALUATION

Line 892: l_pref_table hxc_preference_evaluation.t_pref_table;

888: l_periods periods;
889: l_previous_period_end DATE;
890: l_previous_period_start DATE;
891: l_default_tc_period VARCHAR2(20);
892: l_pref_table hxc_preference_evaluation.t_pref_table;
893:
894: l_empty_period VARCHAR2(50);
895:
896: BEGIN

Line 898: hxc_preference_evaluation.resource_preferences(

894: l_empty_period VARCHAR2(50);
895:
896: BEGIN
897:
898: hxc_preference_evaluation.resource_preferences(
899: p_resource_id => p_resource_id
900: , p_pref_code_list=> 'TC_W_TCRD_PERIOD'
901: , p_pref_table => l_pref_table
902: , p_resp_id => -101

Line 1285: IF hxc_preference_evaluation.resource_preferences( p_resource_id,

1281:
1282: -- 5922228 ( Fetching the preference for the given resource id for
1283: -- future time card periods )
1284:
1285: IF hxc_preference_evaluation.resource_preferences( p_resource_id,
1286: 'TC_W_TCRD_ST_ALW_EDITS',
1287: 10,
1288: sysdate
1289: ,101

Line 1369: l_pref_table hxc_preference_evaluation.t_pref_table;

1365: l_current_assignment PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;
1366: l_rec_period_id VARCHAR2(50);
1367:
1368: l_index BINARY_INTEGER;
1369: l_pref_table hxc_preference_evaluation.t_pref_table;
1370:
1371: /*
1372: CURSOR c_assignments(
1373: p_resource_id IN NUMBER

Line 1400: AND hxc_preference_evaluation.resource_preferences(

1396: rp.start_date
1397: FROM hxc_recurring_periods rp,
1398: per_time_period_types p
1399: WHERE p.period_type (+) = rp.period_type
1400: AND hxc_preference_evaluation.resource_preferences(
1401: p_resource_id,'TC_W_TCRD_PERIOD|1|') = rp.recurring_period_id;
1402: */
1403:
1404: CURSOR c_period_info(p_recurring_period_id number)

Line 1429: hxc_preference_evaluation.resource_preferences(

1425: end if;
1426:
1427: -- call the preference
1428:
1429: hxc_preference_evaluation.resource_preferences(
1430: p_resource_id => p_resource_id
1431: , p_pref_code_list=> 'TC_W_TCRD_PERIOD,TC_W_TCRD_ST_ALW_EDITS'
1432: , p_pref_table => l_pref_table
1433: , p_resp_id => -101

Line 1458: -- hxc_preference_evaluation.resource_preferences(

1454:
1455:
1456:
1457: -- l_rec_period_id :=
1458: -- hxc_preference_evaluation.resource_preferences(
1459: -- p_resource_id,
1460: -- 'TC_W_TCRD_PERIOD|1|'
1461: -- );
1462:

Line 1486: -- hxc_preference_evaluation.resource_preferences(

1482: hr_utility.trace('l_rec_period_start_date=' || g_rec_period_start_date);
1483: END IF;
1484:
1485: -- l_num_past_days :=
1486: -- hxc_preference_evaluation.resource_preferences(
1487: -- p_resource_id,
1488: -- 'TC_W_TCRD_ST_ALW_EDITS',
1489: -- 6);
1490:

Line 1492: -- hxc_preference_evaluation.resource_preferences(

1488: -- 'TC_W_TCRD_ST_ALW_EDITS',
1489: -- 6);
1490:
1491: -- l_num_future_days :=
1492: -- hxc_preference_evaluation.resource_preferences(
1493: -- p_resource_id,
1494: -- 'TC_W_TCRD_ST_ALW_EDITS',
1495: -- 11);
1496: