[Home] [Help]
719:
720: l_index := p_details.first;
721: Loop
722: Exit When Not p_details.exists(l_index);
723: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
724:
725: IF p_blocks(p_details(l_index)).start_time is not null and
726: p_blocks(p_details(l_index)).stop_time is null and
727: (p_blocks(p_details(l_index)).approval_status = hxc_timecard.c_submitted_status
765: l_index := p_details.first;
766:
767: Loop
768: Exit When Not p_details.exists(l_index);
769: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
770: l_detail_date := trunc(
771: hxc_timecard_block_utils.date_value(
772: p_blocks(
773: p_days(
767: Loop
768: Exit When Not p_details.exists(l_index);
769: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_index)))) then
770: l_detail_date := trunc(
771: hxc_timecard_block_utils.date_value(
772: p_blocks(
773: p_days(
774: p_blocks(p_details(l_index)).parent_building_block_id
775: )
867: l_block_index := p_details.first;
868:
869: Loop
870: Exit When Not p_details.exists(l_block_index);
871: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_block_index)))) then
872: l_detail_date := trunc(
873: hxc_timecard_block_utils.date_value(
874: p_blocks(
875: p_days(
869: Loop
870: Exit When Not p_details.exists(l_block_index);
871: if(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_block_index)))) then
872: l_detail_date := trunc(
873: hxc_timecard_block_utils.date_value(
874: p_blocks(
875: p_days(
876: p_blocks(p_details(l_block_index)).parent_building_block_id
877: )
947: -- First find the "active" timecard scope building block
948: -- index.
949: --
950:
951: l_tc_index := hxc_timecard_block_utils.find_active_timecard_index
952: (p_blocks => p_blocks);
953:
954:
955: l_validate_on_save := hxc_timecard_properties.find_property_value
1596: p_attributes
1597: )
1598: )
1599: OR
1600: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))
1601: --AND
1602: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1603: )then
1604:
1598: )
1599: OR
1600: (hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))))
1601: --AND
1602: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1603: )then
1604:
1605: l_detail_date := trunc(hxc_timecard_block_utils.date_value
1606: (p_blocks(p_days(p_blocks(p_details(l_detail_index)).parent_building_block_id)).start_time
1601: --AND
1602: --(hxc_timecard_block_utils.is_active_block(p_blocks(p_details(l_detail_index))))
1603: )then
1604:
1605: l_detail_date := trunc(hxc_timecard_block_utils.date_value
1606: (p_blocks(p_days(p_blocks(p_details(l_detail_index)).parent_building_block_id)).start_time
1607: ));
1608: if(day_locked(p_timecard_props, p_blocks(p_details(l_detail_index)).resource_id,l_detail_date)) then
1609: hxc_timecard_message_helper.addErrorToCollection
1618: ,null
1619: ,null
1620: );
1621: else
1622: if(hxc_timecard_block_utils.is_new_block(p_blocks(p_details(l_detail_index)))) then
1623: --
1624: -- It is ok, this entry is allowed, the day is not locked, and it is a new
1625: -- building block
1626: --
1702:
1703: l_index := p_blocks.first;
1704: LOOP
1705: Exit When ((Not p_blocks.exists(l_index)) or (l_found));
1706: if(hxc_timecard_block_utils.process_block(p_blocks(l_index))) then
1707: l_found := true;
1708: end if;
1709: l_index := p_blocks.next(l_index);
1710: END LOOP;