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 1372: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1368: -- This function gets building block information type id from a field name
1369: -- ========================================================================
1370: FUNCTION get_info_type_id(
1371: p_field_name IN hxc_mapping_components.field_name%TYPE
1372: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1373: )
1374: RETURN hxc_bld_blk_info_types.bld_blk_info_type%TYPE
1375: IS
1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

Line 1380: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1376: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
1377:
1378: CURSOR c_info_type_id(
1379: p_field_name IN hxc_mapping_components.field_name%TYPE
1380: ,p_retrieval_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1381: )
1382: IS
1383: SELECT mc.bld_blk_info_type_id
1384: FROM hxc_mapping_components mc

Line 1387: ,hxc_retrieval_processes rp

1383: SELECT mc.bld_blk_info_type_id
1384: FROM hxc_mapping_components mc
1385: ,hxc_mapping_comp_usages mcu
1386: ,hxc_mappings m
1387: ,hxc_retrieval_processes rp
1388: WHERE upper(mc.field_name) = upper(p_field_name)
1389: AND rp.mapping_id = m.mapping_id
1390: AND rp.retrieval_process_id = p_retrieval_process_id
1391: AND m.mapping_id = mcu.mapping_id

Line 1509: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1505: END;
1506:
1507:
1508: PROCEDURE build_attribute_detail(
1509: p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1510: ,p_block_attribute IN OUT NOCOPY HXC_ATTRIBUTE_TYPE
1511: ,p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
1512: ,p_template_type IN VARCHAR2
1513: )

Line 1530: ,hxc_retrieval_processes rp

1526: select mc.segment
1527: from hxc_mapping_components mc
1528: ,hxc_mapping_comp_usages mcu
1529: ,hxc_mappings m
1530: ,hxc_retrieval_processes rp
1531: ,hxc_bld_blk_info_types bbit
1532: ,hxc_bld_blk_info_type_usages bbui
1533: where rp.mapping_id = m.mapping_id
1534: AND mc.field_name = p_field_name

Line 1706: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE

1702:
1703:
1704: FUNCTION app_to_block_attributes(
1705: p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
1706: ,p_process_id IN hxc_retrieval_processes.retrieval_process_id%TYPE
1707: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1708: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1709: ,p_template_type IN VARCHAR2
1710: )

Line 3108: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

3104: l_detail_stop_date DATE;
3105: l_zero_template VARCHAR2(1);
3106: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
3107: l_dyn_template_sql VARCHAR2(2000);
3108: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3109: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
3110: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');
3111: l_tp_stop_time DATE := TO_DATE(p_stop_time, 'YYYY/MM/DD');
3112: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 3165: p_process_name IN hxc_retrieval_processes.NAME%TYPE

3161: )
3162: WHERE rownum = 1;
3163:
3164: CURSOR c_otm_retrieval_process(
3165: p_process_name IN hxc_retrieval_processes.NAME%TYPE
3166: )
3167: IS
3168: SELECT retrieval_process_id
3169: FROM hxc_retrieval_processes

Line 3169: FROM hxc_retrieval_processes

3165: p_process_name IN hxc_retrieval_processes.NAME%TYPE
3166: )
3167: IS
3168: SELECT retrieval_process_id
3169: FROM hxc_retrieval_processes
3170: WHERE name = p_process_name;
3171:
3172: CURSOR c_retrieval_process(
3173: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

Line 3177: FROM hxc_retrieval_processes hrp,

3173: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
3174: )
3175: IS
3176: SELECT hrp.retrieval_process_id
3177: FROM hxc_retrieval_processes hrp,
3178: hxc_time_recipients htr
3179: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
3180: AND htr.time_recipient_id = hrp.time_recipient_id;
3181:

Line 5624: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

5620: l_detail_stop_date DATE;
5621:
5622: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
5623:
5624: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
5625: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
5626: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');
5627: l_tp_stop_time DATE := TO_DATE(p_stop_time, 'YYYY/MM/DD');
5628: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 5646: p_process_name IN hxc_retrieval_processes.NAME%TYPE

5642: where fa.application_short_name = p_dyn_template_app
5643: and htr.application_id = fa.application_id;
5644:
5645: CURSOR c_otm_retrieval_process(
5646: p_process_name IN hxc_retrieval_processes.NAME%TYPE
5647: )
5648: IS
5649: SELECT retrieval_process_id
5650: FROM hxc_retrieval_processes

Line 5650: FROM hxc_retrieval_processes

5646: p_process_name IN hxc_retrieval_processes.NAME%TYPE
5647: )
5648: IS
5649: SELECT retrieval_process_id
5650: FROM hxc_retrieval_processes
5651: WHERE name = p_process_name;
5652:
5653: CURSOR c_retrieval_process(
5654: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

Line 5658: FROM hxc_retrieval_processes hrp,

5654: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
5655: )
5656: IS
5657: SELECT hrp.retrieval_process_id
5658: FROM hxc_retrieval_processes hrp,
5659: hxc_time_recipients htr
5660: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
5661: AND htr.time_recipient_id = hrp.time_recipient_id;
5662:

Line 5930: FROM hxc_retrieval_processes

5926:
5927: IF l_transaction_process_id_tab(l_index) = -1 THEN
5928: SELECT retrieval_process_id
5929: INTO l_transaction_process_id_tab(l_index)
5930: FROM hxc_retrieval_processes
5931: WHERE name = 'BEE Retrieval Process';
5932: END IF;
5933:
5934: SELECT time_recipient_name

Line 5945: FROM hxc_retrieval_processes

5941: and object_version_number = l_timecard_ovn
5942: )
5943: AND time_recipient_id IN
5944: (SELECT time_recipient_id
5945: FROM hxc_retrieval_processes
5946: WHERE retrieval_process_id = l_transaction_process_id_tab(l_index));
5947:
5948:
5949: