[Home] [Help]
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
403: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type)
456: p_blocks.extend;
457: p_blocks(p_blocks.last) := l_detail_blocks(l_detail_index);
458: l_detail_index := l_detail_blocks.next(l_detail_index);
459: if(p_missing_rows) then
460: hxc_trans_display_key_utils.set_row_data
461: (p_blocks(p_blocks.last).translation_display_key,
462: p_row_data);
463: end if;
464: End Loop;
463: end if;
464: End Loop;
465:
466: If (p_missing_rows) then
467: p_missing_rows := hxc_trans_display_key_utils.missing_rows(p_row_data);
468: end if;
469:
470: End load_app_period_details;
471:
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
483: (p_day_id in hxc_time_building_blocks.time_building_block_id%type,
540: p_detail_ovn_list.extend;
541: p_detail_ovn_list(p_detail_ovn_list.last) := p_blocks(p_blocks.last).object_version_number;
542: l_detail_index := l_detail_blocks.next(l_detail_index);
543: if(p_missing_rows) then
544: hxc_trans_display_key_utils.set_row_data
545: (p_blocks(p_blocks.last).translation_display_key,
546: p_row_data);
547: end if;
548: End Loop;
548: End Loop;
549: l_day_index := p_day_id_list.next(l_day_index);
550: End Loop;
551: If (p_missing_rows) then
552: p_missing_rows := hxc_trans_display_key_utils.missing_rows(p_row_data);
553: end if;
554: End load_details;
555:
556: PROCEDURE load_collection
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
565: ) is
566:
567: l_day_id_list block_id_list;
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:
619: l_discard_date1 date;
738: and p.person_id (+) = apsum.approver_id
739: and p.effective_end_date (+) = hr_general.end_of_time
740: and bbit.bld_blk_info_type = 'APPROVAL';
741:
742: l_row_data hxc_trans_display_key_utils.translation_row_used;
743: l_missing_rows boolean;
744: l_app_period_start_time date;
745: l_app_period_stop_time date;
746: l_attribute hxc_attribute_type;
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
859: -- Tell load collection we do not care about
860: -- the row translation information.
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
883:
903: p_template_start_time out NOCOPY date,
904: p_template_stop_time out NOCOPY date
905: )is
906:
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();