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_TIMECARD dependencies on HXC_TIMECARD_BLOCK_UTILS

Line 169: hxc_timecard_block_utils.sort_blocks

165:
166: /*
167: Sort blocks
168: */
169: hxc_timecard_block_utils.sort_blocks
170: (p_blocks => p_blocks
171: ,p_timecard_blocks => l_timecard_blocks
172: ,p_day_blocks => l_day_blocks
173: ,p_detail_blocks => l_detail_blocks

Line 264: hxc_timecard_block_utils.sort_blocks

260:
261: /* End of fix for bug 6489820 */
262:
263: /* fix by senthil for bug 5099360*/
264: hxc_timecard_block_utils.sort_blocks
265: (p_blocks => p_blocks
266: ,p_timecard_blocks => l_timecard_blocks
267: ,p_day_blocks => l_day_blocks
268: ,p_detail_blocks => l_detail_blocks

Line 349: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

345: end if;
346:
347: if hxc_timecard_message_helper.noErrors then
348:
349: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
350:
351: /*
352: Bug 3345143 - this is done in the summary apis now.
353:

Line 385: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

381: (p_messages => p_messages);
382:
383: end if;
384:
385: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
386: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
387:
388:
389: -- OTL-Absences Integration (Bug 8779478)

Line 386: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

382:
383: end if;
384:
385: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
386: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
387:
388:
389: -- OTL-Absences Integration (Bug 8779478)
390: -- Moved the following code inside a BEGIN-EXCEPTION-END block to handle exceptions effectively

Line 395: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN

391: -- for Bug 8888138
392: BEGIN
393: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
394: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
395: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN
396:
397: IF g_debug THEN
398: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.SAVE_TIMECARD');
399: END IF;

Line 401: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);

397: IF g_debug THEN
398: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.SAVE_TIMECARD');
399: END IF;
400:
401: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);
402: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time);
403: l_resource_id := p_blocks(l_timecard_index).resource_id;
404: l_tc_status := p_blocks(l_timecard_index).approval_status;
405:

Line 402: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time);

398: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.SAVE_TIMECARD');
399: END IF;
400:
401: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);
402: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time);
403: l_resource_id := p_blocks(l_timecard_index).resource_id;
404: l_tc_status := p_blocks(l_timecard_index).approval_status;
405:
406: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,

Line 555: hxc_timecard_block_utils.initialize_timecard_index;

551: l_index := l_attributes.next(l_index);
552: END LOOP;
553: END IF;
554:
555: hxc_timecard_block_utils.initialize_timecard_index;
556:
557: ----------------- Default Attributes -------------------------------------------------------
558: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
559: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);

Line 558: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

554:
555: hxc_timecard_block_utils.initialize_timecard_index;
556:
557: ----------------- Default Attributes -------------------------------------------------------
558: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
559: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
560: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
561: l_resource_id := p_blocks(l_active_index).resource_id;
562:

Line 559: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);

555: hxc_timecard_block_utils.initialize_timecard_index;
556:
557: ----------------- Default Attributes -------------------------------------------------------
558: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
559: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
560: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
561: l_resource_id := p_blocks(l_active_index).resource_id;
562:
563:

Line 560: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

556:
557: ----------------- Default Attributes -------------------------------------------------------
558: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
559: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
560: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
561: l_resource_id := p_blocks(l_active_index).resource_id;
562:
563:
564: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,

Line 594: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

590: /*
591: Determine if this is a resubmitted timecard
592: */
593:
594: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
595:
596: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
597: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
598: (p_blocks(l_timecard_index).time_building_block_id

Line 596: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then

592: */
593:
594: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
595:
596: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
597: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
598: (p_blocks(l_timecard_index).time_building_block_id
599: ,p_blocks(l_timecard_index).object_version_number
600: ,p_blocks(l_timecard_index).resource_id

Line 601: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

597: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
598: (p_blocks(l_timecard_index).time_building_block_id
599: ,p_blocks(l_timecard_index).object_version_number
600: ,p_blocks(l_timecard_index).resource_id
601: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
602: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
603: );
604: else
605: l_resubmit := c_delete;

Line 602: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)

598: (p_blocks(l_timecard_index).time_building_block_id
599: ,p_blocks(l_timecard_index).object_version_number
600: ,p_blocks(l_timecard_index).resource_id
601: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
602: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
603: );
604: else
605: l_resubmit := c_delete;
606: end if;

Line 615: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;

611: this information in from the
612: middle tier, to avoid another
613: pref evaluation
614: */
615: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;
616: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;
617:
618: if (l_tbb_id <0 ) then -- when we are creating tmecard/template the id will be -ve value,so in this case we pass
619: l_tbb_id := null; -- NULL instead of -ve value

Line 616: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;

612: middle tier, to avoid another
613: pref evaluation
614: */
615: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;
616: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;
617:
618: if (l_tbb_id <0 ) then -- when we are creating tmecard/template the id will be -ve value,so in this case we pass
619: l_tbb_id := null; -- NULL instead of -ve value
620: l_tbb_ovn :=null;

Line 626: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

622:
623: hxc_timecard_properties.get_preference_properties
624: (p_validate => c_yes
625: ,p_resource_id => p_blocks(l_timecard_index).resource_id
626: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
627: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
628: ,p_for_timecard => false
629: ,p_messages => p_messages
630: ,p_property_table => l_timecard_props

Line 627: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)

623: hxc_timecard_properties.get_preference_properties
624: (p_validate => c_yes
625: ,p_resource_id => p_blocks(l_timecard_index).resource_id
626: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
627: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
628: ,p_for_timecard => false
629: ,p_messages => p_messages
630: ,p_property_table => l_timecard_props
631: ,p_timecard_bb_id => l_tbb_id -- passs the extra parameter timecard ID

Line 709: hxc_timecard_block_utils.sort_blocks

705:
706: else
707: if((p_validate = c_yes)OR(p_template=c_yes)) then
708:
709: hxc_timecard_block_utils.sort_blocks
710: (p_blocks => p_blocks
711: ,p_timecard_blocks => l_timecard_blocks
712: ,p_day_blocks => l_day_blocks
713: ,p_detail_blocks => l_detail_blocks

Line 914: hxc_timecard_block_utils.sort_blocks

910: if(l_day_blocks.count = 0) then
911: --
912: -- Only bother to resort if we have to
913: --
914: hxc_timecard_block_utils.sort_blocks
915: (p_blocks => g_deposit_blocks
916: ,p_timecard_blocks => l_timecard_blocks
917: ,p_day_blocks => l_day_blocks
918: ,p_detail_blocks => l_detail_blocks

Line 1135: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;

1131: hxc_timecard_message_helper.processerrors
1132: (p_messages => p_messages);
1133:
1134: p_timecard_id := g_deposit_blocks
1135: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
1136:
1137: p_timecard_ovn := g_deposit_blocks
1138: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
1139:

Line 1138: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;

1134: p_timecard_id := g_deposit_blocks
1135: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
1136:
1137: p_timecard_ovn := g_deposit_blocks
1138: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
1139:
1140: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
1141:
1142:

Line 1175: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)

1171: BEGIN
1172: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
1173: THEN
1174: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
1175: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)
1176: THEN
1177:
1178: IF g_debug THEN
1179: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DEPOSIT_CONTROLLER');

Line 1183: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);

1179: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DEPOSIT_CONTROLLER');
1180: END IF;
1181:
1182: l_resource_id := p_blocks(l_timecard_index).resource_id ;
1183: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);
1184: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time) ;
1185: l_tc_status := p_blocks(l_timecard_index).approval_status ;
1186:
1187: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,

Line 1184: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time) ;

1180: END IF;
1181:
1182: l_resource_id := p_blocks(l_timecard_index).resource_id ;
1183: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);
1184: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time) ;
1185: l_tc_status := p_blocks(l_timecard_index).approval_status ;
1186:
1187: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,
1188: l_start_date,

Line 1545: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

1541: -- For bug
1542: -- If the lock is invalid, it might just have timed out, therefore
1543: -- request a new lock.
1544: --
1545: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1546:
1547: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then
1548:
1549: hxc_lock_api.request_lock

Line 1547: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then

1543: -- request a new lock.
1544: --
1545: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1546:
1547: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then
1548:
1549: hxc_lock_api.request_lock
1550: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
1551: ,p_resource_id=> p_blocks(l_timecard_index).resource_id

Line 1583: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

1579: end if;
1580:
1581: -- OTL - ABS Integration
1582:
1583: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1584:
1585: hxc_retrieve_absences.g_lock_row_id := p_lock_rowid;
1586: hxc_retrieve_absences.g_person_id := p_blocks(l_timecard_index).resource_id;
1587: hxc_retrieve_absences.g_start_time := FND_DATE.canonical_to_date(p_blocks(l_timecard_index).start_time);

Line 1693: l_blocks(l_block_count) := hxc_timecard_block_utils.build_block

1689: Begin
1690:
1691: for block_rec in c_blocks(p_timecard_id) loop
1692: l_blocks.extend;
1693: l_blocks(l_block_count) := hxc_timecard_block_utils.build_block
1694: (block_rec.time_building_block_id
1695: ,block_rec.object_version_number);
1696: if(p_load_mode = c_delete) then
1697: --

Line 1923: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);

1919: --
1920: -- Main delete processing
1921: --
1922:
1923: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
1924:
1925: hxc_timecard_properties.get_preference_properties
1926: (p_validate => hxc_timecard.c_yes
1927: ,p_resource_id => l_blocks(l_timecard_index).resource_id

Line 1928: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)

1924:
1925: hxc_timecard_properties.get_preference_properties
1926: (p_validate => hxc_timecard.c_yes
1927: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1928: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1929: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1930: ,p_for_timecard => false
1931: ,p_messages => l_messages
1932: ,p_property_table => l_timecard_props

Line 1929: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)

1925: hxc_timecard_properties.get_preference_properties
1926: (p_validate => hxc_timecard.c_yes
1927: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1928: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1929: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1930: ,p_for_timecard => false
1931: ,p_messages => l_messages
1932: ,p_property_table => l_timecard_props
1933: ,p_timecard_bb_id => p_timecard_id --passs the extra parameter timecard ID

Line 1942: hxc_timecard_block_utils.sort_blocks

1938: (p_messages => l_messages);
1939:
1940: l_messages.delete;
1941:
1942: hxc_timecard_block_utils.sort_blocks
1943: (p_blocks => l_blocks
1944: ,p_timecard_blocks => l_timecard_blocks
1945: ,p_day_blocks => l_day_blocks
1946: ,p_detail_blocks => l_detail_blocks