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
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
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);
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:
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 )
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
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);
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);
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;