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

Line 1074: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1070: -- This function gets building block information type id from a field name
1071: -- ========================================================================
1072: FUNCTION get_info_type_id(
1073: p_field_name IN hxc_mapping_components.field_name%TYPE
1074: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1075: )
1076: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1077: IS
1078: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

Line 1082: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1078: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1079:
1080: CURSOR c_info_type_id(
1081: p_field_name IN hxc_mapping_components.field_name%TYPE
1082: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1083: )
1084: IS
1085: SELECT mc.bld_blk_info_type_id
1086: FROM hxc_mapping_components mc

Line 1089: ,hxc_retrieval_processes rp

1085: SELECT mc.bld_blk_info_type_id
1086: FROM hxc_mapping_components mc
1087: ,hxc_mapping_comp_usages mcu
1088: ,hxc_mappings m
1089: ,hxc_retrieval_processes rp
1090: WHERE upper(mc.field_name) = upper(p_field_name)
1091: AND rp.mapping_id = m.mapping_id
1092: AND rp.retrieval_process_id = p_retrieval_process_id
1093: AND m.mapping_id = mcu.mapping_id

Line 1211: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1207: END;
1208:
1209:
1210: PROCEDURE build_attribute_detail(
1211: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1212: ,p_block_attribute IN OUT NOCOPY HXC_ATTRIBUTE_TYPE
1213: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1214: ,p_template_type IN VARCHAR2
1215: )

Line 1232: ,hxc_retrieval_processes rp

1228: select mc.segment
1229: from hxc_mapping_components mc
1230: ,hxc_mapping_comp_usages mcu
1231: ,hxc_mappings m
1232: ,hxc_retrieval_processes rp
1233: ,hxc_bld_blk_info_types bbit
1234: ,hxc_bld_blk_info_type_usages bbui
1235: where rp.mapping_id = m.mapping_id
1236: AND mc.field_name = p_field_name

Line 1408: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1404:
1405:
1406: FUNCTION app_to_block_attributes(
1407: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
1408: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1409: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1410: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1411: ,p_template_type IN VARCHAR2
1412: )

Line 2808: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

2804: l_detail_stop_date DATE;
2805: l_zero_template VARCHAR2(1);
2806: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
2807: l_dyn_template_sql VARCHAR2(2000);
2808: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
2809: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
2810: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');
2811: l_tp_stop_time DATE := TO_DATE(p_stop_time, 'YYYY/MM/DD');
2812: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 2865: p_process_name IN hxc_retrieval_processes.NAME%TYPE

2861: )
2862: WHERE rownum = 1;
2863:
2864: CURSOR c_otm_retrieval_process(
2865: p_process_name IN hxc_retrieval_processes.NAME%TYPE
2866: )
2867: IS
2868: SELECT retrieval_process_id
2869: FROM hxc_retrieval_processes

Line 2869: FROM hxc_retrieval_processes

2865: p_process_name IN hxc_retrieval_processes.NAME%TYPE
2866: )
2867: IS
2868: SELECT retrieval_process_id
2869: FROM hxc_retrieval_processes
2870: WHERE name = p_process_name;
2871:
2872: CURSOR c_retrieval_process(
2873: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

Line 2877: FROM hxc_retrieval_processes hrp,

2873: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
2874: )
2875: IS
2876: SELECT hrp.retrieval_process_id
2877: FROM hxc_retrieval_processes hrp,
2878: hxc_time_recipients htr
2879: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
2880: AND htr.time_recipient_id = hrp.time_recipient_id;
2881:

Line 5205: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

5201: l_detail_stop_date DATE;
5202:
5203: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
5204:
5205: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
5206: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
5207: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');
5208: l_tp_stop_time DATE := TO_DATE(p_stop_time, 'YYYY/MM/DD');
5209: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 5227: p_process_name IN hxc_retrieval_processes.NAME%TYPE

5223: where fa.application_short_name = p_dyn_template_app
5224: and htr.application_id = fa.application_id;
5225:
5226: CURSOR c_otm_retrieval_process(
5227: p_process_name IN hxc_retrieval_processes.NAME%TYPE
5228: )
5229: IS
5230: SELECT retrieval_process_id
5231: FROM hxc_retrieval_processes

Line 5231: FROM hxc_retrieval_processes

5227: p_process_name IN hxc_retrieval_processes.NAME%TYPE
5228: )
5229: IS
5230: SELECT retrieval_process_id
5231: FROM hxc_retrieval_processes
5232: WHERE name = p_process_name;
5233:
5234: CURSOR c_retrieval_process(
5235: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

Line 5239: FROM hxc_retrieval_processes hrp,

5235: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
5236: )
5237: IS
5238: SELECT hrp.retrieval_process_id
5239: FROM hxc_retrieval_processes hrp,
5240: hxc_time_recipients htr
5241: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
5242: AND htr.time_recipient_id = hrp.time_recipient_id;
5243:

Line 5511: FROM hxc_retrieval_processes

5507:
5508: IF l_transaction_process_id_tab(l_index) = -1 THEN
5509: SELECT retrieval_process_id
5510: INTO l_transaction_process_id_tab(l_index)
5511: FROM hxc_retrieval_processes
5512: WHERE name = 'BEE Retrieval Process';
5513: END IF;
5514:
5515: SELECT time_recipient_name

Line 5526: FROM hxc_retrieval_processes

5522: and object_version_number = l_timecard_ovn
5523: )
5524: AND time_recipient_id IN
5525: (SELECT time_recipient_id
5526: FROM hxc_retrieval_processes
5527: WHERE retrieval_process_id = l_transaction_process_id_tab(l_index));
5528:
5529:
5530: