2532: SYSDATE,
2533: l_user_id,
2534: SYSDATE);
2535:
2536: -- Create the interface in the BNE_INTERFACES_TL table
2537:
2538: INSERT INTO BNE_INTERFACES_TL
2539: ( APPLICATION_ID,
2540: INTERFACE_CODE,
2534: SYSDATE);
2535:
2536: -- Create the interface in the BNE_INTERFACES_TL table
2537:
2538: INSERT INTO BNE_INTERFACES_TL
2539: ( APPLICATION_ID,
2540: INTERFACE_CODE,
2541: LANGUAGE,
2542: SOURCE_LANG,
6200: ,p_msg_text => 'Deleting interfaces...');
6201:
6202: FOR dimintg_intfs_csr_rec IN dimintg_intfs_csr
6203: LOOP
6204: DELETE FROM bne_interfaces_tl WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6205: END LOOP;
6206:
6207: DELETE FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'
6208: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';