APPS.HXC_MAPPING_UTILITIES dependencies on HXC_MAPPING_UTILITIES

Line 1: package body hxc_mapping_utilities as

1: package body hxc_mapping_utilities as
2: /* $Header: hxcmputl.pkb 120.12 2011/07/12 06:14:24 pnshukla noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 31: ( hxc_mapping_utilities.get_day_date

27: AND
28: ((
29: p_start_date BETWEEN
30: DECODE ( bb.type, 'RANGE', bb.start_time,
31: ( hxc_mapping_utilities.get_day_date
32: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
33: AND
34: DECODE ( bb.type, 'RANGE', bb.stop_time,
35: ( hxc_mapping_utilities.get_day_date

Line 35: ( hxc_mapping_utilities.get_day_date

31: ( hxc_mapping_utilities.get_day_date
32: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
33: AND
34: DECODE ( bb.type, 'RANGE', bb.stop_time,
35: ( hxc_mapping_utilities.get_day_date
36: ( 'STOP', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
37: OR
38: p_end_date BETWEEN
39: DECODE ( bb.type, 'RANGE', bb.start_time,

Line 40: ( hxc_mapping_utilities.get_day_date

36: ( 'STOP', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
37: OR
38: p_end_date BETWEEN
39: DECODE ( bb.type, 'RANGE', bb.start_time,
40: ( hxc_mapping_utilities.get_day_date
41: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
42: AND
43: DECODE ( bb.type, 'RANGE', bb.stop_time,
44: ( hxc_mapping_utilities.get_day_date

Line 44: ( hxc_mapping_utilities.get_day_date

40: ( hxc_mapping_utilities.get_day_date
41: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
42: AND
43: DECODE ( bb.type, 'RANGE', bb.stop_time,
44: ( hxc_mapping_utilities.get_day_date
45: ( 'STOP', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) ) )
46: OR (
47: DECODE ( bb.type, 'RANGE', bb.start_time,
48: ( hxc_mapping_utilities.get_day_date

Line 48: ( hxc_mapping_utilities.get_day_date

44: ( hxc_mapping_utilities.get_day_date
45: ( 'STOP', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) ) )
46: OR (
47: DECODE ( bb.type, 'RANGE', bb.start_time,
48: ( hxc_mapping_utilities.get_day_date
49: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
50: BETWEEN p_start_date AND p_end_date
51: OR
52: DECODE ( bb.type, 'RANGE', bb.stop_time,

Line 53: ( hxc_mapping_utilities.get_day_date

49: ( 'START', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
50: BETWEEN p_start_date AND p_end_date
51: OR
52: DECODE ( bb.type, 'RANGE', bb.stop_time,
53: ( hxc_mapping_utilities.get_day_date
54: ( 'STOP', bb.parent_building_block_id, bb.parent_building_block_ovn ) ) )
55: BETWEEN p_start_date AND p_end_date ))
56: START WITH bb.time_building_block_id = p_timecard_bb_id
57: AND bb.object_version_number = p_timecard_ovn

Line 2174: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;

2170: l_index_inner number;
2171:
2172: l_cons_index number;
2173:
2174: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;
2175:
2176:
2177: l_installed varchar2(1) := 'N';
2178:

Line 3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;

3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:
3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;
3024:
3025: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
3026: l_field_name_outer varchar2(1000);
3027: l_field_value_outer varchar2(1000);

Line 3383: end hxc_mapping_utilities;

3379:
3380: END get_mappingvalue_sum;
3381:
3382:
3383: end hxc_mapping_utilities;