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_RETRIEVAL_PROCESSES

Line 180: ,hxc_retrieval_processes rp

176: bbit.bld_blk_info_type
177: from hxc_mapping_components mc
178: ,hxc_mapping_comp_usages mcu
179: ,hxc_mappings m
180: ,hxc_retrieval_processes rp
181: ,hxc_bld_blk_info_types bbit
182: ,hxc_bld_blk_info_type_usages bbui
183: where rp.mapping_id = m.mapping_id
184: and rp.retrieval_process_id = p_retrieval_process_id

Line 1168: ,p_process_name IN HXC_RETRIEVAL_PROCESSES.NAME%TYPE)

1164: c_ret_pro retrieval_ref_cursor;
1165:
1166: CURSOR c_retrieval_process
1167: (p_app IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1168: ,p_process_name IN HXC_RETRIEVAL_PROCESSES.NAME%TYPE)
1169: IS
1170: SELECT retrieval_process_id
1171: FROM HXC_RETRIEVAL_PROCESSES
1172: WHERE name = p_process_name

Line 1171: FROM HXC_RETRIEVAL_PROCESSES

1167: (p_app IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1168: ,p_process_name IN HXC_RETRIEVAL_PROCESSES.NAME%TYPE)
1169: IS
1170: SELECT retrieval_process_id
1171: FROM HXC_RETRIEVAL_PROCESSES
1172: WHERE name = p_process_name
1173: AND time_recipient_id = p_app;
1174:
1175: l_sql VARCHAR2(32000);

Line 1176: l_app_process_name HXC_RETRIEVAL_PROCESSES.NAME%TYPE;

1172: WHERE name = p_process_name
1173: AND time_recipient_id = p_app;
1174:
1175: l_sql VARCHAR2(32000);
1176: l_app_process_name HXC_RETRIEVAL_PROCESSES.NAME%TYPE;
1177: l_proc VARCHAR2(30) := 'find_app_deposit_process';
1178:
1179: BEGIN
1180:

Line 1659: hxc_retrieval_processes rp

1655: WHERE
1656: mc.mapping_component_id in (Select mcu.mapping_component_id from
1657: hxc_mappings m ,
1658: hxc_mapping_comp_usages mcu,
1659: hxc_retrieval_processes rp
1660: WHERE
1661: rp.mapping_id = m.mapping_id and
1662: rp.retrieval_process_id = p_retrieval_process_id and
1663: m.mapping_id = mcu.mapping_id )

Line 2688: ,hxc_retrieval_processes rp

2684: select mc.segment
2685: from hxc_mapping_components mc
2686: ,hxc_mapping_comp_usages mcu
2687: ,hxc_mappings m
2688: ,hxc_retrieval_processes rp
2689: ,hxc_bld_blk_info_types bbit
2690: ,hxc_bld_blk_info_type_usages bbui
2691: where rp.mapping_id = m.mapping_id
2692: AND mc.field_name = p_field_name

Line 3905: l_app_valid_proc_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

3901: l_date DATE := SYSDATE;
3902: l_block NUMBER;
3903: x NUMBER;
3904: l_proc VARCHAR2(30):='deposit_blocks';
3905: l_app_valid_proc_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3906: l_retrieval_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3907: --l_app_attributes app_attributes_info;
3908: l_upd_sql VARCHAR2(2000);
3909: l_val_sql VARCHAR2(2000);

Line 3906: l_retrieval_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;

3902: l_block NUMBER;
3903: x NUMBER;
3904: l_proc VARCHAR2(30):='deposit_blocks';
3905: l_app_valid_proc_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3906: l_retrieval_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3907: --l_app_attributes app_attributes_info;
3908: l_upd_sql VARCHAR2(2000);
3909: l_val_sql VARCHAR2(2000);
3910: l_block_string VARCHAR2(32767);

Line 3994: FROM hxc_retrieval_processes rp

3990: -- GPM v115.42
3991:
3992: CURSOR csr_get_retrieval IS
3993: SELECT rp.retrieval_process_id
3994: FROM hxc_retrieval_processes rp
3995: WHERE name = p_retrieval_process;
3996:
3997:
3998: l_template_name hxc_time_attributes.attribute1%type;