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_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_TIME_ATTRIBUTES

Line 1045: ,hxc_time_attributes ta

1041: ) is
1042: select 'Y'
1043: from hxc_time_building_blocks tbb
1044: ,hxc_time_attribute_usages tau
1045: ,hxc_time_attributes ta
1046: where ta.time_attribute_id = tau.time_attribute_id
1047: and tau.time_building_block_id = tbb.time_building_block_id
1048: and tau.time_building_block_ovn = tbb.object_version_number
1049: and tbb.date_to = hr_general.end_of_time

Line 1063: ,hxc_time_attributes ta

1059: ,p_time_building_block_id in number) is
1060: select 'Y'
1061: from hxc_time_building_blocks tbb
1062: ,hxc_time_attribute_usages tau
1063: ,hxc_time_attributes ta
1064: where ta.time_attribute_id = tau.time_attribute_id
1065: and tau.time_building_block_id = tbb.time_building_block_id
1066: and tau.time_building_block_ovn = tbb.object_version_number
1067: and tbb.date_to = hr_general.end_of_time

Line 2307: ,p_timecard IN OUT NOCOPY hxc_time_attributes_api.timecard

2303:
2304: PROCEDURE build_timecard_structure(
2305: p_block IN NUMBER
2306: ,p_deposit_process_id IN NUMBER
2307: ,p_timecard IN OUT NOCOPY hxc_time_attributes_api.timecard
2308: ,p_update_required IN OUT NOCOPY BOOLEAN)
2309: IS
2310: CURSOR csr_bb_attributes(p_time_attribute_id NUMBER,
2311: p_ta_ovn NUMBER) IS

Line 2313: from hxc_time_attributes

2309: IS
2310: CURSOR csr_bb_attributes(p_time_attribute_id NUMBER,
2311: p_ta_ovn NUMBER) IS
2312: select *
2313: from hxc_time_attributes
2314: where time_attribute_id = p_time_attribute_id
2315: and (
2316: (object_version_number = p_ta_ovn)
2317: OR

Line 2343: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;

2339: l_attribute_index NUMBER;
2340: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
2341: l_bld_blk_info_type VARCHAR2(150);
2342: l_proc VARCHAR2(30) := 'build_timecard_structure';
2343: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
2344: l_exception EXCEPTION;
2345: l_att_count NUMBER;
2346: y NUMBER;
2347: l_replacement BOOLEAN := false;

Line 2700: l_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE;

2696: and mc.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2697: AND bbit.bld_blk_info_type_id = bbui.bld_blk_info_type_id
2698: AND bbit.bld_blk_info_type = p_attribute_category;
2699:
2700: l_time_attribute_id hxc_time_attributes.time_attribute_id%TYPE;
2701: l_segment hxc_mapping_components.segment%TYPE;
2702: l_att_count NUMBER;
2703: l_mapping_component t_mapping_comp; --AI7
2704:

Line 2906: from hxc_time_attributes

2902:
2903: IF g_attributes(p_attribute_number).changed IS NULL THEN
2904: begin
2905: select 1 into l_dummy
2906: from hxc_time_attributes
2907: where time_attribute_id = p_app_attributes(p_app_attribute_count).time_attribute_id
2908: and object_version_number = (select max(object_version_number)
2909: from hxc_time_attributes ta2
2910: where ta2.time_attribute_id = time_attribute_id)

Line 2909: from hxc_time_attributes ta2

2905: select 1 into l_dummy
2906: from hxc_time_attributes
2907: where time_attribute_id = p_app_attributes(p_app_attribute_count).time_attribute_id
2908: and object_version_number = (select max(object_version_number)
2909: from hxc_time_attributes ta2
2910: where ta2.time_attribute_id = time_attribute_id)
2911: and NVL(attribute1,'NULL') = NVL(g_attributes(p_attribute_number).attribute1,'NULL')
2912: and NVL(attribute2,'NULL') = NVL(g_attributes(p_attribute_number).attribute2,'NULL')
2913: and NVL(attribute3,'NULL') = NVL(g_attributes(p_attribute_number).attribute3,'NULL')

Line 2969: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE

2965: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
2966: l_att_count NUMBER;
2967:
2968: cursor csr_attribute
2969: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
2970: ) is
2971: select 1
2972: from hxc_time_attributes ta
2973: where ta.time_attribute_id = p_time_attribute_id;

Line 2972: from hxc_time_attributes ta

2968: cursor csr_attribute
2969: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
2970: ) is
2971: select 1
2972: from hxc_time_attributes ta
2973: where ta.time_attribute_id = p_time_attribute_id;
2974:
2975: l_attribute_row csr_attribute%ROWTYPE;
2976: l_new varchar2(30);

Line 3417: l_attribute1 HXC_TIME_ATTRIBUTES.ATTRIBUTE1%TYPE := P_ATTRIBUTE1;

3413:
3414: l_last_index BINARY_INTEGER;
3415: l_next_index BINARY_INTEGER;
3416: l_proc VARCHAR2(30) := 'DEPOSIT ATTRIBUTE INFO';
3417: l_attribute1 HXC_TIME_ATTRIBUTES.ATTRIBUTE1%TYPE := P_ATTRIBUTE1;
3418: l_attribute_category HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE%TYPE;
3419: l_bld_blk_info_type_id HXC_BLD_BLK_INFO_TYPES.BLD_BLK_INFO_TYPE_ID%TYPE;
3420:
3421: BEGIN

Line 3830: l_public_private HXC_TIME_ATTRIBUTES.ATTRIBUTE2%TYPE;

3826: end update_ovns;
3827:
3828: function public_private return varchar2 is
3829:
3830: l_public_private HXC_TIME_ATTRIBUTES.ATTRIBUTE2%TYPE;
3831:
3832: begin
3833:
3834: if (fnd_profile.value('HXC_CREATE_PUBLIC_TEMPLATES') = 'Y') then

Line 3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;

3882: ,p_allow_error_tc boolean default FALSE -- GPM v115.87
3883: ) IS
3884: --
3885: l_old_block HXC_TIME_BUILDING_BLOCKS%ROWTYPE;
3886: l_old_attribute HXC_TIME_ATTRIBUTES%ROWTYPE;
3887: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE;
3888: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;

Line 3893: l_timecard hxc_time_attributes_api.timecard;

3889: l_max_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE;
3890: l_deposit_process_id NUMBER;
3891: l_time_source_id hxc_time_sources.time_source_id%TYPE;
3892: l_time_source_name hxc_time_sources.name%TYPE;
3893: l_timecard hxc_time_attributes_api.timecard;
3894: l_attribute_index NUMBER;
3895: l_bld_blk_info_type_id NUMBER;
3896: l_mapping_comp_usage_id NUMBER;
3897: l_component_row hxc_mapping_components%ROWTYPE;

Line 3920: l_temp_temp_name hxc_time_Attributes.attribute1%type;

3916: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3917: l_resubmitted VARCHAR2(3);
3918: l_fnd_separator VARCHAR2(5) := FND_GLOBAL.LOCAL_CHR(0);
3919: l_error_message VARCHAR2(4000);
3920: l_temp_temp_name hxc_time_Attributes.attribute1%type;
3921: l_transaction_tab hxc_deposit_wrapper_utilities.t_transaction;
3922: l_overall_status varchar2(7) := 'SUCCESS';
3923: l_approval_style_id HXC_APPROVAL_STYLES.APPROVAL_STYLE_ID%TYPE;
3924:

Line 3998: l_template_name hxc_time_attributes.attribute1%type;

3994: FROM hxc_retrieval_processes rp
3995: WHERE name = p_retrieval_process;
3996:
3997:
3998: l_template_name hxc_time_attributes.attribute1%type;
3999:
4000: l_temp_att_count NUMBER := 0;
4001: l_found_name BOOLEAN := FALSE;
4002: l_index BINARY_INTEGER;

Line 5075: hxc_time_attributes ta,

5071: ,ta.ATTRIBUTE30 ta_ATTRIBUTE30
5072: ,ta.BLD_BLK_INFO_TYPE_ID ta_INFO_TYPE
5073: ,ta.OBJECT_VERSION_NUMBER ta_OVN
5074: from hxc_time_attribute_usages tau,
5075: hxc_time_attributes ta,
5076: hxc_bld_blk_info_types bbit
5077: where tau.time_building_block_id = p_tbb_id
5078: and tau.time_building_block_ovn = p_tbb_ovn
5079: and ta.time_attribute_id = tau.time_attribute_id

Line 5165: from hxc_time_attributes ta,

5161: -- Cursor to fetch the template details
5162: cursor get_template_details(p_time_building_block_id in number)
5163: is
5164: select attribute2||'|'||tau.time_building_block_id
5165: from hxc_time_attributes ta,
5166: hxc_time_attribute_usages tau
5167: where ta.time_attribute_id=tau.time_attribute_id
5168: and ta.attribute_category='TEMPLATES'
5169: and tau.time_building_block_id=p_time_building_block_id;

Line 5654: FROM hxc_time_attributes hta,

5650: hta.attribute25, hta.attribute26, hta.attribute27,
5651: hta.attribute28, hta.attribute29, hta.attribute30,
5652: hta.bld_blk_info_type_id, hta.object_version_number, 'N' NEW,
5653: 'N' changed, 'N' process
5654: FROM hxc_time_attributes hta,
5655: hxc_time_attribute_usages htau,
5656: hxc_bld_blk_info_types hbbit
5657: WHERE htau.time_building_block_id = p_build_block_id
5658: AND htau.time_building_block_ovn = p_build_block_ovn