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_INLINE_NOTIF_UTILS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 12: block_id hxc_time_building_blocks.time_building_block_id%type,

8: g_debug boolean := hr_utility.debug_enabled;
9:
10: type context_details is record
11: (context fnd_descr_flex_contexts.descriptive_flex_context_code%type,
12: block_id hxc_time_building_blocks.time_building_block_id%type,
13: entered boolean
14: );
15:
16: type context_details_table is table of context_details index by binary_integer;

Line 23: RETURN 'HXC_TIME_BUILDING_BLOCKS';

19: RETURN VARCHAR2
20: AS
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 '';

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 186: from hxc_time_building_blocks

182: l_column := p_column;
183: END IF;
184:
185: l_query := 'select '||l_column||'
186: from hxc_time_building_blocks
187: where time_building_block_id = :p_det_bb_id
188: and object_version_number = :p_det_bb_ovn';
189:
190: if(p_get_type=c_new_get_type) then

Line 214: (p_bb_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,

210: p_blocks IN OUT NOCOPY hxc_self_service_time_deposit.timecard_info)
211: AS
212:
213: CURSOR c_time_building_blocks
214: (p_bb_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
215: p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
216: p_get_type in varchar2) is
217: select tbb1.TIME_BUILDING_BLOCK_ID
218: ,tbb1.TYPE

Line 215: p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,

211: AS
212:
213: CURSOR c_time_building_blocks
214: (p_bb_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE,
215: p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE,
216: p_get_type in varchar2) is
217: select tbb1.TIME_BUILDING_BLOCK_ID
218: ,tbb1.TYPE
219: ,tbb1.MEASURE

Line 240: from hxc_time_building_blocks tbb1

236: ,'N' CHANGED
237: ,'N' PROCESS
238: ,tbb1.application_set_id
239: ,tbb1.translation_display_key
240: from hxc_time_building_blocks tbb1
241: where tbb1.TIME_BUILDING_BLOCK_ID = p_bb_id
242: and tbb1.OBJECT_VERSION_NUMBER = p_bb_ovn
243: and decode(p_get_type,'NEW',hr_general.end_of_time,tbb1.date_to) = tbb1.date_to;
244:

Line 267: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

263:
264: END;
265:
266: PROCEDURE get_attributes(
267: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
268: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
269: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
270: )
271: IS

Line 268: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

264: END;
265:
266: PROCEDURE get_attributes(
267: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
268: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
269: ,p_attributes IN OUT NOCOPY hxc_self_service_time_deposit.building_block_attribute_info
270: )
271: IS
272: l_attribute_index NUMBER;

Line 276: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

272: l_attribute_index NUMBER;
273: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
274:
275: CURSOR c_block_attributes(
276: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
277: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
278: )
279: IS
280: select a.time_attribute_id

Line 277: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

273: l_temp_attribute hxc_self_service_time_deposit.attribute_info;
274:
275: CURSOR c_block_attributes(
276: p_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
277: ,p_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
278: )
279: IS
280: select a.time_attribute_id
281: ,au.time_building_block_id

Line 478: p_block_id in hxc_time_building_blocks.time_building_block_id%type

474:
475: function context_index
476: (p_context_details in context_details_table,
477: p_context in varchar2,
478: p_block_id in hxc_time_building_blocks.time_building_block_id%type
479: ) return pls_integer is
480: l_index pls_integer;
481: begin
482: l_index := p_context_details.first;

Line 544: p_block_id in hxc_time_building_blocks.time_building_block_id%type,

540: End parse_day_details_table;
541:
542: procedure maintain_context_details
543: (p_context_details in out nocopy context_details_table,
544: p_block_id in hxc_time_building_blocks.time_building_block_id%type,
545: p_context in varchar2,
546: p_new_entry in varchar2,
547: p_old_entry in varchar2) is
548: l_index pls_integer;

Line 594: from hxc_time_building_blocks htbb, hxc_ap_detail_links hadl

590:
591: cursor get_last_creation_dates(p_app_bb_id NUMBER) is
592: select tab.creation_date
593: from (select distinct htbb.creation_date creation_date
594: from hxc_time_building_blocks htbb, hxc_ap_detail_links hadl
595: where htbb.time_building_block_id = hadl.time_building_block_id
596: and hadl.application_period_id = p_app_bb_id
597: order by creation_date desc) tab
598: where rownum <= 2;

Line 603: from hxc_time_building_blocks detail,hxc_time_building_blocks day

599:
600: cursor get_tk_last_creation_dates(p_app_bb_id NUMBER) is
601: select tab.creation_date
602: from (select distinct detail.creation_date creation_date
603: from hxc_time_building_blocks detail,hxc_time_building_blocks day
604: where day.parent_building_block_id =p_app_bb_id
605: and detail.parent_building_block_id = day.time_building_block_id
606: and detail.parent_building_block_ovn = day.object_version_number
607: and detail.scope='DETAIL'

Line 613: from hxc_time_building_blocks htbb

609: where rownum <= 2;
610:
611: cursor get_old_det_ovn(p_det_bb_id NUMBER,p_last_creation_date DATE) is
612: select NVL(max(object_version_number),-1)
613: from hxc_time_building_blocks htbb
614: where htbb.creation_date <= (p_last_creation_date+0.000011574)
615: and date_to <> hr_general.end_of_time
616: and htbb.time_building_block_id = p_det_bb_id
617: and htbb.approval_status = hxc_timecard.c_submitted_status;

Line 688: ELSIF (l_table_name = 'HXC_TIME_BUILDING_BLOCKS') THEN

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;
691:
692:

Line 704: ELSIF (l_table_name = 'HXC_TIME_BUILDING_BLOCKS') 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;
707: END IF;
708: