6148: --
6149: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6150: --
6151:
6152: FEM_ENGINES_PKG.User_Message (
6153: p_app_name => 'FEM'
6154: ,p_msg_text => 'Deleting layout blocks and layout cols...');
6155:
6156: FOR dimintg_lyts_csr_rec IN dimintg_lyts_csr
6160: DELETE FROM bne_layout_blocks_b WHERE layout_code = dimintg_lyts_csr_rec.layout_code;
6161: DELETE FROM bne_layout_blocks_tl WHERE layout_code = dimintg_lyts_csr_rec.layout_code;
6162: END LOOP;
6163:
6164: FEM_ENGINES_PKG.User_Message (
6165: p_app_name => 'FEM'
6166: ,p_msg_text => 'Deleted...');
6167:
6168: FEM_ENGINES_PKG.User_Message (
6164: FEM_ENGINES_PKG.User_Message (
6165: p_app_name => 'FEM'
6166: ,p_msg_text => 'Deleted...');
6167:
6168: FEM_ENGINES_PKG.User_Message (
6169: p_app_name => 'FEM'
6170: ,p_msg_text => 'Deleting layouts...');
6171:
6172:
6176: END LOOP;
6177:
6178: DELETE FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';
6179:
6180: FEM_ENGINES_PKG.User_Message (
6181: p_app_name => 'FEM'
6182: ,p_msg_text => 'Deleted...');
6183:
6184: FEM_ENGINES_PKG.User_Message (
6180: FEM_ENGINES_PKG.User_Message (
6181: p_app_name => 'FEM'
6182: ,p_msg_text => 'Deleted...');
6183:
6184: FEM_ENGINES_PKG.User_Message (
6185: p_app_name => 'FEM'
6186: ,p_msg_text => 'Deleting interface cols');
6187:
6188: FOR dimintg_intfs_csr_rec IN dimintg_intfs_csr
6190: DELETE FROM bne_interface_cols_b WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6191: DELETE FROM bne_interface_cols_tl WHERE interface_code = dimintg_intfs_csr_rec.interface_code;
6192: END LOOP;
6193:
6194: FEM_ENGINES_PKG.User_Message (
6195: p_app_name => 'FEM'
6196: ,p_msg_text => 'Deleted...');
6197:
6198: FEM_ENGINES_PKG.User_Message (
6194: FEM_ENGINES_PKG.User_Message (
6195: p_app_name => 'FEM'
6196: ,p_msg_text => 'Deleted...');
6197:
6198: FEM_ENGINES_PKG.User_Message (
6199: p_app_name => 'FEM'
6200: ,p_msg_text => 'Deleting interfaces...');
6201:
6202: FOR dimintg_intfs_csr_rec IN dimintg_intfs_csr
6206:
6207: DELETE FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'
6208: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';
6209:
6210: FEM_ENGINES_PKG.User_Message (
6211: p_app_name => 'FEM'
6212: ,p_msg_text => 'Deleted...');
6213:
6214: FEM_ENGINES_PKG.User_Message (
6210: FEM_ENGINES_PKG.User_Message (
6211: p_app_name => 'FEM'
6212: ,p_msg_text => 'Deleted...');
6213:
6214: FEM_ENGINES_PKG.User_Message (
6215: p_app_name => 'FEM'
6216: ,p_msg_text => 'Deleting attr maps');
6217:
6218: DELETE FROM fem_webadi_dim_attr_maps;
6216: ,p_msg_text => 'Deleting attr maps');
6217:
6218: DELETE FROM fem_webadi_dim_attr_maps;
6219:
6220: FEM_ENGINES_PKG.User_Message (
6221: p_app_name => 'FEM'
6222: ,p_msg_text => 'Deleted...');
6223:
6224: IF ( FND_API.To_Boolean( p_char => p_commit) ) THEN