APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_CATEGORIES

Line 549: l_time_category_id hxc_time_categories.time_category_id%TYPE;

545: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info )
546: RETURN NUMBER IS
547:
548: l_hours NUMBER := 0;
549: l_time_category_id hxc_time_categories.time_category_id%TYPE;
550:
551: BEGIN
552:
553: l_hours := calc_timecard_hrs (

Line 585: l_time_category_id hxc_time_categories.time_category_id%TYPE;

581: , p_time_category_name VARCHAR2 )
582: RETURN NUMBER IS
583:
584: l_hours NUMBER := 0;
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 );

Line 863: from hxc_time_Categories

859: p_master_pref_table hxc_preference_evaluation.t_pref_table;
860:
861: cursor gaz_time_sql is
862: select time_category_id
863: from hxc_time_Categories
864: where time_category_name = 'GARRYS TIME SQL TEST';
865:
866: CURSOR csr_get_first_asg_date ( p_resource_id NUMBER
867: , p_tc_start DATE

Line 1976: l_tc_id_1 hxc_time_categories.time_category_id%TYPE;

1972: l_period_id hxc_recurring_periods.recurring_period_id%TYPE;
1973: l_reference_period NUMBER(10);
1974: l_consider_zero_hours VARCHAR2(10);
1975:
1976: l_tc_id_1 hxc_time_categories.time_category_id%TYPE;
1977: l_tc_id_2 hxc_time_categories.time_category_id%TYPE;
1978:
1979: l_bb_ind BINARY_INTEGER;
1980:

Line 1977: l_tc_id_2 hxc_time_categories.time_category_id%TYPE;

1973: l_reference_period NUMBER(10);
1974: l_consider_zero_hours VARCHAR2(10);
1975:
1976: l_tc_id_1 hxc_time_categories.time_category_id%TYPE;
1977: l_tc_id_2 hxc_time_categories.time_category_id%TYPE;
1978:
1979: l_bb_ind BINARY_INTEGER;
1980:
1981: TYPE r_tc1 IS RECORD ( match VARCHAR2(1) );

Line 3217: l_time_category_id hxc_time_categories.time_category_id%TYPE;

3213: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3214: n number;
3215: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3216: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3217: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3218:
3219: l_prefs hxc_preference_evaluation.t_pref_table;
3220:
3221: Begin

Line 3324: l_time_category_id hxc_time_categories.time_category_id%TYPE;

3320: ,P_TIME_ENTRY_RULE_GROUP_ID NUMBER) IS
3321: n number;
3322: l_timecard_info_rec hxc_time_entry_rules_utils_pkg.r_timecard_info;
3323: l_terg_id hxc_pref_hierarchies.attribute1%TYPE;
3324: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3325:
3326: l_prefs hxc_preference_evaluation.t_pref_table;
3327:
3328: FUNCTION chk_bb_late (

Line 4823: l_time_category_id hxc_time_categories.time_category_id%TYPE;

4819: WHERE hmc.segment = upper(p_segment)
4820: AND hbb.BLD_BLK_INFO_TYPE_ID = hmc.bld_blk_info_type_id
4821: AND hbb.BLD_BLK_INFO_TYPE = 'BUILDING_BLOCKS';*/
4822:
4823: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4824: l_tbb_index NUMBER;
4825: l_att_index NUMBER;
4826: l_old_tbb_index NUMBER;
4827: l_old_att_index NUMBER;

Line 4835: l_operator hxc_time_categories.OPERATOR%TYPE;

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;
4838: l_tc_bb_ok_string VARCHAR2(32000);
4839: l_tc_bb_not_ok_string VARCHAR2(32000);

Line 5179: l_time_category_id hxc_time_categories.time_category_id%TYPE;

5175: p_message_level VARCHAR2,
5176: p_rule_record hxc_time_entry_rules_utils_pkg.csr_get_rules%ROWTYPE
5177: )
5178: IS
5179: l_time_category_id hxc_time_categories.time_category_id%TYPE;
5180: l_tbb_index NUMBER;
5181: l_tbb_parent_index NUMBER;
5182: l_date_worked DATE;
5183: n NUMBER;