APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 25: RETURN 'HXC_TIME_ATTRIBUTES';

21: BEGIN
22: IF (instr(upper(p_access),'TIME')>0) THEN
23: RETURN 'HXC_TIME_BUILDING_BLOCKS';
24: ELSIF (instr(upper(p_access),'FLEX')>0) THEN
25: RETURN 'HXC_TIME_ATTRIBUTES';
26: ELSE
27: RETURN '';
28: END IF;
29: END get_table_name;

Line 73: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta

69:
70: if(p_get_type = c_new_get_type) then
71: if p_context like 'PAEXPITDFF%' THEN
72: l_query := l_query ||
73: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta
74: where htau.time_building_block_id= :p_det_bb_id
75: and htau.time_building_block_ovn = :p_det_bb_ovn
76: and tbb.time_building_block_id = htau.time_building_block_id
77: and tbb.object_version_number = htau.time_building_block_ovn

Line 83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

79: and htau.time_attribute_id = hta.time_attribute_id
80: and hta.attribute_category = :p_context';
81: else
82: l_query := l_query ||
83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
84: where htau.time_building_block_id= :p_det_bb_id
85: and htau.time_building_block_ovn = :p_det_bb_ovn
86: and tbb.time_building_block_id = htau.time_building_block_id
87: and tbb.object_version_number = htau.time_building_block_ovn

Line 96: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta

92: end if;
93: else
94: if p_context like 'PAEXPITDFF%' THEN
95: l_query := l_query ||
96: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta
97: where htau.time_building_block_id= :p_det_bb_id
98: and htau.time_building_block_ovn = :p_det_bb_ovn
99: and htau.time_attribute_id = hta.time_attribute_id
100: and hta.attribute_category = :p_context';

Line 103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

99: and htau.time_attribute_id = hta.time_attribute_id
100: and hta.attribute_category = :p_context';
101: else
102: l_query := l_query ||
103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
104: where htau.time_building_block_id= :p_det_bb_id
105: and htau.time_building_block_ovn = :p_det_bb_ovn
106: and htau.time_attribute_id = hta.time_attribute_id
107: and hta.bld_blk_info_type_id = bbit.bld_blk_info_type_id

Line 319: from hxc_time_attributes a,

315: ,a.object_version_number
316: ,'N' NEW
317: ,'N' CHANGED
318: ,'N' PROCESS
319: from hxc_time_attributes a,
320: hxc_time_attribute_usages au,
321: hxc_bld_blk_info_types bbit
322: where au.time_building_block_id = p_building_block_id
323: and au.time_building_block_ovn = p_ovn

Line 686: IF(l_table_name = 'HXC_TIME_ATTRIBUTES') THEN

682: CLOSE get_old_det_ovn;
683:
684: ELSE
685:
686: IF(l_table_name = 'HXC_TIME_ATTRIBUTES') THEN
687: l_day_detail_array(l_dd_count).new_entry := get_flex_value(l_column,l_context,l_det_bb_id,l_det_bb_ovn,c_new_get_type);
688: ELSIF (l_table_name = 'HXC_TIME_BUILDING_BLOCKS') THEN
689: l_day_detail_array(l_dd_count).new_entry := get_tbb_value(l_column,l_det_bb_id,l_det_bb_ovn,c_new_get_type);
690: END IF;

Line 702: IF(l_table_name = 'HXC_TIME_ATTRIBUTES') THEN

698:
699: IF (l_old_det_ovn = -1) THEN
700: l_day_detail_array(l_dd_count).old_entry := '';
701: ELSE
702: IF(l_table_name = 'HXC_TIME_ATTRIBUTES') THEN
703: l_day_detail_array(l_dd_count).old_entry := get_flex_value(l_column,l_context,l_det_bb_id,l_old_det_ovn,c_old_get_type);
704: ELSIF (l_table_name = 'HXC_TIME_BUILDING_BLOCKS') THEN
705: l_day_detail_array(l_dd_count).old_entry := get_tbb_value(l_column,l_det_bb_id,l_old_det_ovn,c_old_get_type);
706: END IF;

Line 827: hxc_time_attributes ta,

823: --Dynamic query to select alias value as get_alias_location gives storing attribute
824: -- and building block info type for each alias name
825: l_query:= 'select ta.'|| l_select;
826: l_query:= l_query || ' from
827: hxc_time_attributes ta,
828: hxc_time_attribute_usages tau,
829: HXC_BLD_BLK_INFO_TYPES bbit
830: where tau.time_building_block_id = :l_time_building_block_id and tau.time_building_block_ovn = :l_time_building_block_ovn
831: and tau.time_attribute_id = ta.time_attribute_id