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_BLOCK_COLLECTION_UTILS dependencies on HXC_ATTRIBUTE_TABLE_TYPE

Line 34: p_attributes in out NOCOPY hxc_attribute_table_type

30: Procedure load_attributes
31: (p_block_id_list in block_id_list,
32: p_block_ovn_list in block_ovn_list,
33: p_load_template_attributes in varchar2,
34: p_attributes in out NOCOPY hxc_attribute_table_type
35: ) is
36:
37: cursor c_attribute_type_info
38: (p_block_id in hxc_time_building_blocks.time_building_block_id%type,

Line 96: l_attributes hxc_attribute_table_type;

92: ta.attribute_category <> nvl(decode(p_load_template_attributes,'Y','SECURITY'),'$Sys_deF$')
93: )
94: and ta.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
95:
96: l_attributes hxc_attribute_table_type;
97: l_attribute_index binary_integer;
98: l_block_index binary_integer;
99:
100: Begin

Line 102: p_attributes := hxc_attribute_table_type();

98: l_block_index binary_integer;
99:
100: Begin
101: if(p_attributes is null) then
102: p_attributes := hxc_attribute_table_type();
103: end if;
104: l_attributes := hxc_attribute_table_type();
105: l_block_index := p_block_id_list.first;
106: Loop

Line 104: l_attributes := hxc_attribute_table_type();

100: Begin
101: if(p_attributes is null) then
102: p_attributes := hxc_attribute_table_type();
103: end if;
104: l_attributes := hxc_attribute_table_type();
105: l_block_index := p_block_id_list.first;
106: Loop
107: Exit when not p_block_id_list.exists(l_block_index);
108: open c_attribute_type_info(p_block_id_list(l_block_index),p_block_ovn_list(l_block_index),p_load_template_attributes);

Line 185: p_attributes in out nocopy hxc_attribute_table_type

181: p_stop_time in date,
182: p_day_id_list out nocopy block_id_list,
183: p_day_ovn_list out nocopy block_ovn_list,
184: p_blocks in out nocopy hxc_block_table_type,
185: p_attributes in out nocopy hxc_attribute_table_type
186: ) is
187:
188: CURSOR c_block_type_info is
189: select hxc_block_type

Line 261: p_attributes in out nocopy hxc_attribute_table_type

257: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,
258: p_day_id_list out nocopy block_id_list,
259: p_day_ovn_list out nocopy block_ovn_list,
260: p_blocks in out nocopy hxc_block_table_type,
261: p_attributes in out nocopy hxc_attribute_table_type
262: ) is
263:
264: CURSOR c_block_type_info is
265: select hxc_block_type

Line 398: p_attributes in out NOCOPY hxc_attribute_table_type,

394: p_stop_time in date,
395: p_detail_id_list in out nocopy block_id_list,
396: p_detail_ovn_list in out nocopy block_ovn_list,
397: p_blocks in out NOCOPY hxc_block_table_type,
398: p_attributes in out NOCOPY hxc_attribute_table_type,
399: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
400: p_missing_rows in out NOCOPY boolean) is
401:
402: CURSOR c_block_type_info

Line 478: p_attributes in out NOCOPY hxc_attribute_table_type,

474: p_day_ovn_list in block_ovn_list,
475: p_detail_id_list in out nocopy block_id_list,
476: p_detail_ovn_list in out nocopy block_ovn_list,
477: p_blocks in out NOCOPY hxc_block_table_type,
478: p_attributes in out NOCOPY hxc_attribute_table_type,
479: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
480: p_missing_rows in out NOCOPY boolean) is
481:
482: CURSOR c_block_type_info

Line 560: p_attributes out NOCOPY hxc_attribute_table_type,

556: PROCEDURE load_collection
557: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
558: p_load_template_attributes in varchar2,
559: p_blocks out NOCOPY hxc_block_table_type,
560: p_attributes out NOCOPY hxc_attribute_table_type,
561: p_top_level_start_date out NOCOPY date,
562: p_top_level_stop_date out NOCOPY date,
563: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
564: p_missing_rows in out NOCOPY boolean

Line 614: p_attributes out NOCOPY hxc_attribute_table_type,

610:
611: PROCEDURE load_collection
612: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
613: p_blocks out NOCOPY hxc_block_table_type,
614: p_attributes out NOCOPY hxc_attribute_table_type,
615: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
616: p_missing_rows in out NOCOPY boolean
617: ) is
618:

Line 646: p_attributes out NOCOPY hxc_attribute_table_type

642: --
643: PROCEDURE get_application_period
644: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
645: p_blocks out NOCOPY hxc_block_table_type,
646: p_attributes out NOCOPY hxc_attribute_table_type
647: ) is
648:
649: cursor c_app_period_times
650: (p_application_period_id in hxc_app_period_summary.application_period_id%type) is

Line 682: p_attributes out NOCOPY hxc_attribute_table_type

678: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
679: p_start_time in date,
680: p_stop_time in date,
681: p_blocks out NOCOPY hxc_block_table_type,
682: p_attributes out NOCOPY hxc_attribute_table_type
683: ) is
684:
685: cursor c_app_attribute
686: (p_app_period_id hxc_time_building_blocks.time_building_block_id%type) is

Line 785: p_attributes := hxc_attribute_table_type();

781: -- Ok, now add the dummy application attribute, still used in the fragment view
782: -- Since the block structure does not include the columns from the summary tables
783: --
784: if(p_attributes is null) then
785: p_attributes := hxc_attribute_table_type();
786: end if;
787: open c_app_attribute(p_app_period_id);
788: fetch c_app_attribute into l_attribute;
789: if(c_app_attribute%found) then

Line 854: p_attributes out NOCOPY hxc_attribute_table_type

850: --
851: PROCEDURE get_timecard
852: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
853: p_blocks out NOCOPY hxc_block_table_type,
854: p_attributes out NOCOPY hxc_attribute_table_type
855: ) is
856: l_row_data hxc_trans_display_key_utils.translation_row_used;
857: l_missing_rows boolean;
858: Begin

Line 878: p_attributes out NOCOPY hxc_attribute_table_type,

874: --
875: PROCEDURE get_timecard
876: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
877: p_blocks out NOCOPY hxc_block_table_type,
878: p_attributes out NOCOPY hxc_attribute_table_type,
879: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
880: p_missing_rows in out NOCOPY boolean
881: ) is
882: Begin

Line 885: p_attributes := hxc_attribute_table_type();

881: ) is
882: Begin
883:
884: p_blocks := hxc_block_table_type();
885: p_attributes := hxc_attribute_table_type();
886: load_collection
887: (p_timecard_id,
888: p_blocks,
889: p_attributes,

Line 902: p_attributes out NOCOPY hxc_attribute_table_type,

898: --
899: PROCEDURE get_template
900: (p_template_id in hxc_time_building_blocks.time_building_block_id%type,
901: p_blocks out NOCOPY hxc_block_table_type,
902: p_attributes out NOCOPY hxc_attribute_table_type,
903: p_template_start_time out NOCOPY date,
904: p_template_stop_time out NOCOPY date
905: )is
906:

Line 912: p_attributes := hxc_attribute_table_type();

908: l_missing_rows boolean;
909:
910: Begin
911: p_blocks := hxc_block_table_type();
912: p_attributes := hxc_attribute_table_type();
913: l_missing_rows := false;
914:
915: load_collection
916: (p_template_id,