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

Line 193: if(hxc_timecard_block_utils.is_new_block(p_block)) then

189: return varchar2 is
190:
191: Begin
192:
193: if(hxc_timecard_block_utils.is_new_block(p_block)) then
194: --
195: -- Process flag is set to No for new block.
196: -- User probably entered it, then deleted it
197: -- without commit to db inbetween. Don't

Line 302: l_parent_chk := hxc_timecard_block_utils.is_parent_block

298: EXIT WHEN NOT p_block_list.exists(l_index);
299:
300: l_block := p_blocks(p_block_list(l_index));
301:
302: l_parent_chk := hxc_timecard_block_utils.is_parent_block
303: (p_block => l_block,
304: p_parent_id => l_old_bb_id,
305: p_parent_ovn => l_old_ovn,
306: p_check_id => true

Line 406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)

402: (p_effective_date => sysdate
403: ,p_type => p_block.type
404: ,p_measure => p_block.measure
405: ,p_unit_of_measure => p_block.unit_of_measure
406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
408: ,p_parent_building_block_id => p_block.parent_building_block_id
409: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
410: ,p_scope => p_block.scope

Line 407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)

403: ,p_type => p_block.type
404: ,p_measure => p_block.measure
405: ,p_unit_of_measure => p_block.unit_of_measure
406: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
407: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
408: ,p_parent_building_block_id => p_block.parent_building_block_id
409: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
410: ,p_scope => p_block.scope
411: ,p_approval_style_id => p_block.approval_style_id

Line 480: if(hxc_timecard_block_utils.is_active_block(p_block)) then

476: -- Call the API, with the real values!
477: --
478:
479:
480: if(hxc_timecard_block_utils.is_active_block(p_block)) then
481:
482: hxc_building_block_api.create_building_block
483: (p_effective_date => sysdate
484: ,p_type => p_block.type

Line 487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)

483: (p_effective_date => sysdate
484: ,p_type => p_block.type
485: ,p_measure => p_block.measure
486: ,p_unit_of_measure => p_block.unit_of_measure
487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
489: ,p_parent_building_block_id => p_block.parent_building_block_id
490: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
491: ,p_scope => p_block.scope

Line 488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)

484: ,p_type => p_block.type
485: ,p_measure => p_block.measure
486: ,p_unit_of_measure => p_block.unit_of_measure
487: ,p_start_time => hxc_timecard_block_utils.date_value(p_block.start_time)
488: ,p_stop_time => hxc_timecard_block_utils.date_value(p_block.stop_time)
489: ,p_parent_building_block_id => p_block.parent_building_block_id
490: ,p_parent_building_block_ovn => p_block.parent_building_block_ovn
491: ,p_scope => p_block.scope
492: ,p_approval_style_id => p_block.approval_style_id

Line 574: if(hxc_timecard_block_utils.process_block(l_block)) then

570: EXIT WHEN NOT p_timecard_blocks.exists(l_index);
571:
572: l_block := p_blocks(p_timecard_blocks(l_index));
573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then

571:
572: l_block := p_blocks(p_timecard_blocks(l_index));
573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
579: if(l_new_bb_id is not null) then

Line 577: if(hxc_timecard_block_utils.is_new_block(l_block)) then

573: -- if(p_messages.count < 1) then
574: if(hxc_timecard_block_utils.process_block(l_block)) then
575: if(hxc_timecard_block_utils.is_timecard_block(l_block)) then
576:
577: if(hxc_timecard_block_utils.is_new_block(l_block)) then
578: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
579: if(l_new_bb_id is not null) then
580: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
581: end if;

Line 651: if(hxc_timecard_block_utils.process_block(l_block)) then

647: EXIT WHEN NOT p_day_blocks.exists(l_index);
648:
649: l_block := p_blocks(p_day_blocks(l_index));
650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 652: if(hxc_timecard_block_utils.is_day_block(l_block)) then

648:
649: l_block := p_blocks(p_day_blocks(l_index));
650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
656: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);

Line 654: if(hxc_timecard_block_utils.is_new_block(l_block)) then

650:
651: if(hxc_timecard_block_utils.process_block(l_block)) then
652: if(hxc_timecard_block_utils.is_day_block(l_block)) then
653:
654: if(hxc_timecard_block_utils.is_new_block(l_block)) then
655: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
656: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
657: p_blocks(p_day_blocks(l_index)) := l_block;
658: maintain_dependents

Line 781: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then

777: EXIT WHEN NOT p_detail_blocks.exists(l_index) OR l_duplicate_block;
778:
779: l_block := p_blocks(p_detail_blocks(l_index));
780:
781: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then
782: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');
783: l_duplicate_block := true;
784: end if;
785:

Line 817: if(hxc_timecard_block_utils.process_block(l_block)) then

813: EXIT WHEN NOT p_detail_blocks.exists(l_index);
814:
815: l_block := p_blocks(p_detail_blocks(l_index));
816:
817: if(hxc_timecard_block_utils.process_block(l_block)) then
818: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
819:
820: if(hxc_timecard_block_utils.is_new_block(l_block)) then
821: if(hxc_timecard_block_utils.is_active_block(l_block)) then

Line 818: if(hxc_timecard_block_utils.is_detail_block(l_block)) then

814:
815: l_block := p_blocks(p_detail_blocks(l_index));
816:
817: if(hxc_timecard_block_utils.process_block(l_block)) then
818: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
819:
820: if(hxc_timecard_block_utils.is_new_block(l_block)) then
821: if(hxc_timecard_block_utils.is_active_block(l_block)) then
822: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

Line 820: if(hxc_timecard_block_utils.is_new_block(l_block)) then

816:
817: if(hxc_timecard_block_utils.process_block(l_block)) then
818: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
819:
820: if(hxc_timecard_block_utils.is_new_block(l_block)) then
821: if(hxc_timecard_block_utils.is_active_block(l_block)) then
822: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
823: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
824: p_blocks(p_detail_blocks(l_index)) := l_block;

Line 821: if(hxc_timecard_block_utils.is_active_block(l_block)) then

817: if(hxc_timecard_block_utils.process_block(l_block)) then
818: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
819:
820: if(hxc_timecard_block_utils.is_new_block(l_block)) then
821: if(hxc_timecard_block_utils.is_active_block(l_block)) then
822: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
823: add_transaction_info(l_new_bb_id,1,null,p_transaction_info,p_messages);
824: p_blocks(p_detail_blocks(l_index)) := l_block;
825: maintain_dependents

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

970:
971: Begin
972:
973: --***********DAYS Vs HOURS - Start ************
974: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
975: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
976: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
977: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
978: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

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

973: --***********DAYS Vs HOURS - Start ************
974: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
975: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
976: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
977: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
978: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
979: l_resource_id := p_blocks(l_active_index).resource_id;
980:
981: --Get the Preference value - Time Store Days to Hour Conversion

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

974: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
975: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
976: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
977: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
978: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
979: l_resource_id := p_blocks(l_active_index).resource_id;
980:
981: --Get the Preference value - Time Store Days to Hour Conversion
982: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,

Line 1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);

1263:
1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

Line 1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);

1264: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1265: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;

Line 1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,

1266: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1273: close c_check_bussiness_group_id;
1274:

Line 1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

1267: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1268: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1269:
1270: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1271: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1272: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1273: close c_check_bussiness_group_id;
1274:
1275: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);

Line 1301: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

1297: -- Blocks have to be in order, to ensure
1298: -- self referential integrity
1299:
1300: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1301: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1302: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1303: deposit_day_blocks(p_blocks,p_attributes,p_day_blocks,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1304: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1305: --

Line 1302: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

1298: -- self referential integrity
1299:
1300: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1301: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1302: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1303: deposit_day_blocks(p_blocks,p_attributes,p_day_blocks,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1304: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1305: --
1306: -- And now corresponding attributes