1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1629: hr_utility.trace('Timecard Stop Time ::'||l_tc_stop_time);
1630: END IF;
1631:
1632: -- get approval style
1633: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,
1634: p_preference_code => 'TS_PER_APPROVAL_STYLE',
1635: p_start_evaluation_date => l_tc_start_time,
1636: p_end_evaluation_date => l_tc_stop_time,
1637: p_sorted_pref_table => l_pref_table,
1788: else
1789: l_pref_eval_date := trunc(l_tc_start_date);
1790: end if;
1791:
1792: l_precision := hxc_preference_evaluation.resource_preferences
1793: (l_resource_id,
1794: 'TC_W_TCRD_UOM',
1795: 3,
1796: l_pref_eval_date
1795: 3,
1796: l_pref_eval_date
1797: );
1798:
1799: l_rounding_rule := hxc_preference_evaluation.resource_preferences
1800: (l_resource_id,
1801: 'TC_W_TCRD_UOM',
1802: 4,
1803: l_pref_eval_date
1872: l_precision VARCHAR2(4);
1873: l_rounding_rule VARCHAR2(20);
1874:
1875: BEGIN
1876: l_precision := hxc_preference_evaluation.resource_preferences
1877: (p_resource_id,
1878: 'TC_W_TCRD_UOM',
1879: 3,
1880: p_start_date
1879: 3,
1880: p_start_date
1881: );
1882:
1883: l_rounding_rule := hxc_preference_evaluation.resource_preferences
1884: (p_resource_id,
1885: 'TC_W_TCRD_UOM',
1886: 4,
1887: p_start_date