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_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_CATEGORY_UTILS_PKG

Line 558: , p_time_category_id => hxc_time_category_utils_pkg.g_time_category_id );

554: p_hrs_period_start => p_hrs_period_start
555: , p_hrs_period_end => p_hrs_period_end
556: , p_tco_bb => p_tco_bb
557: , p_tco_att => p_tco_att
558: , p_time_category_id => hxc_time_category_utils_pkg.g_time_category_id );
559:
560: RETURN l_hours;
561:
562: END calc_timecard_hrs;

Line 589: l_time_category_id := hxc_time_category_utils_pkg.get_time_category_id ( p_time_category_name => p_time_category_name );

585: l_time_category_id hxc_time_categories.time_category_id%TYPE;
586:
587: BEGIN
588:
589: l_time_category_id := hxc_time_category_utils_pkg.get_time_category_id ( p_time_category_name => p_time_category_name );
590:
591: l_hours := calc_timecard_hrs (
592: p_hrs_period_start => p_hrs_period_start
593: , p_hrs_period_end => p_hrs_period_end

Line 638: hxc_time_category_utils_pkg.initialise_time_category (

634: if g_debug then
635: hr_utility.set_location('Processing '||l_proc, 15);
636: end if;
637:
638: hxc_time_category_utils_pkg.initialise_time_category (
639: p_time_category_id => p_time_category_id
640: , p_tco_att => p_tco_att );
641:
642: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (

Line 642: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (

638: hxc_time_category_utils_pkg.initialise_time_category (
639: p_time_category_id => p_time_category_id
640: , p_tco_att => p_tco_att );
641:
642: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (
643: p_tc_bb_ok_string => hxc_time_category_utils_pkg.g_tc_bb_ok_string
644: , p_hrs => l_timecard_hrs
645: , p_period_start => p_hrs_period_start
646: , p_period_end => p_hrs_period_end );

Line 643: p_tc_bb_ok_string => hxc_time_category_utils_pkg.g_tc_bb_ok_string

639: p_time_category_id => p_time_category_id
640: , p_tco_att => p_tco_att );
641:
642: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (
643: p_tc_bb_ok_string => hxc_time_category_utils_pkg.g_tc_bb_ok_string
644: , p_hrs => l_timecard_hrs
645: , p_period_start => p_hrs_period_start
646: , p_period_end => p_hrs_period_end );
647:

Line 652: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (

648: ELSE
649:
650: -- no time category set this sum all hours on the timecard regardless
651:
652: hxc_time_category_utils_pkg.sum_tc_bb_ok_hrs (
653: p_tc_bb_ok_string => NULL
654: , p_hrs => l_timecard_hrs
655: , p_period_start => p_hrs_period_start
656: , p_period_end => p_hrs_period_end );

Line 2022: hxc_time_category_utils_pkg.initialise_time_category (

2018: end if;
2019:
2020: -- we always have to intialise the first time category so do it now
2021:
2022: hxc_time_category_utils_pkg.initialise_time_category (
2023: p_time_category_id => l_tc_id_1
2024: , p_tco_att => p_tco_att );
2025:
2026: if g_debug then

Line 2041: IF ( NOT hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )

2037: IF ( p_tco_bb(l_bb_ind).scope = 'DETAIL' and
2038: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285
2039: THEN
2040:
2041: IF ( NOT hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )
2042: THEN
2043:
2044: IF ( l_tc_id_2 IS NULL )
2045: THEN

Line 2080: hxc_time_category_utils_pkg.initialise_time_category (

2076:
2077: IF ( l_tc_id_2 IS NOT NULL )
2078: THEN
2079:
2080: hxc_time_category_utils_pkg.initialise_time_category (
2081: p_time_category_id => l_tc_id_2
2082: , p_tco_att => p_tco_att );
2083:
2084: -- now process the second time category

Line 2095: IF ( hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )

2091: IF ( p_tco_bb(l_bb_ind).scope = 'DETAIL' and
2092: p_tco_bb(l_bb_ind).date_to = hr_general.end_of_time ) --Fix for Bug#2943285
2093: THEN
2094:
2095: IF ( hxc_time_category_utils_pkg.chk_tc_bb_ok ( p_tco_bb(l_bb_ind).time_building_block_id ) )
2096: THEN
2097:
2098: -- since this building block matches the time category check to make sure that the bb
2099: -- did not match the first time category, if it did then raise an error

Line 2486: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,

2482: , p_operator VARCHAR2 ) RETURN NUMBER IS
2483:
2484:
2485: CURSOR csr_get_total_hrs ( p_start_date DATE, p_end_date DATE) IS
2486: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,
2487: tbb_detail.object_version_number),0)) ),0)
2488: FROM
2489: hxc_timecard_summary ts,
2490: hxc_time_building_blocks tbb_day,

Line 2659: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;

2655: THEN
2656:
2657: -- calculate PTO INC hours
2658:
2659: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2660: hxc_time_category_utils_pkg.g_time_category_id
2661: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2662:
2663: l_hrs := 0;

Line 2660: hxc_time_category_utils_pkg.g_time_category_id

2656:
2657: -- calculate PTO INC hours
2658:
2659: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2660: hxc_time_category_utils_pkg.g_time_category_id
2661: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2662:
2663: l_hrs := 0;
2664:

Line 2692: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;

2688: end if;
2689:
2690: l_total_hrs := l_total_hrs - l_hrs;
2691:
2692: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;
2693:
2694: END IF;
2695:
2696: ELSIF ( l_db_pre_period_start IS NOT NULL )

Line 2721: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;

2717: THEN
2718:
2719: -- calculate PTO INC hours
2720:
2721: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2722: hxc_time_category_utils_pkg.g_time_category_id
2723: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2724:
2725: l_hrs := 0;

Line 2722: hxc_time_category_utils_pkg.g_time_category_id

2718:
2719: -- calculate PTO INC hours
2720:
2721: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2722: hxc_time_category_utils_pkg.g_time_category_id
2723: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2724:
2725: l_hrs := 0;
2726:

Line 2739: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;

2735: end if;
2736:
2737: l_total_hrs := l_total_hrs - l_hrs;
2738:
2739: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;
2740:
2741: END IF;
2742:
2743: ELSIF( l_db_post_period_start IS NOT NULL )

Line 2768: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;

2764: THEN
2765:
2766: -- calculate PTO INC hours
2767:
2768: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2769: hxc_time_category_utils_pkg.g_time_category_id
2770: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2771:
2772: l_hrs := 0;

Line 2769: hxc_time_category_utils_pkg.g_time_category_id

2765:
2766: -- calculate PTO INC hours
2767:
2768: l_old_tc_id := hxc_time_category_utils_pkg.g_time_category_id;
2769: hxc_time_category_utils_pkg.g_time_category_id
2770: := hxc_time_entry_rules_utils_pkg.g_ter_record.ter_inc_pto_plan_id;
2771:
2772: l_hrs := 0;
2773:

Line 2785: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;

2781: end if;
2782:
2783: l_total_hrs := l_total_hrs - l_hrs;
2784:
2785: hxc_time_category_utils_pkg.g_time_category_id := l_old_tc_id;
2786:
2787: END IF;
2788:
2789: ELSE

Line 3271: hxc_time_category_utils_pkg.initialise_time_category(

3267: l_time_category_id := r_rules.attribute2;
3268: if g_debug then
3269: hr_utility.trace('Time Category ID' || l_time_category_id);
3270: end if;
3271: hxc_time_category_utils_pkg.initialise_time_category(
3272: p_time_category_id => to_number(l_time_category_id),
3273: p_tco_att => P_TIME_ATTRIBUTES);
3274: n := p_time_building_blocks.first;
3275: loop

Line 3278: if (hxc_time_category_utils_pkg.chk_tc_bb_ok( p_time_building_blocks(n).time_building_block_id)) then

3274: n := p_time_building_blocks.first;
3275: loop
3276: exit when not p_time_building_blocks.exists(n);
3277: if (p_time_building_blocks(n).scope = 'DETAIL') then
3278: if (hxc_time_category_utils_pkg.chk_tc_bb_ok( p_time_building_blocks(n).time_building_block_id)) then
3279: add_error_to_table (
3280: p_message_table => p_messages
3281: , p_message_name => r_rules.attribute1
3282: , p_message_token => NULL

Line 4833: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;

4829: l_old_tco_att hxc_self_service_time_deposit.building_block_attribute_info;
4830: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
4831: l_build_change_list VARCHAR2 (2000);
4832: l_change_list VARCHAR2 (2000);
4833: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;
4834: l_long LONG;
4835: l_operator hxc_time_categories.OPERATOR%TYPE;
4836: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4837: l_tc_bb_ok_tab_old hxc_time_category_utils_pkg.t_tc_bb_ok;

Line 4836: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

4832: l_change_list VARCHAR2 (2000);
4833: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;
4834: l_long LONG;
4835: l_operator hxc_time_categories.OPERATOR%TYPE;
4836: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4837: l_tc_bb_ok_tab_old hxc_time_category_utils_pkg.t_tc_bb_ok;
4838: l_tc_bb_ok_string VARCHAR2(32000);
4839: l_tc_bb_not_ok_string VARCHAR2(32000);
4840: n NUMBER;

Line 4837: l_tc_bb_ok_tab_old hxc_time_category_utils_pkg.t_tc_bb_ok;

4833: l_time_cat_tab hxc_time_category_utils_pkg.t_time_category;
4834: l_long LONG;
4835: l_operator hxc_time_categories.OPERATOR%TYPE;
4836: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4837: l_tc_bb_ok_tab_old hxc_time_category_utils_pkg.t_tc_bb_ok;
4838: l_tc_bb_ok_string VARCHAR2(32000);
4839: l_tc_bb_not_ok_string VARCHAR2(32000);
4840: n NUMBER;
4841: l_tbb_deleted BOOLEAN;

Line 4875: hxc_time_category_utils_pkg.evaluate_time_category (

4871: end if;
4872:
4873: -- populate the time category bb ok table
4874:
4875: hxc_time_category_utils_pkg.evaluate_time_category (
4876: p_time_category_id => p_rule_record.attribute1
4877: , p_tc_bb_ok_tab => l_tc_bb_ok_tab
4878: , p_tc_bb_ok_string => l_tc_bb_ok_string
4879: , p_tc_bb_not_ok_string => l_tc_bb_not_ok_string );

Line 4884: hxc_time_category_utils_pkg.push_attributes ( l_old_tco_att );

4880:
4881: -- populate the old attribute table
4882:
4883:
4884: hxc_time_category_utils_pkg.push_attributes ( l_old_tco_att );
4885:
4886:
4887: -- populate the time category bb ok table
4888:

Line 4889: hxc_time_category_utils_pkg.evaluate_time_category (

4885:
4886:
4887: -- populate the time category bb ok table
4888:
4889: hxc_time_category_utils_pkg.evaluate_time_category (
4890: p_time_category_id => p_rule_record.attribute1
4891: , p_tc_bb_ok_tab => l_tc_bb_ok_tab_old
4892: , p_tc_bb_ok_string => l_tc_bb_ok_string
4893: , p_tc_bb_not_ok_string => l_tc_bb_not_ok_string

Line 4898: hxc_time_category_utils_pkg.push_attributes ( p_tco_att );

4894: , p_use_tc_bb_cache => FALSE );
4895:
4896: -- put back the original attributes
4897:
4898: hxc_time_category_utils_pkg.push_attributes ( p_tco_att );
4899:
4900: END IF;
4901:
4902: if g_debug then

Line 5192: hxc_time_category_utils_pkg.initialise_time_category (

5188: l_time_category_id := p_rule_record.attribute1;
5189:
5190: IF (l_time_category_id IS NOT NULL)
5191: THEN
5192: hxc_time_category_utils_pkg.initialise_time_category (
5193: p_time_category_id=> TO_NUMBER (l_time_category_id),
5194: p_tco_att=> p_tco_att
5195: );
5196: l_tbb_index := p_tco_bb.FIRST;

Line 5225: IF (hxc_time_category_utils_pkg.chk_tc_bb_ok (

5221: l_tbb_parent_index := p_tco_bb.next(l_tbb_parent_index);
5222: END LOOP;
5223: END IF;
5224:
5225: IF (hxc_time_category_utils_pkg.chk_tc_bb_ok (
5226: p_tco_bb (l_tbb_index).time_building_block_id
5227: )
5228: )
5229: THEN