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_BLOCK_TABLE_TYPE

Line 125: p_blocks in out nocopy hxc_block_table_type,

121: End load_attributes;
122:
123: Procedure load_top_level_block
124: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
125: p_blocks in out nocopy hxc_block_table_type,
126: p_top_level_start_date in out nocopy date,
127: p_top_level_stop_date in out nocopy date
128: ) is
129:

Line 163: p_blocks := hxc_block_table_type();

159: and date_to = hr_general.end_of_time;
160:
161: Begin
162: if(p_blocks is null) then
163: p_blocks := hxc_block_table_type();
164: end if;
165: p_blocks.extend;
166: open c_block_type_info(p_top_level_block_id);
167: fetch c_block_type_info into p_blocks(1);

Line 184: p_blocks in out nocopy hxc_block_table_type,

180: p_start_time in date,
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

Line 236: l_day_blocks hxc_block_table_type;

232: and timecard_check.object_version_number = days.parent_building_block_ovn
233: )
234: order by days.start_time;
235:
236: l_day_blocks hxc_block_table_type;
237: l_day_index pls_integer;
238:
239: Begin
240:

Line 241: l_day_blocks := hxc_block_table_type();

237: l_day_index pls_integer;
238:
239: Begin
240:
241: l_day_blocks := hxc_block_table_type();
242: open c_block_type_info;
243: fetch c_block_type_info bulk collect into l_day_blocks,p_day_id_list,p_day_ovn_list;
244: close c_block_type_info;
245: l_day_index := l_day_blocks.first;

Line 260: p_blocks in out nocopy hxc_block_table_type,

256: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%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

Line 304: l_day_blocks hxc_block_table_type;

300: and days_ovn.parent_building_block_id = top_level.time_building_block_Id
301: and days_ovn.parent_building_block_ovn = top_level.object_version_number)
302: order by days.start_time;
303:
304: l_day_blocks hxc_block_table_type;
305: l_day_index pls_integer;
306: Begin
307: l_day_blocks := hxc_block_table_type();
308: open c_block_type_info;

Line 307: l_day_blocks := hxc_block_table_type();

303:
304: l_day_blocks hxc_block_table_type;
305: l_day_index pls_integer;
306: Begin
307: l_day_blocks := hxc_block_table_type();
308: open c_block_type_info;
309: fetch c_block_type_info bulk collect into l_day_blocks,p_day_id_list,p_day_ovn_list;
310: close c_block_type_info;
311: l_day_index := l_day_blocks.first;

Line 322: (p_blocks in out nocopy hxc_block_table_type,

318:
319: End load_days;
320:
321: Procedure add_missing_days
322: (p_blocks in out nocopy hxc_block_table_type,
323: p_start_time in date,
324: p_stop_time in date
325: ) is
326:

Line 330: l_temp_blocks hxc_block_table_type;

326:
327: l_index pls_integer;
328: l_curr_day date;
329: l_day hxc_block_type;
330: l_temp_blocks hxc_block_table_type;
331: l_day_diff number;
332:
333: Begin
334: l_temp_blocks := hxc_block_table_type();

Line 334: l_temp_blocks := hxc_block_table_type();

330: l_temp_blocks hxc_block_table_type;
331: l_day_diff number;
332:
333: Begin
334: l_temp_blocks := hxc_block_table_type();
335: -- Check for days missing at the start
336: l_day_diff := trunc(fnd_date.canonical_to_date(p_blocks(2).start_time)) - trunc(p_start_time);
337: l_day := p_blocks(2);
338: if(l_day_diff > 0) then

Line 364: l_temp_blocks := hxc_block_table_type();

360: if(l_temp_blocks.count>0) then
361: p_blocks := l_temp_blocks;
362: end if;
363: -- Check for days missing at the end
364: l_temp_blocks := hxc_block_table_type();
365: l_day_diff := trunc(p_stop_time) - trunc(fnd_date.canonical_to_date(p_blocks(p_blocks.last).stop_time));
366: l_day := p_blocks(2);
367: if(l_day_diff > 0) then
368: -- preppend the existing days

Line 397: p_blocks in out NOCOPY hxc_block_table_type,

393: p_start_time in date,
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:

Line 443: l_detail_blocks hxc_block_table_type;

439: and days.object_version_number = details.parent_building_block_ovn
440: and adl.application_period_id = p_app_period_id
441: and details.date_to = hr_general.end_of_time;
442:
443: l_detail_blocks hxc_block_table_type;
444: l_detail_index pls_integer;
445:
446: Begin
447:

Line 448: l_detail_blocks := hxc_block_table_type();

444: l_detail_index pls_integer;
445:
446: Begin
447:
448: l_detail_blocks := hxc_block_table_type();
449: open c_block_type_info(p_app_period_id);
450: fetch c_block_type_info bulk collect into l_detail_blocks,p_detail_id_list, p_detail_ovn_list;
451: close c_block_type_info;
452:

Line 477: p_blocks in out NOCOPY hxc_block_table_type,

473: (p_day_id_list in block_id_list,
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:

Line 516: l_detail_blocks hxc_block_table_type;

512: and details.parent_building_block_ovn = p_day_ovn
513: and details.date_to = hr_general.end_of_time;
514:
515: l_day_index binary_integer;
516: l_detail_blocks hxc_block_table_type;
517: l_detail_index pls_integer;
518:
519: Begin
520: p_detail_id_list := block_id_list();

Line 522: l_detail_blocks := hxc_block_table_type();

518:
519: Begin
520: p_detail_id_list := block_id_list();
521: p_detail_ovn_list := block_ovn_list();
522: l_detail_blocks := hxc_block_table_type();
523: --
524: -- When can use forall and bulkcollect together
525: -- in SQL statements, change this to use forall!
526: --

Line 559: p_blocks out NOCOPY hxc_block_table_type,

555:
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,

Line 613: p_blocks out NOCOPY hxc_block_table_type,

609: End load_collection;
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

Line 645: p_blocks out NOCOPY hxc_block_table_type,

641: -- +--------------------------------------------------------------------------+
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

Line 681: p_blocks out NOCOPY hxc_block_table_type,

677: PROCEDURE get_application_period
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

Line 853: p_blocks out NOCOPY hxc_block_table_type,

849: -- +--------------------------------------------------------------------------+
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;

Line 877: p_blocks out NOCOPY hxc_block_table_type,

873: -- +--------------------------------------------------------------------------+
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

Line 884: p_blocks := hxc_block_table_type();

880: p_missing_rows in out NOCOPY boolean
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,

Line 901: p_blocks out NOCOPY hxc_block_table_type,

897: -- +--------------------------------------------------------------------------+
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

Line 911: p_blocks := hxc_block_table_type();

907: l_row_data hxc_trans_display_key_utils.translation_row_used;
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