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 1082: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then

1078: EXIT WHEN NOT p_detail_blocks.exists(l_index) OR l_duplicate_block;
1079:
1080: l_block := p_blocks(p_detail_blocks(l_index));
1081:
1082: if(hxc_timecard_block_utils.is_active_block(l_block) AND is_duplicate_block(p_blocks, l_block)) then
1083: hr_utility.trace(' DUPLICATE BLOCK is TRUE ');
1084: l_duplicate_block := true;
1085: end if;
1086:

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

1143: EXIT WHEN NOT p_detail_blocks.exists(l_index);
1144:
1145: l_block := p_blocks(p_detail_blocks(l_index));
1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then

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

1144:
1145: l_block := p_blocks(p_detail_blocks(l_index));
1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);

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

1146:
1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
1153: -- OTL - ABS Integration
1154: l_element := find_element(p_attributes,l_old_bb_id);

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

1147: if(hxc_timecard_block_utils.process_block(l_block)) then
1148: if(hxc_timecard_block_utils.is_detail_block(l_block)) then
1149:
1150: if(hxc_timecard_block_utils.is_new_block(l_block)) then
1151: if(hxc_timecard_block_utils.is_active_block(l_block)) then
1152: deposit_new_block(l_block,l_old_bb_id,l_new_bb_id,p_transaction_info,p_messages);
1153: -- OTL - ABS Integration
1154: l_element := find_element(p_attributes,l_old_bb_id);
1155: IF g_debug

Line 1185: IF hxc_timecard_block_utils.is_active_block(l_block)

1181: end if;
1182: else
1183: deposit_old_block(l_block,l_old_ovn,l_new_ovn,p_deleted_blocks,p_transaction_info,p_messages);
1184: -- OTL - ABS Integration
1185: IF hxc_timecard_block_utils.is_active_block(l_block)
1186: then
1187: l_element := find_element(p_attributes,l_block.time_building_block_id);
1188: IF g_debug
1189: THEN

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

1331:
1332: Begin
1333:
1334: --***********DAYS Vs HOURS - Start ************
1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

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

1334: --***********DAYS Vs HOURS - Start ************
1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
1340: l_resource_id := p_blocks(l_active_index).resource_id;
1341:
1342: --Get the Preference value - Time Store Days to Hour Conversion

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

1335: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
1336: l_timecard_id := p_blocks(l_active_index).time_building_block_id;
1337: l_timecard_ovn := p_blocks(l_active_index).object_version_number;
1338: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
1339: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
1340: l_resource_id := p_blocks(l_active_index).resource_id;
1341:
1342: --Get the Preference value - Time Store Days to Hour Conversion
1343: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,

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

1624:
1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));

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

1625: hr_utility.trace('*********************InvalidSecurityContext Trace Start**********************************');
1626: hr_utility.trace('InvalidSecurityContext > PER_BUSINESS_GROUP_ID from fnd profile : '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));
1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;

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

1627: hr_utility.trace('InvalidSecurityContext > ORG_ID from fnd profile : '||fnd_profile.value('ORG_ID'));
1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1634: close c_check_bussiness_group_id;
1635:

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

1628: hr_utility.trace('InvalidSecurityContext > Resource_id : '|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id);
1629: hr_utility.trace('InvalidSecurityContext > Timecard Start Time :'|| p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time);
1630:
1631: open c_check_bussiness_group_id(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1632: hxc_timecard_block_utils.date_value(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time));
1633: fetch c_check_bussiness_group_id into l_business_group_id,l_organization_id;
1634: close c_check_bussiness_group_id;
1635:
1636: hr_utility.trace('InvalidSecurityContext > BUSINESS_GROUP_ID of the person : '||l_business_group_id);

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

1666: -- Blocks have to be in order, to ensure
1667: -- self referential integrity
1668:
1669: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1670: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1671: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1672: 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);
1673: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1674: --

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

1667: -- self referential integrity
1668:
1669: deposit_timecard_blocks(p_blocks,p_attributes,p_timecard_blocks,p_day_blocks,l_deleted_blocks,p_transaction_info,p_messages);
1670: l_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
1671: l_timecard_ovn := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
1672: 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);
1673: deposit_detail_blocks(p_blocks,p_attributes,p_detail_blocks,l_deleted_blocks,p_transaction_info,p_messages,l_timecard_id,l_timecard_ovn);
1674: --
1675: -- And now corresponding attributes

Line 1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN

1682: -- Maintain the timecard summary structures
1683: populate_transaction_data_set(p_transaction_info);
1684:
1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));

Line 1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,

1684:
1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:

Line 1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),

1685: -- OTL - ABS Integration
1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:

Line 1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));

1686: IF p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope THEN
1687:
1688: hxc_retrieve_absences.manage_retrieval_audit (p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id,
1689: FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).start_time),
1690: TRUNC(FND_DATE.canonical_to_date(p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).stop_time)));
1691: END IF;
1692:
1693:
1694: